DA-100 Exam Study Guide (Analyzing Data With Microsoft Power BI)
You can access DA-100 Exam Microsoft official page here
Preparing for the DA-100 Analyzing Data with Microsoft Power BI Certificate exam? Don’t know where to start? This post is the DA-100 Certificate Study Guide (with links to each exam objective).
I have curated a list of articles from Microsoft documentation for each objective of the DA-100 exam. I hope this article will help you to achieve the Microsoft Certified Data Analyst Associate Certificate. Also, please share the post within your circles so it helps them to prepare for the exam.
Skills Measured
- Prepare the Data (20-25%)
- Model the Data (25-30%)
- Visualize the Data (20-25%)
- Analyze the Data (10-15%)
- Deploy and Maintain Deliverables (10-15%)
DA-100 Exam Free Study Guide
For each test objective, I’ve compiled a thorough collection of articles from Microsoft documentation. Please feel free to forward this page to your friends and coworkers in order to assist them in preparing for the test .
Prepare the Data (20-25%)
Get Data from Different Data Sources
- Identify and connect to a data source
- Data sources in Power BI desktop
- Connect to data in Power BI desktop
- Change data source settings
- Manage data sources
- Select a shared dataset or create a local dataset
- Where your workbook file is saved makes a difference
- Power BI shared datasets
- Select a storage mode
- Storing data in the Power BI file
- Choose an appropriate query type
- Query overview in Power BI Desktop
- Identify query performance issues
- Fix performance issues
- Optimization guide for Power BI
- Use Microsoft Dataverse
- What is Microsoft Dataverse?
- Get started with Dataverse
- Use parameters
- Specify parameters for the data source in Power BI
- Use or create a PBIDS file
- Using PBIDS files to get data
- How to create a PBIDS connection file?
- Use or create a data flow
- Creating a dataflow
- Connect to a dataset using the XMLA endpoint
- Dataset connectivity with the XMLA endpoint
Profile the Data
- Identify data anomalies
- Visualize anomalies using batch detection & Power BI
- Examine data structures
- Simplify the data structure
- Interrogate column properties
- Column Profiling in Power BI Desktop
- Interrogate data statistics
- Worldwide demographics & statistics using Power Query & Power View
- How to get descriptive statistics for multiple columns?
Clean, Transform, and Load the Data
- Resolve inconsistencies, unexpected or null values, and data quality issues
- Inconsistencies with date-type fields
- Tips & tricks for creating relationships in Power BI Desktop
- Relationships in Power BI Desktop when the data has null or blank values
- How to Spot and Improve Data Quality in Power BI
- Apply user-friendly value replacements
- Replace Values and Column Data Types with Power BI
- Replacing the values
- Identify and create appropriate keys for joins
- Model relationships in Power BI Desktop
- Evaluate and transform column data types
- Evaluate & change column data types
- Apply data shape transformations to table structures
- Shape & combine data in Power BI Desktop
- Combine queries
- Merging queries
- Apply user-friendly naming conventions to columns and queries
- Data import best practices in Power BI
- Leverage Advanced Editor to modify Power Query M code
- The Advanced Editor
- Configure data loading
- New updates in Power Query
- Resolve data import errors
- Resolve data import errors
Model the Data (25-30%)
Design a Data Model
- Define the tables
- Tables in Power BI reports and dashboards
- Configure table and column properties
- Format the table
- Adjust the column width of a table
- Define quick measures
- Use quick measures for common calculations
- Flatten out a parent-child hierarchy
- Video on flattening a parent-child hierarchy
- Define role-playing dimensions
- Role-playing dimensions
- Define a relationship’s cardinality and cross-filter direction
- The Cardinality option
- Cross filter direction
- Design the data model to meet performance requirements
- Optimization guide for Power BI
- Resolve many-to-many relationships
- Many-to-many relationship guidance
- Create a common date table
- Common Date Filter for Multiple Tables
- Define the appropriate level of data granularity
- Hierarchies in data models
Develop a Data Model
- Apply cross-filter direction and security filtering
- Enable bidirectional cross-filtering in Power BI Desktop
- Model relationships defined with a cross filter direction
- Row-level security (RLS) with Power BI
- Create calculated tables
- Create calculated tables in Power BI Desktop
- Create hierarchies
- Create a hierarchy in Power BI
- Create calculated columns
- Create calculated columns in Power BI desktop
- Implement row-level security roles
- Restrict data access with RLS for Power BI Desktop
- Set up the Q&A feature
- Use Power BI Q&A to explore your data & create visuals
- Q&A for Power BI business users
Create Measures by Using DAX
- Use DAX to build complex measures
- Create & use your own measures
- DAX: Use variables to improve your formulas
- Use CALCULATE to manipulate filters
- DAX: Avoid using FILTER as a filter argument
- Implement Time Intelligence using DAX
- Time intelligence in Power BI desktop
- Replace numeric columns with measures
- Convert column to measure
- Use basic statistical functions to enhance data
- DAX Statistical Functions
- Create semi-additive measures
- Semi additive measures in DAX for Power pivot
Optimize Model Performance
- Remove unnecessary rows and columns
- Delete records or rows if the blank field
- Remove Columns from Tables in Power BI
- Identify poorly performing measures, relationships, and visuals
- Slow Measures
- Dealing with slow measures
- Slow Power BI report
- Table relationship causes severe performance drop
- Power BI Desktop Visuals slow load
- Improve cardinality levels by changing data types
- Optimize high cardinality columns in VertiPaq
- Improve cardinality levels through summarization
- Summarizing data
- Create and manage aggregations
- Create & manage aggregations
Visualize the Data (20-25%)
Create Reports
- Add visualization items to reports
- Add visuals to a Power BI report
- Choose an appropriate visualization type
- Visualization types in Power BI
- Format and configure visualizations
- Getting started with the formatting pane
- Import a custom visual
- Power BI visual files
- Configure conditional formatting
- Use conditional formatting in tables
- Apply slicing and filtering
- Slicers in Power BI
- Add a filter to a report in Power BI
- Add an R or Python visual
- Create Power BI visuals by using Python
- Create Power BI visuals using R
- Configure the report page
- Change the display of a report page
- Design and configure for accessibility
- Design Power BI reports for accessibility
- Configure automatic page refresh
- Automatic page refresh in Power BI
- Create a paginated report
- What are paginated reports?
- Create a paginated report for Power BI Report Server
- Create a paginated report based on a Power BI shared dataset
Create Dashboards
- Set mobile view
- Optimize a dashboard for mobile phones – Power BI
- Manage tiles on a dashboard
- Edit or remove a dashboard tile
- Configure data alerts
- Set alerts on Power BI dashboards
- Use the Q&A feature
- Q&A on dashboards
- Add a dashboard theme
- Use dashboard themes in the Power BI service
- Pin a live report page to a dashboard
- Add a new dashboard tile is by pinning an entire report page
Enrich Reports for Usability
- Configure bookmarks
- Bookmarks in Power BI desktop to share insights & build stories
- Create custom tooltips
- Customize tooltips in Power BI desktop
- Edit and configure interactions between visuals
- Change how visuals interact in a Power BI report
- Configure navigation for a report
- Make navigation easier with Power BI buttons
- Apply sorting
- Sort by column in Power BI Desktop
- Configure Sync Slicers
- Sync & use slicers on other pages
- Use the selection pane
- Power BI: Explore the new selection pane feature
- Use drill through and cross filter
- Set up drill through in Power BI reports
- Drilldown into data using interactive visuals
- Drill mode in a visual in Power BI
- Export report data
- Export data from a visual in a report
- Design reports for mobile devices
- Optimize Power BI reports for the mobile app
- Power BI Design for Mobile Device
Analyze the Data (10-15%)
Enhance Reports to Expose Insights
- Apply conditional formatting
- Use conditional formatting in tables
- Apply slicers and filters
- Power BI Slicers vs Filters
- Perform top N analysis
- When & How to Use TOPN in Power BI
- Explore statistical summary
- Explore statistical summary
- Use the Q&A visual
- The Q&A feature in Power BI
- Add a Quick Insights result to a report
- Review Quick insights
- Create reference lines by using the Analytics pane
- Use the Analytics pane
- Use the Play Axis feature of a visualization
- Play Axis (Dynamic Slicer)
- Personalize visuals
- Let users personalize visuals in a report
- Personalize visuals in a report
Perform Advanced Analysis
- Identify outliers
- Identify outliers with Power BI visuals
- How to detect anomalies & outliers In your data
- Conduct Time Series analysis
- Conduct time series analysis
- Use groupings and binnings
- Use grouping and binning in Power BI desktop
- Use the Key Influencers to explore dimensional variances
- Find important factors with the Key influencers visual
- Use the decomposition tree visual to break down a measure
- Decomposition Tree visual to break down a measure
- Apply AI Insights
- Use AI insights in Power BI desktop
Deploy and Maintain Deliverables (10-15%)
Manage Datasets
- Configure a dataset scheduled refresh
- Configure scheduled refresh
- Configure row-level security group membership
- Power BI Row-level Security Groups
- Row-level security using AD groups
- Providing access to datasets
- Build permission for shared datasets
- Configure incremental refresh settings
- Incremental refresh in Power BI
- Promote or certify Power BI datasets
- Promote your dataset – Power BI
- Certify datasets – Power BI
- Identify downstream dataset dependencies
- Dataset impact analysis
- Configure large dataset format
- Large datasets in Power BI Premium
- Using Power BI with large datasets
Create and Manage Workspaces
- Create and configure a workspace
- Create the new workspaces in Power BI
- Manage your workspace in Power BI & Microsoft 365
- Recommend a development lifecycle strategy
- Introducing Power BI deployment pipelines (Preview)
- Video on the future of content lifecycle management in Power BI
- Assign workspace roles
- Roles in the new workspaces
- Configure and update a workspace app
- Change your published app
- Publish, import, or update assets in a workspace
- Publish an app in Power BI
- Apply sensitivity labels to workspace content
- How to apply sensitivity labels in Power BI?
- Use deployment pipelines
- Introduction to deployment pipelines
- Get started with deployment pipelines
- Configure subscriptions
- Subscribe to a report or dashboard
- Subscribe yourself to reports & dashboards
- Promote or certify Power BI content
- Promote your reports, dashboards, & apps
- Endorse your content
- Endorsement – Promote & certify Power BI content
This brings us to the end of the DA-100 Analyzing Data with Microsoft Power BI Study Guide.
Follow Me to Receive Updates on DA-100 Exam
Share the DA-100 Study Guide in Your Network
Share on facebook
Share on twitter
Share on linkedin
