Intermediate10 weeks30 lessons
Watch a free lessonData Analysis
Turn messy spreadsheets into decisions. Clean real data, answer business questions with Excel and SQL, and build dashboards a manager can act on without asking you to explain them.
Instructor: Alex Olam
Course content
Module 1: The analyst's real job
- 1.1What analysts actually spend their time on▶ Watch free preview
- 1.2Never edit the raw data: the three-sheet habit
- 1.3Turn a vague request into an answerable question
- 1.4Get data out of a POS, bank or portal export
- 1.5Excel, Google Sheets, or both?
Module 2: Cleaning data properly
- 2.1The five things that break a spreadsheet
- 2.2Fix numbers and naira amounts stored as text
- 2.3Fix dates that sort in the wrong order
- 2.4Deduplicate names that were typed four ways
- 2.5Convert to a Table and lock in your structure
Module 3: Formulas that answer questions
- 3.1SUM, COUNT and AVERAGE without embarrassing yourself
- 3.2Absolute and relative references
- 3.3IF and nested conditions for flags
- 3.4SUMIFS and COUNTIFS: totals by category
- 3.5XLOOKUP to join two sheets
Module 4: Pivot tables and summarising
- 4.1Your first pivot table
- 4.2Group dates into months, quarters and years
- 4.3Change the calculation: count, average, percent of total
- 4.4Slicers and filters for exploring
- 4.5Calculated fields for margin and growth
Module 5: SQL for analysts
- 5.1Why analysts learn SQL even with Excel
- 5.2SELECT, WHERE and ORDER BY
- 5.3GROUP BY: the pivot table of SQL
- 5.4JOINs without fear
- 5.5Dates and ranges in SQL
Module 6: Capstone: dashboard and report
- 6.1Choose the right chart for the question
- 6.2Build a one-page dashboard
- 6.3Conditional formatting that highlights, not decorates
- 6.4Write findings a busy manager will act on
- 6.5Package it as a portfolio piece
Membership