Course Details
Course Outline
1 - Module 1: Get Started with Microsoft Data Analytics
Data Analytics and MicrosoftGetting Started with Power BI
2 - Module 2: Prepare Data in Power BI
Get data from various data sources
3 - Module 3: Clean, Transform, and Load Data in Power BI
Data shapingData ProfilingEnhance the data structure
4 - Module 4: Design a Data Model in Power BI
Introduction to data modelingWorking with tablesDimensions and Hierarchies
5 - Module 5: Create Model Calculations using DAX in Power BI
Introduction to DAXReal-time dashboardsAdvanced DAX
6 - Module 6: Optimize Model Performance in Power BI
Optimize the data model for performanceOptimize DirectQuery Models
7 - Module 7: Create Reports in Power BI
Design a reportEnhance the report
8 - Module 8: Create Dashboards in Power BI
Create a DashboardReal-time DashboardsEnhance a Dashboard
9 - Module 9: Identify Patterns and Trends in Power BI
Advanced AnalyticsData Insights through AI visuals
10 - Module 10: Create and Manage Workspaces in Power BI
Creating WorkspacesSharing and Managing Assets
11 - Module 11: Manage Files and Datasets in Power BI
ParametersDatasets
12 - Module 12: Row-level Security in Power BI
Security in Power BI
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
Before attending this course, students must have:
Successful Data Analysts start this role with experience of working with data in the cloud.
Specifically:
Understanding core data concepts.
Knowledge of working with relational data in the cloud.
Knowledge of working with non-relational data in the cloud.
Knowledge of data analysis and visualization concepts.
You can gain the prerequisites and a better understanding of working with data in Azure by completing Course DP-900T00: Microsoft Azure Data Fundamentals before taking this course.
Before attending this course, students should have an understanding of the following concepts as related to Windows Server technologies:
High availability and disaster recovery
Automation
Monitoring
Troubleshooting