{"id":34400,"date":"2021-01-30T09:32:57","date_gmt":"2021-01-30T09:32:57","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=34400"},"modified":"2021-01-30T10:29:28","modified_gmt":"2021-01-30T10:29:28","slug":"learn-to-create-and-manage-aggregations","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/learn-to-create-and-manage-aggregations\/","title":{"rendered":"Learn to Create and Manage Aggregations"},"content":{"rendered":"\n<p>The purpose of <em>Aggregations<\/em>&nbsp;in Power BI is to help you reduce table sizes so that you can concentrate on important data and improve query performance. Moreover, aggregations allow interactive analysis than big data in ways that are not possible otherwise, and also can immensely reduce the cost of unlocking large datasets for decision making. We shall learn to create and manage aggregrations. <\/p>\n\n\n\n<p><strong>Benefits of using aggregations <\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, using aggregation lead to Better query performance over big data. Also, every interaction with Power BI visuals submits DAX queries to the dataset. Therefore, cached aggregated data utilizes a fraction of the resources required for detail data, for you can unlock big data that could not be accessed.<\/li><li>Secondly, it helps optimize the data refresh. Moreover smaller cache sizes reduce refresh times, so data gets to users quicker.<\/li><li>Lastly, it helps in building balanced architectures. Remember, the Power BI in-memory cache handles aggregated queries, thereby limiting queries sent in DirectQuery mode and assisting you to meet concurrency limits. Thereby, the remaining detail-level queries are to be filtered, transactional-level queries, which data warehouses and big-data systems generally handle well.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/media\/desktop-aggregations\/aggregations_07.jpg\" alt=\"Aggregations in Microsoft Power BI Desktop\"\/><figcaption>Source: Microsoft<\/figcaption><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"create-an-aggregated-table\"><strong>Steps to create an aggregated table<\/strong><\/h4>\n\n\n\n<p>Use the following steps to create an aggregated table:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, set up a new table with the fields you want, depending on your data source and model.<\/li><li>Secondly, define the aggregations by using the&nbsp;<strong>Manage aggregations<\/strong>&nbsp;dialog.<\/li><li>Then, if applicable, change the&nbsp;storage mode&nbsp;for the aggregated table.<\/li><\/ul>\n\n\n\n<p>How to manage aggregrations?<\/p>\n\n\n\n<p>Once you have created the new table that has the required fields, then in the&nbsp;<strong>Fields<\/strong>&nbsp;pane of any Power BI Desktop view, right-click the table, and choose <strong>Manage aggregations<\/strong>.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/media\/desktop-aggregations\/aggregations-06.png\" alt=\"Select Manage aggregations\"\/><figcaption>Source: Microsoft<\/figcaption><\/figure><\/div>\n\n\n\n<p>Also, the&nbsp;<strong>Manage aggregations<\/strong>&nbsp;dialog shows a row for each column in the table, wherein you can specify the aggregation behavior. Further, the&nbsp;<strong>Summarization<\/strong>&nbsp;drop-down in the&nbsp;<strong>Manage aggregations<\/strong>&nbsp;dialog offers the following values:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Count<\/li><li>GroupBy<\/li><li>Max<\/li><li>Min<\/li><li>Sum<\/li><li>Count table rows<\/li><\/ul>\n\n\n\n<p>For more visit: <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/desktop-aggregations\" target=\"_blank\" rel=\"noreferrer noopener\">Use aggregation in Power BI Desktop<\/a><\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.testpreptraining.ai\/analyzing-data-with-microsoft-power-bi-da-100-free-test\"><img decoding=\"async\" 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\"\/><\/a><\/figure><\/div>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The purpose of Aggregations&nbsp;in Power BI is to help you reduce table sizes so that you can concentrate on important data and improve query performance. Moreover, aggregations allow interactive analysis than big data in ways that are not possible otherwise, and also can immensely reduce the cost of unlocking large datasets for decision making. We&#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,4309,3955,3954],"class_list":["post-34400","page","type-page","status-publish","hentry","category-microsoft-azure","tag-da-100-study-guide","tag-manage-aggregations","tag-microsoft-exam-da-100-exam-questions","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>Learn to Create and Manage Aggregations - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Learn to create and manage aggregations with latets and updated practice test. Start preparaing for Microosft 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\/learn-to-create-and-manage-aggregations\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Learn to Create and Manage Aggregations - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Learn to create and manage aggregations with latets and updated practice test. Start preparaing for Microosft Exam DA-100 Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/learn-to-create-and-manage-aggregations\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-30T10:29:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/media\/desktop-aggregations\/aggregations_07.jpg\" \/>\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\/learn-to-create-and-manage-aggregations\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/learn-to-create-and-manage-aggregations\/\",\"name\":\"Learn to Create and Manage Aggregations - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2021-01-30T09:32:57+00:00\",\"dateModified\":\"2021-01-30T10:29:28+00:00\",\"description\":\"Learn to create and manage aggregations with latets and updated practice test. Start preparaing for Microosft Exam DA-100 Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/learn-to-create-and-manage-aggregations\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/learn-to-create-and-manage-aggregations\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/learn-to-create-and-manage-aggregations\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Learn to Create and Manage Aggregations\"}]},{\"@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":"Learn to Create and Manage Aggregations - Testprep Training Tutorials","description":"Learn to create and manage aggregations with latets and updated practice test. Start preparaing for Microosft 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\/learn-to-create-and-manage-aggregations\/","og_locale":"en_US","og_type":"article","og_title":"Learn to Create and Manage Aggregations - Testprep Training Tutorials","og_description":"Learn to create and manage aggregations with latets and updated practice test. Start preparaing for Microosft Exam DA-100 Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/learn-to-create-and-manage-aggregations\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2021-01-30T10:29:28+00:00","og_image":[{"url":"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/media\/desktop-aggregations\/aggregations_07.jpg"}],"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\/learn-to-create-and-manage-aggregations\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/learn-to-create-and-manage-aggregations\/","name":"Learn to Create and Manage Aggregations - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2021-01-30T09:32:57+00:00","dateModified":"2021-01-30T10:29:28+00:00","description":"Learn to create and manage aggregations with latets and updated practice test. Start preparaing for Microosft Exam DA-100 Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/learn-to-create-and-manage-aggregations\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/learn-to-create-and-manage-aggregations\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/learn-to-create-and-manage-aggregations\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Learn to Create and Manage Aggregations"}]},{"@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\/34400","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=34400"}],"version-history":[{"count":4,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/34400\/revisions"}],"predecessor-version":[{"id":34410,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/34400\/revisions\/34410"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=34400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=34400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=34400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}