{"data":{"_id":"6ae40d55ad69f3eadd1b3c1d","name":"Data Analysis","slug":"data-analysis","image":"https://images.unsplash.com/photo-1551288049-bebda4e38f71?auto=format&fit=crop&w=1200&q=80","icon":"data-analysis","accentColor":"#0D9488","isFree":false,"price":899,"features":["Advanced SQL (Window Functions & CTEs)","Modern ELT with dbt","Interactive Dashboards & Visualization","A/B Testing & Product Cohort Analytics"],"tags":["Interactive Roadmap","Data Analysis","SQL","dbt","Business Intelligence"],"category":null,"description":"Master advanced SQL, dbt data transformations, Python analytics with Pandas & Polars, interactive BI dashboard storytelling, and statistical A/B testing.","modules":[{"icon":"💾","title":"Advanced SQL for Enterprise Analytics","description":"Window functions (ROW_NUMBER, RANK, DENSE_RANK, LEAD, LAG), Common Table Expressions (CTEs), and query optimization.","duration":"3 hours","order":1,"isFree":true,"isPublished":true,"isProject":false,"content":"### The Universal Analytics Language\nWindow functions allow you to perform rolling averages, cumulative sums, and customer ranking without expensive self-joins.\n\n```sql\n-- Calculate 7-day rolling revenue average\nSELECT \n  order_date,\n  daily_revenue,\n  AVG(daily_revenue) OVER (\n    ORDER BY order_date \n    ROWS BETWEEN 6 PRECEDING AND CURRENT ROW\n  ) AS rolling_7d_avg\nFROM daily_sales;\n```","subsections":[{"title":"Window Functions & Ranking Mechanics","description":"PARTITION BY, ORDER BY, frame clauses (ROWS vs RANGE), and offset navigation with LEAD/LAG.","duration":"75 mins","content":"Mastering complex SQL window calculations.","isFree":true,"isPublished":true,"order":1,"_id":"6ae3ed503f5d6ea8c6dd3c55","locked":false},{"title":"Recursive CTEs & Query Plan Optimization","description":"Traverse hierarchical org charts and optimize slow database queries using execution plans.","duration":"75 mins","content":"Query tuning and CTEs.","isFree":true,"isPublished":true,"order":2,"_id":"6ae3ed503f5d6ea8c6dd3c56","locked":false}],"_id":"6ae3ed503f5d6ea8c6dd3c54","locked":false},{"icon":"🐼","title":"Data Wrangling with Python, Pandas & Polars","description":"Data cleaning, handling missing values, GroupBy aggregations, pivoting, and time-series resampling....","duration":"3 hours","order":2,"isFree":false,"isPublished":true,"isProject":false,"content":"","subsections":[{"title":"Data Cleaning & Transformation Strategies","description":"String manipulation, regex extraction, datetime parsing, and handling categorical values.","duration":"75 mins","content":"","isFree":false,"isPublished":true,"order":1,"_id":"6ae3ed503f5d6ea8c6dd3c58","locked":true},{"title":"GroupBy Aggregations & Pivot Tables","description":"Multi-index aggregations, custom aggregation functions, and unstacking tabular structures.","duration":"75 mins","content":"","isFree":false,"isPublished":true,"order":2,"_id":"6ae3ed503f5d6ea8c6dd3c59","locked":true}],"_id":"6ae3ed503f5d6ea8c6dd3c57","locked":true},{"icon":"🏗️","title":"Data Modeling & The Modern ELT Stack with dbt","description":"Star schema vs Snowflake schema, dimensional modeling (Fact and Dimension tables), and dbt transformation workflows....","duration":"3 hours","order":3,"isFree":false,"isPublished":true,"isProject":false,"content":"","subsections":[{"title":"Dimensional Modeling: Kimball Methodology","description":"Fact tables, dimension tables, slowly changing dimensions (SCD Type 1 & 2), and surrogate keys.","duration":"75 mins","content":"","isFree":false,"isPublished":true,"order":1,"_id":"6ae3ed503f5d6ea8c6dd3c5b","locked":true},{"title":"dbt Models, Tests & Documentation","description":"Jinja templating in SQL, ref() dependencies, schema testing, and lineage graph generation.","duration":"75 mins","content":"","isFree":false,"isPublished":true,"order":2,"_id":"6ae3ed503f5d6ea8c6dd3c5c","locked":true}],"_id":"6ae3ed503f5d6ea8c6dd3c5a","locked":true},{"icon":"🧪","title":"Statistical Rigor & Product A/B Testing","description":"Sample size determination, statistical significance, p-values, z-tests, and avoiding peeking bias....","duration":"2.5 hours","order":4,"isFree":false,"isPublished":true,"isProject":false,"content":"","subsections":[{"title":"Sample Size Calculation & Power Analysis","description":"Minimum Detectable Effect (MDE), statistical power (1 - Beta), and significance level (Alpha).","duration":"60 mins","content":"","isFree":false,"isPublished":true,"order":1,"_id":"6ae3ed503f5d6ea8c6dd3c5e","locked":true},{"title":"Analyzing Experiment Results & Common Pitfalls","description":"Two-sample t-tests, chi-square tests, novelty effects, and sample ratio mismatches (SRM).","duration":"60 mins","content":"","isFree":false,"isPublished":true,"order":2,"_id":"6ae3ed503f5d6ea8c6dd3c5f","locked":true}],"_id":"6ae3ed503f5d6ea8c6dd3c5d","locked":true},{"icon":"📉","title":"Cohort Analysis, Funnels & Retention Metrics","description":"User retention curves, cohort matrices, conversion funnel drop-off analysis, and LTV/CAC calculations....","duration":"2.5 hours","order":5,"isFree":false,"isPublished":true,"isProject":false,"content":"","subsections":[{"title":"Building Cohort Retention Matrices in SQL","description":"Compute month-over-month retention percentages using SQL self-joins and window functions.","duration":"60 mins","content":"","isFree":false,"isPublished":true,"order":1,"_id":"6ae3ed503f5d6ea8c6dd3c61","locked":true},{"title":"Conversion Funnels & Drop-Off Diagnostics","description":"Identify highest-friction steps in sign-up and checkout flows to optimize conversion.","duration":"60 mins","content":"","isFree":false,"isPublished":true,"order":2,"_id":"6ae3ed503f5d6ea8c6dd3c62","locked":true}],"_id":"6ae3ed503f5d6ea8c6dd3c60","locked":true},{"icon":"📊","title":"Capstone: Executive Revenue & Product Growth Analytics Dashboard","description":"Build an end-to-end executive analytics report combining advanced SQL data models in dbt, cohort retention matrices, and an interactive Plotly/BI dash...","duration":"4 hours","order":6,"isFree":false,"isPublished":true,"isProject":true,"content":"","subsections":[{"title":"SQL Data Modeling & Dimensional Warehousing","description":"Write transformation models and data quality tests in dbt.","duration":"90 mins","content":"","isFree":false,"isPublished":true,"order":1,"_id":"6ae3ed503f5d6ea8c6dd3c64","locked":true},{"title":"Executive Visualizations & Insight Presentation","description":"Create interactive charts and draft an actionable executive summary report.","duration":"90 mins","content":"","isFree":false,"isPublished":true,"order":2,"_id":"6ae3ed503f5d6ea8c6dd3c65","locked":true}],"_id":"6ae3ed503f5d6ea8c6dd3c63","locked":true}],"details":[],"status":"published","__v":0},"message":"Course fetched successfully"}