Microsoft Data Analytics

The audience for this course is data analyst, 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.

PREREQUISITES

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.

Learn how to accurately perform data analysis using Power BI.

Develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.

Microsoft Data Analytics

• Data Analytics

• Getting Started

Design a Data Model

• Working with tables

• Dimensions and Hierarchies

Labs

Create Measures using DAX

• Introduction to DAX

• DAX context

• Advanced DAX Lab

Optimize Model Performance

• Optimize the model for performance

• Optimize DirectQuery Models

• Create and manage Aggregations

Create Reports

• Design a report

• Enhance the report

Labs

Create Dashboards

• Create a Dashboard

• Real-time Dashboards

• Enhance a Dashboard Labs

Perform Advanced Analytics

• Advanced Analytics

• Data Insights through AI visuals

Labs

Create and Manage Workspaces

• Creating Workspaces

• Sharing and Managing Assets

Labs

Manage Datasets

• Parameters

• Datasets

Row-level security

Performing Real-Time Analytics with Stream Analytics

Lab Demo

• Explain data streams and event processing

• Data Ingestion with Event Hubs

• Processing Data with Stream Analytics Jobs

Azure Real-Time Reference Architectures