PL-300: Microsoft Power BI Data Analyst Training Course

Module 1: Get Started with Microsoft Data Analytics for Government

This module explores the various roles within the data analytics field, outlines the key responsibilities of a Data Analyst, and provides an overview 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 analytics for government
• Identify the tasks performed by a Data Analyst for government operations
• Describe the Power BI landscape of products and services for government use
• Use the Power BI service for government applications

Module 2: Getting Data in Power BI for Government

This module explores identifying and retrieving data from various sources. Students will learn about connectivity options, data storage methods, and the performance implications of direct data connections versus data imports.

Lessons

• Data Analytics and Microsoft for Government
• Optimize Performance in Power BI for Government
• Resolve Data Errors in Power BI for Government

Lab : Preparing Data in Power BI Desktop for Government

• Prepare Data for Government Applications

After completing this module, students will be able to:

• Identify and retrieve data from different sources for government use
• Understand the connection methods and their performance implications for government operations
• Use Microsoft Dataverse for government applications
• Connect to a data flow for government purposes

Module 3: Cleaning, Transforming, and Loading Data in Power BI for Government

This module teaches the process of profiling and understanding data conditions. Students will learn how to identify anomalies, assess data size and structure, and perform necessary cleaning and transformation steps to prepare data for loading into a model.

Lessons

• Shaping Data for Government Applications
• Profiling Data for Government Use
• Enhancing the Data Structure for Government Operations

Lab : Loading Data in Power BI Desktop for Government

• Loading Data for Government Purposes

After completing this module, students will be able to:

• Apply data shape transformations for government applications
• Enhance the structure of data for government use
• Profile and examine data for government operations

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.

Lessons

• Introduction to Data Modeling for Government
• Working with Tables in Power BI for Government
• Dimensions and Hierarchies in Power BI for Government

Lab : Data Modeling in Power BI Desktop for Government

• Create Model Relationships for Government Use
• Configure Table and Column Properties for Government Applications
• Create Hierarchies for Government Operations

After completing this module, students will be able to:

• Understand the basics of data modeling for government
• Define relationships and their cardinality for government use
• Implement Dimensions and Hierarchies for government applications

Module 5: Create Model Calculations using DAX in Power BI for Government

This module introduces the Data Analysis Expressions (DAX) language and its capabilities for enhancing data models. Students will learn about aggregations, Measures, calculated columns and tables, and Time Intelligence functions to solve calculation and data analysis problems.

Lessons

• Introduction to DAX for Government
• Real-time Dashboards in Power BI for Government
• Advanced DAX for Government Applications

Lab : Introduction to DAX in Power BI Desktop for Government

• Create Calculated Tables for Government Use
• Create Calculated Columns for Government Operations
• Create Measures for Government Applications

Lab : Advanced DAX in Power BI Desktop for Government

• Use the CALCULATE() Function to Manipulate Filter Context for Government Purposes
• Use Time Intelligence Functions for Government Applications

After completing this module, students will be able to:

• Understand DAX for government applications
• Use DAX for simple formulas and expressions in a government context
• Create calculated tables and measures for government use
• Build simple measures for government operations
• Work with Time Intelligence and Key Performance Indicators for government purposes

Module 6: Optimize Model Performance in Power BI for Government

This module introduces steps, processes, concepts, and data modeling best practices necessary to optimize a data model for enterprise-level performance in government operations.

Lessons

• Optimizing the Data Model for Performance in Government
• Optimizing DirectQuery Models for Government Use

After completing this module, students will be able to:

• Understand the importance of variables for government operations
• Enhance the data model for government use
• Optimize the storage model for government applications

Module 7: Create Reports in Power BI for Government

This module introduces fundamental concepts and principles of designing and building reports, including selecting appropriate visuals, designing page layouts, and applying essential functionality. It also covers designing for accessibility in a government context.

Lessons

• Designing a Report for Government Use
• Enhancing a Report for Government Applications

Lab : Enhancing Reports with Interaction and Formatting in Power BI Desktop for Government

• Create and Configure Sync Slicers for Government Use
• Create a Drillthrough Page for Government Operations
• Apply Conditional Formatting for Government Purposes
• Create and Use Bookmarks for Government Applications

Lab : Designing a Report in Power BI Desktop for Government

• Design a Report for Government Use
• Configure Visual Fields and Format Properties for Government Applications

After completing this module, students will be able to:

• Design a report page layout for government use
• Select and add effective visualizations for government applications
• Add basic report functionality for government operations
• Add report navigation and interactions for government purposes

Module 8: Create Dashboards in Power BI for Government

This module teaches how to create compelling stories through the use of dashboards and different navigation tools. Students will learn about features and functionality to enhance dashboards for usability and insights in a government context.

Lessons

• Creating a Dashboard for Government Use
• Real-time Dashboards for Government Applications
• Enhancing a Dashboard for Government Purposes

Lab : Creating a Dashboard in Power BI Service for Government

• Create a Dashboard for Government Use
• Pin Visuals to a Dashboard for Government Operations
• Use Q&A to Create a Dashboard Tile for Government Applications

After completing this module, students will be able to:

• Create a Dashboard for government use
• Understand real-time Dashboards for government applications
• Enhance Dashboard usability for government purposes

Module 9: Identify Patterns and Trends in Power BI for Government

This module helps students apply additional features to enhance reports for analytical insights. Students will learn to use the report for actual data analysis and perform advanced analytics using AI visuals for deeper and meaningful insights.

Lessons

• Advanced Analytics for Government
• Data Insights through AI Visuals for Government Use

Lab : Data Analysis in Power BI Desktop for Government

• Create Animated Scatter Charts for Government Applications
• Use the Visual to Forecast Values for Government Operations

After completing this module, students will be able to:

• Use the Analyze feature for government purposes
• Identify outliers in data for government use
• Use AI visuals for government applications
• Use the Advanced Analytics custom visual for government operations

Module 10: Create and Manage Workspaces in Power BI for Government

This module introduces students to Workspaces, including how to create and manage them. Students will also learn how to share content, such as reports and dashboards, and distribute an App for government use.

Lessons

• Creating Workspaces for Government Use
• Sharing and Managing Assets in Power BI for Government

After completing this module, students will be able to:

• Create and manage a workspace for government operations
• Understand workspace collaboration for government use
• Monitor workspace usage and performance for government purposes
• Distribute an App for government applications

Module 11: Manage Files and Datasets in Power BI for Government

This module introduces parameters and datasets. Students will learn how to manage datasets and parameters, build dynamic reports with parameters, and set dataset refresh options for government use.

Lessons

• Parameters for Government Use
• Datasets for Government Applications

After completing this module, students will be able to:

• Manage datasets and parameters for government operations
• Build dynamic reports with parameters for government use
• Schedule dataset refresh for government applications
• Troubleshoot gateway service connectivity for government purposes

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 for government use.

Lessons

• Security in Power BI for Government

Lab : Enforce Row-Level Security in Power BI for Government

• Configure Many-to-Many Relationships for Government Use
• Enforce Row-Level Security for Government Applications

After completing this module, students will be able to:

• Implement row-level security using both the Static and Dynamic methods for government operations