Length
12 weeks
Four stages, one capstone
Classes
3 a week
Live, with a task in every class
Where
Ibadan or online
Old Bodija centre or live online
You finish with
A certificate
Plus a Power BI dashboard
The tools you’ll use
- Excel
- Power Query
- Power Pivot
- DAX
- Power BI
What you’ll learn, stage by stage
Twelve weeks in four stages, with a hands-on task in every class and a dashboard capstone at the end.
- Weeks 1–301
Excel foundations
- Formulas and functions you will use every day
- Sorting, filtering and tables
- PivotTables to summarise thousands of rows
- Charts that tell a clear story
- Weeks 4–602
Clean and shape data with Power Query
- Bring in data from files and folders
- Fix messy columns, dates and duplicates
- Merge and append tables
- Steps that refresh with new data
- Weeks 7–903
Model data with Power Pivot and DAX
- Relationships between tables
- Building a data model
- Calculated columns and measures in DAX
- Comparing months, quarters and years
- Weeks 10–1204
Power BI dashboards and capstone
- Visuals, layout and colour
- Filters, slicers and drill-down
- Sharing a report people can use
- Capstone: a dashboard on a real dataset
Projects
What you’ll build
Real work you can show people, built with examples from home.
Project 1
A sales report for a Bodija shop
Summarise a month of sales in naira with PivotTables and charts, and spot the best-selling items.
Project 2
Clean a messy export
Take a real-world spreadsheet full of gaps and typos and turn it into a tidy table with Power Query.
How every lesson runs
5–10 min
Recap
What we covered last time, and today’s question.
15–20 min
Teach
One new idea, explained with real examples.
10 min
Live demo
Watch it done, step by step, on screen.
20 min
You build it
Hands-on practice while instructors help.
5 min
Check
Quick questions to lock it in.
Finish with a capstone and a certificate
In the last weeks you build a dashboard on a real dataset and present what it shows. When you finish, you receive a PractiCode Academy certificate of completion in the name you gave us when you enrolled.
FAQs
Questions people ask us
Quick answers about classes, payment and SIWES. Can’t find yours? We reply on WhatsApp.
Still have a question?
Message our team and we’ll get back to you the same day.
01Do I need any experience?
No. Data Analysis starts with Excel basics and builds up to Power BI dashboards.
02Can I join online?
Yes. Every class runs onsite at our centre in Old Bodija, Ibadan, and live online at the same time.
03How much does it cost?
You’ll see the full fee on the enrolment form before you pay anything. SIWES and IT students get 50% off tuition.
04What do I finish with?
A Power BI dashboard built on real data, the reports you made each week, and a PractiCode Academy certificate of completion.
Start Data Analysis with us.
Registration takes about five minutes, and you’ll see the fee before you pay.