ZENITHLABGet access
Zenith Lab
Data Analyst TrackSelf-paced course

Data Science & Analysis

Spreadsheets through a full capstone analysis: clean real messy data, query it, analyze it in Python, validate it statistically, and ship a dashboard that answers an actual business question.

9
modules
315
practice tasks
10
portfolio projects
21
in-app pages
8.3h
of module content
Full curriculum

10 modules, in order

  1. 0Orientation
    A short, honest self-check. Beginners start at Module 1. Later tracks are optional only if you already write code or pandas, plus what analysts actually do and what Modules 1-9 will (and will not) teach you.
Stage 0 · Spreadsheets before code
  1. 1Spreadsheet & Data Literacy Foundations40m
    Rows, columns, and cells as the mental model for what a "dataset" is, the five formulas that cover most real spreadsheet work, sorting and filtering, and why "tidy data" is the idea everything after this module depends on.
Stage 1 · Python foundations for data
  1. 2Python Foundations for Data45m
    Six ideas, each taught through a real analyst task, with code you actually write and run in a real Python interpreter in the browser. Every concept exists here because Module 3 onward needs it.
  2. 3Pandas & NumPy Fundamentals50m
    What you parsed by hand with a loop in Module 2, pandas does in one line, then gives you filtering, grouping, and joining on top. Runs against the same real datasets you'll use for the rest of the course.
Stage 2 · Real-world data skills
  1. 4Data Cleaning & Validation55m
    Where most analyst time actually goes. You get raw data and an audit to perform, not a checklist to follow, because finding the problems is the skill, not something anyone can hand you a list of.
  2. 5Exploratory Data Analysis & Statistics50m
    Not a maths course. Every concept exists to answer one question a stakeholder will actually ask: is this difference real, or did we just get lucky? You compute the numbers, and learn when not to trust them.
Stage 3 · Querying and communicating
  1. 6SQL for Analysts45m
    A real SQLite database running entirely in the page, with a messy shop's worth of customers, orders, and products, NULLs, cancelled orders, and duplicate-row traps included. Every exercise starts from a business question and is checked against the live database.
  2. 7Data Visualization & Storytelling45m
    Every chart is real: you write actual Plotly code that runs in a real Python interpreter in your browser. The hard part was never the charting syntax, it's choosing the right chart and knowing when one is honest or quietly lying.
  3. 8Dashboards & Business Communication50m
    Every KPI and chart is computed by your own Python code running on real, messy funnel data from Module 4. A dashboard is not a picture of numbers, it's an argument built out of them.
Stage 4 · Capstone
  1. 9Capstone Analysis Project120m
    One real client, one real ambiguous problem, every skill from Modules 1-8 in service of answering it. No numbered steps: you decide what to clean, what to query, what to chart, and what to recommend.
Inside the course

5 sections, 21 real pages

Learn5 pagesCourse structure, reference material, and where you left off
  • DashboardYour home base: progress, streaks, and what's next
  • SyllabusThe full course outline, module by module
  • Learning RoadmapThe whole journey mapped on one page
  • Cheat SheetsPrintable quick-reference for every tool
  • Python Survival GuideA crash-course reference for Python syntax
Practice9 pagesExtra reps, quizzes, and skill tracking
  • Quiz CenterEvery module's quiz, plus a cumulative final
  • SQL PracticeGraded SQL exercises against a real database
  • Excel PracticeGraded Excel formula exercises
  • Python PracticeGraded Python exercises in a real interpreter
  • Statistics PracticeGraded statistics exercises on real datasets
  • Automation PracticeGraded scripting and automation exercises
  • Integrated ChallengesCross-tool challenges combining everything you've learned
  • Skill DiagnosticA placement check for where to start
  • Mastery ProfileYour real skill level, tracked per tool
Decide · simulations2 pagesJudgment-call scenarios, labeled simulations
  • Tableau PracticeLabeled Tableau decision simulations
  • Power BI PracticeLabeled Power BI decision simulations
Build3 pagesThe real projects and labs you'll actually ship
  • Desktop Labs (required)The required lab done in the real desktop tool, not a simulation
  • ProjectsThe real portfolio projects you'll build
  • Deploy GuideStep-by-step: deploy your work live
Evidence2 pagesPortfolio, career path, and proof you can show
  • My PortfolioEvery completed project, auto-summarized
  • Career PathCareer Path Edition: readiness and job-landing playbook
Practice tasks by tool

315 tasks, broken down

Excel35 tasks
Python50 tasks
SQL60 tasks
Statistics40 tasks
Tableau40 tasks
Power BI40 tasks
Automation30 tasks
Integrated Cross-Tool Challenges20 tasks
What you'll actually do
  • Clean messy, real business datasets
  • Write real SQL queries against a live database
  • Analyze data in Excel and Python (pandas)
  • Run statistical tests, correlation, and regression
  • Choose the right chart and spot a misleading one
  • Practice Tableau and Power BI judgment in honest in-browser simulations, then submit one real Desktop Lab
  • Automate a repetitive analytical workflow
  • Complete an end-to-end capstone and portfolio projects
Portfolio projects you'll build

10 real projects

"The Leaky Funnel"
E-commerce & Retail
"The Understaffed Quarter"
People & HR
"The Campaign That Didn’t Work"
Marketing & Agency
"The Slow Season"
Finance & Small Business
"The Churn Cliff"
SaaS
"The Overpriced Listing"
Real Estate
Unlock in the course
"The Wait Time Problem"
Healthcare Operations
Unlock in the course
"The Empty Rooms"
Travel & Hospitality
Unlock in the course
"The Phantom Stock"
Retail
Unlock in the course
"The Monthly Scorecard"
Executive & BI, multi-tool capstone
Unlock in the course
Tools and topics covered
ExcelSQLPythonStatisticsTableauPower BIAutomationData CleaningDashboardsBusiness Analysis
What's actually included
  • Diagnostic assessment with an adaptive learning roadmap
  • Mastery profile tracking your real skill level per tool
  • Quiz Center covering every module
  • Printable cheat sheets for every tool
  • 10 real portfolio projects, auto-summarized for your resume
  • A downloadable portfolio site template
  • Step-by-step guide to deploying it live on Vercel
  • Career Path Edition: pricing, job boards, and interview framing
  • Required Tableau Public or Power BI Desktop lab (not the in-browser simulations)
Why it matters

Most analysis starts with messy data, not a clean spreadsheet.

A SQL JOIN can silently multiply rows and produce a completely wrong business result.

Correlation does not prove that one variable caused another.

An average can hide a huge difference between customers.

Choosing the wrong chart can make a correct dataset tell the wrong story.

Excel, SQL, and Python solve different parts of the same analytical workflow.

Career Path Edition

A portfolio of real analyses, built from messy data through a defended recommendation, the kind of evidence that gets interviews instead of another tutorial notebook.

Ready to start? Self-paced, start whenever you are.

Get access