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
5
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-2
Business-ready dashboards on a real e-commerce dataset
Metrics a CEO would pin - defined, designed, defended.
WK 3
Product & funnel analysis with written insights
Investigate a real drop/spike and write the insight a PM would act on.
WK 4
A/B test design doc with MDE reasoning
The doc a growth PM would review.
WK 5-7
Python analysis notebooks + automated pipeline
Your SQL work made repeatable, automated, then live on AWS Lambda.
WK 8
Capstone ML model + business write-up
A simple model on business data, evaluated in business terms.
◆ 8-WEEK BREAKDOWN

What you'll ship, week by week.

WEEK
1
Setup + Data Familiarity
◆ 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
  • ▸Metabase familiarity
  • ▸Database exploration with JOINs and GROUP BY across orders/customers/products
  • ▸Asking business questions and translating them into SQL
  • ▸First Metabase Dashboard
SKILLS YOU'LL ADD
Explore a real database schemaTurn business questions into queriesBuild a first dashboard
Curated learning resources land with this week's task.
TOOLS⚙ SQL⚙ Metabase
◆ YOU SHIP THIS WEEK
Project 1 begins: your first Metabase dashboard on the e-commerce dataset
Reviewed in Discord · written feedback within 24h
WEEK
2
Dashboards that Matter
◆ SHIPS
Week 2
↳You'll arrive with: You can navigate the schema and have one reviewed dashboard behind you.
WHAT YOU'LL DO
  • ▸Window functions and CTEs for cleaner SQL
  • ▸Metric definitions stakeholders can't argue with
  • ▸Dashboard design
  • ▸Stakeholder-style reporting
SKILLS YOU'LL ADD
Define metrics stakeholders trustDesign dashboards people actually readReport in stakeholder language
Curated learning resources land with this week's task.
TOOLS⚙ SQL⚙ Metabase
◆ YOU SHIP THIS WEEK
Project 1 ships: a business-ready metrics dashboard
Reviewed in Discord · written feedback within 24h
WEEK
3
Product & Business Analysis
◆ SHIPS
Week 3
↳You'll arrive with: Confident SQL and a shipped, reviewed dashboard.
WHAT YOU'LL DO
  • ▸Funnel and cohort analysis with window functions
  • ▸Investigate drops/spikes with root-cause SQL, not guesswork
  • ▸Communicate insights
SKILLS YOU'LL ADD
Analyze revenue and funnelsInvestigate drops and spikesWrite insights a PM would act on
Curated learning resources land with this week's task.
TOOLS⚙ SQL⚙ Metabase
◆ YOU SHIP THIS WEEK
Project 2 ships: product & funnel analysis with written insights
Reviewed in Discord · written feedback within 24h
WEEK
4
Experimentation & Problem Solving
◆ SHIPS
Week 4
↳You'll arrive with: You've shipped analysis a stakeholder could read.
WHAT YOU'LL DO
  • ▸A/B test design with sample-size and MDE reasoning
  • ▸Root-cause investigations
  • ▸Define the right questions & metrics
  • ▸Handle incomplete or messy data
  • ▸Justify decisions & trade-offs
  • ▸Executive-style summary & next steps
SKILLS YOU'LL ADD
Design an A/B test with MDE reasoningRun root-cause investigationsHandle messy, incomplete dataWrite executive-style summaries
Curated learning resources land with this week's task.
TOOLS⚙ SQL⚙ Docs
◆ YOU SHIP THIS WEEK
Project 3 ships: an A/B test design doc with MDE reasoning
Reviewed in Discord · written feedback within 24h
WEEK
5
Python for Analytical Workflows
◆ SHIPS
Week 5
↳You'll arrive with: All the SQL you need and three reviewed artifacts (Weeks 1-4). Python workflows start here — building on basic syntax into production pandas analysis.
WHAT YOU'LL DO
  • ▸Reading data from SQL / CSV with pandas
  • ▸Metric computation with pandas groupby, merge, and pivot_table
  • ▸Reusable analysis notebooks/scripts
  • ▸Bridging SQL outputs with Python logic
SKILLS YOU'LL ADD
Pull SQL/CSV results into PythonCompute business metrics in codeBuild reusable analysis notebooks
Curated learning resources land with this week's task.
TOOLS⚙ Python⚙ pandas⚙ Jupyter
◆ YOU SHIP THIS WEEK
Project 4 begins: Python analysis notebooks
Reviewed in Discord · written feedback within 24h
WEEK
6
Automation & Pipelines
◆ SHIPS
Week 6
↳You'll arrive with: Working Python notebooks from Week 5.
WHAT YOU'LL DO
  • ▸Scheduled data pulls with Python + cron-style scheduling
  • ▸Automating recurring reports
  • ▸Designing simple data pipelines
  • ▸Failure handling & data freshness thinking
SKILLS YOU'LL ADD
Schedule recurring data pullsAutomate recurring reportsDesign simple, resilient pipelines
Curated learning resources land with this week's task.
TOOLS⚙ Python
◆ YOU SHIP THIS WEEK
Advances Project 4: your notebooks become an automated reporting pipeline
Reviewed in Discord · written feedback within 24h
WEEK
7
AWS Lambda & Cloud Scheduling
◆ SHIPS
Week 7
↳You'll arrive with: Automated Python pipeline from Week 6.
WHAT YOU'LL DO
  • ▸Deploying Python pipeline functions to AWS Lambda
  • ▸EventBridge / CloudWatch triggers
  • ▸Environment variables, secrets & database connections in Lambda
  • ▸Cloud logs & monitoring for silent pipeline breaks
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
◆ YOU SHIP THIS WEEK
Project 4 ships: a live, scheduled AWS Lambda data pipeline
Reviewed in Discord · written feedback within 24h
WEEK
8
Applied ML & Final Review
◆ SHIPS
Week 8
↳You'll arrive with: SQL + Python + a production pipeline: everything the model needs, you built.
WHAT YOU'LL DO
  • ▸Building a simple model (scikit-learn) on business data
  • ▸Evaluating results with precision/recall/PR-AUC, not just accuracy
  • ▸Communicating ML outcomes to non-technical stakeholders
SKILLS YOU'LL ADD
Judge when ML fits a business problemBuild a simple 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
◆ YOU SHIP THIS WEEK
Project 5 ships: capstone ML model + a write-up in business terms
Reviewed in Discord · written feedback within 24h
◆ HOW IT RUNS

Yes, you get videos. Yes, you get live time — 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 · a personal weekly 30-min 1:1. 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