Course Outline
Module 1: Initial Steps in Microsoft Data Analytics
This section examines the various roles within the data ecosystem, defines the critical responsibilities of a Data Analyst, and reviews the Power BI product portfolio for government use.
Lessons
- Data Analytics and Microsoft Ecosystem
- Introduction to Power BI
Upon completion of this module, learners will be able to:
- Analyze the diverse roles within the data field
- Identify key tasks performed by a Data Analyst
-
Articulate the Power BI product and service landscape
- Navigate the Power BI service environment
Module 2: Ingesting Data in Power BI
This section focuses on locating and retrieving data from diverse sources. It covers connectivity options, data storage strategies, and the performance implications of DirectQuery versus Import modes.
Lessons
- Data Analytics and Microsoft Ecosystem
- Performance Optimization Techniques
- Data Error Resolution
Lab : Preparing Data in Power BI Desktop
- Data Preparation Procedures
Upon completion of this module, learners will be able to:
-
Locate and retrieve data from multiple sources
- Evaluate connection methods and their associated performance impacts
- Utilize Microsoft Dataverse
- Establish connections to data flows
Module 3: Data Cleaning, Transformation, and Loading in Power BI
This section teaches data profiling and assessment techniques. It covers identifying anomalies, analyzing data dimensions, and executing necessary cleaning and transformation steps prior model loading.
Lessons
-
Data Shaping Techniques
-
Data Profiling Methods
-
Enhancing Data Structure Integrity
Lab : Loading Data in Power BI Desktop
- Data Loading Procedures
Upon completion of this module, learners will be able to:
-
Apply data shaping transformations
-
Improve the structural integrity of data
-
Profile and inspect data quality
Module 4: Data Modeling in Power BI
This section covers the foundational principles of designing scalable and high-performance data models. It addresses common modeling challenges, including relationship management, security implementation, and performance tuning.
Lessons
-
Foundations of Data Modeling
-
Table Management
-
Dimensions and Hierarchies
Lab : Data Modeling in Power BI Desktop
- Establish Model Relationships
- Configure Table and Column Properties
- Construct Hierarchies
Upon completion of this module, learners will be able to:
-
Comprehend core data modeling principles
-
Define relationships and specify cardinality
-
Implement Dimensions and Hierarchies
Module 5: Model Calculations using DAX in Power BI
This section introduces Data Analysis Expressions (DAX) to enhance model capabilities. It covers aggregations, Measures, calculated columns and tables, and Time Intelligence functions for solving complex analytical problems.
Lessons
-
DAX Fundamentals
-
Real-time Dashboard Implementation
-
Advanced DAX Techniques
Lab : Introduction to DAX in Power BI Desktop
- Create Calculated Tables
- Create Calculated Columns
- Create Measures
Lab : Advanced DAX in Power BI Desktop
- Utilize the CALCULATE() function to manage filter context
- Implement Time Intelligence functions
Upon completion of this module, learners will be able to:
-
Understand DAX syntax and logic
-
Apply DAX for formulas and expressions
-
Construct calculated tables and measures
-
Develop basic calculation measures
-
Utilize Time Intelligence and Key Performance Indicators
Module 6: Optimizing Model Performance in Power BI
This section introduces best practices, concepts, and processes required to optimize data models for enterprise-level performance and scalability.
Lessons
-
Performance Optimization of Data Models
-
Optimization of DirectQuery Models
Upon completion of this module, learners will be able to:
-
Recognize the significance of variables in performance
-
Refine and enhance data models
-
Optimize storage engine configurations
Module 7: Report Development in Power BI
This section covers the principles of designing effective reports, including visual selection, page layout design, and essential functionality. It also addresses accessibility standards for government compliance.
Lessons
-
Report Design Principles
-
Report Enhancement Strategies
Lab : Enhancing Reports with Interaction and Formatting in Power BI Desktop
- Create and Configure Synchronized Slicers
- Implement Drillthrough Pages
- Apply Conditional Formatting
- Create and Utilize Bookmarks
Lab : Report Design in Power BI Desktop
- Design Report Layouts
- Configure Visual Fields and Formatting Properties
Upon completion of this module, learners will be able to:
-
Design effective report page layouts
-
Select and deploy appropriate visualizations
-
Implement core report functionality
-
Add navigation elements and interaction capabilities
Module 8: Dashboard Creation in Power BI
This section teaches how to construct compelling dashboards using narrative techniques and available navigation tools. It introduces features designed to improve usability and deliver actionable insights.
Lessons
-
Dashboard Construction
-
Real-time Dashboard Capabilities
-
Dashboard Enhancement Techniques
Lab : Creating a Dashboard in Power BI Service
- Create Dashboards
- Pin Visuals to Dashboards
- Use Q&A to Generate Dashboard Tiles
Upon completion of this module, learners will be able to:
-
Construct functional Dashboards
-
Understand Real-time Dashboard mechanics
-
Enhance Dashboard usability and clarity
Module 9: Pattern and Trend Identification in Power BI
This section applies advanced features to extract analytical insights from data. It includes the use of AI visuals for deeper analysis and equips learners with steps to conduct formal data analysis.
Lessons
-
Advanced Analytics Techniques
-
Data Insights via AI Visuals
Lab : Data Analysis in Power BI Desktop
- Create Animated Scatter Charts
- Utilize Visual Forecasting Tools
Upon completion of this module, learners will be able to:
-
Utilize the Analyze feature
-
Identify data outliers
-
Deploy AI Visuals
-
Use Advanced Analytics custom visuals
Module 10: Workspace Management in Power BI
This section introduces Workspaces for content creation and management. It covers sharing reports and dashboards, and the distribution of Apps for broader access.
Lessons
-
Workspace Creation and Management
-
Content Sharing and Asset Management
Upon completion of this module, learners will be able to:
-
Create and administer workspaces
-
Facilitate workspace collaboration
-
Monitor workspace usage metrics and performance
- Distribute Applications
Module 11: File and Dataset Management in Power BI
This section introduces parameters and datasets. It covers dataset management, dynamic report creation using parameters, and configuration of refresh schedules.
Lessons
- Parameters
- Datasets
Upon completion of this module, learners will be able to:
- Manage datasets and parameters
- Develop dynamic reports using parameters
- Schedule dataset refresh operations
- Troubleshoot gateway service connectivity
Module 12: Row-Level Security in Power BI
This section introduces static and dynamic row-level security methods and provides guidance on their implementation.
Lessons
- Security Implementation in Power BI
Lab : Enforcing Row-Level Security
- Configure Many-to-Many Relationships
- Enforce Row-Level Security
Upon completion of this module, learners will be able to:
- Implement row-level security using both Static and Dynamic methods
Testimonials (2)
The basic structure of Power BI, its main functions, as well as some advanced functions
Alessandro Binaghi - Great Place to Work(R) Institute Italia Srl
Course - PL-300: Microsoft Power BI Data Analyst
Lot of features usable in our processes
