Course Outline
Module 1: Get Started with Microsoft Data Analytics for Government
This module explores various roles in the data field, outlines the key responsibilities of a Data Analyst, and delves into the landscape of the Power BI portfolio.
Lessons
- Data Analytics and Microsoft for Government
- Getting Started with Power BI for Government
After completing this module, students will be able to:
- Explore the different roles in data management for government
- Identify the tasks performed by a data analyst in a public sector context
- Describe the Power BI landscape of products and services for government use
- Use the Power BI service effectively in government workflows
Module 2: Getting Data in Power BI for Government
This module covers identifying and retrieving data from various sources. It also explores connectivity options, data storage methods, and the performance implications of direct data connections versus importing data.
Lessons
- Data Analytics and Microsoft for Government
- Optimize Performance in Government Data Systems
- Resolve Data Errors in Public Sector Datasets
Lab: Preparing Data in Power BI Desktop for Government
- Prepare Data for Government Use
After completing this module, students will be able to:
- Identify and retrieve data from different sources for government projects
- Understand the connection methods and their performance implications in public sector applications
- Use Microsoft Dataverse for government data management
- Connect to a data flow for government use
Module 3: Cleaning, Transforming, and Loading Data in Power BI for Government
This module teaches the process of profiling and understanding the condition of data. Students will learn how to identify anomalies, assess the size and shape of their data, and perform necessary cleaning and transformation steps to prepare it for loading into a model.
Lessons
- Shaping the Data for Government Use
- Profiling the Data for Government Insights
- Enhancing the Data Structure for Government Applications
Lab: Loading Data in Power BI Desktop for Government
- Loading Data for Government Projects
After completing this module, students will be able to:
- Apply data shape transformations for government datasets
- Enhance the structure of government data
- Profile and examine government data for accuracy and completeness
Module 4: Design a Data Model in Power BI for Government
This module covers fundamental concepts of designing and developing a data model for optimal performance and scalability. It also addresses common data modeling issues, including relationships, security, and performance optimization.
Lessons
- Introduction to Data Modeling for Government
- Working with Tables in Government Datasets
- Dimensions and Hierarchies for Government Use
Lab: Data Modeling in Power BI Desktop for Government
- Create Model Relationships for Government Projects
- Configure Tables and Column Properties for Government Data
- Create Hierarchies for Government Reports
After completing this module, students will be able to:
- Understand the basics of data modeling in a government context
- Define relationships and their cardinality for government datasets
- Implement dimensions and hierarchies in government data models
Module 5: Create Model Calculations using DAX in Power BI for Government
This module introduces the capabilities of DAX for enhancing a data model. Students will learn about aggregations, measures, calculated columns and tables, and Time Intelligence functions to solve calculation and data analysis problems specific to government applications.
Lessons
- Introduction to DAX for Government Data Analysis
- Real-time Dashboards for Government Use
- Advanced DAX Techniques for Government Data
Lab: Introduction to DAX in Power BI Desktop for Government
- Create Calculated Tables for Government Reports
- Create Calculated Columns for Government Data
- Create Measures for Government Analytics
Lab: Advanced DAX in Power BI Desktop for Government
- Use the CALCULATE() function to manipulate filter context in government datasets
- Utilize Time Intelligence functions for government data analysis
After completing this module, students will be able to:
- Understand DAX and its applications in government data modeling
- Use DAX for simple formulas and expressions in government datasets
- Create calculated tables and measures for government reports
- Build simple measures for government analytics
- Work with Time Intelligence and Key Performance Indicators for government insights
Module 6: Optimize Model Performance in Power BI for Government
This module introduces steps, processes, concepts, and best practices necessary to optimize a data model for enterprise-level performance in government applications.
Lessons
- Optimize the Data Model for Performance in Government Projects
- Optimize DirectQuery Models for Government Use
After completing this module, students will be able to:
- Understand the importance of variables in government data models
- Enhance the data model for optimal performance in government applications
- Optimize the storage model for government datasets
Module 7: Create Reports in Power BI for Government
This module introduces fundamental concepts and principles of designing and building a report, including selecting appropriate visuals, designing a page layout, and applying essential functionality. It also covers designing reports for accessibility in government settings.
Lessons
- Design a Report for Government Use
- Enhance the Report for Government Insights
Lab: Enhancing Reports with Interaction and Formatting in Power BI Desktop for Government
- Create and configure Sync Slicers for government reports
- Create a drillthrough page for detailed government data exploration
- Apply conditional formatting for government data visualization
- Create and use Bookmarks for government report navigation
Lab: Designing a Report in Power BI Desktop for Government
- Design a report page layout for government projects
- Configure visual fields and format properties for government data
After completing this module, students will be able to:
- Design a report page layout for government use
- Select and add effective visualizations for government reports
- Add basic report functionality for government insights
- Add report navigation and interactions for government applications
Module 8: Create Dashboards in Power BI for Government
This module teaches how to create compelling stories through dashboards, including the use of different navigation tools. It introduces features and functionality to enhance dashboards for usability and insights in government settings.
Lessons
- Create a Dashboard for Government Use
- Real-time Dashboards for Government Applications
- Enhance a Dashboard for Government Insights
Lab: Creating a Dashboard in Power BI Service for Government
- Create a Dashboard for government projects
- Pin visuals to a Dashboard for government reports
- Use Q&A to create a dashboard tile for government data
After completing this module, students will be able to:
- Create a Dashboard for government use
- Understand real-time Dashboards in government applications
- Enhance Dashboard usability for government insights
Module 9: Identify Patterns and Trends in Power BI for Government
This module equips students with the skills to apply advanced features for analytical insights in data, using reports for actual data analysis. It also covers performing advanced analytics using AI visuals for deeper government data insights.
Lessons
- Advanced Analytics for Government Data
- Data Insights through AI Visuals for Government Use
Lab: Data Analysis in Power BI Desktop for Government
- Create animated scatter charts for government data visualization
- Use the visual to forecast values for government reports
After completing this module, students will be able to:
- Use the Analyze feature in government data reports
- Identify outliers in government data
- Utilize AI visuals for government insights
- Use the Advanced Analytics custom visual for government data analysis
Module 10: Create and Manage Workspaces in Power BI for Government
This module introduces students to workspaces, including how to create and manage them. It also covers sharing content, such as reports and dashboards, and distributing an App for government use.
Lessons
- Creating Workspaces for Government Projects
- Sharing and Managing Assets in Government Settings
After completing this module, students will be able to:
- Create and manage a workspace for government projects
- Understand workspace collaboration in government settings
- Monitor workspace usage and performance for government applications
- Distribute an App for government use
Module 11: Manage Files and Datasets in Power BI for Government
This module introduces parameters and datasets, including how to manage them. It also covers building dynamic reports with parameters and setting dataset refresh options for government applications.
Lessons
- Parameters for Government Data Management
- Datasets for Government Use
After completing this module, students will be able to:
- Manage datasets and parameters for government projects
- Build dynamic reports with parameters for government use
- Schedule dataset refresh for government data management
- Troubleshoot gateway service connectivity in government applications
Module 12: Row-level Security in Power BI for Government
This module introduces row-level security, both static and dynamic methods, and how to implement them in government settings.
Lessons
- Security in Power BI for Government Data
Lab: Enforce Row-Level Security for Government Data
- Configure many-to-many relationships for government data models
- Enforce row-level security for government datasets
After completing this module, students will be able to:
- Implement row-level security using both the Static and Dynamic methods in government applications
Testimonials (1)
Real world knowledge from someone in the industry
