Data Analytics
Clean messy data, find the story in it and present it so people act.
- Course fee
- ₦50,000
- Duration
- 4 weeks
- Sessions
- 8 · 2 per week
- You leave with
- A dashboard and an analysis note
About this course
Business analytics with the tools Nigerian companies actually run: advanced Excel, data cleaning, charts and dashboards, then reading and presenting findings. You finish with a dashboard built on a real messy dataset and a written recommendation.
What you will be able to do
- Clean and validate a messy real-world dataset
- Build pivot tables and summary analysis
- Choose the right chart and build dashboards
- Write findings and recommendations a manager can act on
The deliverable
Certificate requirement
A dashboard and an analysis note
An interactive Excel or Sheets dashboard over a real messy dataset, plus a one-page written analysis stating what the data shows and what to do about it.
How the course is assessed
Level 1
Know
You can explain the concept, name the tools involved and recognise the difference between doing it well and doing it carelessly.
Level 2
Do
You can perform the task independently, without the instructor repeating the steps, and fix the obvious problems when they appear.
Level 3
Create
You can use the skill to produce something a real person would pay for — a document, a design, a website, a report, a repaired machine.
Week by week
4 weeks, 8 practical sessions. Click any session to read the complete class lecture — objectives, taught content, the instructor demonstration, practice, mistakes to avoid, homework and the marking rubric.
Week 1 — Data & cleaning
Data types, structures, cleaning, validation and transformation.
Week 2 — Analysis
Formulas, lookups, pivot tables and summary statistics.
Week 3 — Visualisation
Chart selection, dashboards and layout.
Week 4 — Reporting
Interpretation, storytelling with data and the final project.
- Session 7105 min · 15 min read
Reading the Numbers
- Basic analysis
- Trends and comparisons
- Correlation vs causation
- Sample size honesty
- Session 8105 min · 15 min read
Storytelling & Final Project
- Storytelling with data
- Writing recommendations
- Presenting to a manager
- Final project: dashboard and analysis note
Data Analytics — questions
The things prospective students actually ask before enrolling.
Do I need to know programming?+
No. This course uses Excel and Google Sheets, which is what most Nigerian business analysis actually runs on. Python, SQL and Power BI are the natural next step and we tell you when it becomes worth learning them.
What level of Excel do I need before starting?+
You should be comfortable with basic formulas, sorting and filtering — the content of the Microsoft Office course's Excel sessions. If those feel unfamiliar, take Microsoft Office first.
Other courses in Office & Data
Microsoft Office
Documents, spreadsheets and presentations you can actually produce.
₦30,000 · 3 weeks
Typing & Computer Basics
Go from nervous around a computer to independently confident with one.
₦20,000 · 2 weeks
Data Entry
Accuracy first: handle real business data without introducing errors.
₦20,000 · 2 weeks