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
Prerequisites
Basic proficiency with computers and office applications
Prior experience working with data tables in Excel or similar tools
Familiarity with basic data concepts (rows, columns, tables)
No prior Power BI or DAX knowledge is required (covered from scratch during the training)
Learning Outcomes
Understand the core components and architecture of Power BI
Ingest data from multiple sources and prepare it for analysis
Clean and transform data using Power Query
Build data models and establish relationships across tables
Write foundational DAX expressions for custom calculations
Design interactive reports and dashboards
Contribute to decision-support processes through effective data visualization
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
-
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
-
Moving Power BI Premium/Pro environments to Fabric capacity, converting dataflows to Gen2 and sources to Lakehouse and Direct Lake, so BI teams produce a risk-controlled migration roadmap.
- Live Course
- 6 modules
Get in touch
