DA-100: Analyzing Data with Microsoft Power BI

Design a Data Model

• Define the Tables
• Configure Table and Column Properties
• Define Quick Measures
• 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
• Create a Common Date Table
• Define the Appropriate Level of Data Granularity

Develop a Data Model

• Apply Cross-Filter Direction and Security Filtering
• Create Calculated Tables
• Create Hierarchies
• Create Calculated Columns
• Implement Row-level Security Roles
• Set up the Q&A Feature

Create Measures by using DAX

• Use DAX to Build Complex Measures
• Use CALCULATE to Manipulate Filters
• Implement Time Intelligence using DAX
• Replace Nmeric Columns with Measures
• Use Basic Statistical Functions to Enhance Data
• Create Semi-Additive Measures

Optimize Model Performance

• Remove Unnecessary Rows and Columns
• Indentify Poorly Performing Measures, Relationships, and Visuals
• Improve Cardinality Levels by Changing Data Types
• Improve Cardinality Levels Through Summarization
• Create and Manage Aggregations

Create Reports

• Add Visualization Items to Reports
• Choose an Appropriate Visualization Type
• Format and Configure Visualizations
• Import a Custom Visual
• Configure Conditional Formatting
• Apply Slicing and Filtering
• Add an R or Python Visual
• Configure the Report Page
• Design and Configure for Accessibility

Create Dashboards

• Set Mobile View
• manage tiles on a Dashboard
• Configure Data Alerts
• Use the Q&A Feature
• Add a Dashboard Theme
• Pin a Live Report Page to a Dashboard
• Configure Data Classification

Enrich Reports for Usability

• Configure Bookmarks
• Create Custom Tooltips
• Edit and Configure Interactions Between Visuals
• Configure Navigation for a Report
• Apply Sorting
• Configure Sync Slicers
• Use the Selection Pane
• Use Drillthrough and Cross Filter
• Drilldown into Data using Interactive Visuals
• Export Report Data

Enhance Reports to Expose Insights

• Apply Conditional Formatting
• Apply Slicers and Filters
• Perform top N Analysis
• Explore Statistical Summary
• Use the Q&A Visual
• Add a Quick Insights Result to a Report
• Create Reference Lines by using Analytics Pane
• Use the Play Axis Feature of a Visualization

Perform Advanced Analysis

• Indentify Outliers
• Conduct Time Series Analysis
• Use Goupings and Binnings
• Use the Key Influencers to Explore Dimensional Variances
• Use the Decomposition Tree Visual to Break Down a Measure
• Apply AI Insights

Manage Datasets

• Configure a Dataset Scheduled Refresh
• Configure Row-level Security Group Membership
• Providing Access to Datasets
• Configure Incremental Refresh Settings
• Endorse a Dataset

Create and Manage Workspaces

• Create and Configure a Workspace
• Recommend a Development Lifecycle Strategy
• Assign Workspace Roles
• Configure and Update a Workspace App
• Publish, Import, or Update Assets in a Workspace