Course Outline
MODULE 1: POWER BI
This module clarifies the value proposition of Power BI, reviews the available product offerings and their benefits, and explains how Power BI updates are delivered.
Lessons
- Defining Power BI
- Overview of the Power BI Product Suite
- Distinguishing Between Product Features
- Navigating Power BI Updates
After completing this module, students will be able to:
- Comprehend the core concepts of Power BI.
- Identify distinctions between various products.
- Grasp the mechanism of Power BI updates.
MODULE 2: POWER BI DESKTOP
In this module, we will outline the steps for installing 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 use.
Lessons
- Installing Power BI Desktop
- Navigating the Power BI Desktop Interface
- Utilizing File Types: PBIX versus PBIT
- Inspecting Data Sources
- Managing Data Refresh
- Understanding Data Types
Lab 2: POWER BI DESKTOP
- Introduction to Power BI
- Understand and apply the installation of Power BI Desktop.
- Understand and apply the use of PBIX and PBIT file formats.
- Understand data sources, data refresh mechanisms, and data types.
MODULE 3: WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
This module covers importing, transforming, loading, and manipulating data using CSV, TXT, and Excel files. Power BI processes these file types efficiently.
Lessons
- Importing Data
- Transforming Data
- Loading Data
- Appending Operations
- Managing Folders and Files
- Utilizing Pivot Tables
Lab 3: WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
- Importing, Transforming, and Loading Data
- Appending Operations
- Managing Folders and Files
- Utilizing Pivot Tables
After completing this module, students will be able to:
- Understand and apply data import, transformation, and loading processes.
- Understand and apply appending operations.
- Understand and apply folder and file management techniques.
- Understand and apply the use of 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 models
Lab 4: CONNECTING TO DATABASES
- Importing From SQL Server and Inspecting Relationships
- Importing From SSAS Multidimensional
After completing this module, students will be able to:
- Understand and apply SQL Server imports and relationship inspection.
- Understand data relationships.
- Understand and apply SSAS Multidimensional imports.
MODULE 5: MERGING, GROUPING, SUMMARIZING, AND CALCULATING DATA
This module addresses historical challenges with merges, demonstrates how streamlined they are today, and explores options for grouping, summarizing, and calculating data.
Lessons
- Understanding Merge Challenges
- Executing Merges
- Grouping Options
- Summarizing
- Calculating
Lab 5: MERGING, GROUPING, SUMMARIZING, AND CALCULATING DATA
- Executing Merges
- Grouping and Summarizing
- Calculating
After completing this module, students will be able to:
- Understand and apply merge execution.
- Understand and apply grouping and summarizing techniques.
- Understand and apply calculation methods.
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
- Understand and apply report creation.
- Understand and apply the matrix visualization.
- Understand and apply the map visualization.
- Understand and apply the card visualization.
- Understand and apply the chart visualization.
- Understand and apply slicer usage.
- Understand and apply publishing to Power BI Online.
MODULE 7: POWER BI ONLINE
This module explores the definition of Power BI Online, reviews its features, and discusses 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, students will be able to:
- Understand and apply navigation of the Power BI Online interface.
- Understand and apply data importing.
- Understand and apply report creation.
- Understand and apply report filtering.
- Understand and apply the addition of KPIs to reports.
- Understand and apply dashboard creation.
- Understand and apply tile pinning.
Requirements
A fundamental grasp of Excel and Database management is required.
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
