{"id":32198,"date":"2021-01-15T11:37:43","date_gmt":"2021-01-15T11:37:43","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=32198"},"modified":"2021-01-15T11:39:48","modified_gmt":"2021-01-15T11:39:48","slug":"analyze-data-structures","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/analyze-data-structures\/","title":{"rendered":"Analyze Data Structures"},"content":{"rendered":"\n<p>In general,&nbsp;the&nbsp;data&nbsp;holds&nbsp;its predefined&nbsp;table and column names, when&nbsp;we import data&nbsp;from multiple sources&nbsp;into Power BI Desktop. Indeed, you may wish to change&nbsp;these names for maintaining the consistent format&nbsp;and create meaningful data structures for a user.&nbsp;Moreover, you can use&nbsp;Power Query Editor in Power BI Desktop for making name changes and simplifying the data structure.&nbsp;<\/p>\n\n\n\n<p>Let us suppose the columns have been already renamed, and you are required to examine the names of the queries (tables) to determine if any improvements can be made. Further, you may need to&nbsp;review the contents of the columns&nbsp;and replace&nbsp;any&nbsp;values&nbsp;that require correction.&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"alignright is-resized\"><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/clean-data-power-bi\/media\/03-rename-query-ssm.png#lightbox\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/clean-data-power-bi\/media\/03-rename-query-ssm.png\" alt=\"Rename a query\" width=\"197\" height=\"256\"\/><\/a><figcaption>Source: Microsoft<\/figcaption><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"renamea-query\"><strong>How to rename&nbsp;a query?<\/strong><\/h4>\n\n\n\n<p>Changing uncommon or unrelatable query names to more specific and familiar names is a good practice for a user.&nbsp;Example, while importing a product fact table&nbsp;into Power BI Desktop with query name as&nbsp;<em>FactProductTable<\/em>, is not clear so you may change it to a simpler name, as&nbsp;<em>Products<\/em>. <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, in&nbsp;Power Query Editor, in&nbsp;the&nbsp;<strong>Queries<\/strong>&nbsp;pane&nbsp;to the left of your data, select the&nbsp;query&nbsp;that you want to rename. <\/li><li>In the second step, right-click&nbsp;the query&nbsp;and select&nbsp;<strong>Rename<\/strong>.&nbsp;<\/li><li>Then, edit the current name or type&nbsp;a&nbsp;new name,&nbsp;and&nbsp;then&nbsp;press&nbsp;<strong>Enter<\/strong>.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"replace-values\"><strong>How to replace values?<\/strong><\/h4>\n\n\n\n<p>In Power Query Editor, you must use the&nbsp;<strong>Replace Values<\/strong>&nbsp;feature&nbsp;to replace any value with another value in a selected column.&nbsp;<\/p>\n\n\n\n<p>Steps to replace values &#8211; <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, in the&nbsp;<strong>Value to Find<\/strong>&nbsp;box, enter the&nbsp;name of the&nbsp;value&nbsp;that you want to replace<\/li><li>Then&nbsp;in the&nbsp;<strong>Replace With<\/strong>&nbsp;box, enter the correct value name&nbsp;and&nbsp;then&nbsp;select&nbsp;<strong>OK<\/strong>.&nbsp; Note, in Power Query, we cannot select one cell and change one value, as performed in Excel.<\/li><li>Now, you can review the list of steps that you took to restructure and correct your data&nbsp;in the&nbsp;<strong>Query Settings<\/strong>&nbsp;pane.&nbsp;<\/li><li>Next, when&nbsp;you have completed&nbsp;all steps&nbsp;that you want to take,&nbsp;you can select&nbsp;<strong>Close&nbsp;&amp; Apply<\/strong>&nbsp;to close&nbsp;Power&nbsp;Query Editor and apply your changes to your data model.&nbsp;<\/li><li>Though, you can take further&nbsp;action&nbsp;to clean and transform your data.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter is-resized\"><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/clean-data-power-bi\/media\/03-value-find-ssm.png#lightbox\"><img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/clean-data-power-bi\/media\/03-value-find-ssm.png\" alt=\"replace\u00a0one value with another in the value to find box\" width=\"-64\" height=\"-27\"\/><\/a><figcaption>Source: Microsoft<\/figcaption><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"replacenull-values\"><strong>How to replace&nbsp;null values?<\/strong><\/h4>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"alignright is-resized\"><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/clean-data-power-bi\/media\/03-replace-null-zero-ss.png#lightbox\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/clean-data-power-bi\/media\/03-replace-null-zero-ss.png\" alt=\"Replace null value with zero\" width=\"405\" height=\"152\"\/><\/a><figcaption>Source: Microsoft<\/figcaption><\/figure><\/div>\n\n\n\n<p>There are cases when you might find that your&nbsp;data sources&nbsp;contain null values. For&nbsp;instance, a&nbsp;product export amount on a&nbsp;purchase order&nbsp;may have a null value&nbsp;considering it&#8217;s synonymous with zero. So, if the value stays null, the averages will not calculate&nbsp;correctly.&nbsp;Therefore, it is suggested to change the nulls to zero, which will produce a more accurate&nbsp;export average. In the same vein, using the same steps used earlier will help you replace the null values with zero (&#8216;0&#8217;).&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"remove-duplicates\"><strong>How to remove duplicates?<\/strong>&nbsp;<\/h4>\n\n\n\n<p>We can remove duplicates from columns to only keep unique names in a selected column by using the&nbsp;<strong>Remove Duplicates<\/strong>&nbsp;feature in Power Query.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, select the column<\/li><li>Then, right-click on the header of the column<\/li><li>Select the&nbsp;<strong>Remove Duplicates<\/strong>&nbsp;option.&nbsp;<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"best-practices-for-naming-tables-columns-and-values\"><strong>Best Naming Practices <\/strong><\/h4>\n\n\n\n<p>Indeed there are no fixed rules or specific naming conventions for tables, columns, and values have no fixed rules, yet some of the suggested practices are &#8211; <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, use the language and abbreviations that are commonly used within your organization as common terminology.&nbsp;<\/li><li>Secondly, it is suggested to give tables, columns, and measures descriptive business terms and replace underscores (&#8220;_&#8221;) with spaces. <\/li><li>Thirdly, you should be consistent with abbreviations, prefaces, and words like &#8220;number&#8221; and &#8220;ID.&#8221; <\/li><li>Then avoid using too many short abbreviations as they may cause confusion within your organization.&nbsp;<\/li><li>Also, remove prefixes or suffixes used in table names <\/li><li>When replacing values, values that are too long might be difficult to read and fit on a visual. Values that are too short might be difficult to interpret. <\/li><li>Lastly, you should avoid using acronyms in values, given that the text will fit on the visual.<\/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>In general,&nbsp;the&nbsp;data&nbsp;holds&nbsp;its predefined&nbsp;table and column names, when&nbsp;we import data&nbsp;from multiple sources&nbsp;into Power BI Desktop. Indeed, you may wish to change&nbsp;these names for maintaining the consistent format&nbsp;and create meaningful data structures for a user.&nbsp;Moreover, you can use&nbsp;Power Query Editor in Power BI Desktop for making name changes and simplifying the data structure.&nbsp; Let us suppose the&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[174],"tags":[4021,1830,3954],"class_list":["post-32198","page","type-page","status-publish","hentry","category-microsoft-azure","tag-analyze-data-structures","tag-da-100-study-guide","tag-microsoft-exam-da-100-free-practice-test"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Analyze Data Structures - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Upgrade your skills with latest and updated practice test. Start preparing for Microsoft Exam DA-100 and learn about Data Structures Now!\" \/>\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\/analyze-data-structures\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Analyze Data Structures - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Upgrade your skills with latest and updated practice test. Start preparing for Microsoft Exam DA-100 and learn about Data Structures Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/analyze-data-structures\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-15T11:39:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/clean-data-power-bi\/media\/03-rename-query-ssm.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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/analyze-data-structures\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/analyze-data-structures\/\",\"name\":\"Analyze Data Structures - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2021-01-15T11:37:43+00:00\",\"dateModified\":\"2021-01-15T11:39:48+00:00\",\"description\":\"Upgrade your skills with latest and updated practice test. Start preparing for Microsoft Exam DA-100 and learn about Data Structures Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/analyze-data-structures\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/analyze-data-structures\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/analyze-data-structures\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Analyze Data Structures\"}]},{\"@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":"Analyze Data Structures - Testprep Training Tutorials","description":"Upgrade your skills with latest and updated practice test. Start preparing for Microsoft Exam DA-100 and learn about Data Structures Now!","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\/analyze-data-structures\/","og_locale":"en_US","og_type":"article","og_title":"Analyze Data Structures - Testprep Training Tutorials","og_description":"Upgrade your skills with latest and updated practice test. Start preparing for Microsoft Exam DA-100 and learn about Data Structures Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/analyze-data-structures\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2021-01-15T11:39:48+00:00","og_image":[{"url":"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/clean-data-power-bi\/media\/03-rename-query-ssm.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/analyze-data-structures\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/analyze-data-structures\/","name":"Analyze Data Structures - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2021-01-15T11:37:43+00:00","dateModified":"2021-01-15T11:39:48+00:00","description":"Upgrade your skills with latest and updated practice test. Start preparing for Microsoft Exam DA-100 and learn about Data Structures Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/analyze-data-structures\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/analyze-data-structures\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/analyze-data-structures\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Analyze Data Structures"}]},{"@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\/32198","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=32198"}],"version-history":[{"count":6,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/32198\/revisions"}],"predecessor-version":[{"id":32212,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/32198\/revisions\/32212"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=32198"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=32198"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=32198"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}