{"id":11767,"date":"2021-01-14T15:18:38","date_gmt":"2021-01-14T09:48:38","guid":{"rendered":"https:\/\/www.testpreptraining.com\/blog\/?p=11767"},"modified":"2023-10-09T12:32:11","modified_gmt":"2023-10-09T07:02:11","slug":"da-100-analyzing-data-with-microsoft-power-bi-cheat-sheet","status":"publish","type":"post","link":"https:\/\/www.testpreptraining.ai\/blog\/da-100-analyzing-data-with-microsoft-power-bi-cheat-sheet\/","title":{"rendered":"DA-100: Analyzing Data with Microsoft Power BI Cheat Sheet"},"content":{"rendered":"\n<p>Want to elevate your career with a professional certification? Are you confused about where to start you revisions from? Don\u2019t worry as you have arrived at the right place. This<strong> <a rel=\"noreferrer noopener\" href=\"https:\/\/www.testpreptraining.ai\/analyzing-data-with-microsoft-power-bi-da-100-exam\" target=\"_blank\">Analyzing Data with Microsoft Power BI DA-100<\/a><\/strong> Cheat Sheet is all you need to kick start your revisions. It will provide you with a quick summary of all the resources you need to pass the exam. Moreover, it will act as your golden ticket to achieve your credential. <\/p>\n\n\n\n<p>This examination will authenticate your proficiency and furnish you with industry-relevant skills for utilizing Power BI. Consistency and determination are crucial for success in cracking this exam. This cheat sheet serves as your guide for thorough revisions. But first, let&#8217;s quickly review the exam details.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Microsoft<\/strong> <strong>DA-100: Exam Overview<\/strong> <\/h3>\n\n\n\n<p>In the role of a Data Analyst, your responsibility is to empower businesses in optimizing the value of their data assets through Microsoft Power BI. This exam equips you with the knowledge to evolve into a subject matter expert, tasked with executing the following responsibilities:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Firstly, Designing and building scalable data models<\/li>\n\n\n\n<li>Secondly, Cleaning and transforming data<\/li>\n\n\n\n<li>Lastly, Enabling advanced analytic capabilities to provide meaningful business value using easy-to-comprehend data visualizations.<\/li>\n<\/ul>\n\n\n\n<p>Moreover, Data Analysts collaborate with essential stakeholders across various sectors to provide pertinent insights in alignment with identified business requirements.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Certification Details: <strong>Microsoft<\/strong> <strong>DA-100<\/strong><\/strong><\/h3>\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 take the exam.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/07\/ss1-750x139.png\" alt=\"DA-100 Certification Path\" class=\"wp-image-12210\"\/><figcaption class=\"wp-element-caption\">Source: Microsoft<\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\"><strong>Exam Prerequisites <\/strong><\/h4>\n\n\n\n<p>For a Data Analyst, it is recommended to have a foundational comprehension of data repositories and data processing, both in on-premises and cloud environments.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Cheat Sheet for Analyzing Data with Microsoft Power BI DA-100<\/strong><\/h3>\n\n\n\n<p>This exam is a stepping stone to your dream career therefore, you should prepare with all your focus. Revising for the exam is a huge task. This Cheat Sheet details the steps that will ensure your success in the exam. Also, it highlights the resources that will define your journey to success.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/01\/Cheat-Sheet-1.png\" alt=\"Microsoft DA-100 cheat sheet\" class=\"wp-image-11774\" srcset=\"https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/01\/Cheat-Sheet-1.png 750w, https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/01\/Cheat-Sheet-1-300x160.png 300w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\"><strong>Deeply Analyse the Exam Objectives<\/strong><\/h3>\n\n\n\n<p>Firstly, you must have a clear understanding of the exam rules and policies. You should familiarise yourself with the exam course and concepts to excel in the exam. Moreover, tailoring your study plan around the exam objectives is important for your preparations. You must devote enough time to each of 5 domains that this exam covers. The Microsoft DA-100 study guide covers the following topics:<\/p>\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<h3 class=\"wp-block-heading\"><strong>Prepare 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\/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\">\n<li>Identify and connect to a data source (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Change data source settings (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Select a shared dataset or create a local dataset (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Select a storage mode (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Choose an appropriate query type (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Identify query performance issues (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Use Microsoft Dataverse (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Use parameters<\/li>\n\n\n\n<li>Use or create a PBIDS file<\/li>\n\n\n\n<li>Use or create a data flow<\/li>\n\n\n\n<li>Connect to a dataset using the XMLA endpoint<\/li>\n<\/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\">\n<li>identify data anomalies (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>examine data structures (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>interrogate column properties<\/li>\n\n\n\n<li>interrogate data statistics (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n<\/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\">\n<li>Resolve inconsistencies, unexpected or null values, and data quality issues (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Apply user-friendly value replacements (<strong>Microsoft Documentation:<\/strong>&nbsp;<a href=\"https:\/\/community.powerbi.com\/t5\/Desktop\/Replace-values\/td-p\/542421\" target=\"_blank\" rel=\"noreferrer noopener\">Replace values<\/a>)<\/li>\n\n\n\n<li>Identify and create appropriate keys for joins (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Evaluate and transform column data types (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Apply data shape transformations to table structures (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Combine queries (<strong>Microsoft Documentation:<\/strong>&nbsp;<a href=\"https:\/\/community.powerbi.com\/t5\/Desktop\/merge-queries\/td-p\/463371\" target=\"_blank\" rel=\"noreferrer noopener\">merge queries<\/a>)<\/li>\n\n\n\n<li>Apply user-friendly naming conventions to columns and queries<\/li>\n\n\n\n<li>Leverage advanced editor to modify power query m code (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Configure data loading<\/li>\n\n\n\n<li>Resolve data import errors (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n<\/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<h5 class=\"wp-block-heading\"><strong>Design a data model<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Define the tables (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Configure table and column properties<\/li>\n\n\n\n<li>Define quick measures (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Flatten out a parent-child hierarchy<\/li>\n\n\n\n<li>Define role-playing dimensions (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Define a relationship\u2019s cardinality and cross-filter direction (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Design the data model to meet performance requirements (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Resolve many-to-many relationships (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Create a common date table<\/li>\n\n\n\n<li>Define the appropriate level of data granularity<\/li>\n<\/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\">\n<li>Apply cross-filter direction and security filtering (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Create calculated tables (<strong>Microsoft Documentation:<\/strong>&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/desktop-calculated-tables\" target=\"_blank\" rel=\"noreferrer noopener\">Create calculated tables in Power BI Desktop<\/a>)<\/li>\n\n\n\n<li>Create hierarchies<\/li>\n\n\n\n<li>Create calculated columns (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Implement row-level security roles (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Set up the q&amp;a feature (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n<\/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\">\n<li>Use DAX to build complex measures (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Use CALCULATE to manipulate filters (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Implement Time Intelligence using DAX (<strong>Microsoft Documentation:<\/strong>&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/dax\/time-intelligence-functions-dax\" target=\"_blank\" rel=\"noreferrer noopener\">Time intelligence functions<\/a>)<\/li>\n\n\n\n<li>Replace numeric columns with measures (<strong>Microsoft Documentation:<\/strong>&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/dax\/replace-function-dax\" target=\"_blank\" rel=\"noreferrer noopener\">REPLACE<\/a>)<\/li>\n\n\n\n<li>Use basic statistical functions to enhance data (<strong>Microsoft Documentation:<\/strong>&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/dax\/statistical-functions-dax\" target=\"_blank\" rel=\"noreferrer noopener\">Statistical functions<\/a>)<\/li>\n\n\n\n<li>Create semi-additive measures (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n<\/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\">\n<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>\n\n\n\n<li>Identify poorly performing measures, relationships, and visuals (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Improve cardinality levels by changing data types (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Improve cardinality levels through summarization<\/li>\n\n\n\n<li>Create and manage aggregations (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n<\/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<h5 class=\"wp-block-heading\"><strong>Create reports<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Add visualization items to reports (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Choose an appropriate visualization type (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Format and configure visualizations (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Import a custom visual (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Configure conditional formatting (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Apply slicing and filtering (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Add an r or python visual (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Configure the report page (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Design and configure for accessibility (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Configure automatic page refresh<\/li>\n\n\n\n<li>Create a paginated report<\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Create dashboards<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Set mobile view (<strong>Microsoft Documentation:<\/strong>&nbsp;<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 \u2013 Power BI<\/a>)<\/li>\n\n\n\n<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\">&nbsp;Edit or remove a dashboard tile<\/a>)<\/li>\n\n\n\n<li>Configure data alerts (<strong>Microsoft Documentation:<\/strong>&nbsp;<a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-da-100-analyzing-data-with-microsoft-power-bi\/Set%20alerts%20on%20Power%20BI%20dashboards\" target=\"_blank\" rel=\"noreferrer noopener\">Tutorial: Set alerts on Power BI dashboards<\/a>)<\/li>\n\n\n\n<li>Use the q&amp;a feature (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Add a dashboard theme (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Pin a live report page to a dashboard (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n<\/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\">\n<li>Configure bookmarks (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Create custom tooltips (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Edit and configure interactions (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Use the selection pane<\/li>\n\n\n\n<li>Use drill through and cross filter<\/li>\n\n\n\n<li>Drilldown into data using interactive visuals (<strong>Microsoft Documentation:<\/strong>&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/consumer\/end-user-drill\">Drill mode in a visual in Power BI<\/a>)<\/li>\n\n\n\n<li>Export report data&nbsp; between visuals (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Configure navigation for a report<\/li>\n\n\n\n<li>Apply sorting (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Configure sync slicers (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n<\/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<h5 class=\"wp-block-heading\"><strong>Enhance reports to expose insights<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Apply conditional formatting (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Apply slicers and filters<\/li>\n\n\n\n<li>Perform top n analysis<\/li>\n\n\n\n<li>Explore statistical summary (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Use the q&amp;a visual (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Add a quick insights result to a report (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Create reference lines by using analytics pane (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Use the play axis feature of a visualization<\/li>\n\n\n\n<li>Personalize Visuals<\/li>\n<\/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\">\n<li>Identify outliers (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Conduct time series analysis (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Use groupings and innings (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Use the key influencers to explore dimensional variances (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Use the decomposition tree visual to break down a measure (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Apply ai insights (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n<\/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<h5 class=\"wp-block-heading\"><strong>Manage datasets<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Configure a dataset scheduled refresh (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Configure row-level security group membership<\/li>\n\n\n\n<li>Providing access to datasets (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Configure incremental refresh settings (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Promote or Certify PowerBI datasets<\/li>\n\n\n\n<li>Identify downstream Dataset Dependencies<\/li>\n\n\n\n<li>Configure large dataset format<\/li>\n<\/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\">\n<li>Create and configure a workspace (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Recommend a development lifecycle strategy<\/li>\n\n\n\n<li>Assign workspace roles (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Configure and update a workspace app (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Publish, import, or update assets in a workspace (<strong>Microsoft Documentation:<\/strong>&nbsp;<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>\n\n\n\n<li>Apply sensitivity labels to workspace content<\/li>\n\n\n\n<li>Use Deployment pipelines<\/li>\n\n\n\n<li>Configure subscriptions<\/li>\n\n\n\n<li>Promote or certify Power BI content<\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong><em><a href=\"https:\/\/www.testpreptraining.ai\/blog\/how-to-prepare-for-da-100-analyzing-data-with-microsoft-power-bi\/\" target=\"_blank\" rel=\"noreferrer noopener\">Start preparing for DA-100 exam using the Preparation Guide!<\/a><\/em><\/strong><\/h5>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Resources to supplement your learning<\/strong><\/h3>\n\n\n\n<p>Choosing the right resources with reliable content is very important. Make sure the content is precise and reliable enough. As you have probably been preparing for this exam we hope that you have made a wise choice in terms of your learning resources. However, here are a few quick links that will definitely benefit your preparations and help you ace the exam:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignright is-resized\"><img decoding=\"async\" src=\"https:\/\/images-na.ssl-images-amazon.com\/images\/I\/51U8x6JD3CL._SX402_BO1,204,203,200_.jpg\" alt=\"DA-100 Book\" style=\"width:147px;height:182px\" width=\"147\" height=\"182\"\/><\/figure>\n<\/div>\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 certification Exam. Therefore, our suggestion to you would be to find the Microsoft DA-100 book from genuine sources.&nbsp; We recommend you refer to the<strong>&nbsp;Data Analysis with Microsoft Power BI Book by Brian Larson.<\/strong><\/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\">&nbsp;Microsoft data analytics Learning Path<\/a>&nbsp;for DA-100 exam<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Training Course<\/strong><\/h5>\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-<\/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>In this course, you will explore different techniques and optimal approaches aligned with both business and technical needs for modeling, visualizing, and analyzing data using Power BI. Additionally, the course will demonstrate how to retrieve and process data from various sources, encompassing both relational and non-relational data.<\/p>\n\n\n\n<p><strong>Skills Acquired<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Firstly, Ingest, clean, and transform data<\/li>\n\n\n\n<li>Secondly, Model data for performance and scalability<\/li>\n\n\n\n<li>Thirdly, Design and create reports for data analysis<\/li>\n\n\n\n<li>Also, Apply and perform advanced report analytics<\/li>\n\n\n\n<li>Further, Manage and share report assets<\/li>\n\n\n\n<li>Finally, Create paginated reports in Power B<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Online Tutorials <\/strong><\/h4>\n\n\n\n<p><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-da-100-analyzing-data-with-microsoft-power-bi\/\" target=\"_blank\" rel=\"noreferrer noopener\">Online Tutorials&nbsp;<\/a>provide you descriptive details about the exam and its policies. They help in mastering the exam concepts and ease your preparations. Remember that cheat sheet is not sufficient for qualifying the exam. You must begin your preparations with DA-100 Online Tutorials. . <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-da-100-analyzing-data-with-microsoft-power-bi\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" width=\"961\" height=\"150\" src=\"https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/01\/Oracle-1Z0-1082-20-2.png\" alt=\"Microsoft DA-100 online tutorials\" class=\"wp-image-11773\" srcset=\"https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/01\/Oracle-1Z0-1082-20-2.png 961w, https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/01\/Oracle-1Z0-1082-20-2-300x47.png 300w\" sizes=\"(max-width: 961px) 100vw, 961px\" \/><\/a><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\"><strong>Attempt Practice Tests<\/strong><\/h3>\n\n\n\n<p>The final recommendation for your preparatory guide involves practice tests. Microsoft DA-100 Practice Exam tests provide assistance by offering the experience of a real examination. They provide quick results and detailed reports of the candidate\u2019s performance, which eventually helps the candidate to find out the areas of strengths and weaknesses in different domains. Further attempt multiple practice tests to keep a check on your preparations. Also, aim at performing better in each subsequent test. This will in turn boost your confidence and make you exam ready. <a rel=\"noreferrer noopener\" href=\"https:\/\/www.testpreptraining.ai\/analyzing-data-with-microsoft-power-bi-da-100-free-test\" target=\"_blank\">Start using DA-100 practice exam tests now.<\/a> <\/p>\n\n\n<div class=\"wp-block-image\">\n<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 noreferrer\"><img decoding=\"async\" width=\"961\" height=\"150\" src=\"https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/01\/Oracle-1Z0-1082-20-1.png\" alt=\"Microsoft DA-100 free practice tests\" class=\"wp-image-11772\" srcset=\"https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/01\/Oracle-1Z0-1082-20-1.png 961w, https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/01\/Oracle-1Z0-1082-20-1-300x47.png 300w\" sizes=\"(max-width: 961px) 100vw, 961px\" \/><\/a><\/figure>\n<\/div>\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.&nbsp;<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","protected":false},"excerpt":{"rendered":"<p>Want to elevate your career with a professional certification? Are you confused about where to start you revisions from? Don\u2019t worry as you have arrived at the right place. This Analyzing Data with Microsoft Power BI DA-100 Cheat Sheet is all you need to kick start your revisions. It will provide you with a quick&#8230;<\/p>\n","protected":false},"author":1,"featured_media":11775,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,260],"tags":[],"class_list":["post-11767","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud-computing","category-microsoft"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>DA-100: Analyzing Data with Microsoft Power BI Cheat Sheet - Blog<\/title>\n<meta name=\"description\" content=\"Start preparing with advanced learning resources and free practice tests with DA-100: Analyzing Data with Microsoft Power BI\" \/>\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\/blog\/da-100-analyzing-data-with-microsoft-power-bi-cheat-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DA-100: Analyzing Data with Microsoft Power BI Cheat Sheet - Blog\" \/>\n<meta property=\"og:description\" content=\"Start preparing with advanced learning resources and free practice tests with DA-100: Analyzing Data with Microsoft Power BI\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/blog\/da-100-analyzing-data-with-microsoft-power-bi-cheat-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-14T09:48:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-09T07:02:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/01\/Cheat-Sheet.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=\"author\" content=\"TestPrepTraining\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"TestPrepTraining\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/blog\/da-100-analyzing-data-with-microsoft-power-bi-cheat-sheet\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/blog\/da-100-analyzing-data-with-microsoft-power-bi-cheat-sheet\/\",\"name\":\"DA-100: Analyzing Data with Microsoft Power BI Cheat Sheet - Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/blog\/#website\"},\"datePublished\":\"2021-01-14T09:48:38+00:00\",\"dateModified\":\"2023-10-09T07:02:11+00:00\",\"author\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/blog\/#\/schema\/person\/b46daaf932dbfb07cbe7db807006780c\"},\"description\":\"Start preparing with advanced learning resources and free practice tests with DA-100: Analyzing Data with Microsoft Power BI\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/blog\/da-100-analyzing-data-with-microsoft-power-bi-cheat-sheet\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/blog\/da-100-analyzing-data-with-microsoft-power-bi-cheat-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/blog\/da-100-analyzing-data-with-microsoft-power-bi-cheat-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DA-100: Analyzing Data with Microsoft Power BI Cheat Sheet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/blog\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/blog\/\",\"name\":\"Learning Resources\",\"description\":\"Testprep Training Blogs\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.testpreptraining.ai\/blog\/#\/schema\/person\/b46daaf932dbfb07cbe7db807006780c\",\"name\":\"TestPrepTraining\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4cd4f7acc79865d9ba457114e386c039833599aae3707598a92eda256c6a5278?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4cd4f7acc79865d9ba457114e386c039833599aae3707598a92eda256c6a5278?s=96&d=mm&r=g\",\"caption\":\"TestPrepTraining\"},\"description\":\"Testprep Training offers a wide range of practice exams and online courses for Professional certification exam curated by field experts and working professionals. Evaluate your skills and build confidence to appear for the exam.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DA-100: Analyzing Data with Microsoft Power BI Cheat Sheet - Blog","description":"Start preparing with advanced learning resources and free practice tests with DA-100: Analyzing Data with Microsoft Power BI","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\/blog\/da-100-analyzing-data-with-microsoft-power-bi-cheat-sheet\/","og_locale":"en_US","og_type":"article","og_title":"DA-100: Analyzing Data with Microsoft Power BI Cheat Sheet - Blog","og_description":"Start preparing with advanced learning resources and free practice tests with DA-100: Analyzing Data with Microsoft Power BI","og_url":"https:\/\/www.testpreptraining.ai\/blog\/da-100-analyzing-data-with-microsoft-power-bi-cheat-sheet\/","og_site_name":"Blog","article_published_time":"2021-01-14T09:48:38+00:00","article_modified_time":"2023-10-09T07:02:11+00:00","og_image":[{"width":750,"height":400,"url":"https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/01\/Cheat-Sheet.png","type":"image\/png"}],"author":"TestPrepTraining","twitter_card":"summary_large_image","twitter_misc":{"Written by":"TestPrepTraining","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/blog\/da-100-analyzing-data-with-microsoft-power-bi-cheat-sheet\/","url":"https:\/\/www.testpreptraining.ai\/blog\/da-100-analyzing-data-with-microsoft-power-bi-cheat-sheet\/","name":"DA-100: Analyzing Data with Microsoft Power BI Cheat Sheet - Blog","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/blog\/#website"},"datePublished":"2021-01-14T09:48:38+00:00","dateModified":"2023-10-09T07:02:11+00:00","author":{"@id":"https:\/\/www.testpreptraining.ai\/blog\/#\/schema\/person\/b46daaf932dbfb07cbe7db807006780c"},"description":"Start preparing with advanced learning resources and free practice tests with DA-100: Analyzing Data with Microsoft Power BI","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/blog\/da-100-analyzing-data-with-microsoft-power-bi-cheat-sheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/blog\/da-100-analyzing-data-with-microsoft-power-bi-cheat-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/blog\/da-100-analyzing-data-with-microsoft-power-bi-cheat-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/blog\/"},{"@type":"ListItem","position":2,"name":"DA-100: Analyzing Data with Microsoft Power BI Cheat Sheet"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/blog\/#website","url":"https:\/\/www.testpreptraining.ai\/blog\/","name":"Learning Resources","description":"Testprep Training Blogs","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.testpreptraining.ai\/blog\/#\/schema\/person\/b46daaf932dbfb07cbe7db807006780c","name":"TestPrepTraining","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4cd4f7acc79865d9ba457114e386c039833599aae3707598a92eda256c6a5278?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cd4f7acc79865d9ba457114e386c039833599aae3707598a92eda256c6a5278?s=96&d=mm&r=g","caption":"TestPrepTraining"},"description":"Testprep Training offers a wide range of practice exams and online courses for Professional certification exam curated by field experts and working professionals. Evaluate your skills and build confidence to appear for the exam."}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/posts\/11767","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/comments?post=11767"}],"version-history":[{"count":12,"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/posts\/11767\/revisions"}],"predecessor-version":[{"id":33737,"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/posts\/11767\/revisions\/33737"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/media\/11775"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/media?parent=11767"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/categories?post=11767"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/tags?post=11767"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}