The Microsoft DA-100 Exam is challenging and thorough preparation is essential for success. This exam study guide is designed to help you prepare for the Analyzing Data with Microsoft Power BI certification exam. It contains a detailed list of the topics covered on the Professional exam, as well as a detailed list of preparation resources. These study guides for Analyzing Data with Microsoft Power BI will help guide you through the study process for your certification.
DA-100 Analyzing Data with Microsoft Power BI Exam Summary
● Exam Name: Analyzing Data with Microsoft Power BI
● Exam Code: DA-100
● Exam Price: $550 (USD)
● Duration: 180 mins
● Number of Questions: 40-60
● Passing Score: 700 / 1000
● Books / Training: DA-100T00-A: Analyzing Data with Power BI
● Schedule Exam: Pearson VUE
● Sample Questions: Analyzing Data with Microsoft Power BI Sample Questions
● Recommended Practice: Microsoft DA-100 Certification Practice Exam
Exam Syllabus: DA-100 Microsoft Certified - Data Analyst Associate
1. Prepare the Data (20-25%)
● Get data from different data sources
- identify and connect to a data source
- change data source settings
- select a shared dataset or create a local dataset
- select a storage mode
- choose an appropriate query type
- identify query performance issues
- use Microsoft Dataverse
- use parameters
- use or create a PBIDS file
- use or create a data flow
- connect to a dataset using the XMLA endpoint
● Profile the data
- identify data anomalies
- examine data structures
- interrogate column properties
- interrogate data statistics
● Clean, transform, and load the data
- resolve inconsistencies, unexpected or null values, and data quality issues
- apply user-friendly value replacements
- identify and create appropriate keys for joins
- evaluate and transform column data types
- apply data shape transformations to table structures
- combine queries
- apply user-friendly naming conventions to columns and queries
- leverage Advanced Editor to modify Power Query M code
- configure data loading
- resolve data import errors
2. Model the Data (25-30%)
● 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 numeric columns with measures
- use basic statistical functions to enhance data
- create semi-additive measures
● 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
3. Visualize the Data (20-25%)
● 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
- configure automatic page refresh
- create a paginated report
● 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
● 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
- design reports for mobile devices
4. Analyze the Data (10-15%)
● 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
- personalize visuals
● Perform advanced analysis
- identify outliers
- conduct Time Series analysis
- use groupings and binnings
- use the Key Influencers to explore dimensional variances
- use the decomposition tree visual to break down a measure
- apply AI Insights
5. Deploy and Maintain Deliverables (10-15%)
● Manage datasets
- configure a dataset scheduled refresh
- configure row-level security group membership
- providing access to datasets
- configure incremental refresh settings
- promote or certify Power BI datasets
- identify downstream dataset dependencies
- configure large dataset format
● 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
- apply sensitivity labels to workspace content
- use deployment pipelines
- configure subscriptions
- promote or certify Power BI content
Microsoft DA-100 Certification Sample Questions and Answers
To make you familiar with Analyzing Data with Microsoft Power BI (DA-100) certification exam structure, we have prepared this sample question set. We suggest you to try our Sample Questions for MCA Data Analyst DA-100 Certification to test your understanding of Microsoft DA-100process with real Microsoft certification exam environment.
DA-100 Analyzing Data with Microsoft Power BI Sample Questions:-
01. Reference Scenario: click here
You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date. You need to reduce the size of the data model.
What should you do?
a) Round the hour of the Date column to startOfHour
b) Change the data type of the Date column to Text
c) Trim the Date column
d) Split the Date column into two columns, one that contains only the time and another that contains only the date
02. You have a report page named Sales which contains visual A, showing total sales for each city for the selected year, as shown in the exhibit.
You need to configure an interaction for this visual. When clicking Drill through, it should redirect to a detail page that shows Sales for the selected city by Product Line and will preserve all the filters from the Sales page.
Which four actions should you perform?
Each correct answer presents part of the solution.
a) On the Detail page, under the drill through option, add City column as the drill through field.
b) On the Sales page, under the drill through option, add City column as the drill through field.
c) Create a table visual named Visual B to show total sales by city and product line.
d) On the Sales page, under the drill through option, set Keep all filters to On.
e) Create a new page named Detail.
f) On the Detail page, under the drill through option, set Keep all filters to On.
03. Reference Scenario: click here
Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals?
Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
a) a line chart that shows balances by quarter filtered to account categories that are longterm liabilities
b) a clustered column chart that shows balances by date (x-axis) and account category (legend) without filters
c) a clustered column chart that shows balances by quarter filtered to account categories that are long-term liabilities
d) a pie chart that shows balances by account category without filters
e) a ribbon chart that shows balances by quarter and accounts in the legend
04. Reference Scenario: click here
Which DAX expression should you use to get the ending balances in the balance sheet reports?
a) CALCULATE (
SUM( BalanceSheet [BalanceAmount] ), DATESQTD( 'Date'[Date] )
)
b) CALCULATE (
SUM( BalanceSheet [BalanceAmount] ), LASTDATE( 'Date'[Date] )
)
c) FIRSTNONBLANK ( 'Date' [Date]
SUM( BalanceSheet[BalanceAmount] )
)
d) CALCULATE (
MAX( BalanceSheet[BalanceAmount] ), LASTDATE( 'Date' [Date] )
)
05. You have a collection of reports for the HR department of your company. You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months.
Which type of visualization should you use?
a) scatter chart
b) ribbon chart
c) line chart
d) key influences
06. Reference Scenario: click here
You need to create a visualization that compares revenue and cost over time. Which type of visualization should you use?
a) stacked area chart
b) line chart
c) donut chart
d) waterfall chart
07. Reference Scenario: click here
What is the minimum number of datasets and storage modes required to support the reports?
a) two imported datasets
b) a single Direct Query dataset
c) two DirectQuery datasets
d) a single imported dataset
08. You are creating a visual to show the ranking of product categories by sales revenue. Your company's security policy states that you cannot send data outside of your Microsoft Power Bl tenant.
Which approach provides the widest variety of visuals while adhering to the security policy?
a) Use only default visuals
b) Use default or certified custom visuals
c) Use default or any custom visuals from the marketplace
d) Use default visuals or custom visuals uploaded from a .pbiviz file
09. Reference Scenario: click here
You need to provide a solution to provide the sales managers with the required access. What should you include in the solution?
a) Create a security role that has a table filter on the Sales_Manager table where username = UserName()
b) Create a security role that has a table filter on the Region_Manager table where sales_manager_id = UserPrincipalName()
c) Create a security role that has a table filter on the Sales_Manager table where name = UserName()
d) Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.
10. What should you create to meet the reporting requirements of the sales department?
a) a calculated measure that uses a formula of couNTROws(Sales)
b) a calculated column that use a formula of couMTA(Sales[sales_id]>
c) a calculated column that uses a formula of suM(Sales[sales_id])
d) a measure that uses a formula of sw-i(Sales[sales_id])
Answers:-
Answer 1:- d
Answer 2:- a, c, e, f
Answer 3:- a, c
Answer 4:- a
Answer 5:- d
Answer 6:- b
Answer 7:-a
Answer 8:- c
Answer 9:- b
Answer 10:- a