Course Outline
Module 1: Retrieve Data in Power BI for Government
In this module, you will learn how to retrieve data from various sources, including Microsoft Excel, relational databases, and NoSQL data stores. You will also gain knowledge on enhancing performance while retrieving data.
Learning Objectives
By the end of this module, you will be able to:
- Identify and connect to a data source for government use.
- Retrieve data from a relational database, such as Microsoft SQL Server.
- Retrieve data from a file, like Microsoft Excel.
- Retrieve data from applications.
- Retrieve data from Azure Analysis Services.
- Select an appropriate storage mode.
- Address performance issues.
- Resolve data import errors.
Lessons
- Introduction
- Retrieve Data from Files
- Retrieve Data from Relational Data Sources
- Create Dynamic Reports with Parameters
- Retrieve Data from a NoSQL Database
- Retrieve Data from Online Services
- Select an Appropriate Storage Mode
- Retrieve Data from Azure Analysis Services
- Address Performance Issues
- Resolve Data Import Errors
- Exercise - Prepare Data in Power BI Desktop for Government
- Check Your Knowledge
- Summary
Module 2: Clean, Transform, and Load Data in Power BI for Government
In this module, you will learn how to simplify complex models, change data types, rename objects, and pivot data. You will also discover how to profile columns to identify valuable data for deeper analytics.
Learning Objectives
By the end of this module, you will be able to:
- Resolve inconsistencies, unexpected or null values, and data quality issues in government datasets.
- Apply user-friendly value replacements.
- Profile data to gain insights into specific columns before using them for analysis.
- Evaluate and transform column data types.
- Apply data shape transformations to table structures.
- Combine queries from multiple sources.
- Apply user-friendly naming conventions to columns and queries.
- Edit M code in the Advanced Editor.
Lessons
- Introduction
- Shape Initial Data for Government Use
- Simplify Data Structure
- Evaluate and Change Column Data Types
- Combine Multiple Tables into a Single Table
- Profile Data in Power BI for Government
- Use Advanced Editor to Modify M Code
- Exercise - Load Data in Power BI Desktop for Government
- Check Your Knowledge
- Summary
Module 3: Design a Data Model in Power BI for Government
This module will guide you through the process of creating a complex data model in Power BI. You will learn how to simplify disarrayed data from multiple transactional systems, and how to design star schemas and choose appropriate data granularity for optimal performance and usability.
Learning Objectives
In this module, you will:
- Create common date tables for government datasets.
- Configure many-to-many relationships.
- Resolve circular relationships.
- Design star schemas for government data models.
Lessons
- Introduction
- Work with Tables in Government Data Models
- Create a Date Table for Government Use
- Work with Dimensions in Government Data Models
- Define Data Granularity for Government Reports
- Work with Relationships and Cardinality
- Resolve Modeling Challenges in Government Data Models
- Exercise - Model Data in Power BI Desktop for Government
- Check Your Knowledge
- Summary
Module 4: Design Power BI Reports for Government
This module will help you navigate the selection of appropriate visual types to meet your design and report layout requirements in government settings. With over 30 core visuals available in Power BI, choosing the right one can be challenging.
Learning Objectives
In this module, you will:
- Understand the structure of a Power BI report for government use.
- Learn about report objects in government reports.
- Select the appropriate visual type to meet design and layout requirements for government reports.
Lessons
- Introduction
- Design Analytical Report Layouts for Government
- Create Visually Appealing Reports for Government
- Understand Report Objects in Government Reports
- Select Appropriate Report Visuals for Government Use
- Format and Configure Visualizations for Government Reports
- Work with Key Performance Indicators in Government Reports
- Exercise - Design a Report in Power BI Desktop for Government
- Check Your Knowledge
- Summary
Module 5: Configure Power BI Report Filters for Government
This module covers the complex topic of report filtering, providing techniques to design reports that meet specific requirements and user expectations in government settings. You will learn about various filtering methods applicable at both design time and consumption time.
Learning Objectives
In this module, you will:
- Design reports for filtering in government contexts.
- Use slicers to enhance report interactivity in government reports.
- Apply advanced filtering techniques in government reports.
- Implement consumption-time filtering in government reports.
- Select appropriate report filtering techniques for government use.
Lessons
- Introduction to Designing Reports for Filtering in Government
- Apply Filters to the Report Structure in Government Reports
- Use Slicers for Interactive Filtering in Government Reports
- Design Reports with Advanced Filtering Techniques for Government
- Implement Consumption-Time Filtering in Government Reports
- Select Appropriate Report Filter Techniques for Government Use
- Case Study - Configure Report Filters Based on Feedback in Government
- Check Your Knowledge
- Summary
Module 6: Create Dashboards in Power BI for Government
This module will teach you how to create personalized dashboards that allow report consumers to focus on the data points relevant to their needs. You will learn about the differences between Power BI reports and dashboards, including how to pin visuals from different datasets to a single dashboard.
Learning Objectives
In this module, you will:
- Set a mobile view for government dashboards.
- Add themes to the visuals in your government dashboard.
- Configure data classification for government compliance.
- Add real-time dataset visuals to your government dashboards.
- Pin a live report page to a government dashboard.
Lessons
- Introduction to Dashboards in Government
- Configure Data Alerts for Government Dashboards
- Explore Data by Asking Questions in Government Dashboards
- Review Quick Insights in Government Dashboards
- Add a Theme to Your Government Dashboard
- Pin a Live Report Page to a Government Dashboard
- Configure a Real-Time Government Dashboard
- Configure Data Classification for Government Compliance
- Set Mobile View for Government Dashboards
- Exercise - Create a Power BI Dashboard for Government
- Check Your Knowledge
- Summary
Requirements
Not Applicable for government.
Testimonials (5)
The coding and analysis, how the information come together in a report which will be useful for my work
Nokuthula Dhludhlu - National Transmission Company South Africa
Course - Analyzing Data with Power BI
The content was tough but that extra effort I had to put helped me remember and understand power BI better.
Melvin - TLI Group
Course - Power BI DAX Fundamentals
Discussing about our issues
Rr Dwi Putri Periska Sari - PT. Becton Dickinson Indonesia
Course - Power BI for Developers
What I liked the most was the coach's openness regarding the change in content as well as the approach that was previously prepared to accommodate our real needs
Ernesto Sitoe Junior - Electricidade de Mocambique
Course - Advanced Power BI
The second day as Power Bi is a really friendly tool, and clearly Costas knows it very well, it was really good to learn about that tool. Unfortunately we have to see Power pivot in excel first which is really not user friendly but definitely a must see first in order to understand how Power Bi works, and it makes Power Bi look super cool :)
