📊 Course · 16 lessons · about 10.6 hours
Data Analytics & Statistics
The everyday analyst toolkit — spreadsheets, SQL, pandas and EDA — plus statistics, metric design, experiments, BI modelling and dashboards that turn data into decisions.
Start lesson 1 →Roles: Data Analyst · Analytics Engineer · Product Analyst · BI Analyst
Before you start
Part of these career paths
Module 1 · Analyst Toolkit
The tools an analyst uses every day, before any statistics.
- Lesson 0140 minSpreadsheets for Analysis — Excel and Google SheetsClean and analyse data in a spreadsheet: formulas, lookups, pivot tables, conditional formatting and charts, and when to move to SQL or Python.
- Lesson 0240 minSQL for Analytics — The Queries Analysts Write DailyAggregations, joins, CASE, date handling, window functions and CTEs applied to real business questions, with links to the full SQL course.
- Lesson 0345 minPython for Analysts — The pandas Analysis WorkflowLoad, clean, reshape, group and visualise data with pandas in a notebook, and turn the result into a shareable report.
- Lesson 0440 minExploratory Data Analysis — A Repeatable WorkflowA step-by-step EDA checklist: data quality, distributions, segments, relationships and anomalies, ending in written findings.
Module 2 · Statistics for Data
Describe data honestly and know when a difference is real.
- Lesson 0535 minDescriptive Statistics and DistributionsMean, median, percentiles, spread, skew, and outliers; reading histograms and box plots; and choosing the right summary.
- Lesson 0635 minSampling and Confidence IntervalsPopulations versus samples, sampling bias, the central limit theorem, standard error, and confidence intervals in Python.
- Lesson 0740 minHypothesis Testing and p-valuesNull and alternative hypotheses, t-tests and chi-square tests, p-values, errors, power, and what significance does not mean.
- Lesson 0840 minCorrelation and Regression for AnalystsMeasure relationships with correlation, fit and interpret linear regression, and avoid confusing correlation with causation.
Module 3 · Metrics & Experiments
Define metrics people trust and test changes properly.
- Lesson 0935 minDefining Metrics and KPIsNorth-star and guardrail metrics, funnels, cohorts, retention, writing a metric definition, and building a metrics layer.
- Lesson 1040 minA/B Testing — Design, Analysis and PitfallsHypotheses, randomisation units, sample size, running and analysing a test, and the peeking, novelty, and multiple-testing traps.
- Lesson 1140 minFunnel, Cohort and Retention AnalysisBuild conversion funnels, cohort tables and retention curves in SQL and Python, and explain what they say about a product.
Module 4 · BI & Storytelling
Dashboards and narratives that lead to action.
- Lesson 1240 minDashboards with Power BI, Tableau and Looker StudioDesign a dashboard for a decision, model data for BI, choose charts, add filters, and manage refresh and access.
- Lesson 1340 minBI Data Models and Measures — Star Schemas and DAXModel data for BI tools with star schemas and relationships, write measures in DAX, and keep a semantic model fast and trustworthy.
- Lesson 1430 minData Storytelling — From Analysis to DecisionStructure an analysis as a story, choose the one chart that makes the point, write the headline, and present to stakeholders.
Module 5 · Case Studies & Career
Apply the full workflow to a real business problem and prepare for interviews.
- Lesson 1550 minAnalytics Case Study — Customer Churn from Question to DashboardTake a churn question from stakeholder brief to SQL, analysis, a dashboard and a recommendation memo.
- Lesson 1645 minData Analyst Interview PrepSQL, statistics, product-metrics and case questions from data analyst interviews, with model answers and a take-home approach.
