Exam Ref DA-100 Analyzing Data with Microsoft Power BI

✍ Scribed by Daniil Maslyuk

• Publisher: Microsoft Press
• Year: 2021
• Tongue: English
• Leaves: 320
• Edition: 1
• Category: Library

✦ Synopsis

Prepare for Microsoft Exam DA-100 and help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced data analytics professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified Associate level.

Focus on the expertise measured by these objectives:

• Prepare the data
• Model the data
• Visualize the data
• Analyze the data
• Deploy and maintain deliverables
  

This Microsoft Exam Ref:

• Organizes its coverage by exam objectives
• Features strategic, what-if scenarios to challenge you
• Assumes you are an experienced business intelligence professional or data analyst, or have a similar role
  

Analyzing Data with Microsoft Power BI About the Exam
Exam DA-100 focuses on skills and knowledge needed to acquire, profile, clean, transform, and load data; design and develop data models; create measures with DAX; optimize model performance; create reports and dashboards; enrich reports for usability; enhance reports to expose insights; perform advanced analysis; manage datasets, and create and manage workspaces.

About Microsoft Certification
Passing this exam earns your Microsoft Certified: Data Analyst Associate certification, demonstrating your ability to help businesses maximize the value of data assets by using Microsoft Power BI.

As subject matter experts, Data Analysts design and build scalable data models, clean and transform data, and enable advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations.

See full details at: microsoft.com/learn

✦ Table of Contents

Cover
Title Page
Copyright Page
Dedication
Contents at a glance
Contents
Introduction
Organization of this book
Preparing for the exam
Microsoft certifications
Companion files
Quick access to online references
Errata, updates, & book support
Stay in touch
Chapter 1 Prepare the data
Skill 1.1: Get data from different data sources
Skill 1.2: Profile the data
Skill 1.3: Clean, transform, and load the data
Chapter 2 Model the data
Skill 2.1: Design a data model
Define the tables
Configure table and column properties
Define quick measures
Flatten out a parent-child hierarchy
Define role-playing dimensions
Define a relationship’s cardinality and cross-filter direction
Design the data model to meet performance requirements
Resolve many-to-many relationships
Create a common date table
Define the appropriate level of data granularity
Skill 2.2: Develop a data model
Skill 2.3: Create measures by using DAX
Skill 2.4: Optimize model performance
Chapter 3 Visualize the data
Skill 3.1: Create reports
Skill 3.2: Create dashboards
Skill 3.3: Enrich reports for usability
Chapter 4 Analyze the data
Skill 4.1: Enhance reports to expose insights
Skill 4.2: Perform advanced analysis
Chapter 5 Deploy and maintain deliverables
Skill 5.1: Manage datasets
Skill 5.2: Create and manage workspaces
Index
A
B
C
D
E
F
G-H-I
J-K
L
M
N
O-P
Q
R
S
T
U-V
W
X-Y-Z
Page vierge