{"id":12198,"date":"2020-07-17T22:47:44","date_gmt":"2020-07-17T22:47:44","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=12198"},"modified":"2022-03-29T11:14:31","modified_gmt":"2022-03-29T11:14:31","slug":"exam-da-100-analyzing-data-with-microsoft-power-bi","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-da-100-analyzing-data-with-microsoft-power-bi\/","title":{"rendered":"Exam DA-100: Analyzing Data with Microsoft Power BI"},"content":{"rendered":"\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Certification-of-Capability-in-Business-Analysis-5.png\" alt=\"DA-100 Analyzing Data with Microsoft Power BI Online Tutorial\" class=\"wp-image-12207\"\/><\/figure><\/div>\n\n\n\n<p>Given the increasing demand of data analyst, certifications like <a rel=\"noreferrer noopener\" href=\"https:\/\/www.testpreptraining.ai\/analyzing-data-with-microsoft-power-bi-da-100-exam\" target=\"_blank\">Exam DA-100: Analyzing Data with Microsoft Power BI<\/a> is really beneficial. They validate your expertise and equip you with the industry-relevant skills for using Power BI.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Exam DA-100: Analyzing Data with Microsoft Power BI will retire on March 31, 2022. A replacement exam, <a href=\"https:\/\/www.testpreptraining.ai\/microsoft-power-bi-data-analyst-pl-300-exam\" target=\"_blank\" rel=\"noreferrer noopener\">Exam PL-300: Microsoft Power BI Data Analyst<\/a>, is available.<\/strong><\/h2>\n\n\n\n<p>Preparation for this exam demands huge investment in time and efforts. You need to be consistent and determined so as to crack the exam. Also, you need to refer genuine and authentic sources while learning. Here we present you our tutorials and preparatory guide to help you pass the exam with flying colours.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>What is DA-100: Analyzing Data with Microsoft Power BI ?<\/strong><\/h3>\n\n\n\n<p>As a Data Analyst, your role will be to enable businesses to maximize the value of their data assets using Microsoft Power BI. This exam quips you with the understanding to become a subject matter expert who is responsible to perform the following tasks<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/download-4.png\" alt=\"DA-100 Microsoft Data Analyst Associate\" class=\"wp-image-12215\" width=\"170\" height=\"170\"\/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, Designing and building scalable data models<\/li><li>Secondly, Cleaning and transforming data<\/li><li>Lastly, Enabling advanced analytic capabilities to provide meaningful business value using easy-to-comprehend data visualizations.<\/li><\/ul>\n\n\n\n<p>Further, Data Analysts also collaborate with key stakeholders across verticals to deliver relevant insights based on identified business requirements.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to prepare for Exam DA-100: Analyzing Data with Microsoft Power BI exam?\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/xlXphmP8EYE?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Why choose Microsoft DA-100 Exam?<\/strong><\/h4>\n\n\n\n<p>The highly acclaimed Microsoft DA-100 exam accelerates your career growth and definitely helps you climb up your professional ladder. This certification exam also guarantees the following benefits.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"576\" height=\"351\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/image-69.png\" alt=\"DA-100 BENEFITS\" class=\"wp-image-12209\"\/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Validates your skills<\/strong><ul><li>This certification validates your mastery in managing and deploying devices and client applications in an enterprise environment. It also demonstrates your expertise and knowledge.<\/li><\/ul><\/li><li><strong>Enhances Employability<\/strong><ul><li>This certification proves your skills and therefore enhances your employability by making you job ready.<\/li><\/ul><\/li><li><strong>Higher growth opportunities<\/strong><ul><li>This certification guarantees high growth opportunities. About 23% of Microsoft certified professionals reported receiving up to a 20% salary increase. It also helps you chase further advanced goals in the field of IT.<\/li><\/ul><\/li><li><strong>Provides competitive edge<\/strong><ul><li>Microsoft Certifications provide you with a competitive edge over non certified candidates. It is estimated that certified employees earn 15% more than those without certification and are nearly 20% more productive.<\/li><\/ul><\/li><li><strong>Brings recognition<\/strong><ul><li>You\u2019ll make immediate impact as a Microsoft Certified Professional. This credential will help you in getting noticed and bring recognition.<\/li><\/ul><\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Certification Details<\/strong><\/h4>\n\n\n\n<p>If you successfully passed the exam you get your MCSA certification -Microsoft Certified: Data Analyst Associate, which is valid for 2 years from the date you took the exam.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"139\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/ss1-750x139.png\" alt=\"DA-100 Certification Path\" class=\"wp-image-12210\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/ss1-750x139.png 750w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/ss1.png 778w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Exam Details: DA-100<\/strong><\/h4>\n\n\n\n<p>Here are some basic details about the DA-100 exam:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Managing-Microsoft-Teams-MS-700-4.png\" alt=\"Microsoft DA-100 Exam Details\" class=\"wp-image-12211\"\/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>The Microsoft Analyzing Data with Power BI exam covers 40 to 60 questions. However, the Microsoft DA-100 exam questions can be of type multiple choice that is to be attempted in a time limit of 180 minutes. <\/li><li>The DA-100 exam is available in English, Japanese, Chinese and Korean language. <\/li><li>Further to pass this cloud computing type exam you need a score of 70%.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"610\" height=\"376\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/image-70.png\" alt=\"DA-100 Exam Details\" class=\"wp-image-12212\"\/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Prerequisites : DA-100<\/strong><\/h4>\n\n\n\n<p>As a Data Analyst, it is suggested to have a fundamental understanding of data repositories and data processing both on-premises and in the cloud.<\/p>\n\n\n\n<p><strong><em>Before venturing in your preparation journey it is essential to have an understanding of the exam policies.<\/em><\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>DA-100 Exam Retake Policy<\/strong><\/h4>\n\n\n\n<p>If you were not able to clear the exam in the very first attempt, then remember it\u2019s not the end of the road but just a small bump. Microsoft allows you 5 attempts per year for a specific exam. The exam retake policy is as follows-<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>If a candidate is not able to clear the exam in the first attempt, the candidate must wait at least 24 hours before retaking the exam.<\/li><li>If a candidate does not clear the exam the second time, candidate must wait at least 14 days before retaking the exam a third time.<\/li><li>A 14-day waiting period is also there for the fourth and fifth subsequent exam retakes.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Cancellation and Reschedule Policy: Exam DA-100<\/strong><\/h4>\n\n\n\n<p>Microsoft allows free cancelling of the Exam within 24 hours prior to your scheduled appointment.<\/p>\n\n\n\n<p>But, if you fail to show up on your exam day without rescheduling or cancelling your exam, Microsoft reserves all rights to forfeit your entire exam fee.<\/p>\n\n\n\n<p>Rescheduling and Cancellation of your scheduled exams can be done through the Certification Dashboard.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam FAQ: Microsoft DA-100<\/strong><\/h3>\n\n\n\n<p>In order to qualify the DA-100 examination, you must have clarity about all the exam policies.&nbsp; For further queries visit <a rel=\"noreferrer noopener\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-da-100-exam-faqs\/\" target=\"_blank\">Microsoft DA-100 exam FAQs<\/a><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-da-100-exam-faqs\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Tutorials-Preparatory-Guide-2-2.png\" alt=\"DA-100 FAQ\" class=\"wp-image-12197\"\/><\/a><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam Course: DA-100<\/strong><\/h3>\n\n\n\n<p>The DA-100: Analyzing Data with Microsoft Power BI exam covers 5 domains. Further, each domain is divided into subtopics to provide complete clarity about the exam. Also, the percentage against each domain represents its weightage in the exam. Therefore, remember to devote enough time to domains with a higher percentage. The Microsoft DA-100 study guide covers the following topics:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"576\" height=\"345\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/image-71.png\" alt=\"DA-100 Course Outline\" class=\"wp-image-12213\"\/><\/figure><\/div>\n\n\n\n<h5 class=\"wp-block-heading\"><strong><em>Microsoft DA-100 Exam Course Outline was updated on March 23, 2021.<\/em><\/strong><\/h5>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>1. Prepare the data (20-25%)<\/strong><\/h4>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Microsoft Learning Path- <a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/learn\/paths\/prepare-data-power-bi\/\" target=\"_blank\">Prepare data for analysis<\/a><\/strong><\/h6>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Get data from different data sources<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Identify and connect to a data source (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-data-sources\" target=\"_blank\" rel=\"noreferrer noopener\">Data sources in Power BI Desktop<\/a>)<\/li><li>Change data source settings (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/service-gateway-data-sources\" target=\"_blank\" rel=\"noreferrer noopener\">Manage data sources<\/a>)<\/li><li>Select a shared dataset or create a local dataset (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/service-excel-workbook-files#where-your-workbook-file-is-saved-makes-a-difference\" target=\"_blank\" rel=\"noreferrer noopener\">Where your workbook file is saved makes a difference<\/a>)<\/li><li>Select a storage mode (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/get-data\/6-storage-mode\" target=\"_blank\" rel=\"noreferrer noopener\">Select a storage mode<\/a>)<\/li><li>Choose an appropriate query type (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/desktop-query-overview\" target=\"_blank\" rel=\"noreferrer noopener\">Query overview in Power BI Desktop<\/a>)<\/li><li>Identify query performance issues (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/get-data\/8-performance-issues\" target=\"_blank\" rel=\"noreferrer noopener\">Fix performance issues<\/a>)<\/li><li>Use Microsoft Dataverse (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/common-data-service\/data-platform-intro\" target=\"_blank\" rel=\"noreferrer noopener\">What is Common Data Service<\/a>?)<\/li><li>Using parameters<\/li><li>Use or create a PBIDS file<\/li><li>Use or create a data flow<\/li><li>Connect to a dataset using the XMLA endpoint<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Profile the data<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>identify data anomalies (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cognitive-services\/anomaly-detector\/tutorials\/batch-anomaly-detection-powerbi\" target=\"_blank\" rel=\"noreferrer noopener\">Visualize anomalies using batch detection and Power BI<\/a>)<\/li><li>examine data structures (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/clean-data-power-bi\/3-data-structure\" target=\"_blank\" rel=\"noreferrer noopener\">Simplify the data structure<\/a>)<\/li><li>interrogate column properties<\/li><li>interrogate data statistics (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/powerbi.microsoft.com\/fr-fr\/blog\/worldwide-demographics-amp-statistics-using-power-query-and-power-view\/\" target=\"_blank\" rel=\"noreferrer noopener\">Worldwide Demographics &amp; Statistics using Power Query and Power View<\/a>)<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Clean, transform, and load the data<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Resolve inconsistencies, unexpected or null values, and data quality issues (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/desktop-tips-and-tricks-for-creating-reports#tips-and-tricks-for-creating-relationships-in-power-bi-desktop\" target=\"_blank\" rel=\"noreferrer noopener\">Tips and tricks for creating relationships in Power BI Desktop<\/a>)<\/li><li>Apply user-friendly value replacements (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/community.powerbi.com\/t5\/Desktop\/Replace-values\/td-p\/542421\" target=\"_blank\" rel=\"noreferrer noopener\">Replace values<\/a>)<\/li><li>Identify and create appropriate keys for joins (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/desktop-relationships-understand\" target=\"_blank\" rel=\"noreferrer noopener\">Model relationships in Power BI Desktop<\/a>)<\/li><li>Evaluate and transform column data types (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/clean-data-power-bi\/4-column-data-types\" target=\"_blank\" rel=\"noreferrer noopener\">Evaluate and change column data types<\/a>)<\/li><li>Apply data shape transformations to table structures (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-shape-and-combine-data\" target=\"_blank\" rel=\"noreferrer noopener\">Shape and combine data in Power BI Desktop<\/a>)<\/li><li>Combine queries (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/community.powerbi.com\/t5\/Desktop\/merge-queries\/td-p\/463371\" target=\"_blank\" rel=\"noreferrer noopener\">merge queries<\/a>)<\/li><li>Apply user-friendly naming conventions to columns and queries <\/li><li>Leverage advanced editor to modify power query m code (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-query\/power-query-quickstart-using-power-bi#the-advanced-editor\" target=\"_blank\" rel=\"noreferrer noopener\">The Advanced Editor<\/a>)<\/li><li>Configure data loading <\/li><li>Resolve data import errors (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/get-data\/9-import-errors\" target=\"_blank\" rel=\"noreferrer noopener\">Resolve data import errors<\/a>)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>2. Model the data (25-30%)<\/strong><\/h4>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Microsoft Learning Path- <a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/learn\/paths\/model-power-bi\/\" target=\"_blank\">Model data in Power BI<\/a><\/strong><\/h6>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Design a data model<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Define the tables (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/visuals\/power-bi-visualization-tables\" target=\"_blank\" rel=\"noreferrer noopener\">Tables in Power BI reports and dashboards<\/a>)<\/li><li>Configure table and column properties <\/li><li>Define quick measures (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/desktop-quick-measures\" target=\"_blank\" rel=\"noreferrer noopener\">Use quick measures for common calculations<\/a>)<\/li><li>Flatten out a parent-child hierarchy <\/li><li>Define role-playing dimensions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/guidance\/star-schema#role-playing-dimensions\" target=\"_blank\" rel=\"noreferrer noopener\">Role-playing dimensions<\/a>)<\/li><li>Define a relationship&#8217;s cardinality and cross-filter direction (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/desktop-create-and-manage-relationships#cardinality\" target=\"_blank\" rel=\"noreferrer noopener\">Cardinality<\/a>)<\/li><li>Design the data model to meet performance requirements (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/guidance\/power-bi-optimization\" target=\"_blank\" rel=\"noreferrer noopener\">Optimization guide for Power BI<\/a>)<\/li><li>Resolve many-to-many relationships (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/guidance\/relationships-many-to-many\" target=\"_blank\" rel=\"noreferrer noopener\">Many-to-many relationship guidance<\/a>)<\/li><li>Create a common date table <\/li><li>Define the appropriate level of data granularity<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Develop a data model<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Apply cross-filter direction and security filtering (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/desktop-bidirectional-filtering\" target=\"_blank\" rel=\"noreferrer noopener\">Enable bidirectional cross-filtering for DirectQuery in Power BI Desktop<\/a>)<\/li><li>Create calculated tables (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/desktop-calculated-tables\" target=\"_blank\" rel=\"noreferrer noopener\">Creating calculated tables in Power BI Desktop<\/a>)<\/li><li>Creating hierarchies <\/li><li>Creating calculated columns (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/desktop-tutorial-create-calculated-columns\" target=\"_blank\" rel=\"noreferrer noopener\">Create calculated columns in Power BI Desktop<\/a>)<\/li><li>Implement row-level security roles (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/desktop-rls\" target=\"_blank\" rel=\"noreferrer noopener\">Restrict data access with row-level security (RLS) for Power BI Desktop<\/a>)<\/li><li>Set up the q&amp;a feature (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/power-bi-tutorial-q-and-a\" target=\"_blank\" rel=\"noreferrer noopener\">Use Power BI Q&amp;A to explore your data and create visuals<\/a>)<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Create measures by using DAX<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Use DAX to build complex measures (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/desktop-tutorial-create-measures#create-and-use-your-own-measures\" target=\"_blank\" rel=\"noreferrer noopener\">Create and use your own measures<\/a>)<\/li><li>Use CALCULATE to manipulate filters (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/guidance\/dax-avoid-avoid-filter-as-filter-argument\" target=\"_blank\" rel=\"noreferrer noopener\">DAX: Avoid using FILTER as a filter argument<\/a>)<\/li><li>Implement Time Intelligence using DAX (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/dax\/time-intelligence-functions-dax\" target=\"_blank\" rel=\"noreferrer noopener\">Time intelligence functions<\/a>)<\/li><li>Replace numeric columns with measures (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/dax\/replace-function-dax\" target=\"_blank\" rel=\"noreferrer noopener\">REPLACE<\/a>)<\/li><li>Use basic statistical functions to enhance data (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/dax\/statistical-functions-dax\" target=\"_blank\" rel=\"noreferrer noopener\">Statistical functions<\/a>)<\/li><li>Create semi-additive measures (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/analysis-services\/multidimensional-models\/define-semiadditive-behavior?view=asallproducts-allversions#:~:text=To%20add%20semiadditive%20behavior%2C%20open,on%20the%20Choose%20Enhancement%20page.\" target=\"_blank\" rel=\"noreferrer noopener\">Define Semiadditive Behavior<\/a>)<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Optimize model performance<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/guidance\/import-modeling-data-reduction\" target=\"_blank\" rel=\"noreferrer noopener\">Remove unnecessary rows and columns<\/a> <\/li><li>Identify poorly performing measures, relationships, and visuals (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/guidance\/power-bi-optimization\" target=\"_blank\" rel=\"noreferrer noopener\">Optimization guide for Power BI<\/a>)<\/li><li>Improve cardinality levels by changing data types (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/guidance\/import-modeling-data-reduction\" target=\"_blank\" rel=\"noreferrer noopener\">Data reduction techniques for Import modeling<\/a>)<\/li><li>Improve cardinality levels through summarization  <\/li><li>Create and manage aggregations (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/optimize-model-power-bi\/6-aggregations\" target=\"_blank\" rel=\"noreferrer noopener\">Create and manage aggregations<\/a>)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>3. Visualize the data (20-25%)<\/strong><\/h4>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Microsoft Learning Path-  <a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/learn\/paths\/visualize-data-power-bi\/\" target=\"_blank\">Visualize data in Power BI<\/a><\/strong><\/h6>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Create reports<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Add visualization items to reports (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/visuals\/power-bi-report-add-visualizations-i\" target=\"_blank\" rel=\"noreferrer noopener\">Add visuals to a Power BI report<\/a>)<\/li><li>Choose an appropriate visualization type (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/visuals\/power-bi-visualization-types-for-reports-and-q-and-a\" target=\"_blank\" rel=\"noreferrer noopener\">Visualization types in Power BI<\/a>)<\/li><li>Format and configure visualizations (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/visuals\/service-getting-started-with-color-formatting-and-axis-properties\" target=\"_blank\" rel=\"noreferrer noopener\">Getting started with the formatting pane<\/a>)<\/li><li>Import a custom visual (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/developer\/visuals\/power-bi-custom-visuals#:~:text=To%20import%20a%20Power%20BI,Power%20BI%20visual%20to%20AppSource.\" target=\"_blank\" rel=\"noreferrer noopener\">Visual files<\/a>)<\/li><li>Configure conditional formatting (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/desktop-conditional-table-formatting\" target=\"_blank\" rel=\"noreferrer noopener\">Use conditional formatting in tables<\/a>)<\/li><li>Apply slicing and filtering (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/visuals\/power-bi-visualization-slicers\" target=\"_blank\" rel=\"noreferrer noopener\">Slicers in Power BI<\/a>)<\/li><li>Add an r or python visual (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-python-visuals\" target=\"_blank\" rel=\"noreferrer noopener\">Create Power BI visuals by using Python<\/a>)<\/li><li>Configure the report page (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/consumer\/end-user-report-view\" target=\"_blank\" rel=\"noreferrer noopener\">Change the display of a report page<\/a>)<\/li><li>Design and configure for accessibility (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/desktop-accessibility-creating-reports\" target=\"_blank\" rel=\"noreferrer noopener\">Design Power BI reports for accessibility<\/a>)<\/li><li>Configure automatic page refresh<\/li><li>Create a paginated report<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Create dashboards<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Set mobile view (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/service-create-dashboard-mobile-phone-view\" target=\"_blank\" rel=\"noreferrer noopener\">Optimize a dashboard for mobile phones &#8211; Power BI<\/a>)<\/li><li>Manage tiles on a dashboard (<strong>Microsoft Documentation:<\/strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/service-dashboard-edit-tile\" target=\"_blank\" rel=\"noreferrer noopener\"> Edit or remove a dashboard tile<\/a>)<\/li><li>Configure data alerts (<strong>Microsoft Documentation:<\/strong> <a href=\"Set alerts on Power BI dashboards\" target=\"_blank\" rel=\"noreferrer noopener\">Tutorial: Set alerts on Power BI dashboards<\/a>)<\/li><li>Use the q&amp;a feature (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/consumer\/end-user-q-and-a#qa-on-dashboards\" target=\"_blank\" rel=\"noreferrer noopener\">Q&amp;A on dashboards<\/a>)<\/li><li>Add a dashboard theme (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/service-dashboard-themes\" target=\"_blank\" rel=\"noreferrer noopener\">Use Dashboard Themes in Power BI service<\/a>)<\/li><li>Pin a live report page to a dashboard (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/service-dashboard-pin-live-tile-from-report\" target=\"_blank\" rel=\"noreferrer noopener\">Pin an entire report page, as a live tile, to a Power BI dashboard<\/a>)<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Enrich reports for usability<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Configure bookmarks (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/desktop-bookmarks\" target=\"_blank\" rel=\"noreferrer noopener\">Create bookmarks in Power BI Desktop to share insights and build stories<\/a>)<\/li><li>Create custom tooltips (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/desktop-custom-tooltips\" target=\"_blank\" rel=\"noreferrer noopener\">Customize tooltips in Power BI Desktop<\/a>)<\/li><li>Edit and configure interactions (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/service-reports-visual-interactions\" target=\"_blank\" rel=\"noreferrer noopener\">Change how visuals interact in a Power BI report<\/a>)<\/li><li>Use the selection pane <\/li><li>Use drill through and cross filter<\/li><li>Drilldown into data using interactive visuals (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/consumer\/end-user-drill\">Drill mode in a visual in Power BI<\/a>)<\/li><li>Export report data&nbsp; between visuals (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/visuals\/power-bi-visualization-export-data\" target=\"_blank\" rel=\"noreferrer noopener\">Export the data that was used to create a visualization<\/a>)<\/li><li>Configure navigation for a report <\/li><li>Apply sorting (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/desktop-sort-by-column\" target=\"_blank\" rel=\"noreferrer noopener\">Sort by column in Power BI Desktop<\/a>)<\/li><li>Configure sync slicers (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/visuals\/power-bi-visualization-slicers#sync-and-use-slicers-on-other-pages\" target=\"_blank\" rel=\"noreferrer noopener\">Sync and use slicers on other pages<\/a>)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>4. Analyze the data (10-15%)<\/strong><\/h4>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Microsoft Learning Path- <a href=\"https:\/\/docs.microsoft.com\/learn\/paths\/perform-analytics-power-bi\/\" target=\"_blank\" rel=\"noreferrer noopener\">Data analysis in Power BI<\/a><\/strong><\/h6>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Enhance reports to expose insights<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Apply conditional formatting (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/desktop-conditional-table-formatting\" target=\"_blank\" rel=\"noreferrer noopener\">Use conditional formatting in tables<\/a>)<\/li><li>Apply slicers and filters <\/li><li>Perform top n analysis<\/li><li>Explore statistical summary (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/perform-analytics-power-bi\/2-statistical-summary\" target=\"_blank\" rel=\"noreferrer noopener\">Explore statistical summary<\/a>)<\/li><li>Use the q&amp;a visual (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/ai-visuals-power-bi\/2-visual\" target=\"_blank\" rel=\"noreferrer noopener\">Use the Q&amp;A visual<\/a>)<\/li><li>Add a quick insights result to a report (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/perform-analytics-power-bi\/9-quick-insights\" target=\"_blank\" rel=\"noreferrer noopener\">Review Quick insights<\/a>)<\/li><li>Create reference lines by using analytics pane (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/desktop-analytics-pane#use-the-analytics-pane\" target=\"_blank\" rel=\"noreferrer noopener\">Use the Analytics pane<\/a>)<\/li><li>Use the play axis feature of a visualization <\/li><li>Personalize Visuals<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Perform advanced analysis<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Identify outliers (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/perform-analytics-power-bi\/3-visuals\" target=\"_blank\" rel=\"noreferrer noopener\">Identify outliers with Power BI visuals<\/a>)<\/li><li>Conduct time series analysis (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/perform-analytics-power-bi\/6-time-series-analysis\" target=\"_blank\" rel=\"noreferrer noopener\">Conduct time series analysis<\/a>)<\/li><li>Use groupings and innings (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/desktop-grouping-and-binning\" target=\"_blank\" rel=\"noreferrer noopener\">Use grouping and binning in Power BI Desktop<\/a>)<\/li><li>Using the key influencers to explore dimensional variances (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/ai-visuals-power-bi\/3-key-influencers\" target=\"_blank\" rel=\"noreferrer noopener\">Find important factors with the Key influencers visual<\/a>)<\/li><li>Using the decomposition tree visual to break down a measure (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/ai-visuals-power-bi\/4-decomposition-tree\" target=\"_blank\" rel=\"noreferrer noopener\">Use the Decomposition Tree visual to break down a measure<\/a>)<\/li><li>Apply ai insights (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/desktop-ai-insights\" target=\"_blank\" rel=\"noreferrer noopener\">Use AI Insights in Power BI Desktop<\/a>)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>5. Deploy and maintain deliverables (10-15%)<\/strong><\/h4>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Microsoft Learning Path- <a href=\"https:\/\/docs.microsoft.com\/learn\/paths\/perform-analytics-power-bi\/\" target=\"_blank\" rel=\"noreferrer noopener\">Data analysis in Power BI<\/a><\/strong><\/h6>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Manage datasets<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Configure a dataset scheduled refresh (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/refresh-scheduled-refresh\" target=\"_blank\" rel=\"noreferrer noopener\">Configure scheduled refresh<\/a>)<\/li><li>Configure row-level security group membership<\/li><li>Providing access to datasets (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/service-datasets-build-permissions\" target=\"_blank\" rel=\"noreferrer noopener\">Build permission for shared dataset<\/a>s)<\/li><li>Configure incremental refresh settings (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/admin\/service-premium-incremental-refresh\" target=\"_blank\" rel=\"noreferrer noopener\">Incremental refresh in Power BI<\/a>)<\/li><li>Promote or Certify PowerBI datasets<\/li><li>Identify downstream Dataset Dependencies<\/li><li>Configure large dataset format<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Create and manage workspaces<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Create and configure a workspace (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/collaborate-share\/service-create-the-new-workspaces\" target=\"_blank\" rel=\"noreferrer noopener\">Create the new workspaces in Power BI<\/a>)<\/li><li>Recommend a development lifecycle strategy<\/li><li>Assign workspace roles (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/collaborate-share\/service-new-workspaces#:~:text=To%20grant%20access%20to%20a,the%20roles%20they're%20assigned.\" target=\"_blank\" rel=\"noreferrer noopener\">Roles in the new workspaces<\/a>)<\/li><li>Configure and update a workspace app (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/collaborate-share\/service-create-distribute-apps#change-your-published-app\" target=\"_blank\" rel=\"noreferrer noopener\">Change your published app<\/a>)<\/li><li>Publish, import, or update assets in a workspace (<strong>Microsoft Documentation:<\/strong> <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/collaborate-share\/service-create-distribute-apps\" target=\"_blank\" rel=\"noreferrer noopener\"> Publish an app in Power BI<\/a>)<\/li><li>Apply sensitivity labels to workspace content<\/li><li>Use Deployment pipelines<\/li><li>Configure subscriptions<\/li><li>Promote or certify Power BI content<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Preparatory Guide<\/strong> <strong>for Microsoft Exam DA-100<\/strong><\/h2>\n\n\n\n<p>The key to successfully pass an exam is by preparing right. Preparations demand consistency and determination. There are plenty resources available, for your preparations. You must have the right information and tools to crack the exam. We present you our specially curated preparatory guide to help you pass the Microsoft DA-100 Power BI exam in the very first attempt. Let\u2019s discuss step by step.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"2000\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/SAP-Ariba-Procurement-C_ARP2P_2005-2.png\" alt=\"Microsoft DA-100 Preparatory Guide\" class=\"wp-image-12214\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/SAP-Ariba-Procurement-C_ARP2P_2005-2.png 800w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/SAP-Ariba-Procurement-C_ARP2P_2005-2-160x400.png 160w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step 1- Refer the Official Guide<\/strong><\/h4>\n\n\n\n<p>Firstly, you need to go through the <a href=\"https:\/\/query.prod.cms.rt.microsoft.com\/cms\/api\/am\/binary\/RE4qlRu\" target=\"_blank\" rel=\"noreferrer noopener\">Official Microsoft DA-100 Study Guide.<\/a> Familiarise yourself with all the objectives and course domains of the exam. Further, devote enough time to each topic and have in depth knowledge of the subject by tailoring your study focus around the course domains. Moreover, the official guide acts as a blueprint for the exam.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step 2- Look out for resources<\/strong><\/h4>\n\n\n\n<p>There are various learning resources available in the market place for your Microsoft DA-100 exam. Remember to refer the ones that best suit you and support your preparations.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/images-na.ssl-images-amazon.com\/images\/I\/51U8x6JD3CL._SX402_BO1,204,203,200_.jpg\" alt=\"DA-100 Book\" width=\"144\" height=\"178\"\/><\/figure><\/div>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Books your ultimate friends<\/strong><\/h5>\n\n\n\n<p>Books are the most important ingredient of the preparation. There are a vast variety of books available in the market which you can use to prepare for the Microsoft DA-100 Exam. Therefore, our suggestion to you would be to find the Microsoft DA-100 book from genuine sources.&nbsp;We recommend you to refer the <a href=\"https:\/\/www.amazon.in\/Data-Analysis-Microsoft-Power-Bi\/dp\/126045861X\" target=\"_blank\" rel=\"noreferrer noopener\">Data Analysis with Microsoft Power BI Book by Brian Larson<\/a>. <\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Microsoft Learning Paths<\/strong><\/h5>\n\n\n\n<p>Microsoft provides you with their learning paths which are a great way to prepare for the exam. These modules help you learn through hands on experience and include technical workshops. Moreover, Microsoft Learn provides a new approach to learning by offering on-demand dynamic and interactive experience. Remember to refer them during your preparation journey.<\/p>\n\n\n\n<p>Microsoft offers the Get started with<a href=\"https:\/\/docs.microsoft.com\/learn\/paths\/data-analytics-microsoft\/\" target=\"_blank\" rel=\"noreferrer noopener\"> Microsoft data analytics Learning Path<\/a> for DA-100 exam<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step 3- Go for Training Course<\/strong><\/h4>\n\n\n\n<p>Microsoft offers their training courses to provide you with the necessary tools and resources. These Microsoft DA-100 training courses aid your preparations by providing you the practical experience for the exam. Microsoft offers its instructor led training course- <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/courses\/da-100t00\"><\/a><\/p>\n\n\n\n<h6 class=\"wp-block-heading\"><a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/courses\/da-100t00\" target=\"_blank\"><strong>Analyzing Data with Microsoft Power BI<\/strong><\/a><\/h6>\n\n\n\n<p>This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Skills Acquired<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\"><li>Ingest, clean, and transform data<\/li><li>Model data for performance and scalability<\/li><li>Design and create reports for data analysis<\/li><li>Apply and perform advanced report analytics<\/li><li>Manage and share report assets<\/li><li>Create paginated reports in Power BI<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step 4 &#8211; Join a community<\/strong><\/h4>\n\n\n\n<p>Online forums and study groups are indeed a great way to prepare for the DA-100 Exam. The best way to get in touch with other candidates is through study forums or online groups. Moreover, you can ask a question related to the topic you\u2019re having difficulty with.<\/p>\n\n\n\n<p>Also, such groups provide regular insights about the exams. The discussions are really beneficial for you to excel the exam.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step 5 &#8211; Attempt Practice Tests<\/strong><\/h4>\n\n\n\n<p>Finally, it is time to check your preparations. Self-Evaluation is the key and hence your next step is to go for practice tests. The more you\u2019re going to practice, the better for you. Moreover, these practice tests provide you with the real exam environment and also help you analyze areas that need improvement. Strengthening your weaker domains will surely help you pass with flying colors. Therefore, attempt as many Microsoft DA-100 practice exam tests as you can. <a rel=\"noreferrer noopener\" href=\"https:\/\/www.testpreptraining.ai\/analyzing-data-with-microsoft-power-bi-da-100-free-test\" target=\"_blank\">Start practising now.<\/a><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/www.testpreptraining.ai\/analyzing-data-with-microsoft-power-bi-da-100-free-test\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Certification-of-Capability-in-Business-Analysis-6-750x117.png\" alt=\"Microsoft Exam DA-100 Practice test\" class=\"wp-image-12216\" width=\"961\" height=\"150\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Certification-of-Capability-in-Business-Analysis-6-750x117.png 750w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Certification-of-Capability-in-Business-Analysis-6.png 960w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/a><\/figure><\/div>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Enhance your skills and upgrade your profile by qualifying the DA-100 Analyzing Data with Microsoft Power BI exam. <a href=\"https:\/\/www.testpreptraining.ai\/analyzing-data-with-microsoft-power-bi-da-100-exam\" target=\"_blank\" rel=\"noreferrer noopener\">Start your preparations Now!<\/a><\/strong><\/h5>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Analyzing Data with Microsoft Power BI <strong>Exam (DA-100) <\/strong>Online Tutorial<\/strong><\/h2>\n\n\n\n<p>While preparing for Microsoft Exam DA-100: Analyzing Data with Microsoft Power BI it is very important for you to have the right set of resources with the right preparation guide to sail through and qualify the exam.  With enormous set of resources available to choose from, selecting the right fit is what makes the difference. We provide you with last-minute preparation guide to help you prepare better.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Exam-DA-100-750x400.png\" alt=\"\" class=\"wp-image-33334\"\/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Prepare the data (20-25%)<\/strong><\/h3>\n\n\n\n<p><strong>Getting Data from different Data Sources<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/connect-to-a-data-source\/\" target=\"_blank\" rel=\"noreferrer noopener\">Connect to a data source<\/a> <\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/managing-data-source\/\" target=\"_blank\" rel=\"noreferrer noopener\">Managing data source<\/a> <\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/saving-workbook-file\/\" target=\"_blank\" rel=\"noreferrer noopener\">Saving a Workbook File<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/selecting-a-storage-mode\/\" target=\"_blank\" rel=\"noreferrer noopener\">Selecting a storage mode<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-query-in-power-bi-desktop\/\" target=\"_blank\" rel=\"noreferrer noopener\">Overview of Query in Power BI Desktop<\/a> <\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/identifying-performance-issues\/\" target=\"_blank\" rel=\"noreferrer noopener\">Identify query performance issues<\/a> <\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/microsoft-dataverse-and-its-uses\/\" target=\"_blank\" rel=\"noreferrer noopener\">Using Microsoft Dataverse <\/a><\/li><li>Use Parameters<\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/using-pbids-files\/\" target=\"_blank\" rel=\"noreferrer noopener\">Using PBIDS file<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/using-data-flows\/\" target=\"_blank\" rel=\"noreferrer noopener\">Using Data Flows<\/a><\/li><\/ul>\n\n\n\n<p><strong>Profile the data<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/visualize-data-anomalies\/\" target=\"_blank\" rel=\"noreferrer noopener\">Visualize data anomalies<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/analyze-data-structures\/\" target=\"_blank\" rel=\"noreferrer noopener\">Analyze data structures <\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/about-column-properties\/\" target=\"_blank\" rel=\"noreferrer noopener\">Column properties<\/a><\/li><li>Interrogate data statistics <\/li><\/ul>\n\n\n\n<p><strong>Clean, transform, and load the data<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/creating-relationships-in-power-bi-desktop\/\" target=\"_blank\" rel=\"noreferrer noopener\">Handling  inconsistencies, unexpected or null values, and data quality issues <\/a><\/li><li>Apply user-friendly value replacements <\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-model-relationships-in-power-bi-desktop\/\" target=\"_blank\" rel=\"noreferrer noopener\">Overview of Model Relationships in Power BI Desktop<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/evaluate-the-benefits-of-additional-marketing-cloud-products\/\" target=\"_blank\" rel=\"noreferrer noopener\">Evaluating and Transforming Column Data Types<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/shape-and-combine-data-in-power-bi-desktop\/\" target=\"_blank\" rel=\"noreferrer noopener\">Shape and Combine Data in Power BI Desktop<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/combining-data-and-queries\/\" target=\"_blank\" rel=\"noreferrer noopener\">Combine Data and Queries<\/a><\/li><li>Apply user-friendly naming conventions to columns and queries<\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/using-advanced-editor-to-modify-m-code\/\" target=\"_blank\" rel=\"noreferrer noopener\">Using the advanced editor to modify power query m code<\/a> <\/li><li>Configure data loading<\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/resolve-data-import-errors\/\" target=\"_blank\" rel=\"noreferrer noopener\">Resolve data import errors <\/a><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Model the data (25-30%)<\/strong><\/h3>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Microsoft Learning Path-&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/learn\/paths\/model-power-bi\/\" target=\"_blank\">Model data in Power BI<\/a><\/strong><\/h6>\n\n\n\n<p><strong>Design a data model<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/define-tables-in-power-bi-reports\/\" target=\"_blank\" rel=\"noreferrer noopener\">Define the tables <\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/configure-table-column-properties\/\" target=\"_blank\" rel=\"noreferrer noopener\">Configure table and column properties<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/using-quick-measures\/\" target=\"_blank\" rel=\"noreferrer noopener\">Using quick measures <\/a><\/li><li>Flatten out a parent-child hierarchy<\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-role-playing-dimension\/\" target=\"_blank\" rel=\"noreferrer noopener\">Define role-playing dimensions<\/a> <\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/cardinality-and-cross-filter-direction\/\" target=\"_blank\" rel=\"noreferrer noopener\">Relationship\u2019s cardinality and cross-filter direction<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/optimized-power-bi-solutions\/\" target=\"_blank\" rel=\"noreferrer noopener\">Optimized Power BI Solution to meet performance requirements<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-many-to-many-relationship-guidance\/\" target=\"_blank\" rel=\"noreferrer noopener\">Resolve many-to-many relationships<\/a> <\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/create-data-tables-in-power-bi-desktop\/\" target=\"_blank\" rel=\"noreferrer noopener\">Create a common date table<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-dimension-granularity\/\" target=\"_blank\" rel=\"noreferrer noopener\">Define the appropriate level of data granularity<\/a><\/li><\/ul>\n\n\n\n<p><strong>Develop a data model<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/bidirectional-cross-filtering-for-directquery\/\" target=\"_blank\" rel=\"noreferrer noopener\">Cross-filter direction and security filtering <\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/creating-calculated-tables-in-power-bi-desktop\/\" target=\"_blank\" rel=\"noreferrer noopener\">Create calculated tables<\/a> <\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/create-hierarchies\/\" target=\"_blank\" rel=\"noreferrer noopener\">Creating hierarchies<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/creating-calculated-columns\/\" target=\"_blank\" rel=\"noreferrer noopener\">Create calculated columns <\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/row-level-security-rls-for-power-bi-desktop\/\" target=\"_blank\" rel=\"noreferrer noopener\">Implement row-level security roles <\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/using-power-bi-qa-features\/\" target=\"_blank\" rel=\"noreferrer noopener\">Using Power BI q&amp;a feature <\/a><\/li><\/ul>\n\n\n\n<p><strong>Create measures by using DAX<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/create-measures-with-the-data-analysis-expressions-dax\/\" target=\"_blank\" rel=\"noreferrer noopener\">Create Measures with DAX <\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/using-calculate-function-dax\/\" target=\"_blank\" rel=\"noreferrer noopener\">Using CALCULATE Function<\/a> <\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/time-intelligence-functions-using-dax\/\" target=\"_blank\" rel=\"noreferrer noopener\">Time Intelligence Using DAX<\/a> <\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/replace-function\/\" target=\"_blank\" rel=\"noreferrer noopener\">Replace Function with measures <\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/statistical-functions-dax\/\" target=\"_blank\" rel=\"noreferrer noopener\">Using statistical functions with DAX<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/define-semiadditive-behavior\/\" target=\"_blank\" rel=\"noreferrer noopener\">Define semi-additive Behavior <\/a><\/li><\/ul>\n\n\n\n<p><strong>Optimize model performance<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/remove-unnecessary-rows-and-columns\/\" target=\"_blank\" rel=\"noreferrer noopener\">Remove unnecessary rows and columns<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/optimizing-guide-for-power-bi\/\" target=\"_blank\" rel=\"noreferrer noopener\">Optimizing Guide for Power BI for measures, relationships, and visuals <\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/improve-cardinality-levels-by-changing-data-types-and-through-summarization\/\" target=\"_blank\" rel=\"noreferrer noopener\">Improve cardinality levels by changing data types and through summarization<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/learn-to-create-and-manage-aggregations\/\" target=\"_blank\" rel=\"noreferrer noopener\">Learn to Create and Manage Aggregations<\/a> <\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Visualize the data (20-25%)<\/strong><\/h3>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Microsoft Learning Path-&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/learn\/paths\/visualize-data-power-bi\/\" target=\"_blank\">Visualize data in Power BI<\/a><\/strong><\/h6>\n\n\n\n<p><strong>Create reports<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/add-visualizations-item-to-power-bi-reports\/\" target=\"_blank\" rel=\"noreferrer noopener\">Add visualization items to reports <\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/types-of-visualization-in-power-bi\/\" target=\"_blank\" rel=\"noreferrer noopener\">Choose an appropriate visualization type <\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/formatting-and-configuring-visualization\/\" target=\"_blank\" rel=\"noreferrer noopener\">Format and configure visualizations<\/a> <\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/import-a-custom-visual\/\" target=\"_blank\" rel=\"noreferrer noopener\">Import a custom visual<\/a> <\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/conditional-formatting-for-tables-in-power-bi-desktop\/\" target=\"_blank\" rel=\"noreferrer noopener\">Configure conditional formatting <\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/slicing-and-filtering\/\" target=\"_blank\" rel=\"noreferrer noopener\">Apply slicing and filtering <\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/create-power-bi-visuals-using-python\/\" target=\"_blank\" rel=\"noreferrer noopener\">Create Power BI visuals using Python<\/a><\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/configuring-report-pages\/\" target=\"_blank\" rel=\"noreferrer noopener\">Configure the report page<\/a> <\/li><li><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/design-reports-for-accessibility\/\" target=\"_blank\" rel=\"noreferrer noopener\">Design and configure for accessibility <\/a><\/li><\/ul>\n\n\n\n<p><strong>Create dashboards<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Set mobile view <\/li><li>Manage tiles on a dashboard <\/li><li>Configure data alerts <\/li><li>Use the q&amp;a feature <\/li><li>Add a dashboard theme <\/li><li>Pin a live report page to a dashboard <\/li><li>Configure data classification <\/li><\/ul>\n\n\n\n<p><strong>Enrich reports for usability<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Configure bookmarks <\/li><li>Create custom tooltips <\/li><li>Edit and configure interactions <\/li><li>Use the selection pane<\/li><li>Use drill through and cross filter<\/li><li>Drilldown into data using interactive visuals <\/li><li>Export report data&nbsp; between visuals <\/li><li>Configure navigation for a report<\/li><li>Apply sorting <\/li><li>Configure sync slicers <\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Analyze the data (10-15%)<\/strong><\/h3>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Microsoft Learning Path-&nbsp;<a href=\"https:\/\/docs.microsoft.com\/learn\/paths\/perform-analytics-power-bi\/\" target=\"_blank\" rel=\"noreferrer noopener\">Data analysis in Power BI<\/a><\/strong><\/h6>\n\n\n\n<p><strong>Enhance reports to expose insights<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Apply conditional formatting <\/li><li>Apply slicers and filters<\/li><li>Perform top n analysis<\/li><li>Explore statistical summary <\/li><li>Use the q&amp;a visual <\/li><li>Add a quick insights result to a report <\/li><li>Create reference lines by using analytics pane <\/li><li>Use the play axis feature of a visualization<\/li><li>Personalize Visuals<\/li><\/ul>\n\n\n\n<p><strong>Perform advanced analysis<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Identify outliers <\/li><li>Conduct time series analysis <\/li><li>Use groupings and innings <\/li><li>Using the key influencers to explore dimensional variances <\/li><li>Use the decomposition tree visual to break down a measure <\/li><li>Apply ai insights <\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Deploy and maintain deliverables (10-15%)<\/strong><\/h3>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Microsoft Learning Path-&nbsp;<a href=\"https:\/\/docs.microsoft.com\/learn\/paths\/perform-analytics-power-bi\/\">Data analysis in Power BI<\/a><\/strong><\/h6>\n\n\n\n<p><strong>Manage datasets<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Configure a dataset scheduled refresh <\/li><li>Configure row-level security group membership<\/li><li>Providing access to datasets <\/li><li>Configure incremental refresh settings <\/li><li>Promote or Certify PowerBI Content<\/li><li>Identify downstream Dataset Dependencies<\/li><li>Endorse a dataset <\/li><\/ul>\n\n\n\n<p><strong>Create and manage workspaces<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Create and configure a workspace <\/li><li>Recommend a development lifecycle strategy<\/li><li>Assign workspace roles <\/li><li>Configure and update a workspace app <\/li><li>Publish, import, or update assets in a workspace <\/li><li>Apply sensitivity labels to workspace content<\/li><li>Use Deployment pipelines<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/analyzing-data-with-microsoft-power-bi-da-100-free-test\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"961\" height=\"150\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png\" alt=\"Microsoft Exam DA-100 Free Practice Test\" class=\"wp-image-31483\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png 961w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test-750x117.png 750w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/a><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Given the increasing demand of data analyst, certifications like Exam DA-100: Analyzing Data with Microsoft Power BI is really beneficial. They validate your expertise and equip you with the industry-relevant skills for using Power BI. Exam DA-100: Analyzing Data with Microsoft Power BI will retire on March 31, 2022. A replacement exam, Exam PL-300: Microsoft&#8230;<\/p>\n","protected":false},"author":1,"featured_media":12207,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[5945,1226],"tags":[1830,1829,1828,4,1827],"class_list":["post-12198","page","type-page","status-publish","has-post-thumbnail","hentry","category-business-intelligence","category-microsoft","tag-da-100-study-guide","tag-exam-da-100-analyzing-data-with-microsoft-power-bi-exam-details","tag-exam-da-100-analyzing-data-with-microsoft-power-bi-exam-guide","tag-m4f","tag-md-100-preparatory-guide"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Exam DA-100: Analyzing Data with Microsoft Power BI | Preparatory Guide<\/title>\n<meta name=\"description\" content=\"Boost your career by validating your skills in the DA-100 Analyzing Data with Microsoft Power BI exam | Tutorials and Preparatory Guide\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-da-100-analyzing-data-with-microsoft-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exam DA-100: Analyzing Data with Microsoft Power BI | Preparatory Guide\" \/>\n<meta property=\"og:description\" content=\"Boost your career by validating your skills in the DA-100 Analyzing Data with Microsoft Power BI exam | Tutorials and Preparatory Guide\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-da-100-analyzing-data-with-microsoft-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-29T11:14:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Certification-of-Capability-in-Business-Analysis-5.png\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"18 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-da-100-analyzing-data-with-microsoft-power-bi\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-da-100-analyzing-data-with-microsoft-power-bi\/\",\"name\":\"Exam DA-100: Analyzing Data with Microsoft Power BI | Preparatory Guide\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2020-07-17T22:47:44+00:00\",\"dateModified\":\"2022-03-29T11:14:31+00:00\",\"description\":\"Boost your career by validating your skills in the DA-100 Analyzing Data with Microsoft Power BI exam | Tutorials and Preparatory Guide\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-da-100-analyzing-data-with-microsoft-power-bi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-da-100-analyzing-data-with-microsoft-power-bi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-da-100-analyzing-data-with-microsoft-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exam DA-100: Analyzing Data with Microsoft Power BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exam DA-100: Analyzing Data with Microsoft Power BI | Preparatory Guide","description":"Boost your career by validating your skills in the DA-100 Analyzing Data with Microsoft Power BI exam | Tutorials and Preparatory Guide","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-da-100-analyzing-data-with-microsoft-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"Exam DA-100: Analyzing Data with Microsoft Power BI | Preparatory Guide","og_description":"Boost your career by validating your skills in the DA-100 Analyzing Data with Microsoft Power BI exam | Tutorials and Preparatory Guide","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-da-100-analyzing-data-with-microsoft-power-bi\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2022-03-29T11:14:31+00:00","og_image":[{"width":750,"height":400,"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/Certification-of-Capability-in-Business-Analysis-5.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"18 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-da-100-analyzing-data-with-microsoft-power-bi\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-da-100-analyzing-data-with-microsoft-power-bi\/","name":"Exam DA-100: Analyzing Data with Microsoft Power BI | Preparatory Guide","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2020-07-17T22:47:44+00:00","dateModified":"2022-03-29T11:14:31+00:00","description":"Boost your career by validating your skills in the DA-100 Analyzing Data with Microsoft Power BI exam | Tutorials and Preparatory Guide","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-da-100-analyzing-data-with-microsoft-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/exam-da-100-analyzing-data-with-microsoft-power-bi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-da-100-analyzing-data-with-microsoft-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Exam DA-100: Analyzing Data with Microsoft Power BI"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/12198","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=12198"}],"version-history":[{"count":52,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/12198\/revisions"}],"predecessor-version":[{"id":53807,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/12198\/revisions\/53807"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media\/12207"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=12198"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=12198"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=12198"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}