Start a pilot

Programmes · Yaba Digital Skills Academy

Data analysis with Excel and Power BI

Clean messy data, build dashboards a manager will read, and present what they show. Ends with a project on a real Lagos business's sales data.

Apply nowSee the outline
Starts Mon 12 Oct
Fee₦250,000or 2 × ₦125,000; application fee ₦5,000
When12 weeksTue and Thu, 6 pm to 8:30 pm, from 12 Oct
Places3 leftof 32 in the October cohort

What you will be able to do

Clean messy data

Import, reshape and fix real exports from sales and finance systems.

Build dashboards

Power BI reports a manager can read in a minute.

Present findings

Explain what the figures show to the people who will act on them.

Course outline

  1. Weeks 1–3Excel for analysis: tables, lookups, pivot tables
  2. Weeks 4–6Power Query: cleaning and combining data
  3. Weeks 7–10Power BI: models, measures, dashboards
  4. Weeks 11–12Capstone on a Lagos business's sales data