📊 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

SQLpandas DataFrames

Part of these career paths

Machine Learning EngineerAnalytics Engineer & Data AnalystData ScientistData Analyst

Module 1 · Analyst Toolkit

The tools an analyst uses every day, before any statistics.

  1. 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.
  2. 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.
  3. 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.
  4. 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.

  1. Lesson 0535 minDescriptive Statistics and DistributionsMean, median, percentiles, spread, skew, and outliers; reading histograms and box plots; and choosing the right summary.
  2. Lesson 0635 minSampling and Confidence IntervalsPopulations versus samples, sampling bias, the central limit theorem, standard error, and confidence intervals in Python.
  3. 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.
  4. 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.

  1. Lesson 0935 minDefining Metrics and KPIsNorth-star and guardrail metrics, funnels, cohorts, retention, writing a metric definition, and building a metrics layer.
  2. 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.
  3. 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.

  1. 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.
  2. 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.
  3. 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.

  1. 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.
  2. Lesson 1645 minData Analyst Interview PrepSQL, statistics, product-metrics and case questions from data analyst interviews, with model answers and a take-home approach.