84. Microsoft Power BI PL-300 Exam Preparation Full Series – Configure bookmarks in Power BI

Material used in this series

https://drive.google.com/drive/folders/1vxQoOKf3fmB4b0v0QVBtcM5277gMX6pM?usp=drive_link

This playlist contains videos that cover the Microsoft Power BI PL-300 exam preparation syllabus. The exam is divided into 4 learning paths. Each path has multiple sections and then within each section there are topics that are covered in multiple choice questions on the exam.

The 4 learning paths are
– Prepare the data (25–30%)
– Model the data (25–30%)
– Visualize and analyze the data (25–30%)
– Deploy and maintain items (15–20%)

The structured breakdown of each learning path is

1. Prepare the data (25–30%)
Get data from data sources
– Identify and connect to a data source
– Change data source settings, including credentials, privacy levels, and data source locations
– Select a shared semantic model, or create a local data model
– Choose between DirectQuery, Import, and Dual mode
– Change the value in a parameter
– Clean the data

Evaluate data, including data statistics and column properties
– Resolve inconsistencies, unexpected or null values, and data quality issues
– Resolve data import errors

Transform and load the data
– Select appropriate column data types
– Create and transform columns
– Transform a query
– Design a star schema that contains facts and dimensions
– Identify when to use reference or duplicate queries and the resulting impact
– Merge and append queries
– Identify and create appropriate keys for relationships
– Configure data loading for queries

2. Model the data (25–30%)
Design and implement a data model
– Configure table and column properties
– Implement role-playing dimensions
– Define a relationship’s cardinality and cross-filter direction
– Create a common date table
– Implement row-level security roles

Create model calculations by using DAX
– Create single aggregation measures
– Use CALCULATE to manipulate filters
– Implement time intelligence measures
– Identify implicit measures and replace with explicit measures
– Use basic statistical functions
– Create semi-additive measures
– Create a measure by using quick measures
– Create calculated tables

Optimize model performance
– Improve performance by identifying and removing unnecessary rows and columns
– Identify poorly performing measures, relationships, and visuals by using Performance Analyzer
– Improve performance by choosing optimal data types
– Improve performance by summarizing data

3. Visualize and analyze the data (25–30%)
Create reports
– Identify and implement appropriate visualizations
– Format and configure visualizations
– Use a custom visual
– Apply and customize a theme
– Configure conditional formatting
– Apply slicing and filtering
– Configure the report page
– Use the Analyze in Excel feature
– Choose when to use a paginated report

Enhance reports for usability and storytelling
– Configure bookmarks
– Create custom tooltips
– Edit and configure interactions between visuals
– Configure navigation for a report
– Apply sorting
– Configure sync slicers
– Group and layer visuals by using the Selection pane
– Drill down into data using interactive visuals
– Configure export of report content, and perform an export
– Design reports for mobile devices
– Enable personalized visuals in a report
– Design and configure Power BI reports for accessibility

Identify patterns and trends
– Use the Analyze feature in Power BI
– Use grouping, binning, and clustering
– Incorporate the Q&A feature in a report
– Use AI visuals
– Use reference lines, error bars, and forecasting
– Detect outliers and anomalies
– Create and share scorecards and metrics

4. Deploy and maintain items (15–20%)
Create and manage workspaces and items
– Create and configure a workspace
– Assign workspace roles
– Configure and update a workspace app
– Publish, import, or update items in a workspace
– Create dashboards
– Choose a distribution method
– Apply sensitivity labels to workspace content
– Configure subscriptions and data alerts
– Promote or certify Power BI content
– Manage global options for files

Manage semantic models
– Identify when a gateway is required
– Configure a semantic model scheduled refresh
– Configure row-level security group membership
– Provide access to semantic models
– Configure automatic page refresh

———————————————————————————————————————
Hi, I am Abu Bakar Alvi and this is my YouTube channel. I create content about data and related technologies. I am a Microsoft Certified Trainer, Azure Enterprise Data Analyst Associate, Azure Data Engineer Associate, Data Analyst Associate for Power BI, and Tableau Desktop Specialist.

———————————
😍 JOIN 😍
———————————-

YouTube: https://www.youtube.com/thedataguyisb
LinkedIn: https://www.linkedin.com/in/abubakar-alvi/
WhatsApp channel: https://whatsapp.com/channel/0029Va7YRde8kyyFFdDSZk3z