Course Outline
MODULE 1: POWER BI FOR GOVERNMENT
In this module, we will provide an overview of what Power BI for government offers, examine the suite of products available, and discuss how updates are delivered.
Lessons
- What is Power BI?
- Examining the Power BI Suite of Products for Government
- Identifying Differences Between Products for Government Use
- Understanding Power BI Updates for Government
After completing this module, students will be able to:
- Understand the capabilities of Power BI for government.
- Recognize the differences between Power BI products suitable for government use.
- Comprehend how Power BI updates are provided for government applications.
MODULE 2: POWER BI DESKTOP FOR GOVERNMENT
In this module, we will cover the installation process of Power BI Desktop, explore its interface, discuss available file types and data sources, and explain how to configure data refresh settings. We will also review various data types and best practices for their utilization.
Lessons
- Installing Power BI Desktop for Government Use
- Exploring the Power BI Desktop Interface for Government
- Utilizing File Types: PBIX vs PBIT in Government Applications
- Examining Data Sources for Government Data
- Discussing Data Refresh Settings for Government Use
- Understanding Data Types for Government Data
Lab 2: POWER BI DESKTOP FOR GOVERNMENT
- Introduction to Power BI Desktop for Government
- After completing this module, students will be able to:
- Understand and utilize the installation process of Power BI Desktop for government use.
- Understand and utilize PBIX and PBIT file types in government applications.
- Understand data sources, data refresh settings, and data types for government data.
MODULE 3: WORKING WITH CSV, TXT AND EXCEL WORKSHEETS FOR GOVERNMENT
In this module, we will examine the process of importing, transforming, loading, and manipulating data using CSV, TXT, and Excel Worksheets for government applications. Power BI efficiently handles these file types.
Lessons
- Importing Data for Government Use
- Transforming Data for Government Applications
- Loading Data for Government Use
- Appending Operations in Government Datasets
- Working with Folders and Files in Government Environments
- Using Pivot Tables for Government Data Analysis
Lab 3: WORKING WITH CSV, TXT AND EXCEL WORKSHEETS FOR GOVERNMENT
- Importing, Transforming, and Loading Data for Government Use
- Appending Operations in Government Datasets
- Working with Folders and Files in Government Environments
- Using Pivot Tables for Government Data Analysis
After completing this module, students will be able to:
- Understand and utilize importing, transforming, and loading data for government use.
- Understand and utilize appending operations in government datasets.
- Understand and utilize working with folders and files in government environments.
- Understand and utilize using pivot tables for government data analysis.
MODULE 4: CONNECTING TO DATABASES FOR GOVERNMENT
In this module, we will explore the process of connecting to databases and examine relationships in a government context.
Lessons
- Working with Relational Data for Government
- Understanding Relationships in Government Databases
- Importing from SQL Server Analysis Services Multidimensional and Tabular for Government
Lab 4: CONNECTING TO DATABASES FOR GOVERNMENT
- Importing Data from SQL Server and Examining Relationships in Government Databases
- Importing Data from SSAS Multidimensional for Government Use
After completing this module, students will be able to:
- Understand and utilize importing data from SQL Server and examining relationships in government databases.
- Understand relationships in government databases.
- Understand and utilize importing data from SSAS Multidimensional for government use.
MODULE 5: MERGING, GROUPING, SUMMARIZING, AND CALCULATING DATA FOR GOVERNMENT
In this module, we will discuss the historical challenges with merges and how they have been simplified. We will also explore grouping, summarizing, and calculating options for government data.
Lessons
- Understanding Historical Issues with Merges in Government Data
- Performing Merges for Government Datasets
- Grouping Options for Government Data
- Summarizing Government Data
- Calculating for Government Data Analysis
Lab 5: MERGING, GROUPING, SUMMARIZING, AND CALCULATING DATA FOR GOVERNMENT
- Performing Merges for Government Datasets
- Grouping and Summarizing Government Data
- Calculating for Government Data Analysis
After completing this module, students will be able to:
- Understand and utilize performing merges for government datasets.
- Understand and utilize grouping and summarizing for government data.
- Understand and utilize calculating for government data analysis.
MODULE 6: REPORTING FOR GOVERNMENT
In this module, we will create a report and examine various visualization options suitable for government applications.
Lessons
- Creating Reports for Government Use
- Utilizing the Matrix Visualization in Government Reporting
- Utilizing the Map Visualization for Government Data
- Utilizing the Card Visualization for Government Metrics
- Utilizing the Chart Visualization for Government Analysis
- Utilizing Slicers in Government Reports
- Publishing to Power BI Online for Government Use
Lab 6: REPORTING FOR GOVERNMENT
- Creating Reports for Government Use
- Utilizing the Matrix Visualization in Government Reporting
- Utilizing the Map Visualization for Government Data
- Utilizing the Card Visualization for Government Metrics
- Utilizing the Chart Visualization for Government Analysis
- Utilizing Slicers in Government Reports
- Publishing to Power BI Online for Government Use
- After completing this module, students will be able to:
- Understand and utilize creating reports for government use.
- Understand and utilize the matrix visualization in government reporting.
- Understand and utilize the map visualization for government data.
- Understand and utilize the card visualization for government metrics.
- Understand and utilize the chart visualization for government analysis.
- Understand and utilize slicers in government reports.
- Understand and utilize publishing to Power BI Online for government use.
MODULE 7: POWER BI ONLINE FOR GOVERNMENT
In this module, we will explore what Power BI Online is and examine the features available for government use. We will also discuss mobile options suitable for government applications.
Lessons
- Introduction to Power BI Online for Government
- Importing Data for Government Use in Power BI Online
- Creating Reports in Power BI Online for Government
- Configuring Dashboards for Government Applications
- Sharing Reports and Dashboards for Government Collaboration
- Exploring Power BI Mobile for Government Use
Lab 7: POWER BI ONLINE FOR GOVERNMENT
- Exploring the Power BI Online Interface for Government
- Importing Excel (.xlsx or .xlsm), Comma Separated Value (.csv), and Power BI Desktop (.pbix) Files for Government Use
- Creating a Report in Power BI Online for Government
- Adding Filters to a Report for Government Analysis
- Adding KPIs to a Report for Government Metrics
- Creating a Dashboard for Government Use
- Pinning Tiles in Power BI Online for Government
After completing this module, students will be able to:
- Understand and utilize exploring the Power BI Online interface for government.
- Understand and utilize importing data for government use in Power BI Online.
- Understand and utilize creating reports in Power BI Online for government.
- Understand and utilize adding filters to a report for government analysis.
- Understand and utilize adding KPIs to a report for government metrics.
- Understand and utilize creating a dashboard in Power BI Online for government.
- Understand and utilize pinning tiles in Power BI Online for government.
Requirements
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
