Course Outline
MODULE 1: POWER BI
In this module, we will explain what Power BI offers, examine the available products and their benefits, and cover how Power BI updates are delivered.
Lessons
- What is Power BI?
- Examining the Power BI Suite of Products
- Identifying Differences Between Products
- Understanding Power BI Updates
After completing this module, students will be able to:
- Understand Power BI.
- Understand the differences between products.
- Understand Power BI updates.
MODULE 2: POWER BI DESKTOP
In this module, we will explore the steps required to install Power BI Desktop, examine the interface, discuss available file types and data sources, and review how to configure data refresh settings. We will also cover available data types and discuss best practices for using them.
Lessons
- Installing Power BI Desktop
- Exploring the Power BI Desktop Interface
- Utilising File Types; PBIX vs PBIT
- Examining Data Sources
- Discussing Data Refresh
- Understanding Data Types
Lab 2: POWER BI DESKTOP
- Introduction to Power BI
- After completing this module, students will be able to:
- Understand and utilise installing Power BI Desktop.
- Understand and utilise PBIX and PBIT file types.
- Understand 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 with ease.
Lessons
- Importing Data
- Transforming Data
- Loading Data
- Appending Operations
- Working with Folders and Files
- Using Pivot Tables
Lab 3: WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
- Importing, Transforming, and Loading Data
- Appending Operations
- Working with Folders and Files
- Using Pivot Tables
After completing this module, students will be able to:
- Understand and utilise importing, transforming, and loading data.
- Understand and utilise appending operations.
- Understand and utilise working with folders and files.
- Understand and utilise using Pivot Tables.
MODULE 4: CONNECTING TO DATABASES
In this module, we will explore the process of connecting to databases and also examine 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, students will be able to:
- Understand and utilise importing from SQL Server and examining relationships.
- Understand relationships.
- Understand and utilise importing from SSAS Multidimensional.
MODULE 5: MERGING, GROUPING, SUMMARISING, AND CALCULATING DATA
In this module, we will discuss why merges have been challenging in the past, examine how much easier they are to use today, and explore grouping, summarising, and calculating options.
Lessons
- Understanding the Issues with Merges
- Performing Merges
- Grouping Options
- Summarising
- Calculating
Lab 5: MERGING, GROUPING, SUMMARISING, AND CALCULATING DATA
- Performing Merges
- Grouping and Summarising
- Calculating
After completing this module, students will be able to:
- Understand and utilise performing merges.
- Understand and utilise grouping and summarising.
- Understand and utilise calculating.
MODULE 6: REPORTING
In this module, we will create a report and examine the visualisation options.
Lessons
- Creating Reports
- Utilising the Matrix Visualisation
- Utilising the Map Visualisation
- Utilising the Card Visualisation
- Utilising the Chart Visualisation
- Utilising Slicers
- Publishing to Power BI Online
Lab 6: REPORTING
- Creating Reports
- Utilising the Matrix Visualisation
- Utilising the Map Visualisation
- Utilising the Card Visualisation
- Utilising the Chart Visualisation
- Utilising Slicers
- Publishing to Power BI Online
- After completing this module, students will be able to:
- Understand and utilise creating reports.
- Understand and utilise the matrix visualisation.
- Understand and utilise the map visualisation.
- Understand and utilise the card visualisation.
- Understand and utilise the chart visualisation.
- Understand and utilise slicers.
- Understand and utilise publishing to Power BI Online.
MODULE 7: POWER BI ONLINE
In this module, we will explore what Power BI Online is, examine the available features, and discuss 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
After completing this module, students will be able to:
- Understand and utilise exploring the Power BI Online interface.
- Understand and utilise importing data.
- Understand and utilise creating reports.
- Understand and utilise adding filters to a report.
- Understand and utilise adding KPI's to a report.
- Understand and utilise creating a dashboard.
- Understand and utilise pinning tiles.
Requirements
A basic 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
