← All courses
Beginner friendly14 weeks45 lessons9 assignments
Watch a free lesson

Data Analysis

Turn messy spreadsheets into decisions people act on, starting from zero. Clean real exports, answer business questions with Google Sheets, Excel and SQL, think clearly with numbers, build dashboards a manager can read without you, handle personal data lawfully, and finish with a portfolio analysis that gets you hired.

Instructor: Alex Olam

Membership

Sign up to enroll

Recently in this course

  • EzekelefinishedExcel, Google Sheets, or both?5 days ago

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?
  • Audit a Real Export Before Anyone Trusts ItAssignment

Module 2

Cleaning data properly

  • 2.1The five things that break a spreadsheet▶ Watch free preview
  • 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
  • Clean the Bisi Export and Prove Every NumberAssignment

Module 3

Formulas that answer questions

  • 3.1SUM, COUNT and AVERAGE without embarrassing yourself▶ Watch free preview
  • 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
  • Answer Eight Business Questions With Live FormulasAssignment

Module 4

Thinking with numbers

  • 4.1Averages that mislead: mean, median and mode▶ Watch free preview
  • 4.2Spread: ranges, percentiles and standard deviation
  • 4.3Percentages, percentage points and growth rates
  • 4.4Samples, bias and how much data is enough
  • 4.5Correlation, causation and fair comparisons
  • Audit a Report Where Every Number Is CorrectAssignment

Module 5

Pivot tables and summarising

  • 5.1Your first pivot table▶ Watch free preview
  • 5.2Group dates into months, quarters and years
  • 5.3Change the calculation: count, average, percent of total
  • 5.4Slicers and filters for exploring
  • 5.5Calculated fields for margin and growth
  • Build the Summary Table Bisi Actually NeedsAssignment

Module 6

SQL for analysts

  • 6.1Why analysts learn SQL even with Excel▶ Watch free preview
  • 6.2SELECT, WHERE and ORDER BY
  • 6.3GROUP BY: the pivot table of SQL
  • 6.4JOINs without fear
  • 6.5Dates and ranges in SQL
  • Answer Bisi in SQL, and Find What the Database HidesAssignment

Module 7

Charts and dashboards

  • 7.1Choose the right chart for the question▶ Watch free preview
  • 7.2Charts that tell the truth: axes, scales and clutter
  • 7.3Conditional formatting that highlights, not decorates
  • 7.4Build a one-page dashboard
  • 7.5Share a live dashboard online
  • Build the Dashboard Bisi Reads in Thirty SecondsAssignment

Module 8

Telling the story and handling data responsibly

  • 8.1Write findings a busy manager will act on▶ Watch free preview
  • 8.2Present numbers people understand
  • 8.3Personal data and the Nigeria Data Protection Act
  • 8.4Anonymise before you share
  • 8.5Check your work before anyone else does
  • Write the Report, and Make the Data Safe to SendAssignment

Module 9

Capstone: dashboard and report

  • 9.1Choose a dataset and a question worth answering▶ Watch free preview
  • 9.2Run the full analysis, from raw export to answer
  • 9.3Package it as a portfolio piece
  • 9.4Present your analysis in an interview
  • 9.5Get paid: data jobs, freelancing and clients
  • Capstone: One Analysis of Your Own, Finished and PublishedAssignment

🔒 Assignments open once you've finished the lessons and quizzes in their module. They're marked by an instructor and count towards your certificate.