Get The
AI CERTs
LMS App
Unlock exclusive app-only features
Download App
×
Skip to main content
Microsoft Power BI Data Analyst
0%
Previous
Course data
Module 1: Discover Data Analysis
1.1 Introduction to Data Analysis
1.2 Overview of Data Analysis
1.3 Roles in Data
1.4 Tasks of a Data Analyst
1.5 summary
Module 2: Get Started Building with Power BI
2.1 Introduction to Microsoft Power BI
2.2 Use Power BI
2.3 Building Blocks of Power BI
2.4 Tour and Use of the Power BI Service
2.5 summary
Module 3: Create Interactive Reports Using Copilot for Power BI
3.1 Introduction to Interactive Reports Using Copilot for Power BI
3.2 Prepare Data for Copilot Power BI
3.3 Use Copilot PowerBI to Model Your Data
3.4 Create Reports With Copilot for Power BI
3.5 Create Summaries With Copilot for Power BI
3.6 Summary
Module 4: Get Data in Power BI
4.1 Introduction to Get Data in Power BI
4.2 Get Data from Files
4.3 Get Data from Relational Data Sources
4.4 Create Dynamic Reports with Parameters
4.5 Get Data from a NoSQL Database
4.6 Get Data from Online Services
4.7 Select a Storage Mode
4.8 Get Data from Azure Analysis Services
4.9 Fix Performance Issues
4.10 Resolve Data Import Errors
4.11 Summary
Module 5: Clean, Transform And Load Data in Power BI
5.1 Introduction to Clean, Transform And Load Data in Power BI
5.2 Shape The Initial Data
5.3 Simplify the Data Structure
5.4 Evaluate and Change Column Data Types
5.5 Combine Multiple Tables Into A Single Table
5.6 Profile Data In Power BI
5.7 Use Advanced Editor to Modify M Code
5.8 Summary
Module 6: Describe Power BI Desktop Models
6.1 Introduction
6.2 Star Schema Design
6.3 Analytic Queries
6.4 Configure Report Visuals
6.5 Summary
Module 7: Choose A Power BI Model Framework
7.1 Introduction
7.2 Describe Power BI Model Fundamentals
7.3 Determine When to Develop an Import Model
7.4 Determine When To Develop a DirectQuery Model
7.5 Determine When To Develop a Composite Model
7.6 Choose a Model Framework
7.7 Summary
Module 8: Designing a Semantic Model in Power BI
8.1 Introduction
8.2 Simplifying Table Structures
8.3 Create A Date Table
8.4 Work With Dimensions
8.5 Define Data Granularity
8.6 Work with Relationships And Cardinality
8.7 Resolve Modeling Challenges
8.8 Summary
Module 9: Write DAX Formulas For Power BI Desktop Models
9.1 Introduction
9.2 Write DAX Formulas
9.3 DAX Data Types
9.4 Work With DAX Functions
9.5 Use DAX Operators
9.6 Use DAX variables
9.7 Summary
Module 10: Add measures to Power BI Desktop models
10.1 Introduction to Measures in Microsoft Power BI Models
10.2 Create Simple Measures
10.3 Create Compound Measures
10.4 Create Quick Measures
10.5 Compare Calculated Columns With Measures
10.6 Summary
Module 11: Add Calculated Tables And Columns To Power BI Desktop Models
11.1 Introduction To Calculated Tables
11.2 Create Calculated Columns
11.3 Learn about Row Context
11.4 Choose A Technique To Add A Column
11.5 Summary
Module 12: Use DAX Time Intelligence Functions In Power BI Desktop Models
12.1 Introduction To Time Intelligence In Power Bl
12.2 Use DAX Time Intelligence Functions
12.3 Additional Time Intelligence Calculations
12.4 Summary
Module 13: Optimize A Model For Performance In Power BI
13.1 Introduction to Performance Optimization
13.2 Review Performance Of Measures, Relationships And Visuals
13.3 Use variables To Improve Performance And Troubleshooting
13.4 Reduce Cardinality
13.5 Optimize Direct Query Models With Table Level Storage
13.6 Create and manage Aggregations
13.7 Summary
Module 14: Enforce Power BI Model security
14.1 Introduction
14.2 Restrict Access To Power BI Model Data
14.3 Restrict Access To Power BI Model Objects
14.4 Apply Good Modeling Practices
14.5 Summary
Module 15: Scope Report Design Requirements
15.1 Introduction
15.2 Identify The Audience
15.3 Determine Report Types
15.4 Define User Interface Requirements
15.5 Define User Experience Requirements
15.6 Explore Report Designs
15.7 Summary
Module 16: Design Power BI Reports
16.1 Introduction to Power BI Report Design
16.2 Design the Analytical Report Layout
16.3 Designing Visually Appealing Reports
16.4 Report Objects
16.5 Select Report Visuals
16.6 Select Report Visuals to Suit the Report Layout
16.7 Formatting and Configuring Visualizations
16.8 Introduction to KPIs
16.9 Summary
Module 17: Create visual calculations in Power BI Desktop
17.1 Introduction to visual calculations
17.2 Understand visual calculations
17.3 Create visual calculations
17.4 Use Parameters In Visual Calculations
17.5 Sammary
Module 18: Configure Power BI Reports Filters
18.1 Introduction to Designing Reports for Filtering
18.2 Apply Filters To The Report Structure
18.3 Apply Filters with Slicers
18.4 Design Reports With Advanced Filtering Techniques
18.5 Consumption-Time Filtering
18.6 Select Report Filter Techniques
18.7 Summary
Module 19: Enhance power BI report designs for the User Experience
19.1 Design Reports to Show Details
19.2 Design Reports to Highlight Values
19.3 Design Reports That Behave Like Apps
19.4 Work with Bookmarks
19.5 Designing Reports for Navigation
19.6 Work With Visual Headers
19.7 Design Reports with Built-in Assistance
19.8 Tune Report Performance
19.9 Optimize Reports for Mobile Use
19.10 Summary
Module 20: Perform Analytics in power BI
20.1 Introduction to Analytics
20.2 Explore Statistical Summary
20.3 Identify Outliers with Power BI visuals
20.4 Group and Bin Data for Analysis
20.5 Apply Clustering Techniques
20.6 Conduct Time Series Analysis
20.7 Use The Analyze Feature
20.8 Create What-If Parameters
20.9 Use Specialized Visuals
20.10 Summary
Module 21: Create And Manage workspaces In Power BI
21.1 Introduction to Power BI Workspaces
21.2 Distribute a Report Or Dashboard
21.3 Monitor Usage and Performance
21.4 Introduction to Development Life Cycle Strategy
21.5 Troubleshoot Data By Viewing It's Lineage
21.6 Introduction to Data Protection in Power BI
21.7 Summary
Module 22: Manage Semantic Models In Power BI
22.1 Introduction
22.2 Using a Power BI Gateway to Connect to On-Premises Data Sources
22.3 Configure A Semantic Model Scheduled Refresh
22.4 Configuring Incremental Refresh Settings
22.5 Manage And Promote Semantic Models
22.6 Troubleshooting Service Connectivity
22.7 Boost Performance with Query Caching (Premium)
22.8 Summary
Module 23: Create Dashboards in Power BI
23.1 Introduction to Power BI Dashboards
23.2 Configuring Data Alerts in Power BI
23.3 Explore Data By Asking Questions in Power BI
23.4 Reviewing Quick Insights in Power BI
23.5 Dashboard Themes in Power BI
23.6 Pinning a Live Report Page to a Dashboard in Power BI
23.7 Configure a Real-Time Dashboard in Power BI
23.8 Setting Mobile View in Power Bl
23.9 Summary
Module 24: Implement Row-Level Security
24.1 Introduction
24.2 Configure Row-Level Security With The Static Method
24.3 Configuring Row-Level Security (RLS) With The Dynamic Method in Power BI
24.4 Summary
Next
Side panel
Categories
All categories
AI CERTs
AI CERTs- LAN
AICERTs- Extended E-Learnin...
AICERTs- Extended E-Learnin...
AI CERTs-Spanish
ANAB
MS ELearning
Other Category
Other Category - LAN
Eduman
MS Elearning - Russel
V3 - Russel
AICERTs- Extended E-Learnin...
Russian Course
Qazaq Course
AI CERTs - Arabic
AI CERTs - French
Agent X
AI CERTs - Bengali
AI CERTs - Portuguese
ATP
AI CERTs - Chinese
AI CERTs - Azerbaijani
AI CERTs - Turkish
AI CERTs - German
AI CERTs - Indonesian
CFF
Self Paced Vimeo
AI CERTs - Italic
Home
Store
Store
Contact Us
Watch Demo
Log in
Categories
Collapse
Expand
All categories
AI CERTs
AI CERTs- LAN
AICERTs- Extended E-Learnin...
AICERTs- Extended E-Learnin...
AI CERTs-Spanish
ANAB
MS ELearning
Other Category
Other Category - LAN
Eduman
MS Elearning - Russel
V3 - Russel
AICERTs- Extended E-Learnin...
Russian Course
Qazaq Course
AI CERTs - Arabic
AI CERTs - French
Agent X
AI CERTs - Bengali
AI CERTs - Portuguese
ATP
AI CERTs - Chinese
AI CERTs - Azerbaijani
AI CERTs - Turkish
AI CERTs - German
AI CERTs - Indonesian
CFF
Self Paced Vimeo
AI CERTs - Italic
Home
Store
Store
Contact Us
Watch Demo
Course info
Microsoft Power BI Data Analyst
