DA-100: Analyzing Data with Microsoft Power BI

Module 1: Analyzing Data with Microsoft Power BI

Data Analytics and Microsoft

The tasks of a Data Analyst

Getting Started with Power BI

Module 2: Prepare Data in Power BI

Get data from multiple data sources such as SQL Server, Azure Cosmos DB, Azure Analysis Services

connection methods and their performance implications

options for data storage

Optimize query performance

Resolve data import errors

Lab : Preparing Data in Power BI Desktop

Connecting to data sources and inspecting data with Power Query Editor

Module 3: Clean, Transform, and Load Data in Power BI

Identify data anomalies

Data shaping

Apply data shape transformations

Enhance the data structure

Data Profiling

Data cleaning

Lab : Transforming and Loading Data

Querying and transforming data sets

Loading data

Module 4: Design a Data Model in Power BI

Introduction to data modelling

Data relationships

Performance implications

Data security

Working with tables

Dimensions and Hierarchies

Create histograms and rankings

Lab : Data Modelling in Power BI Desktop

Create Model Relationships

Configure Tables

Review the model interface

Create Quick Measures

Lab : Advanced Data Modelling in Power BI Desktop

Configure many-to-many relationships

Enforce row-level security

Module 5: Create Measures using DAX in Power BI

Introduction to DAX

DAX context

Using DAX for simple formulas and expressions

Advanced DAX

Working with Time Intelligence and Key Performance Indicators

Lab : Introduction to DAX in Power BI Desktop

Create calculated tables

Create calculated columns

Create measures

Lab : Advanced DAX in Power BI Desktop

Use the CALCULATE() function to manipulate filter context

Use Time Intelligence functions

Module 6: Optimize Model Performance

Optimise the data model for enterprise-level performance

Achieving efficiency by using variables

Data modelling best practices

Optimise DirectQuery Models

Create and manage Aggregations

Module 7: Create Reports

Design a report page layout

Enhance the report with visualisations

Report navigation and interactions

Use Performance Analyzer to improve efficiency of queries

Lab : Designing a report in Power BI

Create a live connection in Power BI Desktop

Design a report

Configure visual fields and format properties

Lab : Enhancing Power BI reports with interaction and formatting

Create and configure Sync Slicers

Create a drillthrough page

Apply conditional formatting

Create and use Bookmarks

Module 8: Create Dashboards

Graphical representation of data insights

Create a Dashboard

Navigation tools

Real-time Dashboards

Enhance a Dashboard

Lab : Designing a report in Power BI Desktop - Part 1

Create a Dashboard

Pin visuals to a Dashboard

Configure a Dashboard tile alert

Use Q&A to create a dashboard tile

Module 9: Create Paginated Reports in Power BI

Paginated report overview

Create Paginated reports

Lab : Creating a Paginated report

Use Power BI Report Builder

Design a multi-page report layout

Define a data source

Define a dataset

Create a report parameter

Export a report to PDF

Module 10: Perform Advanced Analytics

Advanced Analytics

Statistical functions

Identifying outliers

Conduct time-series analysis

Using the Analyze feature

Use advanced analytics custom visuals

Data Insights through AI visuals

Lab : Data Analysis in Power BI Desktop

Create animated scatter charts

Use the visual to forecast values

Work with Decomposition Tree visual

Work with the Key Influencers visual

Module 11: Create and Manage Workspaces

Creating Workspaces

Understand workspace collaboration

Assigning user roles and security

Distribute an App

Sharing and Managing Assets

Monitor workspace usage and performance

Lab : Publishing and Sharing Power BI Content

Map security principals to dataset roles

Share a dashboard

Publish an App

Module 12: Manage Datasets in Power BI

Create dynamics reports with parameters

Configuring a dataset refresh schedule

Managing Power BI assets

Manage and promote datasets

Troubleshoot gateway connectivity

Module 13: Row-level security

Security in Power BI

Configure row-level security roles and group memberships

Test roles in Power BI Desktop