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
37 minThe Analyst's Workflow
33 minTypes of Data & Variables
41 minSetting Up Your Toolkit
37 min02Spreadsheets: Excel & Google Sheets4 lessons
Formulas & Functions
30 minPivotTables Deep Dive
33 minLookup Functions (VLOOKUP, XLOOKUP, INDEX/MATCH)
35 minConditional Formatting for Insight
22 min03Data Cleaning & Transformation4 lessons
The Tidy Data Principle
44 minHandling Missing Values
26 minDeduplication & Normalization
26 minPower Query for Repeatable Pipelines
29 min04SQL for Analysts4 lessons
SELECT, WHERE, ORDER BY
20 minJOINs: INNER, LEFT, RIGHT, FULL
19 minGROUP BY & Aggregate Functions
19 minWindow Functions & CTEs
27 min05Python for Data Analysis4 lessons
Python & Jupyter Setup
37 minpandas DataFrames Essentials
21 minData Wrangling with pandas
34 minWorking with Dates & Time Series
28 min06Exploratory Data Analysis4 lessons
Summary Statistics & Distributions
18 minFinding Outliers & Anomalies
43 minCorrelation vs. Causation
28 minGenerating Your First Hypotheses
23 min07Statistics for Analysts4 lessons
Probability Foundations
19 minSampling & Confidence Intervals
32 minHypothesis Testing in Practice
27 minA/B Testing for Product Decisions
33 min08Data Visualization Principles4 lessons
Choosing the Right Chart
26 minColor, Contrast & Accessibility
40 minChart Junk & the Data-Ink Ratio
22 minDesigning for the Reader's Eye
28 min09Charts in Python: matplotlib & seaborn4 lessons
Plotting with matplotlib
41 minStatistical Charts with seaborn
20 minCustomising for Publication
30 minInteractive Charts with Plotly
31 min10Dashboards with Tableau & Power BI4 lessons
Tableau: Connecting & Modelling Data
37 minBuilding Your First Tableau Dashboard
27 minPower BI: DAX Basics
39 minPublishing & Sharing Dashboards
29 min11Storytelling with Data4 lessons
Framing the Business Question
19 minNarrative Arcs for Reports
24 minDesigning Executive Summaries
44 minPresenting to Non-Technical Audiences
19 min12Capstone: End-to-End Analytics Project5 lessons
Project Brief & Dataset Walkthrough
43 minCleaning & Modelling the Data
31 minBuilding the Dashboard
32 minDelivering the Final Presentation
34 minNext Steps & Career Pathways
22 min