Beginner · Free course
Data Analytics with Python
Clean, analyse and visualise real data with pandas.
90 lessons24 videos so far5 h 37 min of videoNotes for every lesson
What you’ll learn
- NumPy and pandas
- Cleaning and reshaping data
- Visualisation
- Analysis projects
0 of 90 complete
Curriculum
- 1What a data analyst does, and the analysis workflow12 min
- 2Data, datasets and types of datasoon
- 3Setting up: Jupyter, Colab and Python environmentssoon
- 4Python for data 1: variables, types and operators28 min
- 5Python for data 2: lists, tuples, dicts and sets14 min
- 6Python for data 3: conditions, loops and comprehensions13 min
- 7Python for data 4: functions, errors and files17 min
- 8NumPy 1: arrays and vectorised maths19 min
- 9NumPy 2: indexing, masks, reshaping and axes17 min
- 10NumPy 3: broadcasting, random numbers and NaN16 min
- 11pandas 1: the Series14 min
- 12pandas 2: the DataFramesoon
- 13pandas 3: reading and writing CSV, Excel, JSON and Parquet17 min
- 14pandas 4: selecting with [], loc and iloc11 min
- 15pandas 5: filtering rows12 min
- 16pandas 6: sorting, ranking and creating columnssoon
- 17pandas 7: apply, map, binning and method chaining14 min
- 18Data quality and profiling before cleaning11 min
- 19Cleaning 1: missing values13 min
- 20Cleaning 2: duplicates and data types12 min
- 21Cleaning 3: text data and regular expressions10 min
- 22Cleaning 4: dates and times13 min
- 23Cleaning 5: outliers, validation and sanity checks11 min
- 24GroupBy 1: split-apply-combine and aggregation10 min
- 25GroupBy 2: transform, filter and MultiIndex13 min
- 26Combining data: concat, merge and join13 min
- 27Reshaping: pivot, pivot_table, melt and crosstab11 min
- 28Time series in pandas: resample, rolling and shift16 min
- 29Working with bigger data: memory, speed and Parquetsoon
- 30Charts 1: matplotlib basicssoon
- 31Charts 2: histograms, scatter, box plots and subplotssoon
- 32Charts 3: choosing the right chartsoon
- 33Charts 4: seaborn for statistical plotssoon
- 34Descriptive statistics 1: averagessoon
- 35Descriptive statistics 2: spread and percentilessoon
- 36Descriptive statistics 3: shape, skew and z-scoressoon
- 37EDA 1: exploring one variable at a timesoon
- 38EDA 2: relationships between variablessoon
- 39Probability 1: events, rules and conditional probabilitysoon
- 40Probability 2: Bayes' theorem and base ratessoon
- 41Random variables and discrete distributionssoon
- 42Continuous distributions and the normal curvesoon
- 43Sampling methods and sampling biassoon
- 44Sampling distributions and the central limit theoremsoon
- 45Estimation: confidence intervals and the bootstrapsoon
- 46Hypothesis testing 1: the framework and p-valuessoon
- 47Hypothesis testing 2: t-tests and z-testssoon
- 48Hypothesis testing 3: chi-square, ANOVA and non-parametric testssoon
- 49Hypothesis testing 4: multiple testing and practical significancesoon
- 50Correlation, causation and confoundingsoon
- 51Regression 1: simple linear regressionsoon
- 52Regression 2: multiple regression and its assumptionssoon
- 53Regression 3: logistic regression and prediction basicssoon
- 54Excel for analysts 1: formulas and lookupssoon
- 55Excel for analysts 2: PivotTables and Power Querysoon
- 56SQL for analysts 1: querying databases from Pythonsoon
- 57SQL for analysts 2: CTEs, window functions and DuckDBsoon
- 58Power BI 1: Power Query and the data modelsoon
- 59Power BI 2: DAX measures and report designsoon
- 60Dashboards in Python: Plotly and Streamlitsoon
- 61Metrics and KPIs: defining what to measuresoon
- 62Revenue and growth metricssoon
- 63Engagement metrics: DAU, MAU and stickinesssoon
- 64Funnel analysissoon
- 65Cohort analysissoon
- 66Retention and churnsoon
- 67LTV, CAC and marketing attributionsoon
- 68Customer segmentation with RFMsoon
- 69Pareto, ABC analysis and market basket analysissoon
- 70A/B testing 1: designing an experimentsoon
- 71A/B testing 2: analysing resultssoon
- 72A/B testing 3: pitfalls and quasi-experimentssoon
- 73Time series concepts: trend, seasonality and stationaritysoon
- 74Forecasting 1: baselines, smoothing and error metricssoon
- 75Forecasting 2: ARIMA, Prophet and prediction intervalssoon
- 76Storytelling with data: from chart to insightsoon
- 77The analyst's workflow: framing problems and finding root causessoon
- 78Getting data from APIs and the websoon
- 79How analytics data is built: warehouses, ETL and dbtsoon
- 80Reproducible, responsible analysis: Git, structure and ethicssoon
- 81Interview prep 1: Python and pandas questionssoon
- 82Interview prep 2: SQL questions for analystssoon
- 83Interview prep 3: statistics and A/B testing questionssoon
- 84Interview prep 4: product sense, metrics and business casessoon
- 85Interview prep 5: portfolio, resume and take-home assignmentssoon
- 86Project 1: retail sales analysis end to endsoon
- 87Project 2: app user behaviour: funnels, cohorts and retentionsoon
- 88Project 3: analysing an A/B test of a checkout redesignsoon
- 89Project 4: cricket stats deep divesoon
- 90Capstone: forecasting sales and shipping a dashboardsoon