Course Outline
Module 1: Introduction to Microsoft Data Analytics
This module examines the various roles within the data domain, clarifies the key responsibilities of Data Analysts, and provides an overview of the Power BI product portfolio.
Lessons
- Microsoft and Data Analytics
- Beginning with Power BI
Lab : Starting Out
- Getting Started
Upon completion of this module, you will be able to:
- Examine the different roles in data analytics
- Identify the core tasks performed by a data analyst
- Describe the ecosystem of Power BI products and services
- Navigate and use the Power BI service
Module 2: Data Preparation in Power BI
This module focuses on identifying and retrieving data from a variety of sources. You will explore connectivity and data storage options, gaining an understanding of the performance implications associated with direct connectivity versus data import.
Lessons
- Sourcing data from various origins
- Performance optimization
- Addressing data errors
Lab : Data Preparation in Power BI Desktop
- Preparing Data
Upon completion of this module, you will be able to:
- Source and retrieve data from different platforms
- Comprehend connection methods and their impact on performance
- Improve query performance
- Fix data import issues
Module 3: Cleaning, Transforming, and Loading Data in Power BI
This module guides you through profiling and assessing data condition. You will learn to detect anomalies, evaluate data size and structure, and execute necessary cleaning and transformation steps to prepare the data for model ingestion.
Lessons
- Data reshaping
- Improving data structure
- Data Profiling
Lab : Data Transformation and Loading
- Loading Data
Upon completion of this module, students will be able to:
- Apply data shape transformations
- Enhance the underlying data structure
- Profile and scrutinize the data
Module 4: Designing a Data Model in Power BI
This module covers the essential concepts for designing and developing data models that ensure optimal performance and scalability. It also addresses common data modeling challenges, including relationship management, security, and performance tuning.
Lessons
- Foundations of data modeling
- Managing tables
- Dimensions and Hierarchies
Lab : Data Modeling in Power BI Desktop
- Establish Model Relationships
- Set Up Tables
- Examine the model interface
- Generate Quick Measures
Lab : Advanced Data Modeling in Power BI Desktop
- Set up many-to-many relationships
- Apply row-level security
Upon completion of this module, you will be able to:
- Grasp the fundamentals of data modeling
- Define relationships and their cardinality
- Implement Dimensions and Hierarchies
- Generate histograms and rankings
Module 5: Creating Measures with DAX in Power BI
This module introduces the capabilities of DAX for enhancing data models. You will explore aggregations, the concepts of Measures and calculated columns/tables, and Time Intelligence functions to resolve complex calculation and analysis challenges.
Lessons
- Getting started with DAX
- DAX context
- Advanced DAX techniques
Lab : DAX Basics in Power BI Desktop
- Build calculated tables
- Build calculated columns
- Create measures
Lab : Advanced DAX in Power BI Desktop
- Manipulate filter context using the CALCULATE() function
- Apply Time Intelligence functions
Upon completion of this module, you will be able to:
- Comprehend DAX
- Utilize DAX for basic formulas and expressions
- Develop calculated tables and measures
- Construct simple measures
- Utilize Time Intelligence and Key Performance Indicators
Module 6: Optimizing Model Performance
This module outlines the steps, processes, and best practices required to optimize data models for enterprise-level performance.
Lessons
- Optimizing the model for speed
- Optimizing DirectQuery Models
- Building and managing Aggregations
Upon completion of this module, you will be able to:
- Recognize the importance of variables
- Refine the data model
- Optimize the storage model
- Apply aggregations
Module 7: Building Reports
This module presents the core principles of report design and construction, including selecting appropriate visuals, structuring page layouts, and applying essential functionality. It also addresses the critical aspect of designing for accessibility.
Lessons
- Structuring a report
- Refining the report
Lab : Report Design in Power BI
- Establish a live connection in Power BI Desktop
- Design a report
- Set visual fields and format properties
Lab : Enhancing Power BI reports with interaction and formatting
- Create and set up Sync Slicers
- Develop a drillthrough page
- Apply conditional formatting
- Create and utilize Bookmarks
Upon completion of this module, you will be able to:
- Design a report page layout
- Choose and add effective visualizations
- Incorporate basic report features
- Add report navigation and interactions
- Enhance report performance
- Design with accessibility in mind
Module 8: Building Dashboards
In this module, you will learn to craft compelling narratives using dashboards and various navigation tools. You will be introduced to specific features and functionality to enhance dashboard usability and extract deeper insights.
Lessons
- Building a Dashboard
- Real-time Dashboards
- Improving a Dashboard
Lab : Report Design in Power BI Desktop - Part 1
- Build a Dashboard
- Pin visuals to a Dashboard
- Set up Dashboard tile alerts
- Leverage Q&A to generate a dashboard tile
Upon completion of this module, students will be able to:
- Build a Dashboard
- Understand real-time Dashboards
- Improve Dashboard usability
Module 9: Creating Paginated Reports in Power BI
This module explains paginated reports and their role within the Power BI ecosystem. You will then learn how to construct and publish such reports.
Lessons
- Paginated report fundamentals
- Creating Paginated reports
Lab : Creating a Paginated report
- Leverage Power BI Report Builder
- Design a multi-page report layout
- Define a data source
- Define a dataset
- Create a report parameter
- Export a report to PDF
Upon completion of this module, you will be able to:
- Describe paginated reports
- Build a paginated report
- Create and configure a data source and dataset
- Work with charts and tables
- Publish a report
Module 10: Executing Advanced Analytics
This module helps you apply additional features to enhance reports for deeper analytical insights, equipping you to use the report for practical data analysis. You will also perform advanced analytics using AI visuals to derive more meaningful data insights.
Lessons
- Advanced Analytics
- Data Insights through AI visuals
Lab : Data Analysis in Power BI Desktop
- Create animated scatter charts
- Use the visual to forecast values
- Utilize the Decomposition Tree visual
- Utilize the Key Influencers visual
Upon completion of this module, you will be able to:
- Examine statistical summaries
- Utilize the Analyze feature
- Detect outliers in data
- Perform time-series analysis
- Leverage AI visuals
- Use the Advanced Analytics custom visual
Module 11: Creating and Managing Workspaces
This module introduces Workspaces, detailing how to create and manage them. You will also learn how to share content, such as reports and dashboards, and distribute Apps.
Lessons
- Setting up Workspaces
- Sharing and Managing Assets
Lab : Publishing and Sharing Power BI Content
- Associate security principals with dataset roles
- Share a dashboard
- Publish an App
Upon completion of this module, you will be able to:
- Create and manage a workspace
- Understand workspace collaboration
- Track workspace usage and performance
- Distribute an App
Module 12: Managing Datasets in Power BI
In this module, you will learn how to manage Power BI assets, including datasets and workspaces. You will publish datasets to the Power BI service, then refresh and secure them.
Lessons
- Parameters
- Datasets
Upon completion of this module, you will be able to:
- Create and work with parameters
- Manage datasets
- Set up dataset refresh
- Resolve gateway connectivity issues
Module 13: Row-Level Security
This module guides you through the process of implementing and configuring security in Power BI to protect Power BI assets.
Lessons
- Security in Power BI
Upon completion of this module, you will be able to:
- Understand the components of Power BI security
- Set up row-level security roles and group memberships
Requirements
Data Analysts typically begin this role with experience working with cloud-based data.
Specifically, you should have:
- A solid understanding of core data concepts.
- Proficiency in handling relational data in the cloud.
- Experience with non-relational data in the cloud.
- Familiarity with data analysis and visualization principles.
To build these prerequisites and deepen your understanding of data operations in Azure, we recommend completing Microsoft Azure Data Fundamentals prior to enrolling in this course.
Audience profile
This course is designed for data professionals and business intelligence specialists aiming to master accurate data analysis using Power BI. It is also suited for individuals who develop reports visualizing data from platform technologies located both in the cloud and on-premises.
Target Job Role: Data Analyst
Exam Preparation: DA-100
Specific 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
