Course Details
Course Outline
1 - Get Started with Microsoft Data Analytics
Data Analytics and MicrosoftGetting Started with Power BITour and use the Power BI servicePower BI in the EnterpriseKnowledge Check
2 - Prepare Data in Power BI
Get data from various data sourcesOptimize performanceResolve data errorsKnowledge Check
3 - Clean, Transform, and Load Data in Power BI
Data shapingEnhance the data structureData ProfilingKnowledge Check
4 - Design a Data Model in Power BI
Introduction to data modelingWorking with tablesDimensions and HierarchiesKnowledge Check
5 - Create Measures using DAX in Power BI
Introduction to DAXDAX contextAdvanced DAXKnowledge Check
6 - Optimize Model Performance
Using VariablesFine-tune the data modelOptimize DirectQuery ModelsCreate and manage AggregationsKnowledge Check
7 - Create Reports
Design a reportEnhance the reportKnowledge Check
8 - Create Dashboards
Create a DashboardReal-time DashboardsEnhance a DashboardKnowledge Check
9 - Create Paginated Reports in Power BI
Paginated report overviewCreate Paginated reportsKnowledge Check
10 - Perform Advanced Analytics
Advanced AnalyticsData Insights through AI visualsKnowledge Check
11 - Create and Manage Workspaces
Creating WorkspacesSharing and Managing AssetsKnowledge Check
12 - Manage Datasets in Power BI
ParametersDatasetsKnowledge Check
13 - Row-level security
Security in Power BIKnowledge Check
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Target Audience
The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.
Other Prerequisites
In addition to their professional experience, students who take this training should have technical knowledge equivalent to the information found in the Azure Fundamentals course.