{"id":56451,"date":"2019-05-20T14:03:10","date_gmt":"2019-05-20T08:33:10","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=56451"},"modified":"2021-12-04T13:05:24","modified_gmt":"2021-12-04T07:35:24","slug":"sap-hana-case-study","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/sap-hana-case-study\/","title":{"rendered":"SAP HANA Case Study – The Turning Point for Kellogg’s, Shire & Concepcion"},"content":{"rendered":"

In this SAP HANA case study article, we are going to throw some light on the usefulness of SAP HANA in different sectors and domains of the industry. We will discuss case studies of three companies namely, Shire, Kellogg\u2019s and Concepcion.<\/em><\/p>\n

It will help you to understand the challenge that the companies were facing and how SAP HANA benefitted them in overcoming that challenge.<\/p>\n

Let\u2019s start!<\/p>\n

SAP HANA Case Studies<\/h3>\n

We will start by discussing the case study of Kellogg’s.<\/p>\n

SAP HANA Case Study 1: Kellogg\u2019s<\/h3>\n

Kellogg\u2019s is a leading food manufacturer and a multi-national company based in Michigan, USA. It produces a wide range of convenience foods and cereals.<\/p>\n

Their business extends to 180 countries where their products are manufactured and marketed. The popular corn flakes company was found in 1898 by Kellogg brothers.<\/p>\n

\"Kellogg's<\/a><\/p>\n

The market of ready-to-eat foods like Kellogg\u2019s cereals is a very competitive one with tight margins. Being fully aware of the edge to edge competition in the market, Kellogg\u2019s primary focus has been on its trade spend.<\/p>\n

Trade spend is the money spent by the manufacturer to promote their product at the retailer\u2019s front. Nearly one-third of Kellogg\u2019s annual revenue is spent on promotions as trade spend.<\/p>\n

The promotional activities involve discount coupons, special offers, sale promotions, ad campaigns and buying a preferred slot at the grocery store shelf.<\/p>\n

If the trade spend of Kellogg\u2019s improves by 1% that amounts to a whopping $50 million dollars. This goes to show how important is it for the company to improve their trade spend and make it a profitable investment.<\/p>\n

The challenge<\/h4>\n

To keep a close eye on the company\u2019s trade spend, they created several complex data simulations for data analysis and modeling to be run on traditional relational database systems deployed on-premise. But by 2013, the traditional database system became inefficient for the company\u2019s requirements.<\/p>\n

In requirements, the company needed a bunch of simulations such as TV Ad promotions, coupons campaigns, store displays, sales, digital marketing, shelving costs<\/em> to run on an analysis system.<\/p>\n

The traditional systems could only run one simulation at a time creating a major lag and inefficiency in terms of timely predictions. The predictions were to find out which promotional activity is the most profitable for the company.<\/p>\n

Thus, the company needed an efficient and fast solution in the form of a cloud that store terabytes of data and have analytical capabilities as well. Because real-time feedback on the trade spend of even the slightest change in the market can save or earn the company a lot of revenue.<\/p>\n

Also, with the help of right interpretations and predictions of trade spend data, the company could avoid trivial and waste investments and focus on only the lucrative ones.<\/p>\n

The change<\/h4>\n

Kellogg\u2019s decided to go with SAP\u2019s solution called Accelerated Trade Promotion Management\/Planning (TPM)<\/strong> that is powered by SAP HANA and deployed on a public cloud platform Amazon Web Services (AWS)<\/strong>.<\/p>\n

The AWS provides a fully SAP-certified HANA environment to the solution. This SAP solution was immediately rolled out for test and development environments in the US.<\/p>\n

Due to the cloud-based AWS platform and the in-memory database technology of SAP HANA, the solution achieved speed, agility and optimal performance<\/em> as per the company\u2019s requirements. It was fulfilled without making heavy investment in physical hardware and environment set-up.<\/p>\n

The SAP Accelerated Trade Promotion Management (TPM) solution (powered by SAP HANA) can accommodate several terabytes of data. And, the data can be scaled as per the company\u2019s infrastructure needs and stays affordable.<\/p>\n

The solution breaks down usage and cost to a minute granular level which makes it easy for the users to segregate information and analyze sales operations in each department.<\/p>\n

Moving their setup from premise to cloud has benefited Kellogg\u2019s in many ways. They have saved more than $900,000 on hardware, software, and maintenance. <\/em>They\u00a0are likely to save nearly a million dollars in the next five years\u2019 time.<\/p>\n

The company is also able to save by reducing their trade spend as they can run multiple data simulations (calculations) simultaneously.<\/p>\n

Using AWS on cloud and SAP HANA in-memory database technology, the company could function faster than ever in terms of running data simulations (calculations), analyzing market scenarios and decision-making.<\/p>\n

Role of SAP HANA<\/h4>\n

The SAP TPM solution powered by SAP HANA uses the in-memory database and computing capabilities. Along with SAP HANA, it utilizes multiple AWS instances for SAP applications and HANA database layers.<\/p>\n

The AWS instances are called Amazon Elastic Compute Cloud (Amazon EC2)<\/strong> which can process up to 16TB of trade spend and sales data of the promotional operations in the US weekly. They are also used in modeling, about a dozen complex data simulations in a day.<\/p>\n

Several different Amazon services are used in association with SAP HANA for data backups, direct data access, storage, maintaining logs, monitoring,<\/em> etc.<\/p>\n

SAP HANA Case Study 2: Shire Pharmaceutical Group<\/h3>\n

Shire is leading life science and biotech company focused on rare diseases and specialized conditions. It is based in Dublin, Ireland having around 24,000 employees. The company\u2019s revenue is $15.2 billion US dollar <\/em>(approx) as of the year 2017.<\/p>\n

\"Shire<\/a><\/p>\n

The challenge<\/h4>\n

Shire is one of the leading biotech companies in the world focused on treating rare diseases and highly specialized conditions. It involves seven therapeutic areas ranging from oncology to neuroscience. Shire\u2019s products are sold in more than 100 countries.<\/p>\n

The company wanted to integrate its IT systems. They felt the need to bring together their disparate IT systems especially after a phase of rapid expansion. Also, they wanted to migrate from Oracle to SAP HANA database.<\/p>\n

They wanted to make these changes in order to make their IT systems more organized and centered. This would help the company to operate efficiently and focus entirely on rare disease management.<\/p>\n

The diverse IT systems were initially deployed on both SAP and non-SAP systems. The company required integrating all these systems into a single strong and solid IT system and migrating multiple databases into the SAP HANA database.<\/p>\n

The change<\/h4>\n

After Shire integrated its IT systems using SAP Enterprise Support and migrating from Oracle to SAP HANA, the company has seen a performance improvement by 10%-15%<\/em>.<\/p>\n

Created a solid IT foundation and helped people suffering from rare diseases.<\/p>\n

Shire has a unified IT system and SAP HANA\u2019s in-memory database which enables them to access and analyze huge amounts of data to make innovations and discoveries in the field of rare disease management and curing.<\/p>\n

The SAP HANA solution enhanced the company\u2019s performance, provided support of system health checks, ensured minimal risk and downtime.<\/p>\n

Role of SAP HANA<\/h4>\n

The company got full support from SAP Enterprise Support advisory team during the time of integration. The team extended their support even after integration was successfully done for issue resolution.<\/p>\n

The company admired SAP HANA for its advanced analytics capabilities, high-speed transactions, accuracy, and up-to-date responses and guided analytics and support<\/em>.<\/p>\n

The Shire also experienced an increase in their efficiency by the virtue of a unified IT system and robust in-memory database environment of SAP HANA.<\/p>\n

SAP HANA Case Study 3: Concepcion Industrial Corporation<\/h3>\n

In this case study, we will see how SAP HANA proved to be beneficial for Concepcion Industrial Corporation (CIC) in terms of business growth and cost-effectiveness.<\/p>\n

\"Concepcion<\/a><\/p>\n

The challenge<\/h4>\n

Due to the on-premise deployment of the company\u2019s data centers, the company was facing a problem of uncontrollable increase in IT expenditure. At some instances, the IT expenditure increase surpassed the company\u2019s revenue growth.<\/p>\n

The main money suckers were data servers, data storage, networking apparatus,<\/em> etc on the on-premise data center setup. In addition to this, IT administration expenditures were also shooting up. The on-premise system would also not support IoT solutions and would be awfully costly setup.<\/p>\n

The company needed a cloud-based IT system. The transition from an on-premise IT system to a cloud-based one was a costly process. But it would bring innovation to the company\u2019s ways of working and open new opportunities.<\/p>\n

The change<\/h4>\n

The company decided to move its data center setup to a public cloud. By doing so, they could cut down on a lot of IT expenditures made on on-premise deployment. CIC started looking for potential cloud-service providers like Google, IBM, Microsoft Azure, and Amazon Web Services (AWS).<\/p>\n

After trying out the services of these providers in a test environment, they finalized Amazon Web Services (AWS) as their cloud-services provider.<\/p>\n

The company finally had a cloud-based IT system as they completed migrating its IT systems to AWS Cloud in 2016. They could test a project easily and deploy it within weeks using the cloud0-based infrastructure.<\/p>\n

The cloud-based IT system could also support a large-scale computing environment for products using IoT solutions.<\/p>\n

Role of SAP HANA<\/h4>\n

After a successful migration from an on-premise IT setup to a cloud-based IT system in 2016, the company felt the need for a robust database management and analysis platform. They needed it to take care of their business operations.<\/p>\n

In early 2018, CIC deployed SAP HANA on their cloud-based infrastructure (AWS Cloud). The on-cloud implementation process lasted for about six-eight months until SAP HANA was completely ready for use.<\/p>\n

SAP HANA deployment process was easy, and the company only needed SAP\u2019s support for some extract, transform and load operations.<\/p>\n

SAP HANA plays a very crucial role in managing and assessing CIC\u2019s financial, supply chain, production operations in both consumer and commercial businesses<\/em>. With the help of SAP HANA and AWS cloud-services, CIC was able to reduce their IT costs by 30-50%<\/em>.<\/p>\n

The company is experiencing continuous revenue and business growth without any IT expenditure increase. Also, IT availability increased by 99.99 %. Now the IT department can focus on more important issues and services.<\/p>\n

Summary<\/h3>\n

These were the SAP HANA case studies of three companies; Kellogg\u2019s, Shire and Concepcion. In all of the case studies, we saw how SAP HANA has helped these companies grow in terms of business and profits.<\/p>\n

In short, the business intelligence capabilities, advanced analytics, and HANA\u2019 in-memory database engine helped companies leverage on the heaps of informative data available and manage their resources well.<\/p>\n

Any other SAP HANA case study that you want to explore? Drop in the comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"

In this SAP HANA case study article, we are going to throw some light on the usefulness of SAP HANA in different sectors and domains of the industry. We will discuss case studies of...<\/p>\n","protected":false},"author":6,"featured_media":56458,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18002],"tags":[19773,19771,19770,19772],"class_list":["post-56451","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-hana","tag-concepcion-sap-hana-case-study","tag-kelloggs-sap-hana-case-study","tag-sap-hana-case-study","tag-shire-sap-hana-case-study"],"yoast_head":"\nSAP HANA Case Study - The Turning Point for Kellogg's, Shire & Concepcion - DataFlair<\/title>\n<meta name=\"description\" content=\"SAP HANA case study article covers the case studies of Kellogg's, Shire & Concepcion describing challenges faced and how SAP HANA helped to overcome them.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/sap-hana-case-study\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAP HANA Case Study - The Turning Point for Kellogg's, Shire & Concepcion - DataFlair\" \/>\n<meta property=\"og:description\" content=\"SAP HANA case study article covers the case studies of Kellogg's, Shire & Concepcion describing challenges faced and how SAP HANA helped to overcome them.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/sap-hana-case-study\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-20T08:33:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-04T07:35:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/SAP-HANA-Case-Studies.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"802\" \/>\n\t<meta property=\"og:image:height\" content=\"420\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SAP HANA Case Study - The Turning Point for Kellogg's, Shire & Concepcion - DataFlair","description":"SAP HANA case study article covers the case studies of Kellogg's, Shire & Concepcion describing challenges faced and how SAP HANA helped to overcome them.","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:\/\/data-flair.training\/blogs\/sap-hana-case-study\/","og_locale":"en_US","og_type":"article","og_title":"SAP HANA Case Study - The Turning Point for Kellogg's, Shire & Concepcion - DataFlair","og_description":"SAP HANA case study article covers the case studies of Kellogg's, Shire & Concepcion describing challenges faced and how SAP HANA helped to overcome them.","og_url":"https:\/\/data-flair.training\/blogs\/sap-hana-case-study\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2019-05-20T08:33:10+00:00","article_modified_time":"2021-12-04T07:35:24+00:00","og_image":[{"width":802,"height":420,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/SAP-HANA-Case-Studies.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/sap-hana-case-study\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-case-study\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"SAP HANA Case Study – The Turning Point for Kellogg’s, Shire & Concepcion","datePublished":"2019-05-20T08:33:10+00:00","dateModified":"2021-12-04T07:35:24+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-case-study\/"},"wordCount":1723,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-case-study\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/SAP-HANA-Case-Studies.jpg","keywords":["Concepcion SAP HANA Case Study","Kellogg's SAP HANA Case Study","SAP HANA Case Study","Shire SAP HANA Case Study"],"articleSection":["SAP HANA Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/sap-hana-case-study\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/sap-hana-case-study\/","url":"https:\/\/data-flair.training\/blogs\/sap-hana-case-study\/","name":"SAP HANA Case Study - The Turning Point for Kellogg's, Shire & Concepcion - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-case-study\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-case-study\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/SAP-HANA-Case-Studies.jpg","datePublished":"2019-05-20T08:33:10+00:00","dateModified":"2021-12-04T07:35:24+00:00","description":"SAP HANA case study article covers the case studies of Kellogg's, Shire & Concepcion describing challenges faced and how SAP HANA helped to overcome them.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-case-study\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/sap-hana-case-study\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/sap-hana-case-study\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/SAP-HANA-Case-Studies.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/SAP-HANA-Case-Studies.jpg","width":802,"height":420,"caption":"SAP HANA Case Studies"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/sap-hana-case-study\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SAP HANA Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/sap-hana\/"},{"@type":"ListItem","position":3,"name":"SAP HANA Case Study – The Turning Point for Kellogg’s, Shire & Concepcion"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/56451","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=56451"}],"version-history":[{"count":16,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/56451\/revisions"}],"predecessor-version":[{"id":104904,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/56451\/revisions\/104904"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/56458"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=56451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=56451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=56451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}