{"id":8364,"date":"2022-06-21T15:31:24","date_gmt":"2022-06-21T13:31:24","guid":{"rendered":"https:\/\/avantgarde-labs.com\/?post_type=case_studies&#038;p=8364"},"modified":"2022-06-21T15:31:25","modified_gmt":"2022-06-21T13:31:25","slug":"aufbau-eines-data-warehouse-bei-zotzklimas","status":"publish","type":"case_studies","link":"https:\/\/avantgarde-labs.com\/de\/case-studies\/aufbau-eines-data-warehouse-bei-zotzklimas\/","title":{"rendered":"Aufbau eines Data Warehouse bei ZOTZ|KLIMAS"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"8364\" class=\"elementor elementor-8364\" data-elementor-post-type=\"case_studies\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ef49c0d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ef49c0d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0088d29\" data-id=\"0088d29\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f7845c3 elementor-widget elementor-widget-heading\" data-id=\"f7845c3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Herausforderung<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-1617adc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1617adc\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-df195a7\" data-id=\"df195a7\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fcfeabe elementor-widget elementor-widget-text-editor\" data-id=\"fcfeabe\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>ZOTZ|KLIMAS\u00a0ist ein von Vertrags\u00e4rztInnen gef\u00fchrtes Institut f\u00fcr Labordiagnostik und medizinische Beratung. Das Institut besteht aus Arztpraxen und Laboren an \u00fcber 20 Standorten in Deutschland. Der Schwerpunkt liegt darin, die Kompetenzen interdisziplin\u00e4rer \u00c4rzteteams aus Pathologen, Humangenetikern, Labor\u00e4rzten und Onkologen zu b\u00fcndeln und medizinische Themenbereiche patientenzentriert zu bearbeiten.<\/p><p>Die <strong>f\u00fcr das Financial Controlling notwendigen Daten wurden bisher in Excel-Listen<\/strong> gef\u00fchrt. In diesen wurden die Daten aus den unterschiedlichen Systemen der Praxen und Laboren zusammengef\u00fchrt und manuell aktualisiert. Aufgrund der zunehmenden Anzahl der Arztpraxen und Laboren wurde dieser <strong>Datenintegrationsprozess sehr zeitaufw\u00e4ndig<\/strong> und der Ursprung der Datenfl\u00fcsse in den Excel-Listen nicht immer leicht nachvollziehbar. Zudem waren die Umsatzzahlen beider Unternehmenszweige nur getrennt einsehbar.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-d466783\" data-id=\"d466783\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-221a9c0 elementor-widget elementor-widget-text-editor\" data-id=\"221a9c0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Ziel war es, mit der <strong>Umsetzung eines Data Warehouses<\/strong> eine zentrale Datenbasis zu bilden, in dem alle Daten der unterschiedlichen Quellsysteme konsolidiert werden und ein <strong>Vergleich der Zahlen<\/strong> wie z.B. Auftragsvolumen und Umsatz f\u00fcr Gesch\u00e4ftsentscheidungen von Praxen und Laboren m\u00f6glich wird. Angebundene Reporting-Tools sollen die Daten f\u00fcr das Financial Controlling \u00fcber das Data Warehouse beziehen.<\/p><p>ZOTZ|KLIMAS\u00a0hatte bereits ein umfangreiches Konzept mit einer entsprechenden Technologiewahl entwickelt und holte f\u00fcr die technische Umsetzung einen erfahrenen Entwickler von Avantgarde Labs in ihr Inhouse-Team.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c36d66a elementor-section-stretched elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c36d66a\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;,&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4187aef\" data-id=\"4187aef\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0ec4ed1 elementor-widget elementor-widget-heading\" data-id=\"0ec4ed1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">L\u00f6sung durch Avantgarde Labs<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-cbeaff0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cbeaff0\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-409c3d0\" data-id=\"409c3d0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dcc5fca elementor-widget elementor-widget-text-editor\" data-id=\"dcc5fca\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Zun\u00e4chst wurden alle <strong>relevanten Datenquellen aus den unterschiedlichen Gesch\u00e4ftsanwendungen<\/strong> der Praxen und Laboren in einer Data Staging-Area integriert. Mittels ETL-Prozesse wurden die internen und externen Daten aus den unterschiedlichen Quellen extrahiert, bereinigt, nach Bedarf transformiert und aggregiert in ein Data Warehouse basierend auf MS SQL \u00fcberf\u00fchrt.<\/p><p>Die im Data Warehouse gespeicherten Daten wurden in Relation zu den gew\u00fcnschten Referenzinformationen gesetzt, um sp\u00e4ter per Reporting-Tools die entsprechenden betriebswirtschaftlichen Kennzahlen anhand verschiedener Aspekte <strong>mehrdimensional analysieren<\/strong> zu k\u00f6nnen.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-2b02296\" data-id=\"2b02296\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2fe8ef9 elementor-widget elementor-widget-text-editor\" data-id=\"2fe8ef9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">F\u00fcr die Datenauswertungen und -analysen wurden die Reporting-Tools von Drittanbietern an das Data Warehouse angebunden.\u00a0\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Zudem wurden kreditorische und debitorische Systeme angebunden, damit alle Auftr\u00e4ge f\u00fcr die Kosten- und Gewinnverteilung der beiden Unternehmenszweige abgebildet werden k\u00f6nnen. Die Anbindung eines Warenwirtschafts- und Personalwirtschaftssystems ist bereits in Planung und soll zu einem sp\u00e4teren Zeitpunkt ebenfalls angebunden werden.\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-83d57d4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"83d57d4\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-121c4b1\" data-id=\"121c4b1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9d5a7c1 elementor-widget elementor-widget-heading\" data-id=\"9d5a7c1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Projektergebnis &amp; Kundennutzen<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-0dc9770 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0dc9770\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-0343fd2\" data-id=\"0343fd2\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-758412f elementor-widget elementor-widget-text-editor\" data-id=\"758412f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Durch den Einsatz eines Data Warehouses konnten bei ZOTZ|KLIMAS erstmalig <strong>Datenfl\u00fcsse<\/strong> aus den Gesch\u00e4ftsanwendungen der Praxen und Labors <strong>vollst\u00e4ndig nachvollziehbar und transparent abgebildet<\/strong> werden.<\/p><p><span style=\"font-weight: 400;\">Das Unternehmen\u00a0konnte <strong>einheitliche Reportings<\/strong> \u00fcber beide Unternehmenszweige erstellen und entsprechende <strong>Optimierungen in Gesch\u00e4ftsentscheidungen<\/strong> durchf\u00fchren. <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-18e0dcd\" data-id=\"18e0dcd\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ac7bd46 elementor-widget elementor-widget-text-editor\" data-id=\"ac7bd46\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Zus\u00e4tzlich sind nun wesentliche <strong>Kennzahlen f\u00fcr das Financial Reporting tagesaktuell<\/strong> verf\u00fcgbar.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Data Warehouse Modernisierung f\u00fcr das Financial Controlling von Zotz|Klimas<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"template":"","meta":{"_acf_changed":false,"site-sidebar-layout":"no-sidebar","site-content-layout":"page-builder","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"branche":[240],"solutions":[242,243],"cooperations":[25],"services":[60],"teams":[237],"class_list":["post-8364","case_studies","type-case_studies","status-publish","hentry","branche-gesundheitswesen","solutions-data-integration-services","solutions-data-warehouse","cooperations-time-material","services-data-management","teams-entwickler"],"acf":[],"_links":{"self":[{"href":"https:\/\/avantgarde-labs.com\/de\/wp-json\/wp\/v2\/case_studies\/8364","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/avantgarde-labs.com\/de\/wp-json\/wp\/v2\/case_studies"}],"about":[{"href":"https:\/\/avantgarde-labs.com\/de\/wp-json\/wp\/v2\/types\/case_studies"}],"author":[{"embeddable":true,"href":"https:\/\/avantgarde-labs.com\/de\/wp-json\/wp\/v2\/users\/2"}],"version-history":[{"count":62,"href":"https:\/\/avantgarde-labs.com\/de\/wp-json\/wp\/v2\/case_studies\/8364\/revisions"}],"predecessor-version":[{"id":8531,"href":"https:\/\/avantgarde-labs.com\/de\/wp-json\/wp\/v2\/case_studies\/8364\/revisions\/8531"}],"wp:attachment":[{"href":"https:\/\/avantgarde-labs.com\/de\/wp-json\/wp\/v2\/media?parent=8364"}],"wp:term":[{"taxonomy":"branche","embeddable":true,"href":"https:\/\/avantgarde-labs.com\/de\/wp-json\/wp\/v2\/branche?post=8364"},{"taxonomy":"solutions","embeddable":true,"href":"https:\/\/avantgarde-labs.com\/de\/wp-json\/wp\/v2\/solutions?post=8364"},{"taxonomy":"cooperations","embeddable":true,"href":"https:\/\/avantgarde-labs.com\/de\/wp-json\/wp\/v2\/cooperations?post=8364"},{"taxonomy":"services","embeddable":true,"href":"https:\/\/avantgarde-labs.com\/de\/wp-json\/wp\/v2\/services?post=8364"},{"taxonomy":"teams","embeddable":true,"href":"https:\/\/avantgarde-labs.com\/de\/wp-json\/wp\/v2\/teams?post=8364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}