on-demand course

Exam DA-100 Analyzing Data with Microsoft Power BI (Video)

with Chris Sorensen

October 2021

Intermediate

English

Microsoft Press

Closed Captioning available in English

Watch now

Unlock full access

Includes

Earns Badge

Course outline

Exam DA-100: Analyzing Data with Microsoft Power BI: Introduction
5m 7s
Module introduction
1m 39s
Learning objectives
57s
1.1 Identify and connect to a data source
3m 52s
1.2 Change data source settings
3m 58s
1.3 Select a shared dataset or create a local dataset
6m 24s
1.4 Select a storage mode
8m 39s
1.5 Choose an appropriate query type
9m 13s
1.6 Identify query performance issues
7m 49s
1.7 Use Microsoft Dataverse
1m 35s
1.8 Use parameters
6m 12s
1.9 Use or create a PBIDS file
2m 32s
1.10 Use or create a data flow
9m 21s
1.11 Connect to a dataset using the XMLA endpoint
2m 5s
Learning objectives
31s
2.1 Identify data anomalies
4m 3s
2.2 Examine data structures
2m 41s
2.3 Interrogate column properties
2m 17s
2.4 Interrogate data statistics
4m 42s
Learning objectives
1m 0s
3.1 Resolve inconsistencies, unexpected or null values, and data quality issues
3m 59s
3.2 Apply user-friendly value replacements
3m 22s
3.3 Identify and create appropriate keys for joins
3m 51s
3.4 Evaluate and transform column data types
6m 57s
3.5 Apply data shape transformations to table structures
5m 41s
3.6 Combine queries
12m 42s
3.7 Apply user-friendly naming conventions to columns and queries
7m 3s
3.8 Leverage Advanced Editor to modify Power Query M code
3m 19s
3.9 Configure data loading
4m 38s
3.10 Resolve data import errors
4m 13s
Module introduction
33s
Learning objectives
48s
4.1 Define the tables
5m 37s
4.2 Configure table and column properties
7m 33s
4.3 Define quick measures
5m 52s
4.4 Flatten out a parent-child hierarchy
4m 0s
4.5 Define role-playing dimensions
2m 41s
4.6 Define a relationship's cardinality and cross-filter direction
4m 46s
4.7 Design the data model to meet performance requirements
2m 25s
4.8 Resolve many-to-many relationships
2m 58s
4.9 Create a common date table
10m 8s
4.10 Define the appropriate level of data granularity
1m 54s
4.11 Apply or change sensitivity labels
7m 44s
Learning objectives
36s
5.1 Apply cross-filter direction and security filtering
5m 28s
5.2 Create calculated tables
3m 51s
5.3 Create hierarchies
13m 12s
5.4 Create calculated columns
5m 7s
5.5 Implement row-level security roles
8m 43s
5.6 Set up the Q&A feature
4m 40s
5.7 Implement object-level security
1m 20s
Learning objectives
36s
6.1 Use DAX to build complex measures
4m 14s
6.2 Use CALCULATE to manipulate filters
3m 54s
6.3 Implement Time Intelligence using DAX
2m 38s
6.4 Replace numeric columns with measures
3m 57s
6.5 Use basic statistical functions to enhance data
5m 25s
6.6 Create semi-additive measures
3m 6s
Learning objectives
34s
7.1 Remove unnecessary rows and columns
2m 31s
7.2 Identify poorly performing measures, relationships, and visuals
6m 50s
7.3 Improve cardinality levels
3m 12s
7.4 Optimize DirectQuery models
2m 58s
7.5 Create and manage aggregations
4m 57s
7.6 Use Query Diagnostics
3m 13s

Content preview from Exam DA-100 Analyzing Data with Microsoft Power BI (Video)

3.1 Resolve inconsistencies, unexpected or null values, and data quality issues

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Data Analysis with Microsoft Power BI

Brian Larson

Microsoft Power BI Data Analyst Certification Companion: Preparation for Exam PL-300

Jessica Jolly

Analyzing Data with Power BI and Power Pivot for Excel, First Edition

Alberto Ferrari, Marco Russo

Building Interactive Dashboards with Microsoft Power BI

Peter MacMurchy

Publisher Resources

ISBN: 9780137574520

Exam DA-100 Analyzing Data with Microsoft Power BI (Video)

with Chris Sorensen

Introduction

Module 1: Prepare the Data

Lesson 1: Get Data from Different Data Sources

Lesson 2: Profile the Data

Lesson 3: Clean, Transform, and Load the Data

Module 2: Model the Data

Lesson 4: Design a Data Model

Lesson 5: Develop a Data Model

Lesson 6: Create Measures by Using DAX

Lesson 7: Optimize Model Performance

Module 3: Visualize the Data

Lesson 8: Create Reports

Lesson 9: Create Dashboards

Lesson 10: Enrich Reports for Usability

Module 4: Analyze the Data

Lesson 11: Enhance Reports to Expose Insights

Lesson 12: Perform Advanced Analysis

Module 5: Deploy and Maintain Deliverables

Lesson 13: Manage Datasets

Lesson 14: Create and Manage Workspaces

Summary

Content preview from Exam DA-100 Analyzing Data with Microsoft Power BI (Video)

3.1 Resolve inconsistencies, unexpected or null values, and data quality issues

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

You might also like

Data Analysis with Microsoft Power BI

Microsoft Power BI Data Analyst Certification Companion: Preparation for Exam PL-300

Analyzing Data with Power BI and Power Pivot for Excel, First Edition

Building Interactive Dashboards with Microsoft Power BI

Publisher Resources

Introduction

Module 1: Prepare the Data

Lesson 1: Get Data from Different Data Sources

Lesson 2: Profile the Data

Lesson 3: Clean, Transform, and Load the Data

Module 2: Model the Data

Lesson 4: Design a Data Model

Lesson 5: Develop a Data Model

Lesson 6: Create Measures by Using DAX

Lesson 7: Optimize Model Performance

Module 3: Visualize the Data

Lesson 8: Create Reports

Lesson 9: Create Dashboards

Lesson 10: Enrich Reports for Usability

Module 4: Analyze the Data

Lesson 11: Enhance Reports to Expose Insights

Lesson 12: Perform Advanced Analysis

Module 5: Deploy and Maintain Deliverables

Lesson 13: Manage Datasets

Lesson 14: Create and Manage Workspaces

Summary

Content preview from Exam DA-100 Analyzing Data with Microsoft Power BI (Video)

3.1 Resolve inconsistencies, unexpected or null values, and data quality issues

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,and much more.

You might also like

Data Analysis with Microsoft Power BI

Microsoft Power BI Data Analyst Certification Companion: Preparation for Exam PL-300

Analyzing Data with Power BI and Power Pivot for Excel, First Edition

Building Interactive Dashboards with Microsoft Power BI

Publisher Resources

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.