Microsoft DA-100: 2021 New Master Practice Test- 100 % Pass

Buy Now

Price: $29.99

– Designed to give a detailed classification of Microsoft DA – 100 Examination. The course explains each and every section of the certification exam.

– The practice test includes latest topics added and most relevant use case question scenarios. The questions are designed and drafted by experts.

– Each and every question is answered in detail and the enrolled students can get URL to Microsoft documentation pages and trusted blogs to study each topics in detail.

– The only practice test with case study based real-time questions explained with proper answer and solution.

– 20 Plus Case Study questionnaires. These are real-time based questions drafted to test competency to provide best BI solutions using Power BI platform.

– The questions are refined with latest syllabus & technology updates in Power BI eco-systems.

– Below are different topics covered in the practice sets:

• Microsoft DAX language;

• Microsoft Power Query features;

• Data Modeling in Power BI;

• Data Visualization in Power BI;

• Manage Publishing and Sharing Power BI contents;

• Manage Power BI Administration settings.

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

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

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

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 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

• design reports for mobile devices

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 the 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

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 content

• identify downstream dataset dependencies

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