Topfolio
www.topfolio.in

Data Analyst - Advanced

Full 8-week curriculum

2 Months1-2 hrs/day (more during capstone weeks)Intermediate → Advanced₹4,999 one-time
◆ WHAT'S INSIDE

Everything you'll learn, build, and use.

11
skills
6
tools
8
portfolio projects
WHAT YOU NEED TO START
  • 1-2 hrs/day for the full 8 weeks
  • Good SQL skills (JOINs, GROUP BY, CTEs, Window functions like LEAD/LAG) and basic Python syntax
Everything else is taught inside — Advanced SQL (cohort analysis, complex business metrics) · Production Python pipelines & pandas workflows · AWS Lambda cloud deployment · Applied ML for analysts - Week 8. Resources land with each week's task.
SKILLS YOU'LL ADD
SQL for business analyticsMetric definition & dashboard designProduct & funnel analysisA/B test design (incl. MDE reasoning)Root-cause investigationExecutive-style communicationPython for analysis workflowsReport automation & pipeline designCloud scheduling with AWS LambdaApplied ML judgementWorking with AI the way analysts do on the job
Each skill comes with a curated video course when the task needs it — how it works
TOOLS YOU'LL USE⚙ SQL⚙ Metabase⚙ Python⚙ Jupyter⚙ AWS Lambda⚙ AI copilots
◆ PORTFOLIO PROJECTS YOU'LL SHIP
WK 1
Executive KPI & Revenue Performance Metabase Suite
Metrics a CEO would pin — defined, designed, and reconciled across 500k transactions.
WK 2
Customer Cohort Retention & Churn Velocity Engine
Triangular retention heatmaps and cumulative LTV curves by acquisition channel.
WK 3
Product Funnel Breakdown & Checkout Drop-off RCA
Root-cause isolation of a 4.2% checkout conversion drop across 1.2M telemetry events.
WK 4
Growth Experimentation & A/B Decision Framework
Pre-experiment power analysis, Sample Ratio Mismatch check, and hypothesis decision memo.
WK 5
Operations Analytics & Anomaly Detection Engine
Replaces manual Excel sheets with automated statistical anomaly detection (rolling Z-scores).
WK 6
Enterprise ELT Pipeline & Data Quality Suite
Dimensional star-schema transformation engine with automated data quality assertions.
WK 7
Serverless Cloud Pipeline on AWS Lambda
Daily automated serverless ELT pipeline triggered at 6:00 AM IST with CloudWatch alerts.
WK 8
Applied Predictive Churn & LTV ML System
Cost-sensitive classification model balancing retention coupon budget against saved customer LTV.
◆ 8-WEEK BREAKDOWN

What you'll ship, week by week.

WEEK
1
Executive KPI & Revenue Performance Suite
◆ SHIPS
Week 1
↳You'll arrive with: Prerequisite entry bar: comfortable with SQL (JOINs, GROUP BY, CTEs, Window functions like LEAD/LAG) and basic Python syntax. We jump straight into complex schema analysis and Metabase dashboarding.
WHAT YOU'LL DO
  • ▸PostgreSQL exploration across 500k e-commerce orders, items, payments, and refunds
  • ▸Translating messy business metrics into clean, reusable multi-table SQL CTEs
  • ▸Building an executive Metabase dashboard suite: GMV to Net Revenue waterfall and regional performance
  • ▸Writing the official Metric Dictionary & Data Dictionary
SKILLS YOU'LL ADD
Translate executive questions into SQLDesign business-ready Metabase dashboardsReconcile GMV to Net Revenue metrics
Curated learning resources land with this week's task.
TOOLS⚙ PostgreSQL⚙ Metabase⚙ Docs
◆ YOU SHIP THIS WEEK
Project 1 ships: Executive KPI & Revenue Performance Metabase Suite with documented metric dictionary
Reviewed in Discord · written feedback within 24h
WEEK
2
Customer Cohort Retention & Churn Velocity
◆ SHIPS
Week 2
↳You'll arrive with: Confident SQL and a shipped, reviewed executive KPI dashboard from Week 1.
WHAT YOU'LL DO
  • ▸Triangular cohort retention matrix using window functions and date truncation
  • ▸Computing cumulative 30/60/90-day LTV curves by acquisition channel
  • ▸Identifying repeat purchase latency and drop-off cliff points
  • ▸Drafting an executive retention readout memo for the VP Growth
SKILLS YOU'LL ADD
Build triangular cohort retention queriesCalculate cumulative LTV curvesWrite actionable growth readouts
Curated learning resources land with this week's task.
TOOLS⚙ SQL⚙ Metabase⚙ Docs
◆ YOU SHIP THIS WEEK
Project 2 ships: Customer Cohort Retention & Churn Velocity Engine with executive growth memo
Reviewed in Discord · written feedback within 24h
WEEK
3
Product Funnel Breakdown & Checkout Drop-off RCA
◆ SHIPS
Week 3
↳You'll arrive with: Cohort analysis mastery and strong SQL window functions.
WHAT YOU'LL DO
  • ▸Analyzing 1.2M raw event telemetry records across web and mobile sessions
  • ▸Multi-step conversion funnel segmentation (Device, OS, Payment Gateway)
  • ▸Root-cause isolation of a 4.2% checkout conversion drop
  • ▸Writing a formal Engineering & Product Root Cause Analysis (RCA) document
SKILLS YOU'LL ADD
Analyze raw event telemetryIsolate checkout funnel drop-offsAuthor executive RCA engineering documents
Curated learning resources land with this week's task.
TOOLS⚙ SQL⚙ PostgreSQL⚙ Docs
◆ YOU SHIP THIS WEEK
Project 3 ships: Product Funnel Breakdown & Checkout Drop-off Root Cause Analysis doc
Reviewed in Discord · written feedback within 24h
WEEK
4
Growth Experimentation & A/B Decision Framework
◆ SHIPS
Week 4
↳You'll arrive with: Three reviewed business analysis artifacts behind you.
WHAT YOU'LL DO
  • ▸Pre-experiment power analysis, sample size, and Minimum Detectable Effect (MDE) calculation
  • ▸Detecting Sample Ratio Mismatch (SRM) with Chi-Square tests
  • ▸Two-tailed hypothesis testing (p-values, Z-scores, and 95% confidence intervals)
  • ▸Authoring an executive A/B test decision memo detailing rollout risk
SKILLS YOU'LL ADD
Calculate experiment power & sample sizeDiagnose Sample Ratio Mismatch (SRM)Write executive A/B decision memos
Curated learning resources land with this week's task.
TOOLS⚙ Python⚙ SQL⚙ Scipy Stats⚙ Docs
◆ YOU SHIP THIS WEEK
Project 4 ships: Growth Experimentation & A/B Test Decision Framework with Python statistical verification
Reviewed in Discord · written feedback within 24h
WEEK
5
Operations Analytics & Anomaly Detection Engine
◆ SHIPS
Week 5
↳You'll arrive with: Solid SQL foundation. Python analytics starts here, bridging queries into production pandas workflows.
WHAT YOU'LL DO
  • ▸Automated ingestion of database tables and multi-source CSV exports in Python/pandas
  • ▸Building statistical anomaly detection algorithms (IQR & rolling Z-score)
  • ▸Detecting supply chain logistics SLA breaches and fulfillment spikes
  • ▸Generating automated standalone HTML and PDF operational health reports
SKILLS YOU'LL ADD
Automate multi-source data ingestionImplement statistical anomaly detection in pandasBuild automated HTML business reports
Curated learning resources land with this week's task.
TOOLS⚙ Python⚙ pandas⚙ Seaborn⚙ Jupyter
◆ YOU SHIP THIS WEEK
Project 5 ships: Automated Python Operations Analytics & Anomaly Detection Notebook
Reviewed in Discord · written feedback within 24h
WEEK
6
Enterprise ELT Pipeline & Data Quality Suite
◆ SHIPS
Week 6
↳You'll arrive with: Working Python analytical workflows from Week 5.
WHAT YOU'LL DO
  • ▸Architecting dimensional star-schema models (dim_customers, dim_products, fct_sales)
  • ▸Building modular Python ELT transformation scripts using DuckDB and SQLAlchemy
  • ▸Implementing automated data quality assertions (null checks, uniqueness, range validity)
  • ▸Configuring error logging and Discord/Slack webhook failure alerts
SKILLS YOU'LL ADD
Design star-schema dimensional modelsBuild modular Python ELT transformation pipelinesWrite automated data quality assertions
Curated learning resources land with this week's task.
TOOLS⚙ Python⚙ DuckDB⚙ SQLAlchemy
◆ YOU SHIP THIS WEEK
Project 6 ships: Enterprise ELT Pipeline & Data Quality Transformation Engine
Reviewed in Discord · written feedback within 24h
WEEK
7
Serverless Cloud Pipeline on AWS Lambda
◆ SHIPS
Week 7
↳You'll arrive with: Automated Python ELT pipeline from Week 6.
WHAT YOU'LL DO
  • ▸Packaging Python pipeline functions into serverless AWS Lambda containers/zips
  • ▸Configuring Amazon EventBridge cron schedules for 6:00 AM daily automation
  • ▸Secure secret isolation using AWS Parameter Store / Secrets Manager
  • ▸CloudWatch logging, error monitoring, and automated alerting
SKILLS YOU'LL ADD
Deploy serverless Python functionsConfigure cloud cron triggersMonitor production pipelines
Curated learning resources land with this week's task.
TOOLS⚙ Python⚙ AWS Lambda⚙ EventBridge⚙ S3
◆ YOU SHIP THIS WEEK
Project 7 ships: a live, scheduled AWS Lambda data pipeline with EventBridge triggers
Reviewed in Discord · written feedback within 24h
WEEK
8
Applied Predictive Churn & LTV ML System
◆ SHIPS
Week 8
↳You'll arrive with: SQL + Python + a production cloud pipeline: everything the model needs, you built.
WHAT YOU'LL DO
  • ▸Building a cost-sensitive churn classification model (scikit-learn) on customer behavior data
  • ▸Evaluating results with precision/recall/PR-AUC curves, avoiding deceptive accuracy
  • ▸Business-calibrated probability threshold tuning balancing retention cost vs LTV saved
  • ▸Authoring an executive Slide Deck & ROI Decision Memo for non-technical stakeholders
SKILLS YOU'LL ADD
Judge when ML fits a business problemBuild a cost-calibrated model on business dataEvaluate results in business termsExplain ML to non-technical stakeholders
Curated learning resources land with this week's task.
TOOLS⚙ Python⚙ scikit-learn⚙ Joblib⚙ Docs
◆ YOU SHIP THIS WEEK
Project 8 ships: capstone ML churn model + an executive ROI decision deck
Reviewed in Discord · written feedback within 24h
◆ HOW IT RUNS

Yes, you get videos. Yes, you get 1:1 mentorship — but neither is the program; the work is. Real tasks with deadlines · a curated video course per skill, watched when the task needs it · AI as your pair-worker, reviewed so you understand every line · written review of every submission within 24 hours · 1:1 Discord text review & project mentorship from Anuj. Full details →

₹4,999 one-time · pause anytime · lifetime access
See the program & enrollAsk Anuj on WhatsApp
Data Analyst - Advanced - Full 8-Week Curriculum & Brochure