Course Outline
MODULE 1: POWER BI
This module outlines the capabilities of Power BI, reviews the available product offerings and their respective benefits, and explains the mechanism for Power BI updates.
Lessons
- What is Power BI?
- Overview of the Power BI Product Suite
- Distinguishing Features Between Products
- Understanding Power BI Update Processes
Upon completing this module, students will be able to:
- Comprehend the essence of Power BI.
- Recognize differences among various products.
- Grasp how Power BI updates are managed.
MODULE 2: POWER BI DESKTOP
In this module, we will walk through the installation steps for Power BI Desktop, navigate its interface, review supported file types and data sources, and configure data refresh settings. Additionally, we will explore available data types and discuss best practices for their utilization.
Lessons
- Installing Power BI Desktop
- Navigating the Power BI Desktop Interface
- File Types: PBIX vs PBIT
- Examining Data Sources
- Data Refresh Mechanisms
- Understanding Data Types
Lab 2: POWER BI DESKTOP
- Introduction to Power BI
- Upon completing this module, students will be able to:
- Demonstrate proficiency in installing Power BI Desktop.
- Apply knowledge of PBIX and PBIT file types.
- Understand data sources, refresh configurations, 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 worksheets. Power BI processes these file types with ease.
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
Upon completing this module, students will be able to:
- Demonstrate proficiency in importing, transforming, and loading data.
- Demonstrate proficiency in appending operations.
- Demonstrate proficiency in managing folders and files.
- Demonstrate proficiency in 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
Upon completing this module, students will be able to:
- Demonstrate proficiency in importing from SQL Server and examining relationships.
- Understand relationships.
- Demonstrate proficiency in importing from SSAS Multidimensional.
MODULE 5: MERGING, GROUPING, SUMMARIZING, AND CALCULATING DATA
This module addresses past challenges with data merges, highlights current ease of use, and explores options for grouping, summarizing, and calculating data.
Lessons
- Addressing Merge Challenges
- 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:
- Demonstrate proficiency in performing merges.
- Demonstrate proficiency in grouping and summarizing.
- Demonstrate proficiency in calculating.
MODULE 6: REPORTING
This module involves creating a report and exploring various 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:
- Demonstrate proficiency in creating reports.
- Demonstrate proficiency in using the matrix visualization.
- Demonstrate proficiency in using the map visualization.
- Demonstrate proficiency in using the card visualization.
- Demonstrate proficiency in using the chart visualization.
- Demonstrate proficiency in using slicers.
- Demonstrate proficiency in publishing to Power BI Online.
MODULE 7: POWER BI ONLINE
This module introduces 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
- Navigating 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:
- Demonstrate proficiency in exploring the Power BI Online interface.
- Demonstrate proficiency in importing data.
- Demonstrate proficiency in creating reports.
- Demonstrate proficiency in adding filters to a report.
- Demonstrate proficiency in adding KPIs to a report.
- Demonstrate proficiency in creating a dashboard.
- Demonstrate proficiency in pinning tiles.
Requirements
Fundamental knowledge 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
