Paperback
-
PICK UP IN STORECheck Availability at Nearby Stores
Available within 2 business hours
Related collections and offers
Overview
Focus on the expertise measured by these objectives:
- Prepare the data
- Model the data
- Visualize and analyze the data
- Deploy and maintain assets
This Microsoft Exam Ref:
- Organizes its coverage by exam objectives
- Features strategic, what-if scenarios to challenge you
- Assumes you are a data analyst, business intelligence professional, report creator, or other professional seeking to validate your skills and knowledge in analyzing data with Power BI
About the Exam
Exam PL-300 focuses on knowledge needed to get data from different data sources; clean, transform, and load data; design and develop data models; create model calculations with DAX; optimize model performance; create reports and dashboards; enhance reports for usability and storytelling; identify patterns and trends; and manage files, datasets, and workspaces.
About Microsoft Certification
Passing this exam fulfills your requirements for the Microsoft Certified: Power BI Data Analyst Associate certification, demonstrating your understanding of data repositories and data processes, and your skills in designing and building scalable data models, cleaning and transforming data, enabling advanced analytic capabilities to provide meaningful business value, and collaborating with key stakeholders to deliver relevant insights based on identified business requirements.
See full details at: microsoft.com/learn
Product Details
ISBN-13: | 9780137901234 |
---|---|
Publisher: | Pearson Education |
Publication date: | 08/27/2022 |
Series: | Exam Ref |
Pages: | 224 |
Sales rank: | 579,304 |
Product dimensions: | 7.38(w) x 9.20(h) x 0.50(d) |
About the Author
Table of Contents
Introduction xi
Organization of this book xi
Preparing for the exam xi
Microsoft certifications xii
Quick access to online references xii
Errata, updates, & book support xiii
Stay in touch xiii
Chapter 1 Prepare the data 1
Skill 1.1: Get data from different data sources 1
Identify and connect to a data source 2
Change data source settings 6
Select a shared dataset or create a local dataset 7
Select a storage mode 9
Use Microsoft Dataverse 12
Change the value in a parameter 13
Connect to a dataflow 17
Skill 1.2: Clean, transform, and load the data 18
Profile the data 19
Resolve inconsistencies, unexpected or null values, and data quality issues 23
Identify and create appropriate keys for joins 26
Evaluate and transform column data types 28
Shape and transform tables 30
Combine queries 41
Apply user-friendly naming conventions to columns and queries 45
Configure data loading 46
Resolve data import errors 47
Chapter summary 48
Thought experiment 49
Thought experiment answers 51
Chapter 2 Model the data 53
Skill 2.1: Design a data model 53
Define the tables and design a data model that uses a star schema 54
Configure table and column properties 56
Design and implement role-playing dimensions 58
Define a relationship's cardinality and cross-filter direction 61
Create a common date table 66
Skill 2.2: Develop a data model 68
Create calculated tables 68
Create hierarchies 70
Create calculated columns 71
Implement row-level security roles 73
Use the Q&A feature 79
Skill 2.3: Create model calculations by using DAX 83
Create basic measures by using DAX 83
Use CALCULATE to manipulate filters 86
Implement Time Intelligence using DAX 91
Replace implicit measures with explicit measures 93
Use basic statistical functions 94
Create semi-additive measures 95
Use quick measures 97
Skill 2.4: Optimize model performance 100
Remove unnecessary rows and columns 100
Identify poorly performing measures, relationships, and visuals 101
Reduce cardinality levels to improve performance 102
Chapter summary 104
Thought experiment 105
Thought experiment answers 108
Chapter 3 Visualize and analyze the data 111
Skill 3.1: Create reports 111
Add visualization items to reports 112
Choose an appropriate visualization type 113
Format and configure visualizations 124
Use a custom visual 125
Apply and customize a theme 126
Configure conditional formatting 128
Apply slicing and filtering 130
Configure the report page 133
Use the Analyze in Excel feature 134
Choose when to use a paginated report 135
Skill 3.2: Create dashboards 135
Manage tiles on a dashboard 136
Configure mobile view 138
Use the Q&A feature 139
Add a Quick Insights result to a dashboard 140
Add a dashboard theme 142
Pin a live report page to a dashboard 143
Skill 3.3: Enhance reports for usability and storytelling 144
Configure bookmarks 144
Create custom tooltips 147
Edit and configure interactions between visuals 149
Configure navigation for a report 150
Apply sorting 151
Configure sync slicers 152
Group and layer visuals by using the Selection pane 154
Drill down into data using interactive visuals 155
Export report data 156
Design reports for mobile devices 156
Skill 3.4: Identify patterns and trends 157
Use the Analyze feature in Power BI 158
Identify outliers 159
Choose between continuous and categorical axes 160
Use groupings, binnings, and clustering 161
Use AI visuals 164
Use the Forecast feature 168
Create reference lines by using the Analytics pane 168
Chapter summary 170
Thought experiment 172
Thought experiment answers 174
Chapter 4 Deploy and maintain assets 177
Skill 4.1: Manage files and datasets 177
Identify when a gateway is required 178
Configure a dataset scheduled refresh 178
Configure row-level security group membership 180
Provide access to datasets 182
Manage global options for files 185
Skill 4.2: Manage workspaces 186
Create and configure a workspace 186
Assign workspace roles 188
Configure and update a workspace app 189
Publish, import, or update assets in a workspace 193
Apply sensitivity labels to workspace content 195
Configure subscriptions and data alerts 196
Promote or certify Power BI content 198
Chapter summary 199
Thought experiment 200
Thought experiment answers 201
Index 203