Contents
Quick access to online references
Errata, updates, & book support
Skill 1.1: Get data from different data sources
Identify and connect to a data source
Select a shared dataset or create a local dataset
Choose an appropriate query type
Identify query performance issues
Connect to a dataset by using the XMLA endpoint
Examine data structures and interrogate column properties
Skill 1.3: Clean, transform, and load the data
Evaluate and transform column data types
Identify and create appropriate keys for joins
Apply data shape transformations to table structures
Apply user-friendly naming conventions to columns and queries
Leverage the Advanced Editor to modify Power Query M code
Skill 2.1: Design a data model
Configure table and column properties
Flatten out a parent-child hierarchy
Define role-playing dimensions
Define a relationship’s cardinality and cross-filter direction
Design the data model to meet performance requirements
Resolve many-to-many relationships
Define the appropriate level of data granularity
Skill 2.2: Develop a data model
Apply cross-filter direction and security filtering
Implement row-level security roles
Skill 2.3: Create measures by using DAX
Use DAX to build complex measures
Use CALCULATE to manipulate filters
Implement Time Intelligence using DAX
Replace numeric columns with measures
Use basic statistical functions to enhance data
Skill 2.4: Optimize model performance
Remove unnecessary rows and columns
Identify poorly performing measures, relationships, and visuals
Improve cardinality levels by changing data types
Improve cardinality levels through summarization
Create and manage aggregations
Add visualization items to reports
Choose an appropriate visualization type
Format and configure visualizations
Configure conditional formatting
Design and configure for accessibility
Configure automatic page refresh
Pin a live report page to a dashboard
Skill 3.3: Enrich reports for usability
Edit and configure interactions between visuals
Configure navigation for a report
Use drill-through and cross-filter
Drill down into data using interactive visuals
Design reports for mobile devices
Skill 4.1: Enhance reports to expose insights
Add a Quick Insights result to a dashboard
Create reference lines by using the Analytics pane
Use the Play Axis feature of a visualization and conduct time-series analysis
Skill 4.2: Perform advanced analysis
Use the Key influencers to explore dimensional variances
Use the Decomposition tree visual to break down a measure
Chapter 5 Deploy and maintain deliverables
Configure a dataset scheduled refresh
Configure row-level security group membership
Configure incremental refresh settings
Promote or certify Power BI content
Configure large dataset format
Skill 5.2: Create and manage workspaces
Create and configure a workspace
Recommend a development lifecycle strategy
Configure and update a workspace app
Publish, import, or update assets in a workspace