{"id":2988,"date":"2021-07-16T00:00:05","date_gmt":"2021-07-15T22:00:05","guid":{"rendered":"https:\/\/devstage.bix-consulting.com\/?p=2988"},"modified":"2023-06-14T14:14:36","modified_gmt":"2023-06-14T12:14:36","slug":"aufbau-enterprise-data-warehouse","status":"publish","type":"post","link":"https:\/\/teststage.bix-consulting.com\/en\/aufbau-enterprise-data-warehouse\/","title":{"rendered":"Setting up an Enterprise Data Warehouse"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8220;1&#8243; disabled_on=&#8220;on|on|on&#8220; _builder_version=&#8220;4.16&#8243; _module_preset=&#8220;default&#8220; disabled=&#8220;on&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;et_body_layout&#8220;][et_pb_row _builder_version=&#8220;4.16&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;et_body_layout&#8220;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;4.16&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;et_body_layout&#8220;][et_pb_text _builder_version=&#8220;4.16&#8243; _module_preset=&#8220;default&#8220; text_line_height=&#8220;0.3em&#8220; border_color_all=&#8220;#000000&#8243; border_width_bottom=&#8220;1px&#8220; border_color_bottom=&#8220;#c9c9c9&#8243; locked=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;et_body_layout&#8220;]<\/p>\n<h5>Facts about the customer<\/h5>\n<p>&nbsp;<\/p>\n<p>Industry: Measurement and control technology<\/p>\n<p>Company size: Corporation<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8220;4.16&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;et_body_layout&#8220;]<\/p>\n<p>&nbsp;<\/p>\n<h5>Challenge<\/h5>\n<p style=\"text-align: justify;\">During the ongoing implementation of a S\/4HANA system as a replacement for an existing self-developed ERP system, it was discovered that many reporting and analysis requirements could not be met. To address these requirements, it was decided to purchase an enterprise data warehouse.<\/p>\n<p>&nbsp;<\/p>\n<h5>Solution<\/h5>\n<p style=\"text-align: justify;\">The decision was made in favour of the BW\/4HANA as an enterprise data warehouse, as it integrates perfectly into the SAP world and enables a quick implementation with its existing data sources and ready-made content. These advantages, combined with the best practice approaches of biX Consulting, enabled a rapid implementation of the various business content modules on the basis of an architecture that has been tried and tested over many years which allowed both high-performance reporting and rapid adjustments to existing models.<\/p>\n<p>&nbsp;<\/p>\n<h5>Customer benefit<\/h5>\n<p style=\"text-align: justify;\">The client now has a state-of-the-art analytics and reporting platform that supports management with high data quality and decision-making performance, while being able to adapt quickly and cost-effectively to meet future needs.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; disabled_on=&#8220;on|on|on&#8220; _builder_version=&#8220;4.16&#8243; _module_preset=&#8220;default&#8220; disabled=&#8220;on&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;et_body_layout&#8220;][et_pb_row _builder_version=&#8220;4.16&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;et_body_layout&#8220;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;4.16&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;et_body_layout&#8220;][et_pb_text _builder_version=&#8220;4.16&#8243; _module_preset=&#8220;default&#8220; text_line_height=&#8220;0.3em&#8220; border_color_all=&#8220;#000000&#8243; border_width_bottom=&#8220;1px&#8220; border_color_bottom=&#8220;#c9c9c9&#8243; locked=&#8220;off&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;et_body_layout&#8220;]<\/p>\n<h5>Facts about the customer<\/h5>\n<p>&nbsp;<\/p>\n<p>Industry: Measurement and control technology<\/p>\n<p>Company size: Corporation<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8220;4.16&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;et_body_layout&#8220;]<\/p>\n<p>&nbsp;<\/p>\n<h5>Challenge<\/h5>\n<p style=\"text-align: justify;\">During the ongoing implementation of a S\/4HANA system as a replacement for an existing self-developed ERP system, it was discovered that many reporting and analysis requirements could not be met. To address these requirements, it was decided to purchase an enterprise data warehouse.<\/p>\n<p>&nbsp;<\/p>\n<h5>Solution<\/h5>\n<p style=\"text-align: justify;\">The decision was made in favour of the BW\/4HANA as an enterprise data warehouse, as it integrates perfectly into the SAP world and enables a quick implementation with its existing data sources and ready-made content. These advantages, combined with the best practice approaches of biX Consulting, enabled a rapid implementation of the various business content modules on the basis of an architecture that has been tried and tested over many years which allowed both high-performance reporting and rapid adjustments to existing models.<\/p>\n<p>&nbsp;<\/p>\n<h5>Customer benefit<\/h5>\n<p style=\"text-align: justify;\">The client now has a state-of-the-art analytics and reporting platform that supports management with high data quality and decision-making performance, while being able to adapt quickly and cost-effectively to meet future needs.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;||0px||false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;et_body_layout&#8220;][et_pb_row column_structure=&#8220;3_5,2_5&#8243; use_custom_gutter=&#8220;on&#8220; gutter_width=&#8220;2&#8243; make_equal=&#8220;on&#8220; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; background_color=&#8220;#F4F4F4&#8243; custom_margin=&#8220;||||false|false&#8220; custom_padding=&#8220;20px|20px|20px|20px|false|false&#8220; border_radii=&#8220;on|20px|20px|20px|20px&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;et_body_layout&#8220;][et_pb_column type=&#8220;3_5&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;et_body_layout&#8220;][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;||||false|false&#8220; hover_enabled=&#8220;0&#8243; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;et_body_layout&#8220; sticky_enabled=&#8220;0&#8243;]<\/p>\n<h4>Challenge<\/h4>\n<p style=\"text-align: justify;\"><span>The existing data warehouse, which had grown over many years, could no longer meet the current requirements for speed and flexibility. The data flows, which are classically built on redundancy, only allow changes to existing models with great effort and thus significantly reduce the speed of adaptation, which in turn led to dissatisfied departments and increased shadow IT. Self-service approaches could hardly be implemented due to the lack of performance.<\/span><\/p>\n<h6>Facts about the customer<\/h6>\n<p>Industry: Information technology in banking and commerce<\/p>\n<p>Company size: Corporation<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8220;2_5&#8243; module_class=&#8220;vertikal-zentrieren&#8220; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;et_body_layout&#8220;][et_pb_post_title title=&#8220;off&#8220; meta=&#8220;off&#8220; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;||||false|false&#8220; border_radii=&#8220;off||10px|10px|&#8220; border_radii_tablet=&#8220;off||0px|10px|10px&#8220; border_radii_phone=&#8220;off||0px|10px|10px&#8220; border_radii_last_edited=&#8220;on|phone&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;et_body_layout&#8220;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;et_body_layout&#8220;][et_pb_row _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;0px||||false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;et_body_layout&#8220;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;et_body_layout&#8220;][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_margin=&#8220;||||false|false&#8220; custom_padding=&#8220;|20px||20px|false|false&#8220; hover_enabled=&#8220;0&#8243; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;et_body_layout&#8220; sticky_enabled=&#8220;0&#8243;]<\/p>\n<h4>Solution<\/h4>\n<p style=\"text-align: justify;\"><span>The implementation of a data warehouse based on SAP HANA has more than fulfilled the requirements of a modern data warehouse architecture. Flexible and easily adaptable models were designed through database-related processing in conjunction with strong virtualisation, which allow an agile approach to data provision. Due to the high processing speed of an in-memory solution, high-performance reporting has become possible which allowed the departments to work independently on their data.<\/span><\/p>\n<p>&nbsp;<\/p>\n<h4>Customer benefit<\/h4>\n<p style=\"text-align: justify;\"><span>Regularly required reports can be made available on time and with high performance. Due to the lean virtualised architecture, adjustments to new customer requirements can be made easily and quickly. Data models can be linked virtually and allow new insights into company data and processes. This can significantly accelerate and qualitatively strengthen the process of decision-making.<\/span><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>","protected":false},"excerpt":{"rendered":"<p>Implementation of an SAP HANA data warehouse as an efficient tool for data provision and processing in the banking and finance sector<\/p>","protected":false},"author":6,"featured_media":3032,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[241],"tags":[68,43,39,26,45,29,70,31,48,40,66,67,38,27,44,41,50,69,42,49,46,47],"modified_by":"admin","_links":{"self":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/posts\/2988"}],"collection":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/comments?post=2988"}],"version-history":[{"count":0,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/posts\/2988\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/media\/3032"}],"wp:attachment":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/media?parent=2988"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/categories?post=2988"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/tags?post=2988"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}