Prerequisites
Basic Excel knowledge
Familiarity with data concepts
Access to Windows computer
Microsoft account
All programmes
Data Science & Analytics
Data Analysis with Power BI
Turn raw data into clear dashboards, models, and business insights using Microsoft Power BI.
Tuition₦215,000VAT-inclusive where applicable. Instalment plans are available.
What you will learn
Graduate with skills you can demonstrate.
Build professional business dashboards
Explain insights to decision-makers
Prepare for analyst and BI reporting roles
Upcoming classes
Choose a published intake.
The next intake is being confirmed.
Admissions will confirm the start date, class time, learning format, and availability before you make a commitment.
Ask for the next class dateCurriculum
Your course curriculum.
8 modules / 8 weeks
01Week 1: Power BI Foundations and Data Connections
Power BI Desktop, Service, analytics workflow, and report views
Connect to Excel, CSV, folder, web, and database sources
Profile source data and define the business questions
02Week 2: Data Cleaning with Power Query
Correct types, errors, blanks, duplicates, and inconsistent values
Split, merge, pivot, unpivot, append, and combine data
Build repeatable refresh-ready queries
03Week 3: Data Modelling
Facts, dimensions, grain, star schemas, keys, and relationships
Build date and lookup tables and validate filter direction
Avoid ambiguous models and incorrect totals
04Week 4: DAX Fundamentals
Measures versus calculated columns
Aggregation, iteration, DIVIDE, variables, and filter context
Build reusable business measures and validate results
05Week 5: Advanced DAX and Time Intelligence
CALCULATE, FILTER, ALL, VALUES, and context transition
Period comparisons, running totals, moving averages, and variance
Diagnose incorrect measures systematically
06Week 6: Visual Analytics and Storytelling
Select appropriate charts, tables, cards, maps, and decomposition tools
Apply hierarchy, colour, accessibility, tooltips, drill-through, and bookmarks
Design a decision-ready multi-page report
07Week 7: Publishing, Security, and Performance
Workspaces, sharing, apps, gateways, scheduled refresh, and row-level security
Optimize models, measures, visuals, and report usability
Define ownership, access, and refresh operations
08Week 8: Business Intelligence Capstone
Model a realistic sales, finance, HR, or operations dataset
Build and publish an interactive management dashboard
Present findings, limitations, and actionable recommendations
Before the first class
Know what you need and where the course can take you.
Tools you will practise with
Power BI Desktop
Power Query
DAX
Excel data sources
Project experience
Build work worth showing.
Redesign a poorly structured management dashboard
Build a sales or operations performance report
Deliver a complete Power BI business-case capstone
Completion credential
Earn a verifiable Loctech certificate.
Verifiable Loctech certificate of completion. The curriculum substantially overlaps with the Microsoft PL-300 Power BI Data Analyst skills measured, while remaining focused on practical job readiness.
Questions answered
Before you apply.
Do I need Power BI experience?
No. The programme starts with Power BI foundations, but intermediate Excel confidence will help you progress faster.
Can I use Power BI Desktop on a Mac?
Power BI Desktop is a Windows application. Mac learners need access to Windows through a compatible virtual machine or Windows computer.
Do I need SQL?
No. Basic SQL is helpful, but the exercises include self-contained data sources and introduce database connections gently.
Does this prepare me for PL-300?
The curriculum covers many PL-300 skill areas, but the programme prioritises practical analytics and portfolio work rather than exam coaching alone.
Keep exploring
Related programmes.
Data Science & Analytics
AI Automation
6 weeks / Instructor-led
Data Science & Analytics
Artificial Intelligence & Machine Learning
16 weeks / Instructor-led
Data Science & Analytics