{"id":7177,"date":"2023-08-22T12:55:00","date_gmt":"2023-08-22T12:55:00","guid":{"rendered":"https:\/\/accelywp.wp.brainvire.dev\/?p=7177"},"modified":"2025-03-10T09:34:13","modified_gmt":"2025-03-10T09:34:13","slug":"importance-of-data-modeling-in-sap-analytics-cloud","status":"publish","type":"post","link":"https:\/\/www.accely.com\/ae-en\/blog\/importance-of-data-modeling-in-sap-analytics-cloud\/","title":{"rendered":"Importance of Data Modeling in SAP Analytics Cloud"},"content":{"rendered":"\n<section class=\"insights-banner\">\n    <div class=\"container\">\n        <div class=\"insights-banner-wrapper\">\n            <div class=\"insights-banner-left\">\n                                                <h1 class=\"insights-banner-title h3\">Importance of Data Modeling in SAP Analytics Cloud<\/h1>\n                                <div class=\"badge-wrap d-flex d-flex-wrap\">\n                                                           <span class=\"badge badge-orange\">SAP Analytics Cloud<\/span>\n                                                      <\/div>\n                                 <p class=\"publish-date\">Published: August 22, 2023<\/p>\n                                \n                 \n\n\n\n            <\/div>\n                        <div class=\"insights-banner-right\">\n            <img decoding=\"async\" src=\"https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/Importance-of-Data-Modeling-in-SAP-Analytics-Cloud.webp\"  alt=\"Banner\" class=\"insights-banner-img\" width=\"720\" height=\"471\">\n            <\/div>\n                    <\/div>\n    <\/div>\n<\/section>\n\n    <div class=\"main-content-blog-section\">\n        <div class=\"main-content-blog\">\n                            <div class=\"pdp-sidebar-sec-wrap\">\n                    <div class=\"pdp-sidebar\">\n                        <ul class=\"ul-none pdp-sidebar-menu-wrap\">\n                                                    <\/ul>\n                    <\/div>\n                <\/div>\n                <div class=\"content-blog-sections\">\n                                                            <section class=\"insights-middle\" >\n                        <div class=\"insights-container\">\n                            \n                        <div class=\"insights-middle-content\">\n                            <p>Data modeling is so pervasive in our daily lives that we often don\u2019t even notice that changes are being made to the underlying data. But today, you can enhance your data and prepare it for analysis with the assistance of Data modeling in SAP Analytics Cloud easily. You can also edit your data in bulk, define categories and hierarchies, and create your own formulas.<\/p>\n<p><a href=\"https:\/\/www.accely.com\/blog\/a-comprehensive-guide-to-data-allocation-in-sap-analytics-cloud\/\">SAP SAC data models<\/a> fulfill these needs by providing data in a more \u201cusable\u201d form. The simplest way to think of these models is as the framework into which the data is loaded through a data connection (with reference to the framework structure or formats) and then \u201coptimized\u201d or transformed state for use in the various <a href=\"https:\/\/www.accely.com\/blog\/analytical-capabilities-and-features-of-sap-analytics-cloud-sac\/\">reporting and analytical capabilities of SAP SAC<\/a>.<\/p>\n<p>This also explains why the data model is so important. Simply put, you can\u2019t produce anything without a data model, whether it\u2019s a story, an application, or a digital boardroom that isn\u2019t directly tied to the data source. Therefore, data modeling and data model development are essential for the use and development of present and future reports. <a href=\"\/solutions\/sap-analytic-cloud-planning\/\">SAC Planning<\/a> can assist the process seamlessly.<\/p>\n<p><img decoding=\"async\" class=\"alignnone wp-image-60449 size-medium\" src=\"https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/SAC-Analytic-Model-300x165.webp\" alt=\"SAC-Analytic-Model\" width=\"300\" height=\"165\" srcset=\"https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/SAC-Analytic-Model-300x165.webp 300w, https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/SAC-Analytic-Model.webp 768w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p style=\"text-align: center\">Source: https:\/\/blogs.sap.com\/<\/p>\n<p>In <a href=\"\/solutions\/sap-analytics-cloud\/\">SAP Analytics Cloud<\/a>, there are two main business intelligence functions:<\/p>\n<ul>\n<li>Models<\/li>\n<li>Stories<\/li>\n<\/ul>\n<p>Models are where you perform all of your data modeling prior to analyzing it. Data modeling involves data wrangling or cleaning, defining your measure and dimension, and enriching your data by creating hierarchies, specifying units and currencies, and adding formulas to your data.<\/p>\n<p>Stories, however, bring your data to life. In Story mode, your data can be visualized using charts and graphs. This gives you a whole new way to view your data and get valuable insights about your business.<\/p>\n<p>After you click Create &gt; Model in the menu, you will be prompted to link your data. In this case, we will import the file from our desktop.<\/p>\n<p><img decoding=\"async\" class=\"alignnone wp-image-60353 size-medium\" src=\"https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/start-your-model-300x146.webp\" alt=\"\" width=\"300\" height=\"146\" srcset=\"https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/start-your-model-300x146.webp 300w, https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/start-your-model-768x372.webp 768w, https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/start-your-model.webp 1000w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p style=\"text-align: center\">Source: https:\/\/blogs.sap.com\/<\/p>\n<p>You can also skip data modeling entirely and jump straight into Story mode. However, there are some advantages to taking a few minutes in Modeler. For example, if you want to quickly visualize your data in a chart, you may want to jump straight to Story mode.<\/p>\n<p>On the other hand, when you begin in the \u201cModeler view,\u201d you can take your stories to the next level with the help of data modeling. After you\u2019ve entered Modeler, you\u2019ll see the following screen:<\/p>\n<p><img decoding=\"async\" class=\"alignnone wp-image-60697 size-medium\" src=\"https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/modeler-data-integration-300x166.webp\" alt=\"modeler-data-integration\" width=\"300\" height=\"166\" srcset=\"https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/modeler-data-integration-300x166.webp 300w, https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/modeler-data-integration-768x425.webp 768w, https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/modeler-data-integration.webp 1000w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p style=\"text-align: center\">Source: https:\/\/blogs.sap.com\/<\/p>\n<p>The Modeler shows data in the form of rows, columns, and tabs. It also has various tools to help you convert your data.<\/p>\n<p>Let\u2019s learn the basics of Data Modeling:<\/p>\n<h4>Data Wrangling<\/h4>\n<p>We often find inaccuracies in the data we capture. For example, your dates may not be in the correct format, or there may be typos, etc. Before you start your analysis, make sure your data is organized correctly. For example, in the example below we have the location spelled in two different ways, i.e., &#8216;LA&#8217; and &#8216;Los Angeles&#8217;. Obviously, we will need to correct this. We can easily fix this using Find and Replace.<\/p>\n<p><img decoding=\"async\" class=\"alignnone wp-image-59424 size-medium\" src=\"https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/document-data-distribution-300x199.webp\" alt=\"document-data-distribution\" width=\"300\" height=\"199\" srcset=\"https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/document-data-distribution-300x199.webp 300w, https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/document-data-distribution-768x510.webp 768w, https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/document-data-distribution.webp 1000w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p style=\"text-align: center\">Source: https:\/\/blogs.sap.com\/<\/p>\n<p>In the above example, we have found all instances of &#8216;LA&#8217; and replaced it with &#8216;Los Angeles&#8217;. However, since &#8216;Los Angeles&#8217; has been treated as a standalone location, changing its name will not bring it together with the existing &#8216;Los Angeles&#8217; data. To do this, we have to merge the &#8216;Los Angeles&#8217; and &#8216;Los Angeles&#8217; sets. We can choose any instance of &#8216;Los Angeles&#8217;, click transform, and merge it with the &#8216;Other Los Angeles&#8217; data.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-7224\" src=\"\/wp-content\/uploads\/2024\/09\/data-distribution-gif.gif\" alt=\"\" width=\"1000\" height=\"480\" \/><\/p>\n<p style=\"text-align: center\">Source: https:\/\/blogs.sap.com\/<\/p>\n<p>Next,<\/p>\n<p>We have the city and state categories. We want to divide this into two columns. We can easily do this using the splitting function.<\/p>\n<p>Choose the column that you want to separate and click on the split option. You can create new columns by separating them with spaces, dashes, commas, etc. You can also combine two columns.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-7233\" src=\"https:\/\/accelywp.wp.brainvire.dev\/wp-content\/uploads\/2024\/09\/data-distribution-in-column.png\" alt=\"\" width=\"1000\" height=\"387\" srcset=\"https:\/\/www.accely.com\/wp-content\/uploads\/2024\/09\/data-distribution-in-column.png 1000w, https:\/\/www.accely.com\/wp-content\/uploads\/2024\/09\/data-distribution-in-column-300x116.png 300w, https:\/\/www.accely.com\/wp-content\/uploads\/2024\/09\/data-distribution-in-column-768x297.png 768w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/p>\n<p style=\"text-align: center\">Source: https:\/\/blogs.sap.com\/<\/p>\n<p>In Units and Currency, you can specify the type of value you want to display and the units you want to display them in.\u00a0 You can choose from the following options:<\/p>\n<ul>\n<li><strong>Blank<\/strong>: No unit will be shown<\/li>\n<li><strong>Label<\/strong>: You can specify a text label (up to 30 characters long) that you can use to define your display units. You can use it as a measure or as a packaging unit (e.g., \u2018bottles\u2019).<\/li>\n<li><strong>%<\/strong>: The percentage option shows the percentage of the value after the value.<\/li>\n<li><strong>Currency<\/strong>: This option applies to all monetary values.<\/li>\n<\/ul>\n<h4>Hierarchy<\/h4>\n<p>Hierarchy can be used to create parent-child relationships in your data. For instance, let\u2019s say you have sales information for:<\/p>\n<ul>\n<li>Global<\/li>\n<li>Country<\/li>\n<li>State \/ Province<\/li>\n<li>City<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone wp-image-60587 size-medium\" src=\"https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/data-modeling-300x143.webp\" alt=\"data-modeling\" width=\"300\" height=\"143\" srcset=\"https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/data-modeling-300x143.webp 300w, https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/data-modeling-768x366.webp 768w, https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/data-modeling.webp 1000w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p style=\"text-align: center\">Source: https:\/\/blogs.sap.com\/<\/p>\n<p>In Story mode, you\u2019ll be able to drill down into your enriched charts. See how to do this in action in our post on Hierarchies.<\/p>\n<h4>Formula<\/h4>\n<p>You can also use formulas to create new measures. These are easy to use and will save you a lot of time in your story. For instance, in our example dataset, we have 2 measures: the original sales price and the discount. We can use a formula to create a new measure called &#8216;Revenue&#8217;.<\/p>\n<p><img decoding=\"async\" class=\"alignnone wp-image-59552 size-medium\" src=\"https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/cagr-300x226.webp\" alt=\"cagr\" width=\"300\" height=\"226\" srcset=\"https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/cagr-300x226.webp 300w, https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/cagr-768x579.webp 768w, https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/cagr.webp 1000w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p style=\"text-align: center\">Source: https:\/\/blogs.sap.com\/<\/p>\n<p>Data modeling in SAP Analytics Cloud (SAC) is highly valuable and plays a crucial role in the effectiveness of data analysis and reporting.<\/p>\n<p>&nbsp;<\/p>\n                            \n                        <\/div>\n                            \n                        <\/div>\n                    <\/section>\n                                                        <\/div>\n            \n            \n        <\/div>\n    <\/div>\n\n<section class=\"blog-list-sec related-posts-sec\">\n    <div class=\"container\">\n                    <\/div>\n<\/section>","protected":false},"excerpt":{"rendered":"<p>Data modeling in SAP Analytics Cloud (SAC) is highly valuable and plays a crucial role in the effectiveness of data analysis and reporting. <\/p>\n","protected":false},"author":8,"featured_media":35040,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"product-post":[],"industry-post":[],"solution-post":[141],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Importance of Data Modeling in SAP Analytics Cloud | Accely<\/title>\n<meta name=\"description\" content=\"Data modeling in SAP Analytics Cloud (SAC) is highly valuable and plays a crucial role in the effectiveness of data analysis and reporting. Visit us to know more!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Importance of Data Modeling in SAP Analytics Cloud | Accely\" \/>\n<meta property=\"og:description\" content=\"Data modeling in SAP Analytics Cloud (SAC) is highly valuable and plays a crucial role in the effectiveness of data analysis and reporting. Visit us to know more!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.accely.com\/ae-en\/blog\/importance-of-data-modeling-in-sap-analytics-cloud\/\" \/>\n<meta property=\"og:site_name\" content=\"Accely\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-22T12:55:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-10T09:34:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/Importance-of-Data-Modeling-in-SAP-Analytics-Cloud.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"720\" \/>\n\t<meta property=\"og:image:height\" content=\"432\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Muralidharan Venkataraman\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Muralidharan Venkataraman\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Importance of Data Modeling in SAP Analytics Cloud | Accely","description":"Data modeling in SAP Analytics Cloud (SAC) is highly valuable and plays a crucial role in the effectiveness of data analysis and reporting. Visit us to know more!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Importance of Data Modeling in SAP Analytics Cloud | Accely","og_description":"Data modeling in SAP Analytics Cloud (SAC) is highly valuable and plays a crucial role in the effectiveness of data analysis and reporting. Visit us to know more!","og_url":"https:\/\/www.accely.com\/ae-en\/blog\/importance-of-data-modeling-in-sap-analytics-cloud\/","og_site_name":"Accely","article_published_time":"2023-08-22T12:55:00+00:00","article_modified_time":"2025-03-10T09:34:13+00:00","og_image":[{"width":720,"height":432,"url":"https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/Importance-of-Data-Modeling-in-SAP-Analytics-Cloud.webp","type":"image\/webp"}],"author":"Muralidharan Venkataraman","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Muralidharan Venkataraman","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.accely.com\/ae-en\/blog\/importance-of-data-modeling-in-sap-analytics-cloud\/","url":"https:\/\/www.accely.com\/ae-en\/blog\/importance-of-data-modeling-in-sap-analytics-cloud\/","name":"Importance of Data Modeling in SAP Analytics Cloud | Accely","isPartOf":{"@id":"https:\/\/www.accely.com\/ae-en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.accely.com\/ae-en\/blog\/importance-of-data-modeling-in-sap-analytics-cloud\/#primaryimage"},"image":{"@id":"https:\/\/www.accely.com\/ae-en\/blog\/importance-of-data-modeling-in-sap-analytics-cloud\/#primaryimage"},"thumbnailUrl":"https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/Importance-of-Data-Modeling-in-SAP-Analytics-Cloud.webp","datePublished":"2023-08-22T12:55:00+00:00","dateModified":"2025-03-10T09:34:13+00:00","author":{"@id":"https:\/\/www.accely.com\/ae-en\/#\/schema\/person\/f607f6b08bf72badef0da4a7dfd4cc08"},"description":"Data modeling in SAP Analytics Cloud (SAC) is highly valuable and plays a crucial role in the effectiveness of data analysis and reporting. Visit us to know more!","breadcrumb":{"@id":"https:\/\/www.accely.com\/ae-en\/blog\/importance-of-data-modeling-in-sap-analytics-cloud\/#breadcrumb"},"inLanguage":"ae-en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.accely.com\/ae-en\/blog\/importance-of-data-modeling-in-sap-analytics-cloud\/"]}]},{"@type":"ImageObject","inLanguage":"ae-en","@id":"https:\/\/www.accely.com\/ae-en\/blog\/importance-of-data-modeling-in-sap-analytics-cloud\/#primaryimage","url":"https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/Importance-of-Data-Modeling-in-SAP-Analytics-Cloud.webp","contentUrl":"https:\/\/www.accely.com\/wp-content\/uploads\/2023\/08\/Importance-of-Data-Modeling-in-SAP-Analytics-Cloud.webp","width":720,"height":432,"caption":"Importance of Data Modeling in SAP Analytics Cloud"},{"@type":"BreadcrumbList","@id":"https:\/\/www.accely.com\/ae-en\/blog\/importance-of-data-modeling-in-sap-analytics-cloud\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.accely.com\/ae-en\/"},{"@type":"ListItem","position":2,"name":"Importance of Data Modeling in SAP Analytics Cloud"}]},{"@type":"WebSite","@id":"https:\/\/www.accely.com\/ae-en\/#website","url":"https:\/\/www.accely.com\/ae-en\/","name":"Accely","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.accely.com\/ae-en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ae-en"},{"@type":"Person","@id":"https:\/\/www.accely.com\/ae-en\/#\/schema\/person\/f607f6b08bf72badef0da4a7dfd4cc08","name":"Muralidharan Venkataraman","image":{"@type":"ImageObject","inLanguage":"ae-en","@id":"https:\/\/www.accely.com\/ae-en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4cc00cc3712f61020ecdd949436691b6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cc00cc3712f61020ecdd949436691b6?s=96&d=mm&r=g","caption":"Muralidharan Venkataraman"}}]}},"_links":{"self":[{"href":"https:\/\/www.accely.com\/ae-en\/wp-json\/wp\/v2\/posts\/7177"}],"collection":[{"href":"https:\/\/www.accely.com\/ae-en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.accely.com\/ae-en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.accely.com\/ae-en\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.accely.com\/ae-en\/wp-json\/wp\/v2\/comments?post=7177"}],"version-history":[{"count":28,"href":"https:\/\/www.accely.com\/ae-en\/wp-json\/wp\/v2\/posts\/7177\/revisions"}],"predecessor-version":[{"id":63439,"href":"https:\/\/www.accely.com\/ae-en\/wp-json\/wp\/v2\/posts\/7177\/revisions\/63439"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.accely.com\/ae-en\/wp-json\/wp\/v2\/media\/35040"}],"wp:attachment":[{"href":"https:\/\/www.accely.com\/ae-en\/wp-json\/wp\/v2\/media?parent=7177"}],"wp:term":[{"taxonomy":"product-post","embeddable":true,"href":"https:\/\/www.accely.com\/ae-en\/wp-json\/wp\/v2\/product-post?post=7177"},{"taxonomy":"industry-post","embeddable":true,"href":"https:\/\/www.accely.com\/ae-en\/wp-json\/wp\/v2\/industry-post?post=7177"},{"taxonomy":"solution-post","embeddable":true,"href":"https:\/\/www.accely.com\/ae-en\/wp-json\/wp\/v2\/solution-post?post=7177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}