Course Outline
MODULE 1: POWER BI
In this module, we will outline what Power BI offers, review the available products and their respective benefits, and explain how Power BI updates are distributed.
Lessons
- What is Power BI?
- Reviewing the Power BI Product Suite
- Identifying Differences Between Products
- Understanding Power BI Updates
Upon completing this module, students will be able to:
- Comprehend Power BI.
- Grasp the distinctions between various products.
- Comprehend Power BI update mechanisms.
MODULE 2: POWER BI DESKTOP
This module explores the steps required to install Power BI Desktop, navigates the interface, discusses supported file types and data sources, and details how to configure data refresh settings. It also covers available data types and shares best practices for their use.
Lessons
- Installing Power BI Desktop
- Exploring the Power BI Desktop Interface
- Utilizing File Types; PBIX vs PBIT
- Examining Data Sources
- Discussing Data Refresh
- Understanding Data Types
Lab 2: POWER BI DESKTOP
- Introduction to Power BI
- Upon completing this module, students will be able to:
- Comprehend and apply the installation of Power BI Desktop.
- Comprehend and apply PBIX and PBIT file types.
- Comprehend data sources, data refresh, and data types.
MODULE 3: WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
In this module, we will examine importing, transforming, loading, and manipulating data using CSV, TXT, and Excel Worksheets. Power BI handles these file types effortlessly.
Lessons
- Importing Data
- Transforming Data
- Loading Data
- Append Queries
- Working with Folders and Files
- Using Pivot Tables
Lab 3: WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
- Importing, Transforming, and Loading Data
- Append Queries
- Working with Folders and Files
- Using Pivot Tables
Upon completing this module, students will be able to:
- Comprehend and apply importing, transforming, and loading data.
- Comprehend and apply append queries.
- Comprehend and apply working with folders and files.
- Comprehend and apply using Pivot Tables.
MODULE 4: CONNECTING TO DATABASES
This module explores the process of connecting to databases and examining relationships.
Lessons
- Working with Relational Data
- Understanding Relationships
- Importing from SQL Server Analysis Services Multidimensional and Tabular
Lab 4: CONNECTING TO DATABASES
- Importing From SQL Server and Examining Relationships
- Importing From SSAS Multidimensional
Upon completing this module, students will be able to:
- Comprehend and apply importing from SQL Server and examining relationships.
- Comprehend relationships.
- Comprehend and apply importing from SSAS Multidimensional.
MODULE 5: MERGING, GROUPING, SUMMARIZING, AND CALCULATING DATA
This module discusses why merges were challenging in the past, highlights how much easier they are to use now, and explores grouping, summarizing, and calculating options.
Lessons
- Understanding the Challenges with Merges
- Performing Merges
- Grouping Options
- Summarizing
- Calculating
Lab 5: MERGING, GROUPING, SUMMARIZING, AND CALCULATING DATA
- Performing Merges
- Grouping and Summarizing
- Calculating
Upon completing this module, students will be able to:
- Comprehend and apply performing merges.
- Comprehend and apply grouping and summarizing.
- Comprehend and apply calculating.
MODULE 6: REPORTING
In this module, we will create a report and examine the available visualization options.
Lessons
- Creating Reports
- Utilizing the Matrix Visualization
- Utilizing the Map Visualization
- Utilizing the Card Visualization
- Utilizing the Chart Visualization
- Utilizing Slicers
- Publishing to Power BI Online
Lab 6: REPORTING
- Creating Reports
- Utilizing the Matrix Visualization
- Utilizing the Map Visualization
- Utilizing the Card Visualization
- Utilizing the Chart Visualization
- Utilizing Slicers
- Publishing to Power BI Online
- Upon completing this module, students will be able to:
- Comprehend and apply creating reports.
- Comprehend and apply the matrix visualization.
- Comprehend and apply the map visualization.
- Comprehend and apply the card visualization.
- Comprehend and apply the chart visualization.
- Comprehend and apply slicers.
- Comprehend and apply publishing to Power BI Online.
MODULE 7: POWER BI ONLINE
This module explores what Power BI Online is and reviews its features, then discusses mobile options.
Lessons
- Introduction to Power BI Online
- Importing Data
- Creating Reports
- Configuring Dashboards
- Sharing Reports and Dashboards
- Exploring Power BI Mobile
Lab 7: POWER BI ONLINE
- Exploring the Power BI Online Interface
- Importing Excel (.xlsx or .xlsm), Comma Separated Value (.csv), and Power BI Desktop (.pbix) Files
- Creating a Report
- Adding Filters to a Report
- Adding KPIs to a Report
- Creating a Dashboard
- Pinning Tiles
Upon completing this module, students will be able to:
- Comprehend and apply exploring the Power BI Online interface.
- Comprehend and apply importing data.
- Comprehend and apply creating reports.
- Comprehend and apply adding filters to a report.
- Comprehend and apply adding KPIs to a report.
- Comprehend and apply creating a dashboard.
- Comprehend and apply pinning tiles.
Requirements
A fundamental understanding of Excel and Databases
Testimonials (7)
Khobeib was great, so polite, clam and professional. Always willing to help or slow down if needed.
Nicole - Wellington City Council (WCC)
Course - Creating Dashboards Using Microsoft Power BI
the tool itself and what I didn't know about what it could do for us
Sam - Wellington City Council (WCC)
Course - Creating Dashboards Using Microsoft Power BI
The pace, activities and screen mirroring. Power Bi is new to me and I am looking forward to working with it more.
Michelle - Childhood Development Initiative CLG
Course - Creating Dashboards Using Microsoft Power BI
I liked everything!
Chana Wertheimer - Apex Global Solutions
Course - Creating Dashboards Using Microsoft Power BI
The interactive nature. Lots of hands on examples and not just lecture style and hand outs. I learn much better working the way it was taught to us
Derek Brown - Apex Global Solutions
Course - Creating Dashboards Using Microsoft Power BI
Very interactive, trainers were always open to answering questions and helping out if we were falling behind. Appreciated that they were able to customize the training to our needs and use the data sets we provided.
Audrey Bernard - Environment and Climate Change Canada
Course - Creating Dashboards Using Microsoft Power BI
Being able to follow along with hands-on examples
