Guided path
Data Analytics
Learn how to frame analytical questions, work in Excel/SQL/Python, clean and reshape tabular data, perform EDA, build visualisations and communicate evidence.
52 core steps93 detailed lessons13 modules
01
Module 1 · 5 detailed lessons
Analytics Thinking & Problem Framing
1
Browse all 5 lessons in this module →What Data Analytics isPython · Workflow
Open →2Descriptive Diagnostic Predictive and Prescriptive AnalyticsPython · Workflow
Open →3KPIs Dimensions and MeasuresPython · Workflow
Open →4The End to End Analytics WorkflowPython · Workflow
Open →02
03
Module 3 · 15 detailed lessons
Excel & Spreadsheet Analytics
1
Browse all 15 lessons in this module →Workbook Worksheet and Table AnatomyExcel · Spreadsheet
Open →2Lookup Analysis with XLOOKUPExcel · Spreadsheet
Open →3Pivottables for Grouped AnalysisExcel · Spreadsheet
Open →4Spreadsheet Mini Project Sales Performance WorkbookExcel · Spreadsheet
Open →04
05
06
Module 6 · 8 detailed lessons
Data Cleaning & Missing Data
1
Browse all 8 lessons in this module →Detect Missing ValuesPython · Missing
Open →2Deletion vs ImputationPython · Missing
Open →3DuplicatesPython · Workflow
Open →4Outlier ChecksPython · Workflow
Open →07
08
Module 8 · 7 detailed lessons
Exploratory Data Analysis
1
Browse all 7 lessons in this module →Frequency TablesPython · Workflow
Open →2Boxplots and OutliersPython · Plot
Open →3CorrelationPython · Correlation
Open →4EDA ChecklistPython · Workflow
Open →09
Module 9 · 8 detailed lessons
Visualisation & Storytelling
1
Browse all 8 lessons in this module →Chart SelectionPython · Plot
Open →2Line ChartsPython · Plot
Open →3Labels and AnnotationsPython · Plot
Open →4Avoid Misleading ChartsPython · Plot
Open →10
11
12
13
Module 13 · 6 detailed lessons
Capstone Analytics Project
1
Browse all 6 lessons in this module →Frame a Business QuestionPython · Workflow
Open →2Perform EDAPython · Workflow
Open →3Create Final VisualsPython · Plot
Open →4Write an Evidence Based RecommendationPython · Workflow
Open →