{"id":2973,"date":"2021-07-16T00:00:16","date_gmt":"2021-07-15T22:00:16","guid":{"rendered":"https:\/\/devstage.bix-consulting.com\/?p=2973"},"modified":"2023-06-14T14:10:04","modified_gmt":"2023-06-14T12:10:04","slug":"einfuehrung-tableau-und-sap","status":"publish","type":"post","link":"https:\/\/teststage.bix-consulting.com\/en\/einfuehrung-tableau-und-sap\/","title":{"rendered":"Introduction to Tableau and SAP"},"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;post_content&#8220;][et_pb_row _builder_version=&#8220;4.16&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#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;post_content&#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;post_content&#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;post_content&#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;post_content&#8220;][et_pb_row _builder_version=&#8220;4.16&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#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;post_content&#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;post_content&#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;post_content&#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;post_content&#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; hover_enabled=&#8220;0&#8243; border_radii=&#8220;on|20px|20px|20px|20px&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220; sticky_enabled=&#8220;0&#8243;][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;post_content&#8220;][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;||||false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;]<\/p>\n<h4>Challenge<\/h4>\n<p style=\"text-align: justify;\"><span>Tableau is to be increasingly rolled out in the company as a reporting and analysis tool. The plan was to give the existing BW on HANA a greater role in the future and to optimise access for Tableau. Using the existing BW queries did not prove to be the right approach, as neither the performance was satisfactory nor the functional scope in Tableau was sufficient for the requirements.<\/span><\/p>\n<h6>Facts about the customer<\/h6>\n<p>Branche: Lebensmitteleinzelhandel<\/p>\n<p>Company size: Corporation<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8220;2_5&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; hover_enabled=&#8220;0&#8243; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220; module_class=&#8220;vertikal-zentrieren&#8220; sticky_enabled=&#8220;0&#8243;][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; hover_enabled=&#8220;0&#8243; border_radii=&#8220;off||10px|10px|&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220; border_radii_last_edited=&#8220;on|phone&#8220; sticky_enabled=&#8220;0&#8243; border_radii_tablet=&#8220;off||0px|10px|10px&#8220; border_radii_phone=&#8220;off||0px|10px|10px&#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;post_content&#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;post_content&#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;post_content&#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; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;]<\/p>\n<h4>Solution<\/h4>\n<p style=\"text-align: justify;\">In the course of several workshops, the BW system was prepared in such a way that reporting is also possible directly via HANA with Calculation Views. Questions regarding authorisations, development process, data modelling and performance were dealt with and answered in cooperation with the customer. Through an integrated coaching approach, it was possible to ensure that the customer could support the solution by himself and also develop it further.<\/p>\n<p>&nbsp;<\/p>\n<h4>Customer benefit<\/h4>\n<p style=\"text-align: justify;\">By providing a reporting and analysis layer directly on the HANA of the BW system, all requirements for performance and flexibility could be more than fulfilled. Thanks to the direct integration with the existing data and models in BW, major adaptations were not necessary, and the full range of Tableau functions could be used at the same time. Further expansion of the solution can now be driven forward by the customer's IT department without the need for any additional work.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>","protected":false},"excerpt":{"rendered":"<p>Implementation of an integrated Tableau solution on SAP HANA as a reporting and analysis tool in a food wholesaling group<\/p>","protected":false},"author":6,"featured_media":3029,"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":[43,39,26,45,29,31,48,57,40,59,60,58,56,38,27,44,41,50,42,49,46,47,54,55],"modified_by":"admin","_links":{"self":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/posts\/2973"}],"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=2973"}],"version-history":[{"count":0,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/posts\/2973\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/media\/3029"}],"wp:attachment":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/media?parent=2973"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/categories?post=2973"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/tags?post=2973"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}