--- title: How To Learn Advanced Data Warehouse Concepts by Using Aggregates description: Learn data warehouse concepts using our Modeling SAP BW Aggregates guide and use our advanced data modeling guides to build high performance models image: https://www.sapbwconsulting.com/hs-fs/file-16536840-png/images/aggregates_screen_shot-resized-161.png --- ![Data Warehouse Concepts](https://www.sapbwconsulting.com/hs-fs/file-16536840-png/images/aggregates_screen_shot-resized-161.png) # How To Learn Advanced Data Warehouse Concepts by Using Aggregates Table of Contents ## Learn Advanced Data Modeling Concepts Are you, like so many [SAP BW users](https://www.sapbwconsulting.com/blog/understanding-the-most-common-sap-data-warehousing-concepts), suffering from sluggish performance?  Don't really have a big budget for a [SAP HANA upgrade](https://www.sapbwconsulting.com/sap-bw-3.x-to-7.x-upgrade-service-productized-approach-proprietary-methodolgy) yet or even SAP BIW Accelerator?  Don't feel unique!   The majority of SAP BW users are still on an older version of [SAP BW](https://www.sapbwconsulting.com/request-sap-bw-naming-conventions-review), usually 3.X or even earlier according to a recent ASUG survey!  As the experts on [SAP Business Warehouse](https://www.sapbwconsulting.com/understanding-sap-bw-in-5-minutes), we have found that one very typical problem is a poorly designed data model. [![Get the advanced SAP Business Warehouse Guide to Modeling Aggregates](https://no-cache.hubspot.com/cta/default/118735/d6b39a79-f0c3-45cc-9e06-3561b39cebbe.png)](https://cta-redirect.hubspot.com/cta/redirect/118735/d6b39a79-f0c3-45cc-9e06-3561b39cebbe) Therefore, we have spent a lot of time preparing a series of guides based on [SAP Best Practices](https://www.sapbwconsulting.com/blog/how-to-select-the-best-sap-best-practice-solutions) and our own experience as IT Consultants to help you build better, more robust SAP BW Data Modeling guides.  ## Learn More About SAP BW Aggregates   In our latest guide, [Modeling Aggregates](https://www.sapbwconsulting.com/learn-to-model-SAP-BW-Aggregates/), you will find all you need to know to:   ![SAP BW Aggregates](https://www.sapbwconsulting.com/hs-fs/file-16536840-png/images/aggregates_screen_shot-resized-161.png?width=556&height=321&name=aggregates_screen_shot-resized-161.png)   - Define the Need for **Aggregates**. - Understand what an Aggregate is. - Learn how Aggregates can **enhance system perform**. - Learn how to use Aggregates to **supercharge SAP reporting performance**. - Learn why other **performance management techniques** are also required to fully [exploit aggregate](https://www.sapbwconsulting.com/inbound-marketing/learning-seo-from-the-experts)s. - Understand the impact of **data granularity** on your performance. - When and how to **partition a table for aggregate performance**. - Learn which **table spaces** need to be maintained. - Learn when to use **automated aggregate creation tools** and when to do it manually and some rules of thumb to figure it out. - How to **choose the dimensions** for your aggregates. - Choosing the **fact** you want to measure and include in the aggregate. - Know **what you cannot do** with an aggregate.   ## This is One of Many Advanced Data Modeling Concepts   As you can see, there are a lot of issues to keep in mind when modeling aggregates.  You may find that our **[other SAP BW modeling guides](https://www.sapbwconsulting.com/resources/SAP-Data-Modeling/)** are also required to fully understand and build a high performance data model.  If you are an old hand at **Entity Relationship Modeling**, you will especially appreciate knowing the difference between **ERD** and **Star Schemas**, which is not always easy.  Finally, we would like to recommend, as part of increasing your understanding of data warehouse concepts, the criticality of proper **[naming conventions](https://www.sapbwconsulting.com/request-sap-bw-naming-convention-review/)**, which we have found can make or break a project.   Of course, we recommend you grab a copy of SAP BW Aggregates Data Modeling eBook by clicking the button.  [![Get the SAP BW Aggregates Data Modeling Guide](https://no-cache.hubspot.com/cta/default/118735/479f6fee-53b3-42e1-8bb9-a9f8532ac416.png)](https://cta-redirect.hubspot.com/cta/redirect/118735/479f6fee-53b3-42e1-8bb9-a9f8532ac416)     **People who read this also read:** - [Discover How to Model SAP BI Integrated Planning Scenarios](https://www.sapbwconsulting.com/blog/discover-how-to-model-sap-bi-integrated-planning-scenarios) - [5 Lessons Learned In SAP BW Data Modeling](https://www.sapbwconsulting.com/blog/5-lessons-learned-in-sap-bw-data-modeling) - [Get SAP BW Data Modeling Guide Part 1](https://www.sapbwconsulting.com/get-sap-bw-data-modeling-guide-part-I) - [Infocube Dimensional Modeling](https://www.sapbwconsulting.com/resources/infocube-dimensional-modeling) - [Get SAP BW Data Modeling Key Figures Guide](https://www.sapbwconsulting.com/get-sap-bw-data-modeling-key-figures-guide) - 1 Key Tip [When Upgrading](https://www.sapbwconsulting.com/blog/1-key-tip-when-upgrading-from-sap-bw-3-x-to-bw-7-x) from SAP BW 3.X to BW 7.X [Checklist] - Understanding [Embedded Systems](https://www.sapbwconsulting.com/blog/understanding-embedded-systems-vs-sap-hana) vs SAP HANA - 8 Secrets to SAP Enabled [Spend Performance](https://www.sapbwconsulting.com/blog/8-secrets-to-sap-enabled-spend-performance-management) Management   Thanks Topics from this blog: [Aggregates](https://www.sapbwconsulting.com/blog/topic/aggregates) [Best Practices](https://www.sapbwconsulting.com/blog/topic/best-practices) [BW](https://www.sapbwconsulting.com/blog/topic/bw) [How-To](https://www.sapbwconsulting.com/blog/topic/how-to) [HANA](https://www.sapbwconsulting.com/blog/topic/hana) [Naming Conventions](https://www.sapbwconsulting.com/blog/topic/naming-conventions) [Data Modeling](https://www.sapbwconsulting.com/blog/topic/data-modeling) ### Download SAP BW Mindmap Learn what SAP Business Warehouse is and what it does in under five minutes [![Get this Mindmap](https://no-cache.hubspot.com/cta/default/118735/8db2ad37-8211-47a3-86ae-09b6b2bb297b.png)](https://cta-redirect.hubspot.com/cta/redirect/118735/8db2ad37-8211-47a3-86ae-09b6b2bb297b) [mailto:someone@yoursite.com](mailto:someone@yoursite.com) ### Lonnie D. Ayers, PMP About the Author: Lonnie Ayers is a Hubspot Certified Inbound Marketing consultant, with additional certifications in Hubspot Content Optimization, Hubspot Contextual Marketing, and is a Hubspot Certified Partner. Specialized in demand generation and sales execution, especially in the SAP, Oracle and Microsoft Partner space, he has unique insight into the tough challenges Service Providers face with generating leads and closing sales using the latest digital tools. With 15 years of SAP Program Management experience, and dozens of complex sales engagements under his belt, he helps partners develop and communicate their unique sales proposition. Frequently sought as a public speaker in various events, he is available for both inhouse engagements and ** remote coaching. ** ![Balanced Scorecard Consultant](https://www.sapbwconsulting.com/hubfs/social-suggested-images/Balanced%20Scorecard%20Certified%20Graduate.jpg) He also recently released a book **"How to Dominate Any Market - Turbocharging Your Digital Marketing and Sales Results",** which is available on [ Amazon.](https://www.amazon.com/Dominate-Turbocharging-Digital-Marketing-Results/dp/1728357950/ref=sr_1_1?dchild=1&qid=1589182458&refinements=p_27%3ALonnie+D.+Ayers&s=books&sr=1-1&text=Lonnie+D.+Ayers)**** [View All Articles by Lonnie D. Ayers, PMP](https://www.sapbwconsulting.com/blog/author/lonnie-d-ayers-pmp) ## The SAP Blog Subscribe to our blog and receive SAP BW Updates, demand generation, inbound marketing, sales enablement, technology and revenue generation insights and ideas delivered right to your email. [mailto:someone@yoursite.com](mailto:someone@yoursite.com) ![SAP](https://googleads.g.doubleclick.net/pagead/viewthroughconversion/960101754/?value=0&guid=ON&script=0) ![](https://www.facebook.com/tr?id=199270410761059&ev=PageView&noscript=1) ```json { "@context" : "https://schema.org", "@id" : "https://www.sapbwconsulting.com/blog/how-to-learn-advanced-data-warehouse-concepts-by-using-aggregates#blogposting", "@type" : "BlogPosting", "about" : [ { "@type" : "Thing", "name" : "Learn", "sameAs" : "https://en.wikipedia.org/wiki/Learning" }, { "@type" : "Thing", "name" : "data warehouse", "sameAs" : "https://en.wikipedia.org/wiki/Data_warehouse" }, { "@type" : "Thing", "name" : "Modeling", "sameAs" : "https://en.wikipedia.org/wiki/Data_modeling" }, { "@type" : "Organization", "name" : "SAP", "sameAs" : "https://en.wikipedia.org/wiki/SAP_AG" }, { "@type" : "Thing", "name" : "guide", "sameAs" : "https://en.wikipedia.org/wiki/Tutorial" }, { "@type" : "Thing", "name" : "performance models", "sameAs" : "https://en.wikipedia.org/wiki/Performance" }, { "@type" : "Thing", "name" : "Aggregate", "sameAs" : "https://en.wikipedia.org/wiki/Data_aggregation" }, { "@type" : "Thing", "name" : "data", "sameAs" : "https://en.wikipedia.org/wiki/Data" }, { "@type" : "Thing", "name" : "Model", "sameAs" : "https://en.wikipedia.org/wiki/Data_model" }, { "@type" : "Thing", "name" : "Warehouse", "sameAs" : "https://en.wikipedia.org/wiki/Warehouse" }, { "@type" : "Thing", "name" : "concept", "sameAs" : "https://en.wikipedia.org/wiki/Concept" } ], "author" : { "@id" : "https://www.sapbwconsulting.com/about-lonnie-ayers#person" }, "description" : "How to Learn Advanced Data Warehouse Concepts by Using Aggregates", "headline" : "How to Learn Advanced Data Warehouse Concepts by Using Aggregates", "inLanguage" : "en", "mainEntityOfPage" : { "@id" : "https://www.sapbwconsulting.com/blog/how-to-learn-advanced-data-warehouse-concepts-by-using-aggregates#webpage" }, "mentions" : [ { "@type" : "Thing", "name" : "suffering", "sameAs" : "https://en.wikipedia.org/wiki/Suffering" }, { "@type" : "Thing", "name" : "budget", "sameAs" : "https://en.wikipedia.org/wiki/Budget" }, { "@type" : "Thing", "name" : "Accelerator", "sameAs" : "https://en.wikipedia.org/wiki/Accelerometer" }, { "@type" : "Thing", "name" : "Practices", "sameAs" : "https://en.wikipedia.org/wiki/Best_practice" }, { "@type" : "Thing", "name" : "experience", "sameAs" : "https://en.wikipedia.org/wiki/Experience" }, { "@type" : "Thing", "name" : "IT Consultants", "sameAs" : "https://en.wikipedia.org/wiki/Information_technology_consulting" }, { "@type" : "Thing", "name" : "performance management", "sameAs" : "https://en.wikipedia.org/wiki/Performance_management" } ], "name" : "How to Learn Advanced Data Warehouse Concepts by Using Aggregates", "potentialAction" : { "@type" : "ViewAction", "name" : "Request SAP BW Consulting Support", "target" : { "@type" : "EntryPoint", "actionPlatform" : [ "http://schema.org/DesktopWebPlatform", "http://schema.org/MobileWebPlatform" ], "inLanguage" : "en", "urlTemplate" : "https://www.sapbwconsulting.com/SAP-BW-Consulting-Support" } }, "publisher" : { "@id" : "https://www.sapbwconsulting.com#organization" }, "url" : "https://www.sapbwconsulting.com/blog/how-to-learn-advanced-data-warehouse-concepts-by-using-aggregates" } ``` ```json { "@context" : "https://schema.org", "@id" : "https://www.sapbwconsulting.com#website", "@type" : "WebSite", "name" : "SAP BW Consulting, Inc.", "publisher" : { "@id" : "https://www.sapbwconsulting.com#organization" }, "url" : "https://www.sapbwconsulting.com" } ``` ```json { "@context" : "https://schema.org", "@id" : "https://www.sapbwconsulting.com#organization", "@type" : "Organization", "logo" : { "@id" : "https://www.sapbwconsulting.com#logo" }, "name" : "SAP BW Consulting, Inc.", "sameAs" : [ "https://www.linkedin.com/company/543163/admin/", "https://www.youtube.com/user/SAPBWConsulting/", "https://twitter.com/Lonniea39", "https://www.facebook.com/SAPBWConsulting" ], "url" : "https://www.sapbwconsulting.com" } ``` ```json { "@context" : "https://schema.org", "@id" : "https://www.sapbwconsulting.com#logo", "@type" : "ImageObject", "caption" : "SAP BW Consulting, Inc. logo", "url" : "https://www.sapbwconsulting.com/hs-fs/hubfs/sapbw-consulting.png?width=2847&name=sapbw-consulting.png" } ``` ```json { "@context" : "https://schema.org", "@id" : "https://www.sapbwconsulting.com/about-lonnie-ayers#person", "@type" : "Person", "name" : "Lonnie D. Ayers, PMP", "sameAs" : [ "https://www.linkedin.com/in/lonnieayers/", "https://twitter.com/Lonniea39" ], "url" : "https://www.sapbwconsulting.com/about-lonnie-ayers", "worksFor" : { "@id" : "https://www.sapbwconsulting.com#organization" } } ``` ```json { "@context" : "https://schema.org", "@id" : "https://www.sapbwconsulting.com/blog/how-to-learn-advanced-data-warehouse-concepts-by-using-aggregates#webpage", "@type" : "WebPage", "breadcrumb" : { "@id" : "https://www.sapbwconsulting.com/blog/how-to-learn-advanced-data-warehouse-concepts-by-using-aggregates#breadcrumbs" }, "description" : "How to Learn Advanced Data Warehouse Concepts by Using Aggregates", "headline" : "How to Learn Advanced Data Warehouse Concepts by Using Aggregates", "inLanguage" : "en", "isPartOf" : { "@id" : "https://www.sapbwconsulting.com#website" }, "mainEntity" : { "@id" : "https://www.sapbwconsulting.com/blog/how-to-learn-advanced-data-warehouse-concepts-by-using-aggregates#blogposting" }, "name" : "How to Learn Advanced Data Warehouse Concepts by Using Aggregates", "url" : "https://www.sapbwconsulting.com/blog/how-to-learn-advanced-data-warehouse-concepts-by-using-aggregates" } ``` ```json { "@context" : "https://schema.org", "@id" : "https://www.sapbwconsulting.com/blog/how-to-learn-advanced-data-warehouse-concepts-by-using-aggregates#breadcrumbs", "@type" : "BreadcrumbList", "itemListElement" : [ { "@type" : "ListItem", "item" : "https://www.sapbwconsulting.com", "name" : "Home", "position" : 1 }, { "@type" : "ListItem", "item" : "https://www.sapbwconsulting.com/blog", "name" : "Blog", "position" : 2 }, { "@type" : "ListItem", "item" : "https://www.sapbwconsulting.com/blog/how-to-learn-advanced-data-warehouse-concepts-by-using-aggregates", "name" : "How to Learn Advanced Data Warehouse Concepts by Using Aggregates", "position" : 3 } ] } ```