Data Analyst Program

Data Analyst Program

Become a data analyst in seven months

Seven one-month courses take you from your first spreadsheet to a published portfolio. Each month has four weekly lessons and a final project. Start with Excel and work down the list, because every course builds on the one before it.

Courses
7
Weeks
28
Study time
149–164 h
Free videos
91

Start with Excel, Week 1 Read the Excel overview

Program map

Each row is one month and each cell is one week. Weeks you mark as done turn solid. Your progress is saved in this browser only.

W1
W2
W3
W4
Final
M1Excel
Excel Basics and Data Types4–5 hBasic Formulas and Logical Functions5–6 hLookup Functions and Data Cleaning5–6 hPivot Tables, Pivot Charts and the Excel Dashboard6–7 hSales Performance DashboardRubric
M2SQL
Database Basics and SQL Syntax4–5 hSELECT, WHERE and ORDER BY5 hAggregate Functions, GROUP BY and HAVING5–6 hSQL Joins and Subqueries6 hOnline Store Sales ReportRubric
M3Python
Python Basics4–5 hData Structures, Conditional Statements and Loops5–6 hFunctions and NumPy Basics5 hPandas, DataFrames, Data Cleaning and Data Manipulation6–7 hClean and Analyze a Dataset in PythonRubric
M4Statistics
Descriptive Statistics: Mean, Median and Mode4–5 hStandard Deviation and Probability Basics5 hData Distributions and Correlation Analysis5–6 hOutlier Detection and Exploratory Analysis6 hExploratory Data Analysis ReportRubric
M5Power BI
Power BI Basics and Data Import4–5 hPower Query and Data Transformation5–6 hData Modeling, Table Relationships and DAX Basics6 hKPI Cards, Data Visualization and Interactive Dashboards6–7 hInteractive Sales Dashboard in Power BIRubric
M6Guided Project
Dataset Selection, Problem Definition and Data Collection5 hData Cleaning and SQL Analysis6 hPython Analysis and Exploratory Analysis6 hDashboard Creation, Business Insights and Project Documentation7 hCapstone rubricRubric
M7Portfolio
Portfolio Planning: Dataset Selection, Problem Definition and Data Collection5 hData Cleaning, SQL Analysis and Python Analysis7 hExploratory Analysis, Dashboard Creation and Business Insights6 hProject Documentation and Publishing Your Portfolio6–7 hPortfolio rubricRubric

The seven courses

  1. Month 1Excel for Data Analysis4 weeks · 20–24 hours · 0 of 4 done
  2. Month 2SQL for Data Analysis4 weeks · 20–22 hours · 0 of 4 done
  3. Month 3Python for Data Analysis4 weeks · 20–23 hours · 0 of 4 done
  4. Month 4Statistics for Data Analysis4 weeks · 20–22 hours · 0 of 4 done
  5. Month 5Power BI for Data Analysis4 weeks · 21–24 hours · 0 of 4 done
  6. Month 6Guided Data Analysis Project4 weeks · 24 hours · 0 of 4 done
  7. Month 7Data Analyst Portfolio4 weeks · 24–25 hours · 0 of 4 done

How each week works

  1. Read the lessons. Plain-language explanations with worked examples.
  2. Watch the videos. Short, free beginner videos that show the same skill on screen.
  3. Practice. A guided activity you do in the real tool.
  4. Check yourself. Open each quiz question only after you have tried it.
  5. Submit the assignment. A small graded task, then mark the week as done.