Course Outline
MODULE 1: POWER BI
This module outlines the value provided by Power BI, reviews the available product lineup and their respective benefits, and explains how Power BI updates are distributed.
Lessons
- Defining Power BI?
- Reviewing the Power BI Product Suite
- Differentiating Between Products
- Understanding Power BI Update Mechanisms
After completing this module, learners will be able to:
- Grasp the core concepts of Power BI.
- Distinguish between various products.
- Comprehend Power BI update processes.
MODULE 2: POWER BI DESKTOP
In this section, we will cover the installation procedure for Power BI Desktop, navigate the interface, review supported file types and data sources, and configure data refresh settings. We will also address available data types and discuss best practices for their application.
Lessons
- Installing Power BI Desktop
- Navigating the Power BI Desktop Interface
- Utilizing File Types; PBIX vs PBIT
- Examining Data Sources
- Discussing Data Refresh Configurations
- Understanding Data Types
Lab 2: POWER BI DESKTOP
- Introduction to Power BI
- After completing this module, learners will be able to:
- Understand and execute the installation of Power BI Desktop.
- Understand and utilize PBIX and PBIT file types.
- Comprehend data sources, data refresh mechanisms, and data types.
MODULE 3: WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
This module investigates importing, transforming, loading, and manipulating data using CSV, TXT, and Excel Worksheets. Power BI manages these file formats efficiently.
Lessons
- Importing Data
- Transforming Data
- Loading Data
- Appending Operations
- Managing Folders and Files
- Using Pivot Tables
Lab 3: WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
- Importing, Transforming, and Loading Data
- Appending Operations
- Managing Folders and Files
- Using Pivot Tables
After completing this module, learners will be able to:
- Understand and execute data import, transformation, and loading.
- Understand and execute appending operations.
- Understand and execute working with folders and files.
- Understand and execute using Pivot Tables.
MODULE 4: CONNECTING TO DATABASES
This module explores the process of connecting to databases and examines data 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
After completing this module, learners will be able to:
- Understand and execute importing from SQL Server and examining relationships.
- Comprehend relationships.
- Understand and execute importing from SSAS Multidimensional.
MODULE 5: MERGING, GROUPING, SUMMARIZING, AND CALCULATING DATA
In this module, we will discuss why merges were previously challenging, demonstrate how simpler they are to use today, and explore options for grouping, summarizing, and calculating.
Lessons
- Understanding Merge Challenges
- Performing Merges
- Grouping Options
- Summarizing
- Calculating
Lab 5: MERGING, GROUPING, SUMMARIZING, AND CALCULATING DATA
- Performing Merges
- Grouping and Summarizing
- Calculating
After completing this module, learners will be able to:
- Understand and execute performing merges.
- Understand and execute grouping and summarizing.
- Understand and execute calculating.
MODULE 6: REPORTING
In this module, we will construct a report and evaluate 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
- After completing this module, learners will be able to:
- Understand and execute creating reports.
- Understand and utilize the matrix visualization.
- Understand and utilize the map visualization.
- Understand and utilize the card visualization.
- Understand and utilize the chart visualization.
- Understand and utilize slicers.
- Understand and utilize publishing to Power BI Online.
MODULE 7: POWER BI ONLINE
In this module, we will define Power BI Online, review its features, and discuss mobile accessibility 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
After completing this module, learners will be able to:
- Understand and execute exploring the Power BI Online interface.
- Understand and execute importing data.
- Understand and execute creating reports.
- Understand and execute adding filters to a report.
- Understand and execute adding KPIs to a report.
- Understand and execute creating a dashboard.
- Understand and execute pinning tiles.
Requirements
A fundamental grasp 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
