Course Outline
Module 1: Introduction to Microsoft Data Analytics
This module examines the distinct roles within the data ecosystem, defines the specific responsibilities of a Data Analyst, and provides an overview of the Power BI portfolio landscape for government applications.
Lessons
- Data Analytics and Microsoft
- Getting Started with Power BI
Lab : Getting Started
- Getting Started
Upon completion of this module, participants will be able to:
- Examine the various roles within the data domain
- Identify core responsibilities associated with the data analyst role
- Describe the Power BI product and service ecosystem
- Utilize the Power BI service effectively
Module 2: Data Preparation in Power BI
This module focuses on the identification and acquisition of data from diverse sources. It covers connectivity options and storage methods, emphasizing the operational and performance differences between direct connection and data import strategies for enterprise use.
Lessons
- Retrieving data from various sources
- Optimizing system performance
- Resolving data integrity issues
Lab : Preparing Data in Power BI Desktop
- Prepare Data
Upon completion of this module, participants will be able to:
- Identify and acquire data from multiple sources
- Evaluate connection methodologies and their performance implications
- Enhance query efficiency
- Address data import anomalies
Module 3: Data Cleansing, Transformation, and Loading in Power BI
This module outlines the procedures for profiling and assessing data quality. It details methods for detecting anomalies, evaluating data structure, and executing necessary cleansing and transformation steps to ensure readiness for model integration.
Lessons
- Data reshaping techniques
- Improving data architecture
- Data Profiling
Lab : Transforming and Loading Data
- Loading Data
Upon completion of this module, participants will be able to:
- Execute data shape transformations
- Refine the underlying data structure
- Profile and analyze data characteristics
Module 4: Data Model Design in Power BI
This module covers the foundational principles of designing and developing data models with a focus on performance and scalability. It addresses common modeling challenges, including relationship management, security protocols, and optimization for government environments.
Lessons
- Fundamentals of data modeling
- Managing table structures
- Dimensions and Hierarchies
Lab : Data Modeling in Power BI Desktop
- Establish Model Relationships
- Configure Table Settings
- Analyze the model interface
- Generate Quick Measures
Lab : Advanced Data Modeling in Power BI Desktop
- Manage many-to-many relationships
- Apply row-level security controls
Upon completion of this module, participants will be able to:
- Comprehend fundamental data modeling concepts
- Define relationships and cardinality constraints
- Implement dimensional hierarchies
- Construct histograms and ranking structures
Module 5: Measure Creation using DAX in Power BI
This module introduces DAX (Data Analysis Expressions) and its capacity to enhance data models. It covers aggregation methods, the creation of Measures, calculated columns and tables, and Time Intelligence functions to address complex calculation and analysis requirements.
Lessons
- Introduction to DAX
- DAX contextual mechanics
- Advanced DAX applications
Lab : Introduction to DAX in Power BI Desktop
- Develop calculated tables
- Develop calculated columns
- Develop measures
Lab : Advanced DAX in Power BI Desktop
- Apply the CALCULATE() function for filter context manipulation
- Implement Time Intelligence functions
Upon completion of this module, participants will be able to:
- Comprehend DAX syntax and logic
- Apply DAX for standard formulas and expressions
- Construct calculated tables and measures
- Develop basic measures
- Leverage Time Intelligence and Key Performance Indicators
Module 6: Model Performance Optimization
This module presents the essential steps, processes, and best practices required to optimize data models for enterprise-scale performance and efficiency.
Lessons
- Optimizing model performance
- Optimizing DirectQuery models
- Managing aggregations
Upon completion of this module, participants will be able to:
- Recognize the significance of variable usage
- Enhance data model architecture
- Optimize storage configurations
- Implement aggregation strategies
Module 7: Report Development
This module covers the core principles of report design and construction, including the selection of appropriate visuals, page layout planning, and the application of essential functionalities. It also emphasizes the critical importance of accessibility standards in report design.
Lessons
- Report design strategies
- Report enhancement techniques
Lab : Designing a report in Power BI
- Establish a live connection in Power BI Desktop
- Design the report layout
- Configure visual fields and format settings
Lab : Enhancing Power BI reports with interaction and formatting
- Configure synchronized slicers
- Create drill-through pages
- Implement conditional formatting
- Utilize bookmarks for navigation
Upon completion of this module, participants will be able to:
- Structure report page layouts
- Select and integrate effective visualizations
- Incorporate basic report functionalities
- Implement report navigation and interactive elements
- Enhance report rendering performance
- Ensure design accessibility compliance
Module 8: Dashboard Development
This module focuses on constructing compelling data narratives through dashboards and utilizing available navigation tools. It introduces key features and methods for improving dashboard usability and extracting actionable insights.
Lessons
- Dashboard creation
- Real-time dashboard implementation
- Dashboard enhancement strategies
Lab : Designing a report in Power BI Desktop - Part 1
- Create a dashboard
- Pin visuals to a dashboard
- Set up dashboard tile alerts
- Generate dashboard tiles using Q&A
Upon completion of this module, participants will be able to:
- Develop a functional dashboard
- Evaluate real-time dashboard capabilities
- Improve dashboard usability for end-users
Module 9: Paginated Report Creation in Power BI
This module provides an overview of paginated reports and their role within the Power BI ecosystem. It guides participants through the process of building and publishing these reports for formal distribution.
Lessons
- Paginated report overview
- Creating paginated reports
Lab : Creating a Paginated report
- Utilize Power BI Report Builder
- Design multi-page report layouts
- Define data sources
- Define datasets
- Create report parameters
- Export reports to PDF format
Upon completion of this module, participants will be able to:
- Explain the structure of paginated reports
- Construct a paginated report
- Configure data sources and datasets
- Integrate charts and tables
- Publish reports to the service
Module 10: Advanced Analytics Execution
This module enables participants to apply advanced features for deeper analytical insights. It provides the steps necessary for conducting substantive data analysis and utilizing AI-driven visuals to derive meaningful patterns and trends.
Lessons
- Advanced Analytics methodologies
- AI-driven data insights
Lab : Data Analysis in Power BI Desktop
- Generate animated scatter charts
- Apply visual forecasting tools
- Analyze using the Decomposition Tree visual
- Evaluate factors with the Key Influencers visual
Upon completion of this module, participants will be able to:
- Interpret statistical summaries
- Leverage the Analyze feature
- Detect data outliers
- Execute time-series analysis
- Utilize AI-integrated visuals
- Apply Advanced Analytics custom visuals
Module 11: Workspace Creation and Management
This module introduces the management of Workspaces, including their creation and administration. It covers the protocols for sharing content, such as reports and dashboards, and the distribution of applications to authorized users.
Lessons
- Workspace establishment
- Asset sharing and administration
Lab : Publishing and Sharing Power BI Content
- Assign security principals to dataset roles
- Distribute dashboards to stakeholders
- Deploy an App
Upon completion of this module, participants will be able to:
- Establish and manage a workspace
- Understand workspace collaboration models
- Monitor workspace utilization and performance
- Distribute applications to users
Module 12: Dataset Management in Power BI
This module addresses the administration of Power BI assets, including datasets and workspaces. It covers the publication of datasets to the Power BI service, as well as procedures for refreshing and securing data for compliance.
Lessons
- Parameter configuration
- Dataset administration
Upon completion of this module, participants will be able to:
- Configure and manage parameters
- Administer dataset settings
- Set dataset refresh schedules
- Troubleshoot gateway connectivity issues
Module 13: Row-Level Security Implementation
This module details the procedures for implementing and configuring security controls in Power BI to ensure the protection of sensitive assets in accordance with government standards.
Lessons
- Security frameworks in Power BI
Upon completion of this module, participants will be able to:
- Evaluate the components of Power BI security
- Configure row-level security roles and group memberships
Requirements
Data Analysts initiating this role should possess experience working with cloud-based data environments.
Specific requirements include:
- Comprehension of core data concepts.
- Proficiency in managing relational data in cloud platforms.
- Proficiency in managing non-relational data in cloud platforms.
- Familiarity with data analysis and visualization principles.
Participants may acquire the necessary prerequisites and enhance their understanding of Azure data operations by completing Microsoft Azure Data Fundamentals prior to enrolling in this course.
Audience profile
The target audience for this course includes data professionals and business intelligence specialists seeking to master accurate data analysis using Power BI. It is also intended for individuals who develop reports visualizing data from both cloud-based and on-premises platform technologies.
Job role: Data Analyst
Preparation for exam: DA-100
Features: none
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
opened my thinking on how to apply the knowledge gained.
Gabriel Govender - National Transmission Company South Africa
Course - Analyzing Data with Power BI
I liked that it demonstrated practical examples that I can apply in my day-to-day work which will improve my reports.
Nondumiso Mthembu - National Transmission Company South Africa
Course - Analyzing Data with Power BI
Blessing made sure that he knows every one , and referred every candidate by their name which is excellent. He is a well experienced Trainer and has patience, and very helpful to all the candidates. Trainer like him make the training more interesting. Wish to have him allocated to my next training that I will be doing with your company.
Alfred Mashala - National Transmission Company South Africa
Course - Analyzing Data with Power BI
I loved everything about the training especially the dashboard presentations
