Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Microsoft Power BI Data Analyst Certification Guide
  • Table Of Contents Toc
Microsoft Power BI Data Analyst Certification Guide

Microsoft Power BI Data Analyst Certification Guide

By : Edenfield, Corcoran
3.9 (26)
Buy this Book
close
close
Microsoft Power BI Data Analyst Certification Guide

Microsoft Power BI Data Analyst Certification Guide

3.9 (26)
By: Edenfield, Corcoran
Buy this Book

Overview of this book

Microsoft Power BI enables organizations to create a data-driven culture with business intelligence for all. This guide to achieving the Microsoft Power BI Data Analyst Associate certification will help you take control of your organization's data and pass the exam with confidence. From getting started with Power BI to connecting to data sources, including files, databases, cloud services, and SaaS providers, to using Power BI’s built-in tools to build data models and produce visualizations, this book will walk you through everything from setup to preparing for the certification exam. Throughout the chapters, you'll get detailed explanations and learn how to analyze your data, prepare it for consumption by business users, and maintain an enterprise environment in a secure and efficient way. By the end of this book, you'll be able to create and maintain robust reports and dashboards, enabling you to manage a data-driven enterprise, and be ready to take the PL-300 exam with confidence.
Table of Contents (25 chapters)
close
close
close
Preface
Icon
Preface
Icon
Who this book is for
Icon
What this book covers
Icon
To get the most out of this book
Icon
Download the example code files
Icon
Download the color images
Icon
Conventions used
Icon
Get in touch
Icon
Share Your Thoughts
Icon
Learn more on Discord
1
Part 1 – Preparing the Data
Icon
Part 1 – Preparing the Data
Lock Free Chapter
2
Chapter 1: Overview of Power BI and the PL-300 Exam
Icon
Chapter 1: Overview of Power BI and the PL-300 Exam
Icon
A brief overview of Power BI
Icon
Why get certified?
Icon
PL-300 Analyzing Data with Microsoft Power BI
Icon
Summary
Icon
Questions
3
Chapter 2: Connecting to Data Sources
Icon
Chapter 2: Connecting to Data Sources
Icon
Technical requirements
Icon
Identifying data sources
Icon
Connecting to data sources
Icon
Power BI datasets
Icon
Power BI dataflows
Icon
Query performance tuning
Icon
Advanced options (what-if parameters, Power Query parameters, PBIDS files, and XMLA endpoints)
Icon
Summary
Icon
Questions
4
Chapter 3: Profiling the Data
Icon
Chapter 3: Profiling the Data
Icon
Technical requirements
Icon
Identifying data anomalies
Icon
Interrogating data statistics
Icon
Summary
Icon
Questions
5
Chapter 4: Cleansing, Transforming, and Shaping Data
Icon
Chapter 4: Cleansing, Transforming, and Shaping Data
Icon
Technical requirements
Icon
Accessing Power Query in Power BI
Icon
Sorting and filtering
Icon
Managing columns
Icon
Using column transformations
Icon
Using row transformations
Icon
Combining data
Icon
Enriching data with AI
Icon
Using advanced operations of Power Query
Icon
Summary
Icon
Questions
6
Part 2 – Modeling the Data
Icon
Part 2 – Modeling the Data
7
Chapter 5: Designing a Data Model
Icon
Chapter 5: Designing a Data Model
Icon
Technical requirements
Icon
Define the tables
Icon
Flatten out a parent-child hierarchy
Icon
Define role-playing dimensions
Icon
Configure table and column properties
Icon
Define quick measures
Icon
Resolve many-to-many relationships
Icon
Create a common date table
Icon
Define the appropriate level of data granularity
Icon
Design the data model to meet performance requirements
Icon
Summary
Icon
Questions
8
Chapter 6: Using Data Model Advanced Features
Icon
Chapter 6: Using Data Model Advanced Features
Icon
Technical requirements
Icon
Using sensitivity labels
Icon
Implementing row-level security
Icon
Applying natural-language Q&A capability
Icon
Summary
Icon
Questions
9
Chapter 7: Creating Measures Using DAX
chevron up
Icon
Chapter 7: Creating Measures Using DAX
Icon
Technical requirements
Icon
Building complex measures with DAX
Icon
Using CALCULATE to manipulate filters
Icon
Implementing time intelligence using DAX
Icon
Replacing numeric calculated columns with measures
Icon
Using basic statistical functions to enhance data
Icon
Implementing top N analysis
Icon
Creating semi-additive measures
Icon
Summary
Icon
Questions
10
Chapter 8: Optimizing Model Performance
Icon
Chapter 8: Optimizing Model Performance
Icon
Technical requirements
Icon
Optimizing data in the model
Icon
Optimizing measures, relationships, and visuals
Icon
Optimizing with aggregations
Icon
Query diagnostics
Icon
Summary
Icon
Questions
11
Part 3 – Visualizing the Data
Icon
Part 3 – Visualizing the Data
12
Chapter 9: Creating Reports
Icon
Chapter 9: Creating Reports
Icon
Technical requirements
Icon
Understanding the capabilities of Power BI
Icon
Adding visualization items to reports
Icon
Choosing an appropriate visualization type
Icon
Formatting and configuring visualizations
Icon
Importing a custom visual
Icon
Configuring conditional formatting
Icon
Configuring small multiples
Icon
Applying slicing and filtering
Icon
Adding an R or Python visual
Icon
Adding a smart narrative visual
Icon
Configuring the report page
Icon
Designing and configuring for accessibility
Icon
Configuring automatic page refresh
Icon
Creating a paginated report
Icon
Using Power BI datasets in Excel PivotTables
Icon
Summary
Icon
Questions
13
Chapter 10: Creating Dashboards
Icon
Chapter 10: Creating Dashboards
Icon
Technical requirements
Icon
Introducing Power BI dashboards
Icon
Pinning tiles
Icon
Optimizing dashboards
Icon
Summary
Icon
Questions
14
Chapter 11: Enhancing Reports
Icon
Chapter 11: Enhancing Reports
Icon
Technical requirements
Icon
Using bookmarks
Icon
Designing reports for mobile devices
Icon
Summary
Icon
Questions
15
Part 4 – Analyzing the Data
Icon
Part 4 – Analyzing the Data
16
Chapter 12: Exposing Insights from Data
Icon
Chapter 12: Exposing Insights from Data
Icon
Technical requirements
Icon
Exploring slicers and filters
Icon
The Analytics pane
Icon
Summary
Icon
Questions
17
Chapter 13: Performing Advanced Analysis
Icon
Chapter 13: Performing Advanced Analysis
Icon
Technical requirements
Icon
Identifying outliers
Icon
Using anomaly detection
Icon
Conducting time series analysis
Icon
Grouping and binning
Icon
Key influencers
Icon
Decomposition tree visual
Icon
Applying AI insights
Icon
Summary
Icon
Questions
18
Part 5 – Deploying and Maintaining Deliverables
Icon
Part 5 – Deploying and Maintaining Deliverables
19
Chapter 14: Managing Workspaces
Icon
Chapter 14: Managing Workspaces
Icon
Technical requirements
Icon
Using workspaces
Icon
Distributing reports and dashboards
Icon
Using deployment pipelines
Icon
Monitoring workspace usage
Icon
Summary
Icon
Questions
20
Chapter 15: Managing Datasets
Icon
Chapter 15: Managing Datasets
Icon
Technical requirements
Icon
Configuring a dataset scheduled refresh
Icon
Identifying when a gateway is required
Icon
Configuring row-level security group membership
Icon
Providing access to datasets
Icon
Summary
Icon
Questions
21
Part 6 – Practice Exams
Icon
Part 6 – Practice Exams
22
Chapter 16: Practice Exams
Icon
Chapter 16: Practice Exams
Icon
Practice test 1
Icon
Practice Test 2
Icon
Answer keys
23
Other Books You May Enjoy
Icon
Other Books You May Enjoy
Icon
Packt is searching for authors like you
Icon
Share Your Thoughts
1
Appendix: Practice Question Answers
Icon
Appendix: Practice Question Answers
Icon
Chapter 1, Overview of Power BI and the PL-300 Exam
Icon
Chapter 2, Connecting to Data Sources
Icon
Chapter 3, Profiling the Data
Icon
Chapter 4, Cleansing, Transforming, and Shaping Data
Icon
Chapter 5, Designing a Data Model
Icon
Chapter 6, Using Data Model Advanced Features
Icon
Chapter 7, Creating Measures Using DAX
Icon
Chapter 8, Optimizing Model Performance
Icon
Chapter 9, Creating Reports
Icon
Chapter 10, Creating Dashboards
Icon
Chapter 11, Enhancing Reports
Icon
Chapter 12, Exposing Insights from Data
Icon
Chapter 13, Performing Advanced Analytics
Icon
Chapter 14, Managing Workspaces
Icon
Chapter 15, Managing Datasets
Icon
Why subscribe?

Replacing numeric calculated columns with measures

Calculated columns and measures are different in the way they are stored and calculated within Power BI. When calculated columns are added to a data model, the values are calculated and stored for every row. This means that if there are 1,000 rows in a table and you add a calculated column for Margin (using a formula taking sales minus production costs), then for each row of the table, the data model would store a value for Margin. This data would be stored and updated whenever the model was refreshed so there are storage and performance implications when using many calculated columns.

Measures are not stored but instead calculated when used on the fly. Instead of creating a calculated column for Margin, you could instead create a measure that performs the same calculation, but the value would not be stored in the data model but instead be computed when the measure is used in a report visual.

For Power BI to use a measure to...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Microsoft Power BI Data Analyst Certification Guide
End of Section 9
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options
font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon