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