0% found this document useful (0 votes)
12 views179 pages

Slides Download

The Microsoft Power BI Data Analyst Bootcamp (PL-300) is a three-day training program designed to equip participants with essential skills in data preparation, modeling, visualization, and analysis using Power BI. The curriculum includes hands-on experience with data cleaning, DAX for enhancing data models, and deploying Power BI items, along with preparation for the PL-300 certification exam. Participants will also learn about data relationships, row-level security, and performance optimization techniques.

Uploaded by

rafael.knothead
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
12 views179 pages

Slides Download

The Microsoft Power BI Data Analyst Bootcamp (PL-300) is a three-day training program designed to equip participants with essential skills in data preparation, modeling, visualization, and analysis using Power BI. The curriculum includes hands-on experience with data cleaning, DAX for enhancing data models, and deploying Power BI items, along with preparation for the PL-300 certification exam. Participants will also learn about data relationships, row-level security, and performance optimization techniques.

Uploaded by

rafael.knothead
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 179

Microsoft

Power BI Data
Analyst
Bootcamp
(PL-300)

Learn in-demand skills and become a


certified Power BI Data Analyst
Schedule Day 1

● Introduction
● Prepare and model the data
● Get data into Power BI
● Data cleaning
● Data transformation and loading
● Design data model

Microsoft Power BI Data Analyst Bootcamp (PL-300)


Schedule Day 2

● Model, visualize, and analyze the data


● Enhance data model with DAX
● Optimize model performance
● Create reports

Microsoft Power BI Data Analyst Bootcamp (PL-300)


Schedule Day 3

● Visualize and analyze the data


● Enhance reports for usability and storytelling
● Identify patterns and trends
● Deploy Power BI items

○ Create and manage workspace and items


● Practical exam tips and quiz

Microsoft Power BI Data Analyst Bootcamp (PL-300)


Learning Objectives

● Provide actionable insights from the data


● Understand various components of Microsoft Power BI
● Enable data-driven decision making
● Get ready for the PL-300 exam (Microsoft Power BI Data Analyst)

Microsoft Power BI Data Analyst Bootcamp (PL-300)


What’s Your Experience With Microsoft Power BI?
(POLL)
1. What is Power BI?
2. Heard some (cool) people talking about it, but I never tried it myself
3. Created a few reports
4. Can’t start my day without coffee and Power BI
5. Super-duper Power BI user

Microsoft Power BI Data Analyst Bootcamp (PL-300)


Day 1

Microsoft Microsoft Power BI Data


Analyst Bootcamp (PL-300)
Tasks of a Data Analyst

Prepare Model Visualize Analyze Manage


Get Data Into Power BI
Combine Data from Multiple Sources

Sales data HR data Sales goals


SQL Server Excel SharePoint

Power Query

Power BI
Shared vs. local semantic model
Local Semantic Model

ü Created in the Power BI Desktop

ü May include data from multiple disparate sources

ü Once published to Power BI Service, it can be shared with others


Shared Semantic Model

ü Stored in the Power BI Service

ü Live connection from Power BI Desktop

ü Enables separation of reports and semantic layer


Creating Reusable Power BI Assets

Product Customer

Sales
Creating Reusable Power BI Assets
Promoted/Certified

Product

Customer

Sales

Golden dataset
Understanding storage modes
Storage Modes - Import

ü Data stored in columnar in-memory database (VertiPaq)

ü Snapshot at the specific point in time

ü Periodically refreshed

Import DAX queries

ü Fast performance
× Data duplication
× Data latency
Import mode
Storage Modes - DirectQuery

ü Data resides in the original source before, during, and after the query execution

ü Data retrieved from the source at the query time

SQL queries DAX queries

× Slow performance
ü Real-time
ü No data duplication
Direct Query
Storage Modes - Dual

ü Combination of Import and DirectQuery

ü Data is in-memory, but can also be retrieved directly from the source
Working with parameters
Working with Parameters

ü Reusability – store once and use multiple times!

ü Flexibility – dynamically change the query output

Transformation Custom function Incremental


step argument argument refresh
DEMO

Ø Connect to various data sources

Ø Change data source settings

Ø Connect to a local and shared model

Ø Set the storage mode


Q&A
Break
Data Cleaning
Data Profiling with Power Query

Ø Column quality (5)


Ø Valid
Ø Error
Ø Empty

Ø Column distribution (5)


Ø Distinct vs Unique

Ø Column profile (3, 4)


Ø Value distribution
Ø Column statistics
Data import errors

Possible data loading errors


ØQuery Timeout

ØCouldn’t find data formatted as a table

ØCould not find file

ØData type errors


DEMO

Ø Data profiling with Power Query

Ø Resolve data inconsistencies

Ø Resolve data loading errors


Data Transformation and Loading
Power Query is your
best data
transformation
friend!
Append vs Merge
Product Date Customer Sales Amt Product Color Name

2023

Product table

Product Date Customer Sales Amt Product Category Subcategory Description On Sale

2024

Product Category table


Append vs Merge
Product Date Customer Sales Amt Product Color Name Category Subca Descr On Sale
tegory iption

Product table - merged

2023_2024

Append adds ROWS to the existing table Merge adds COLUMNS to the existing table
Merge Query Options
Fruit Fruit

Table A Apple Apple Table B


Orange Orange

Banana Mango

Left Outer Right Outer Inner Full Outer

Fruit Fruit Fruit Fruit Fruit Fruit Fruit Fruit

Apple Apple Apple Apple Apple Apple Apple Apple


Orange Orange
Orange Orange Orange Orange Orange Orange
Banana
Banana Mango
Mango
Understanding Query Folding

ü Translate M to a query language

ü Pushing heavy lifting on the data source

ü Ability to generate a single SQL query that’s going to be executed on

the data source side!


Query Folding – Why Should I Care?

ü Data refresh more efficient

ü With DirectQuery/Dual the query must fold

ü Incremental refresh serves its purpose

ü ALL or NOTHING?
Query Folding and Data Sources
ü Relational databases, Odata, SSAS, SharePoint lists…

ü Excel, text files…don’t support query folding!

ü Not all data transformations will fold

ü Removing/renaming columns ü Merging/Appending queries from different


sources
ü Filtering rows
ü Complex Custom columns
ü Grouping/Summarizing
ü Index columns
ü Merging/Appending queries from the same
source ü Changing column data type (“it depends”)!
ü Simple Custom columns
ü Pivot/Unpivot
Do you know what Star schema is? (POLL)

1. Star schema…What?!
2. I heard about it, but have no idea about how it’s being used
3. I’m familiar with the concept and already implemented it
4. I’m a Star-schema “galactico”

Microsoft Power BI Data Analyst Bootcamp (PL-300)


Star Schema in a Nutshell

Customer Venue

Sales

Event Date
Star schema should
always be a default
choice!
DEMO

Ø Common data transformations with Power Query

Ø Combining queries

Ø Managing parameters

Ø Query folding

Ø Implement a star schema with Power Query


Q&A
Break
Design Data Model
Relationships serve as filters
Relationship Cardinality

One-to-many (1:*) Many-to-one (*:1)

One-to-one (1:1) Many-to-many (*:*)


Relationship Cardinality
Unique values
One-to-many (1:*)

Many-to-one (*:1)
Relationship Cardinality (1:*, *:1)
Product Key Product Name Product Category
1 T-Shirt Clothes
2 Socks Clothes
3 Mug Accessories
1

One-to-many

Sales Key Product Key Sales Amount


1 1 100
2 1 200
3 1 300
4 2 50
5 2 75
6 3 100
7 3 150
Relationship Cardinality (1:*, *:1)
Product Key Product Name Product Category
1 T-Shirt Clothes
2 Socks Clothes
3 Mug Accessories
1

Many-to-one

Sales Key Product Key Sales Amount


1 1 100
2 1 200
3 1 300
4 2 50
5 2 75
6 3 100
7 3 150
Relationship Cardinality (1:*, *:1)
Product Key Product Name Product Category
1 T-Shirt Clothes
2 Socks Clothes Preferred choice in Power BI!
3 Mug Accessories
1

One-to-many

Sales Key Product Key Sales Amount


1 1 100
2 1 200
3 1 300
4 2 50
5 2 75
6 3 100
7 3 150
Relationship Cardinality (*:*)

Account Customer
Account Key Account Name Customer Key Customer Name
1 Account A 1 John Doe
2 Account B 2 Maria Adams
3 Account C 3 Taylor Connor
1
1

AccountCustomer
Account Key Customer Key
1 1
1 2
* *
2 2
3 1
3 3

“Bridge” table
Relationship Filter Direction

Single Direction Both Directions

Recommended practice Implement with care


Relationship Filter Direction (Single)
Product Category Key Product Category
1 Clothes
2 Accessories
1

Sales Key Product Key Sales Amount


* 1 1 100
Product Key Product Name Product Category Key 2 1 200
1 T-Shirt 1 3 1 300
2 Socks 1 4 2 50
3 Mug 2 5 2 75
1 6 3 100
7 3 150
*
Relationship Filter Direction (Both)
Product Category Key Product Category
1 Clothes
2 Accessories
1

Sales Key Product Key Sales Amount


* 1 1 100
Product Key Product Name Product Category Key 2 1 200
1 T-Shirt 1 3 1 300
2 Socks 1 4 2 50
3 Mug 2 5 2 75
1 6 3 100
7 3 150
*

CROSSFILTER()
CROSSFILTER() DAX Function

ü Override default filter direction

ü Valid only during the query execution!

• CROSSFILTER(column1, column2, direction)

Direction -> BOTH, NONE, ONEWAY*


*OneWay_LeftFiltersRight or OneWay_RightFiltersLeft
Implement role-playing
dimensions
Role-playing Dimension

ü Dimension table “plays” multiple roles in the model

ü Commonly used for date-based scenarios

• Order date

• Ship date

• Due date
USERELATIONSHIP() DAX Function

ü Activate inactive relationship

ü Can’t be used when RLS is defined on the table!

• USERELATIONSHIP(column1, column2)
Create a common date table
Date Table in Semantic Model

ü Analyze data by date attributes (calendar year, fiscal year, quarter, month,

week…)

ü Necessary for applying DAX time-intelligence functions


How to Create a Date Table?

ü Source system – data warehouse

ü Power Query

ü DAX

• CALENDAR

• CALENDARAUTO
Implement Row-level security
roles
Row-level security limits access to
specific attributes (country,
product…)
Static vs. Dynamic RLS

Static Dynamic

ü Basic scenarios ü Control access on a granular level

ü Rules maintained within PBIX file ü Access control via data model

ü Easy and straightforward setup ü Reusable and less maintenance

ü Maintenance, lot of manual ü Adds to model complexity


work, not reusable
DEMO

Ø Implement a role-playing dimension

Ø Configure relationship cardinality and cross-filter direction

Ø Create a calendar table

Ø Implement row-level security


Q&A
Day 2

Microsoft Microsoft Power BI Data


Analyst Bootcamp (PL-300)
Introduction and Recap
Enhance Data Model With DAX
What’s Your Experience With DAX? (POLL)

1. What is DAX?
2. I heard of DAX, but never used it
3. I’m familiar with basic DAX concepts
4. I know that I should “filter columns and not tables” in DAX
5. “I speak DAX like an Italian” J

Microsoft Power BI Data Analyst Bootcamp (PL-300)


DAX Essentials

Ø Data Analysis Expressions

Ø Build formulas and expressions with


functions and operators

Ø Create measures, calculated columns, and


calculated tables
Creating DAX measures

Ø Defined with DAX definitions

Ø Computed “on the fly”

Ø Not stored in the data model

Ø Responsive to interactions

Ø Indicated by calculator icon


Implicit vs Explicit vs Quick measures
Creating Calculated Columns

Ø Defined using DAX expressions

Ø Computed & stored in data model

Ø Useful for “helper/connector columns”

Ø Recalculated during data refresh

Ø Table and Sigma icon


Creating Calculated Tables

Ø Defined using DAX expressions

Ø Computed & stored in data model

Ø Useful for aggregating data or


creating custom tables

Ø Table and calculator icon


Common DAX Functions for Calculated Tables

ü CROSSJOIN

ü UNION

ü NATURALINNERJOIN/NATURALLEFTOUTERJOIN

ü INTERSECT

ü DISTINCT

ü VALUES

ü CALENDAR/CALENDARAUTO
Columns vs Measures in DAX

Calculated columns Measures

ü Create values for each row in table ü Calculated on demand

ü Store values in the .pbix file ü Calculated based on filters

ü Increases data model size ü Doesn’t affect data model size

ü Row-by-row calculation can impact ü DAX expressions may still be


performance suboptimal

ü Must be referenced with measures ü Can reference other measures


for reuse directly for reuse
CALCULATE is the only
function that can
change the filter
context!
Understanding Filter Context
Measures are contextually different, or “dynamic,” depending on filters
Inside the CALCULATE Function
Modified filter context Modified filter context
Existing filter context Existing filter context
ProductKey ProductKey
226 226

CustomerKey CustomerKey
123 123

ProductKey

226

CustomerKey

123
Filter Modifiers Inside CALCULATE

Ø KEEPFILTERS
Ø USERELATIONSHIP
Ø CROSSFILTER
Ø ALL family of functions
Ø ALL
Ø ALLEXCEPT
Ø ALLSELECTED
Ø ALLNOBLANKROW
Ø REMOVEFILTERS
Prerequisites
Well-designed calendar table

Continuous dates DateTime or Date column Mark as date table


Start on Jan 1st and end Unique values in the If the relationship is not
on Dec 31st including all column based on the date
dates in range
DEMO

Ø Create calculated columns and measures

Ø Leverage the CALCULATE function to manipulate the filter context

Ø Implement time-intelligence DAX functions


Q&A
Break
Optimize Model Performance
Performance Analyzer

Built-in tool in Power BI Desktop

ØRecord report interactions


ØReview query and rendering times
ØIdentify bottlenecks and optimize
queries
Vertical vs Horizontal Filtering

Vertical Horizontal

Columns Rows

Report consumer

Model structure Reporting design Time dimension Filter by entity


Granularity
=
Level of detail in the dataset
What Is the Lowest Acceptable Granularity?

Day
What Is the Lowest Acceptable Granularity?

Manufacturer
Changing Column Data Type: Dates
Purchase Date Purchase Date
2024-10-10 10:25 2024-10-10
2024-10-10 17:45 2024-10-10
2024-10-10 09:36 2024-10-10
2024-10-10 11:44 2024-10-10
2024-10-10 19:52 2024-10-10

Cardinality = 5 Cardinality = 1
Changing Column Data Type: Decimal Numbers
Sales Amount Sales Amount
123.78612 123.78
123.78615 123.78
123.78618 123.78
123.78621 123.78
123.78624 123.78

Cardinality = 5 Cardinality = 1
What’s the largest table you have to deal with in
Microsoft Power BI? (POLL)
1. < 10k records
2. < 1 million records
3. < 100 million records
4. >= 100 million records

Microsoft Power BI Data Analyst Bootcamp (PL-300)


Large Fact Table

Date Customer ID Product ID Sales Amount


2024-10-12 123 11 10
2024-10-12 456 12 20
2024-10-12 789 12 50
2024-10-13 123 13 30
2024-10-13 456 11 10

100.000.000………….1.000.000.000 rows
Create Aggregated Tables
Date Sales Amount
2024-10-12 80
2024-10-13 40

Date Customer ID Product ID Sales Amount


Product ID Sales Amount 2024-10-12 123 11 10
11 20
2024-10-12 456 12 20
12 70
2024-10-12 789 12 50
13 30
2024-10-13 123 13 30
2024-10-13 456 11 10
Customer ID Sales Amount
123 40
456 30
789 50
Create Aggregated Tables
Date Sales Amount
2024-10-12 80
2024-10-13 40

Date Customer ID Product ID Sales Amount


Product ID Sales Amount 2022-10-12 123 11 10
11 20
2022-10-12 456 12 20
12 70
2022-10-12 789 12 50
13 30
2022-10-13 123 13 30
2022-10-13 456 11 10
Customer ID Sales Amount
123 40
456 30
789 50
Create Aggregated Tables
Date Sales Amount
2024-10-12 80
2024-10-13 40

Date Customer ID Product ID Sales Amount


Product ID Sales Amount 2022-10-12 123 11 10
11 20
2022-10-12 456 12 20
12 70
2022-10-12 789 12 50
13 30
2022-10-13 123 13 30
2022-10-13 456 11 10
Customer ID Sales Amount
123 40
456 30
789 50
Create Aggregated Tables
Date Sales Amount
2024-10-12 80
2024-10-13 40

Date Customer ID Product ID Sales Amount


Product ID Sales Amount 2022-10-12 123 11 10
11 20
2022-10-12 456 12 20
12 70
2022-10-12 789 12 50
13 30
2022-10-13 123 13 30
2022-10-13 456 11 10
Customer ID Sales Amount
123 40
456 30
789 50
Create Aggregated Tables
Date Sales Amount
2024-10-12 80
2024-10-13 40

Date Customer ID Product ID Sales Amount


Product ID Sales Amount 2024-10-12 123 11 10
11 20
2024-10-12 456 12 20
12 70
2024-10-12 789 12 50
13 30
2024-10-13 123 13 30
2024-10-13 456 11 10
Customer ID Sales Amount
123 40
456 30
789 50
Create Aggregated Tables
Date Sales Amount Date Customer ID Product ID Sales Amount
2022-10-12 80 2022-10-12 123 11 10
2022-10-13 40 2022-10-12 456 12 20
2022-10-12 789 12 50
2022-10-13 123 13 30
Product ID Sales Amount
2022-10-13 456 11 10
11 20
12 70
13 30
Reduce the number of rows
Customer ID Sales Amount
123 40
456 30
789 50 Reduce the model size
Aggregation “Awareness” in Power BI
Date Sales Amount
2021-10-12 80
2021-10-13 40

Product ID Sales Amount


11 20
Make Power BI “aware” of aggregated tables
12 70
13 30

Customer ID Sales Amount


123 40
456 30
789 50
DEMO

Ø Use Performance Analyzer to identify problematic elements

Ø Optimize data model by changing data types

Ø Optimize data model by implementing aggregations


Q&A
Creating Reports
Think about the message you
want to share with the audience
• Table • Line Chart
• Bar Chart • Column Chart
• Area Chart 2
Column
Variables:
Chart/ Scatter
Multiple Histogram
Over Time Plot
Items

Comparison Distribution

What do you want


to display?

Relationship Composition

2 3
Variables: Variables: Dynamic Static
Scatter Bubble
Plot Plot

• Stacked Column Chart • Pie Chart


• Stacked Area Chart • Waterfall Chart
Slicers vs Filters
Slicers Filters

Quick access You, the report designer, define filters!

Focused reports

Simplify filtered view


On this visual

On this page
On all pages
Slicers vs. Filters – When to Use What?

Slicers Filters

ü Display common filters on the report page ü Complex filtering requirements

ü Focused view ü Limited space on the report page

ü Simplified filtered state ü Lock/hide aspects of the Filter pane


Choosing the Right Tool – Paginated Report

Data represented in tables

Sales invoice to be printed or exported to PDF

All data in a single report element

Development in Power BI Report Builder


Paginated Report vs “Classic” Power BI
Paginated report Power BI

Development in Power BI Report Builder Development in Power BI Desktop

Print or export all the data Print or export only the visible data

No underlying data model Has its own data model

No shared data sources and shared Possibility to share data sources and
datasets datasets between the reports
Analyze in Excel Prerequisites

ü Admin must enable settings in the Portal

ü Build permission on the Power BI semantic model or


at least a Contributor role in the workspace

ü Power BI license (except for semantic models in


Power BI Premium capacity or Fabric F64 or greater)

Ø Only Import mode models preserve hierarchies


Ø External users can’t use Analyze in Excel
DEMO

Ø Configure report page and visuals

Ø Use custom visuals

Ø Apply custom report theme

Ø Configure conditional formatting

Ø Implement slicers and filters


Q&A
Day 3

Microsoft Microsoft Power BI Data


Analyst Bootcamp (PL-300)
Introduction and Recap
Enhance Reports for Usability and
Storytelling
Design an Appealing Report Layout
Cross-highlight Between Visuals
Drill down Through Visual Using a Hierarchy
Add Shapes and Buttons

Enhance reports
Ø Text boxes
Ø Images
Ø Shapes

Improve navigation with Buttons


Report Navigation with Buttons

ü Back

ü Bookmark

ü Reset

ü Navigator -> Page

navigator/Bookmark navigator
Bookmarks
Capture the current state of the report page

ü Current page
ü Filters
ü Slicers
ü Sort order
ü Drill location
Selection Pane

Layer order Tab order


Defines the order of visuals Controls keyboard user navigation
Drill through
Sync Slicers

ü Slicer selections on page A will propagate to Page B,

even though the slicer is not visible on Page B!

ü Independently configure and format the synced slicer

on Page B
DEMO

Ø Create and configure bookmarks

Ø Create custom tooltips

Ø Edit interactions between the visuals

Ø Configure sync slicers

Ø Implement Drill through feature


Q&A
Break
Identify Patterns and Trends in
Data
Analyze feature
Grouping and Binning

Organize data into categories or intervals to better analyze the data


Identify Outliers

Ø Unexpected deviations in data

Ø Scatter charts can detect outliers

Ø Use DAX to define and analyze


outliers dynamically
Clustering with Scatter chart visual

Ø Automatic data grouping

Ø Enhance pattern recognition and insights

Ø Simplify data understanding and analysis


Numeric Range (What-if) Parameters
Enable scenario planning to support better decision-making
AI in the Q&A feature
Use natural language to ask questions about data and create visuals
Key influencers Visual

Enables identifying factors behind variations


in a chosen target metric
Decomposition Tree Visual
Visualize data hierarchies for in-depth exploration and pattern discovery
Implement Reference Lines

ü Quickly understand data points compared to a reference

ü Available options depend on the column data type


DEMO

Ø Use Analyze feature

Ø Implement grouping and binning

Ø Implement AI visuals

Ø Implement reference lines, error bars and forecasting


Q&A
Create and Manage Workspace
and Items
Workspace is a
container for all
Power BI items
Assign Workspace Roles
Use workspaces for collaboration, not content sharing!
Viewer Role

ü View and interact with the item

ü Read data from the dataflows

ü Create report subscriptions


Contributor Role
Viewer +…

ü Publish, create, edit and delete content

ü Create reports in another workspace

ü Schedule data refresh

ü Modify gateway connection settings

ü Use the Analyze in Excel feature


Member Role
Contributor +…

ü Add members or others with lower permissions

ü Publish/unpublish the app

ü Share items in the app

ü Allow others to reshare items

ü Manage semantic model permissions


Admin Role
Member +…

ü Update and delete the workspace

ü Add or remove any user in a workspace role

ü Allow contributors to update the app

ü Manage subscriptions created by others


Create Apps
Use apps for content distribution!

1
2

3
Subscribe to Power BI Report
Lineage View in the Workspace

Semantic models/Dataflows Reports Dashboards

Data sources
Sensitivity Labels

Ø Must be defined in Microsoft Purview Information Protection

Ø Must be enabled in the Admin Portal

Ø Can be applied both in Power BI Service and Desktop

Ø Apply to individual report/dashboard Settings


Promote and Certify Power BI Items

Promotion Certification

Ø Highlight items valuable and Ø Item meets organizational


worthwhile for others to use quality standards and can be
Ø Encourages the collaborative use regarded as reliable and
and spread of content within an ready for use across the
organization organization
Ø Any item owner and users who Ø Only authorized reviewers
have write permissions can (defined by the
promote the item administrator) can certify
items
What is a Power BI dashboard?
Ø Single page

Ø Visuals pinned from reports

Ø Tiles are static

Ø Default Q&A feature

Ø Refreshes with semantic model

Ø DirectQuery every 15 min


Manage global options
What is Auto Date/Time?

Ø Loading option in Power BI

Ø Support quick time intelligence reporting

Ø Works only in Import mode

Ø Column must be Date or Date/Time type


Core Global Options

Ø Preview features

Ø Privacy levels – isolation between different


data sources

Ø Security

Ø Report settings
Understand gateways
Configure scheduled refresh
8x per day with
shared capacity

48x per day with


Premium capacity
Scheduled Refresh Issues

Disabled Paused

ü 4 consecutive failures ü 2 months of inactivity

ü Configuration update ->

Invalid/expired credentials
Configure Row-level group
membership
Adding Member Groups to RLS Roles

ü Distribution group

ü Mail-enabled group

ü Security group

Users/groups with Admin, Member, or Contributor role in the

workspace will see ALL data, regardless of RLS rules!


Provide access to semantic
models
Understanding the Build Permission

ü New content based on the shared semantic model

ü Export underlying data

ü Use the Analyze in Excel feature

ü Access data via XMLA endpoint


Configure automatic page refresh
Scheduled refresh of the
specific report page!
Auto Page Refresh
Works only with DirectQuery

Fixed Interval Change Detection

ü Set desired interval (1 sec to X days) ü Specify a measure to be monitored


ü All visuals refreshed ü ONE SINGLE query
Auto Page Refresh Considerations

ü Think about expected data change frequency

ü Workload created by queries


20 concurrent users x 3 visuals = 60 queries every 2 seconds!

ü Change detection only with Premium

ü Change detection only on 1 measure per dataset

ü Max 10 data models with Change detection in tenant


DEMO

Ø Assign workspace roles

Ø Configure the app

Ø Create a dashboard

Ø Configure semantic model scheduled refresh

Ø Configure membership for row-level security


Q&A
Practical Exam Tips, Quiz, and
Closing
Practical Exam Tips

ü Make sure to prepare the room (for online takers)


ü You can use Microsoft Learn during the examJ…
ü …but, don’t let this waste too much of your time!
ü Take time to understand case studies and explore the exhibits/datasets before
answering (there is no way back)
Quiz
Join the Quiz!

https://app.sli.do/event/nR8vJfCPY4PJDkLVzkRu4Y
Group Discussion

● Which benefits do you expect from passing the PL-300 exam?


Summary
Takeaways

● Check the official Microsoft PL-300 study guide:


● Official study guide
● PL-300 Certification page with practice assessment
● Take the practice assessment
● Experience demo
● Microsoft Power BI courses and books @ O’Reilly platform

Microsoft Power BI Data Analyst Bootcamp (PL-300)


Q&A

You might also like