Our Solutions Contact Us

2 of 4

Microsoft Power BI Data Analyst

Part of Data Analytics Programme

Module 1

Microsoft Excel: Beginner to Advanced

Module 2

Module 3

Database Engineering with SQL

Module 4

Business Intelligence For Professionals

Duration

2 Weeks (12+ Hours)

Classes

3 per week (2 Hours each)

Mode

Hybrid (Online & Onsite)

Certificate

Certificate of Completion

About This Module

This module introduces you to microsoft power bi data analyst and teaches you the essential skills needed to work confidently on real-world projects.

You'll build confidence with practical exercises, guided instruction, and a strong foundation before moving to the next module.

Curriculum Overview

Explore what you'll learn in this module.

1Introduction to Power BI6 Lessons

Introduction to business intelligence
Role of a Power BI data analyst
Power BI Desktop and Power BI Service
Navigating the Power BI interface
Importing Excel and CSV datasets
Creating basic visualizations

2Data Preparation and Transformation7 Lessons

Connecting to different data sources
Introduction to Power Query
Changing data types
Handling blanks, errors and duplicates
Splitting and merging columns
Appending and merging tables
Data profiling and validation

3Data Modelling7 Lessons

Understanding fact and dimension tables
Creating table relationships
Primary and foreign keys
Cardinality and filter direction
Star and snowflake schemas
Creating a date table
Basic model optimization

4DAX and Data Analysis7 Lessons

Introduction to DAX
Calculated columns and measures
SUM, COUNT, AVERAGE and DIVIDE
Using CALCULATE
Row context and filter context
Basic time-intelligence calculations
Creating business KPIs

5Reports, Visualizations and Dashboards8 Lessons

Tables, matrices and charts
Cards and KPI visuals
Maps and geographical analysis
Filters and slicers
Drill-down and drill-through
Conditional formatting
Buttons, bookmarks and tooltips
Dashboard design and data storytelling

6Publishing, Security and Capstone Project8 Lessons

Publishing reports to Power BI Service
Creating and managing workspaces
Sharing reports and dashboards
Configuring scheduled refresh
Row-level security
Creating mobile-friendly reports
Building an interactive business dashboard
Presenting findings and recommendations

Some of our students work at

Other Modules in This Programme

Module 1

Microsoft Excel: Beginner to Advanced

Continue building your skills with the next part of this programme.

View Module

Module 3

Database Engineering with SQL

Continue building your skills with the next part of this programme.

View Module

Module 4

Business Intelligence For Professionals

Continue building your skills with the next part of this programme.

View Module

Full Programme

Data Analytics Programme

Unlock all modules and complete the full learning journey.

View Full Programme

Ready to start your journey?

Join thousands of learners building in-demand tech skills.

Enroll Now