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