Microsoft Power BI Data Analyst Certification companion : preparation for exam PL-300 / Jessica Jolly.
Jolly, Jessica, author.
2023
QA76.3
Available Online

Linked e-resources

Linked Resource
Online Access
Concurrent users
Unlimited
Authorized users
Authorized users
Document Delivery Supplied
Can lend chapters, not whole ebooks

Details

Title
Microsoft Power BI Data Analyst Certification companion : preparation for exam PL-300 / Jessica Jolly.
Author
Jolly, Jessica, author.
Edition
[First edition].
ISBN
9781484290132 (electronic bk.)
1484290135 (electronic bk.)
9781484290125
1484290127
DOI
https://doi.org/10.1007/978-1-4842-9013-2
Published
New York, NY : Apress, [2023]
Language
English
Description
1 online resource (392 pages) : illustrations
Item Number
10.1007/978-1-4842-9013-2 doi
Call Number
QA76.3
Dewey Decimal Classification
006.6/8
Summary
Use this book to study for the PL-300 Microsoft Power BI Data Analyst exam. The book follows the "Skills Measured" outline provided by Microsoft to help focus your study. Each topic area from the outline corresponds to an area covered by the exam, and the book helps you build a good base of knowledge in each area. Each topic is presented with a blend of practical explanations, theory, and best practices. Power BI is more than just the Power BI Desktop or the Power BI Service. It is two distinct applications and an online service that, together, enable business users to gather, shape, and analyze data to generate and present insights. This book clearly delineates the purpose of each component and explains the key concepts necessary to use each component effectively. Each chapter provides best practices and tips to help an inexperienced Power BI practitioner develop good habits that will support larger or more complex analyses. Many business analysts come to Power BI with a wealth of experience in Excel and particularly with pivot tables. Some of this experience translates readily into Power BI concepts. This book leverages that overlap in skill sets to help seasoned Excel users overcome the initial learning curve in Power BI, but no prior knowledge of any kind is assumed, terminology is defined in non-technical language, and key concepts are explained using analogies and ideas from experiences common to any reader. After reading this book, you will have the background and capability to learn the skills and concepts necessary both to pass the PL-300 exam and become a confident Power BI practitioner.
Note
Includes index.
Access Note
Access limited to authorized users.
Series
Certification study companion series.
Available in Other Form
Print version: 9781484290125
Linked Resources
Online Access
Record Appears in
Online Resources > Ebooks
All Resources
Intro
Table of Contents
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
Part I: Prepare to Study
Chapter 1: Exam Overview
Why Certify?
When Should You Take the Exam?
What Is Reasonably Confident?
Taking the Exam
Signing Up
Online or at a Testing Center?
Choosing Your Time Block
Marking Your Calendar
Canceling or Rescheduling Your Exam
The Exam Format
General Tips for Exam Taking
You've Passed. Now What?
You've Failed. Now What?
Chapter 2: PL-300 Coverage
The Tools
Power BI Desktop

Desktop Updates
Reports and Dashboards
Power Query Editor
The Power BI Service
Workspaces, My workspace, and Apps
Licensing
Languages
Practicing Before the PL-300
Northwind Excel and CSV Files
AdventureWorks Database
What and Why?
Part II: Prepare the Data
Chapter 3: Get Data from Different Sources
Getting the Data
Entering Your Credentials
Change Data Source Settings
Changing Data Source Settings
When a Data Source Moves
Editing Permissions
Clear Permissions
Privacy Levels
Selecting a Storage Mode
Import
Direct Query

For Future Reference: Writing Your Own SQL Code
Live Connection
Using Different Data Sources
Dataverse
Dataflows
Shared Dataset
Local Dataset
Using Folders and SharePoint Folders
Parameters
Defining Parameters
Within the Power Query Editor
In the Power BI Desktop
Chapter 4: Clean, Transform, and Load the Data
Accessing the Power Query Editor
What Is the Power Query Editor?
The M Language
Undoing and Redoing a Step
Naming and Documenting
Data Quality and Distribution
Keys and IDs
Data Types Matter!
For Future Reference: Query Folding

Replacing Data
Blanks and Nulls
Errors
Adding New Data
Adding a New Column
Adding a New Query
Keep Only What You Need
Combining Queries
Append
Merging
Duplicating a query
Referencing a Query
Deleting a Query
Working with Some Data
Only 1000 Rows?
For Future Reference: Future-Proofing Your Work
Excluding and Including Columns
Resolving Errors in Your Query
Incorrect Data Type
Missing or Renamed Column
For Future Reference: Reusing Your Work
The Advanced Editor
Copying a Query
Copying Parts of an M Script

Loading Your Queries (or Not)
A Few Tips and Tricks
Additional Resources
Part III: Model the Data
Chapter 5: Design a Data Model
Define the Tables
Dims and Facts
Using Fields in Visuals
Relationships: A Model's Connective Tissue
One-to-Many Relationship (1-Many)
Many-to-Many Relationships (Many-Many)
One-to-One (1-1)
For Future Reference: Disconnected Tables
Active and Inactive Relationships
Star Schema
Relationships and Directions
Single-Direction Relationships
Bidirectional Relationships
Finally, Cardinality!
Adding a Date Table

Browse Subjects

Show more subjects...

Statistics

from
to
Export