Introduction

The Power BI data analyst provides actionable understandings by leveraging available data and applying domain expertise. The Power BI data analyst cooperates with key stakeholders across verticals to identify business requirements, cleans and transforms the data, and then designs and builds data models by using Power BI. The Power BI data analyst provides meaningful business value through easy-to-comprehend data visualizations, enables others to perform self-service analytics, and deploys and configures solutions for consumption. Candidates for this exam should be proficient in using Power Query and writing expressions by using DAX.

This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

Course Objectives

After completing this training program, participants will know how to:

• Prepare the data

• Model the data

• Visualize and analyze the data

• Deploy and maintain assets

Target Audience

This course is targeted:

• Data professionals

• Business intelligence professionals who want to learn how to accurately perform data analysis using Power BI.

• Individuals who develop reports that visualize data from the data platform technologies that exist both in the cloud and on-premises.

Course Outlines

Day 1: Data Analysis Foundations & Power BI Introduction

Discover Data Analysis
Overview of Data Analysis
Roles in Data
Tasks of a Data Analyst
Building with Power BI Overview
Building Blocks of Power BI
Tour and Use of Power BI Service

Day 2: Data Preparation & Data Loading

Prepare Data for Analysis
Get Data in Power BI
Get Data from Files
Relational Data Sources
NoSQL Databases
Online Services
Azure Analysis Services
Select Storage Mode
Fix Performance Issues
Resolve Data Import Errors

Day 3: Data Cleaning, Transformation & Modeling

Clean, Transform and Load Data
Shape Initial Data
Simplify Data Structure
Change Data Types
Combine Tables
Profile Data in Power BI
Advanced Editor and M Code
Data Model Design
Tables and Relationships
Date Tables and Dimensions
Data Granularity
Modeling Challenges

Day 4: DAX, Measures & Performance Optimization

Introduction to DAX
Context in DAX
CALCULATE Function
Relationships in DAX
Semi-Additive Measures
Time Intelligence
Performance Optimization in Models
Variables for Optimization
Reduce Cardinality
DirectQuery Optimization
Aggregations

Day 5: Visualization, Reporting & Advanced Analytics

Power BI Visuals Overview
Report Design and Layout
Buttons, Bookmarks, Navigation
Filtering, Slicing, Sorting
Conditional Formatting
KPI Dashboards
Publishing and Exporting Reports
Mobile Optimization
Dashboards and Alerts
Paginated Reports
Advanced Analytics (Outliers, Clustering, Time Series)
AI Insights and Visuals
Q&A, Key Influencers, Decomposition Tree