{"id":32381,"date":"2021-01-16T12:01:54","date_gmt":"2021-01-16T12:01:54","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=32381"},"modified":"2021-01-16T12:01:55","modified_gmt":"2021-01-16T12:01:55","slug":"identify-column-headers-and-names","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/identify-column-headers-and-names\/","title":{"rendered":"Identify Column Headers and Names"},"content":{"rendered":"\n<p>Indeed, the first\u00a0step in shaping\u00a0your\u00a0initial data\u00a0involves identifying the column headers and names within the\u00a0data. Thereafter, you should evaluate where they are located to make sure they are placed correctly. Let us suppose the source data\u00a0in the given below csv file for SalesTarget had a target categorized according to products and a subcategory split by months, both of which are organized into columns.\u00a0<\/p>\n\n\n\n<figure class=\"wp-block-image is-style-default\"><img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/clean-data-power-bi\/media\/02-identify-headers-names-ssm.png\" alt=\"Identify column headers and names\"\/><figcaption>Source: Microsoft<\/figcaption><\/figure>\n\n\n\n<p>However, you may observe the data is\u00a0difficult to read. Since, the data in its current state has column headers placed in different rows\u00a0(marked in red),\u00a0and\u00a0several columns\u00a0have\u00a0undescriptive\u00a0names,\u00a0such as\u00a0<strong>Column1<\/strong>,\u00a0<strong>Column2<\/strong>,\u00a0and more. Thus, after identifying where the column headers and names are\u00a0located, you can make changes to\u00a0reorganize the data.\u00a0<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Steps to promote column header<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly,  when you create a table in Power BI\u00a0Desktop, Power\u00a0Query\u00a0Editor\u00a0assumes that\u00a0all\u00a0data belongs in table rows. <\/li><li>However, a data source might have a first row that contains column names<\/li><li>Next, to correct this inaccuracy, you need to promote the first table row\u00a0into column headers.<\/li><li>Lastly, we can promote\u00a0headers\u00a0by selecting the\u00a0<strong>Use First Row as Headers<\/strong>\u00a0option on the\u00a0<strong>Home<\/strong>\u00a0tab. \u00a0Else, by selecting the drop-down button next to\u00a0<strong>Column1<\/strong>\u00a0and then selecting\u00a0<strong>Use First Row as Headers<\/strong>.\u00a0<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"renamecolumns\"><strong>Steps to rename\u00a0columns\u00a0<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>The first step in shaping your data is to\u00a0examine the\u00a0column\u00a0headers. <\/li><li>There can be cases when you find one or more columns have\u00a0the wrong headers,\u00a0or a header with a spelling error or\u00a0the\u00a0header\u00a0naming convention is not consistent or user-friendly.\u00a0<\/li><li>Now, with the\u00a0<strong>Use First Row as Headers<\/strong>\u00a0feature in the illustration. <\/li><li>Here, the column\u00a0that contains\u00a0the subcategory\u00a0<strong>Name<\/strong>\u00a0data\u00a0now\u00a0has\u00a0<strong>Month<\/strong>\u00a0as\u00a0its\u00a0column header. <\/li><li>Since this\u00a0column header\u00a0is incorrect,\u00a0so\u00a0it needs to be renamed.\u00a0<\/li><li>We can rename\u00a0column headers\u00a0by right-clicking\u00a0the header, select\u00a0<strong>Rename<\/strong>, edit\u00a0the\u00a0name,\u00a0and\u00a0then\u00a0press\u00a0<strong>Enter<\/strong>.\u00a0<\/li><li>Else, you can\u202fdouble-click the column header and\u00a0overwrite the name with the\u00a0correct name.\u00a0<\/li><li>Lastly, we can also\u00a0work around this issue by\u00a0removing (skipping)\u00a0the\u00a0first\u00a0two rows and\u00a0then renaming\u00a0the columns to the\u00a0correct\u00a0name.\u00a0<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><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>\n","protected":false},"excerpt":{"rendered":"<p>Indeed, the first\u00a0step in shaping\u00a0your\u00a0initial data\u00a0involves identifying the column headers and names within the\u00a0data. Thereafter, you should evaluate where they are located to make sure they are placed correctly. Let us suppose the source data\u00a0in the given below csv file for SalesTarget had a target categorized according to products and a subcategory split by months,&#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":[1830,3954],"class_list":["post-32381","page","type-page","status-publish","hentry","category-microsoft-azure","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>Identify Column Headers and Names - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Learn to identify column headers and names with an online tutorial and free practice test. Start preparing for Microsoft Exam DA-100 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\/identify-column-headers-and-names\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Identify Column Headers and Names - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Learn to identify column headers and names with an online tutorial and free practice test. Start preparing for Microsoft Exam DA-100 Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/identify-column-headers-and-names\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-16T12:01:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/clean-data-power-bi\/media\/02-identify-headers-names-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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/identify-column-headers-and-names\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/identify-column-headers-and-names\/\",\"name\":\"Identify Column Headers and Names - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2021-01-16T12:01:54+00:00\",\"dateModified\":\"2021-01-16T12:01:55+00:00\",\"description\":\"Learn to identify column headers and names with an online tutorial and free practice test. Start preparing for Microsoft Exam DA-100 Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/identify-column-headers-and-names\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/identify-column-headers-and-names\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/identify-column-headers-and-names\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Identify Column Headers and Names\"}]},{\"@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":"Identify Column Headers and Names - Testprep Training Tutorials","description":"Learn to identify column headers and names with an online tutorial and free practice test. Start preparing for Microsoft Exam DA-100 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\/identify-column-headers-and-names\/","og_locale":"en_US","og_type":"article","og_title":"Identify Column Headers and Names - Testprep Training Tutorials","og_description":"Learn to identify column headers and names with an online tutorial and free practice test. Start preparing for Microsoft Exam DA-100 Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/identify-column-headers-and-names\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2021-01-16T12:01:55+00:00","og_image":[{"url":"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/clean-data-power-bi\/media\/02-identify-headers-names-ssm.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/identify-column-headers-and-names\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/identify-column-headers-and-names\/","name":"Identify Column Headers and Names - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2021-01-16T12:01:54+00:00","dateModified":"2021-01-16T12:01:55+00:00","description":"Learn to identify column headers and names with an online tutorial and free practice test. Start preparing for Microsoft Exam DA-100 Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/identify-column-headers-and-names\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/identify-column-headers-and-names\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/identify-column-headers-and-names\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Identify Column Headers and Names"}]},{"@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\/32381","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=32381"}],"version-history":[{"count":2,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/32381\/revisions"}],"predecessor-version":[{"id":32427,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/32381\/revisions\/32427"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=32381"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=32381"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=32381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}