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.
14 modules / 8 weeks
01Introduction to Data Analysis with Power BI
Introduction to Data Analysis
Understanding Power BI
Download & Install PowerBI
02Introduction to Power BI
Installing Power BI Desktop
Introduction to Power BI
Power BI vs Excel
Other Power BI applications and their functions
03Power BI Environment
Power BI Views
Query Editor - Basic data cleaning
Working with the attached project files
Files from folder
04Data Transformation and Cleaning
Connecting to data sources
The Query Editor
Data types in Power BI
Transforming and cleaning various data sets
Cracking the first simple visualization
05Data Preparation and Modelling Fundamentals
One to Many relationships in Power BI
Grouping and Appending queries
Merging columns and queries
Managing relationships in Power BI
Fact-Dimension model
06Essential Data Visualizations and Functionalities
Best practices for Power BI visualizations
Tables with line, column/bar, pie/donut, and area charts
Date Hierarchy and drill down
Pivoting and Unpivoting columns in Power BI
Many to many relationships and their directionality
Drill through and filtering reports
07Dashboard Creation
Dashboard design principles
Layout standards
Color theory for dashboards
Avoiding clutter
How to present insights to stakeholders
08Mid-Project
Hands-on project in e-commerce, economics, HR, or health-related datasets aimed at applying newly acquired skills
09Advanced Data Visualizations and Functionalities 1
Map Visualization, slicers and tooltips
Editing interactions
Custom columns, conditional columns and columns from examples
Summarizing data using average, min, % Grand Total etc.
Using parameters to get data from a web page
10Advanced Data Visualizations and Functionalities 2
Drill through with buttons and bookmarks
Forecasting using built-in tools
Seasonality and confidence interval for forecasting
11DAX Essentials
Introduction to DAX
Calculated Columns and text functions (LEFT, LEN, CONCAT, REPLACE etc.)
Measures and mathematical functions (SUMX, AVERAGEX, COUNT, ROUND etc.)
12Advanced DAX Functions
ALL, ALLEXCEPT, ALLSELECTED
DATEADD and DATEYTD for advanced analysis
Realistic use cases
13Publishing Your First Report
Publishing first report using Power BI Pro (if available)
Viewing report in a mobile and on a browser
Refreshing the published report
14Final Project
A comprehensive project utilizing real-world datasets from e-commerce, economics, HR, or health
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