DataAnalyticsIntermediate
Data Analytics & Visualization
Master dashboards, statistical analysis, and storytelling with data — from spreadsheets to Python. Learn to clean messy datasets, build interactive dashboards in Tableau and Power BI, and turn raw numbers into decisions that move businesses forward.
P
Prof. Ochieng
Instructor
4.9rating1,456 students49 lessons22 hours
WHAT YOU'LL LEARN
- Complete 49 lessons across 12 modules
- Master foundations of data analytics
- Master spreadsheets: excel & google sheets
- Master data cleaning & transformation
- Master sql for analysts
- Master python for data analysis
CURRICULUM
01Foundations of Data Analytics4 lessons
What Is Data Analytics?Preview
22 minThe Analyst's Workflow
41 minTypes of Data & Variables
43 minSetting Up Your Toolkit
26 min02Spreadsheets: Excel & Google Sheets4 lessons
Formulas & Functions
40 minPivotTables Deep Dive
31 minLookup Functions (VLOOKUP, XLOOKUP, INDEX/MATCH)
25 minConditional Formatting for Insight
24 min03Data Cleaning & Transformation4 lessons
The Tidy Data Principle
32 minHandling Missing Values
44 minDeduplication & Normalization
19 minPower Query for Repeatable Pipelines
26 min04SQL for Analysts4 lessons
SELECT, WHERE, ORDER BY
18 minJOINs: INNER, LEFT, RIGHT, FULL
23 minGROUP BY & Aggregate Functions
22 minWindow Functions & CTEs
35 min05Python for Data Analysis4 lessons
Python & Jupyter Setup
24 minpandas DataFrames Essentials
18 minData Wrangling with pandas
34 minWorking with Dates & Time Series
17 min06Exploratory Data Analysis4 lessons
Summary Statistics & Distributions
35 minFinding Outliers & Anomalies
18 minCorrelation vs. Causation
41 minGenerating Your First Hypotheses
23 min07Statistics for Analysts4 lessons
Probability Foundations
31 minSampling & Confidence Intervals
26 minHypothesis Testing in Practice
43 minA/B Testing for Product Decisions
21 min08Data Visualization Principles4 lessons
Choosing the Right Chart
30 minColor, Contrast & Accessibility
35 minChart Junk & the Data-Ink Ratio
39 minDesigning for the Reader's Eye
15 min09Charts in Python: matplotlib & seaborn4 lessons
Plotting with matplotlib
37 minStatistical Charts with seaborn
44 minCustomising for Publication
42 minInteractive Charts with Plotly
44 min10Dashboards with Tableau & Power BI4 lessons
Tableau: Connecting & Modelling Data
34 minBuilding Your First Tableau Dashboard
44 minPower BI: DAX Basics
29 minPublishing & Sharing Dashboards
37 min11Storytelling with Data4 lessons
Framing the Business Question
17 minNarrative Arcs for Reports
20 minDesigning Executive Summaries
21 minPresenting to Non-Technical Audiences
28 min12Capstone: End-to-End Analytics Project5 lessons
Project Brief & Dataset Walkthrough
24 minCleaning & Modelling the Data
40 minBuilding the Dashboard
23 minDelivering the Final Presentation
30 minNext Steps & Career Pathways
25 min