For more info about Exam DA-100: Analyzing Data with Microsoft Power BI
Exam DA-100: Analyzing Data with Microsoft Power BI
Microsoft DA-100 Exam Syllabus Topics:
| Topic | Details |
|---|---|
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 |
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 - implement object-level security - 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 - use Query Diagnostics |
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 |
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 |
Deploy and Maintain Deliverables (10-15%) | |
| Manage datasets | - configure a dataset scheduled refresh - configure row-level security group membership - provide 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 |
Reference: https://docs.microsoft.com/en-us/learn/certifications/exams/da-100
We not only provide the leading high-quality products which guarantee you pass exam 100% for sure, but also good service
Firstly, as we said before we are a strong company providing the leading high-quality DA-100 dumps VCE which the pass rate is high up to 96.17% based on the past five years' data. We guarantee all candidates pass Microsoft Analyzing Data with Microsoft Power BI if you trust us and study our DA-100 dumps VCE carefully. We assist about 100000+ candidates to pass exams every year. We can always get information about DA-100 from Microsoft official at the first moment once the DA-100 exam changes. We have great relationship with most of largest companies. We pay much money for the information sources every year. We guarantee all DA-100 dumps VCE we sell out are the latest, valid and accurate. We are being followed by many companies but never surpassed.
Secondly, our service is 7*24 online working including official holidays. We deal with all message & emails about exam dumps in two hours. We send you the DA-100 dumps VCE in 15 minutes after your payment. If you have questions about downloading the DA-100 dumps for free, the payment, the pass rate and the update date of exam dumps we are pleased to serve for you. We keep your information safety, we guarantee 100% pass Microsoft Analyzing Data with Microsoft Power BI exam. If you fail the exam with our DA-100 dumps VCE sadly we will full refund you in 2-7 working days.
9000 candidates choose us and pass exams every year, why are you still hesitating? Come and choose us, DA-100 dumps VCE will be your best helper.
After purchase, Instant Download: Upon successful payment, Our systems will automatically send the product you have purchased to your mailbox by email. (If not received within 12 hours, please contact us. Note: don't forget to check your spam.)
DA-100 dumps PDF & DA-100 dumps VCE, which?
DA-100 dumps PDF file is downloadable and is able to print out as hardcopy. Some candidates like study on paper or some candidates are purchase for company, they can print out many copies, and they can discuss & study together in meeting. We provide you DA-100 dumps free download.
DA-100 dumps VCE is more popular actually. The number of purchasing dumps VCE is far more than the dumps PDF especially the online test engine. Dumps VCE can not only provide the exam dumps materials but also it can simulate the real test scene. You can set the time and mark way just like the real test. So that you can not only master the questions & answers of DA-100 exam dumps, study performance after studying but also you can improve the answer speed, keep a good & casual mood while the real test. If you test wrong answers of some questions on DA-100 dumps VCE, the test engine will remind you to practice every time while operating. If some questions are answered correctly every time you can set to hide them. If more details you can try to download DA-100 dumps for free and if you have any questions you can contact with us at any time.
If you care about Microsoft Analyzing Data with Microsoft Power BI exam you should consider us DumpsFree. Our DA-100 dumps take the leading position in this area. Some candidates know us from other friends' recommendation or some know us from someone's blog or forum. You may download our DA-100 dumps for free first. From our dumps free download you will find our exam dumps are really valid and high-quality. Our DA-100 dumps VCE guarantee candidates pass exam 100% for sure. If you choose us, you will not be upset about your Microsoft Certified: Data Analyst Associate Analyzing Data with Microsoft Power BI exams any more.
Joseph 
Barbara 
Jack 
Rex 
Tess 
Devin 
Modesty 
Dale 
Lyle 
Maureen 
Jeremy 
Saxon 
Quintion 
John 
