About the Course
Microsoft Power BI Fundamentals teaches beginners in business intelligence and data visualization how to use Power BI from the ground up. The training covers connecting to data sources, foundational data modeling, and building interactive reports and visuals.
Target Audience
First-time Power BI users
Professionals looking to perform foundational data analysis and reporting
Users who want to visualize their Excel datasets
Professionals stepping into business intelligence tools
Learning Outcomes
Understand the Power BI interface and core workflow
Connect to multiple data sources
Perform foundational data modeling operations
Create clear reports and interactive visuals
Conduct foundational data analysis with Power BI
Curriculum
Module 1 – Introduction to Power BI and Core Concepts
What Is Power BI?
Business Intelligence (BI) concept
Power BI use cases
Power BI Desktop, Service, and Mobile components
Power BI Interface
Report, data, and model views
Basic navigation and workflow
Module 2 – Connecting to Data Sources
Data Sources
Excel workbooks
CSV and text files
Connecting to databases (foundational level)
Data Ingestion Process
Importing data
Data refresh mechanics
Module 3 – Data Preparation with Power Query
Power Query Fundamentals
Data cleaning
Column and row operations
Transformation Operations
Filtering and sorting
Combining queries (Merge / Append)
Data types and resolving errors
Module 4 – Data Modeling
Data Model Concepts
Table relationships
Primary key and foreign key concepts
Modeling
Relationship cardinality types
Introduction to the Star Schema
Module 5 – Introduction to DAX
What Is DAX?
Difference between Measures and Calculated Columns
DAX syntax
Basic DAX Functions
SUM, AVERAGE, COUNT
Simple calculations and ratios
Module 6 – Reports and Visualization
Visual Types
Tables and matrices
Column, line, and pie charts
Report Design
Selecting effective visuals
Page layout and alignment
Module 7 – Interactive Dashboard Design
Interactivity Tools
Filters
Slicers
User Experience
Cross-filtering and visual interactions
Clean and readable dashboard design
Module 8 – Publishing and Sharing
Power BI Service
Publishing reports
Creating dashboards
Sharing and Security: Authorization concepts
Basic sharing scenarios
Module 9 – Applied Power BI Project
End-to-End Application
Data ingestion → modeling → reporting
Building a dashboard from a real business scenario
Review
Best practices
Participant Q&A and feedback
Other Courses in This Category
-
Power BI Essentials
Comprehensive Power BI training for business intelligence teams covering Power Query ETL, relational Star Schema modeling, DAX calculations, Power BI Service, and executive dashboards.
- Live Course
- 9 modules
-
Chart selection, visual perception principles, colour and hierarchy, and data storytelling for analysts and reporting teams who need decision-focused dashboards and presentations that cannot be misread.
- Live Course
- 6 modules
-
Advanced DAX patterns, calculation groups, row-level security, incremental refresh, composite models and performance tuning for experienced Power BI users building enterprise-scale reporting solutions.
- Live Course
- 6 modules
-
Star schema design, fact and dimension tables, relationships and filter direction, date tables and core-to-intermediate DAX measures, so analysts build Power BI models that return correct, maintainable results.
- Live Course
- 6 modules
-
Importing from multiple sources, cleaning, merging, unpivoting, parameters, custom functions and M language basics in Power Query, so Excel and Power BI users automate manual data preparation.
- Live Course
- 6 modules
-
OneLake, Lakehouse, Data Warehouse, Data Factory pipelines, Dataflow Gen2, notebooks and Direct Lake Power BI, giving data and BI teams an end-to-end introduction to Microsoft Fabric components.
- Live Course
- 6 modules
Get in touch
