{"id":8409,"date":"2022-06-21T15:37:44","date_gmt":"2022-06-21T13:37:44","guid":{"rendered":"https:\/\/avantgarde-labs.com\/?post_type=case_studies&#038;p=8409"},"modified":"2022-09-09T10:25:12","modified_gmt":"2022-09-09T08:25:12","slug":"konzeption-entwicklung-eines-data-warehouse-bei-opseo","status":"publish","type":"case_studies","link":"https:\/\/avantgarde-labs.com\/de\/case-studies\/konzeption-entwicklung-eines-data-warehouse-bei-opseo\/","title":{"rendered":"Konzeption &#038; Entwicklung eines Data Warehouse bei Opseo"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"8409\" class=\"elementor elementor-8409\" 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>Die 2013 gegr\u00fcndete Opseo Gruppe vereint deutschlandweit mittelst\u00e4ndische Pflegeunternehmen zu einer auf die au\u00dferklinische Intensivpflege spezialisierten Pflegegruppe. Die Tochtergesellschaften versorgen deutschlandweit aktuell 1400 Intensivpatienten jeden Alters, sowohl in der H\u00e4uslichkeit, in ambulant betreuten Wohngemeinschaften, als auch in station\u00e4ren Pflegeeinrichtungen.<\/p><p>Die f\u00fcr das Reporting <strong>notwendigen Daten<\/strong> wie z.B. Vertr\u00e4ge mit Krankenkassen, Patientendaten, Personaldaten aller Pflegedienste, Kapazit\u00e4ten f\u00fcr Patienten pro Pflegedienstleister, Budget und Finanzdaten wurden <strong>bisher in Excel-Listen <\/strong>gef\u00fchrt.\u00a0<\/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>F\u00fcr die Pflege der Daten war ein <strong>hoher zeitlicher und manueller Aufwand<\/strong> notwendig. Ebenso erfolgte das Reporting in Form von Excel-Darstellungen.<\/p><p>Um sich digital besser positionieren zu k\u00f6nnen, entschied sich Opseo f\u00fcr die <strong>Umsetzung eines Data Warehouses<\/strong> und der Anbindung eines Analyse-Dienstes, um unterschiedliche Reportings und Dashboards f\u00fcr definierte Nutzergruppen erstellen 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\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>Avantgarde Labs \u00fcbernahm die <strong>vollst\u00e4ndige Beratung, Planung und Umsetzung des Projektes zur Umsetzung des Data Warehouses<\/strong> und einer Dashboarding\/Reporting-L\u00f6sung. Da Opseo noch keine Technologie-Vorauswahl getroffen hatte, konnte Avantgarde Labs aus seinem breiten Technologie-Stack die individuell passenden Technologien w\u00e4hlen.<\/p><p>In der <strong>Beratungs- und Konzeptionierungsphase<\/strong> wurden mit Opseo die zahlreichen Datenquellen identifiziert, welche im Data Warehouse integriert werden sollen und in welcher Relation diese jeweils zueinanderstehen. F\u00fcr das DWH wurde eine MS Azure SQL Datenbank gew\u00e4hlt.<\/p><p>In der <strong>Umsetzungsphase<\/strong> wurden initial alle relevanten internen und externen Daten aus den unterschiedlichen Gesch\u00e4ftsanwendungen mittels einem vom Opseo\u2019s Rechenzentrum entwickelten Export-Tool extrahiert und qualit\u00e4tsgesichert.\u00a0<\/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>Die Integration der Daten in die Data Staging Area und die Entwicklung von \u00fcber 50 ETL-Prozessen in MS Azure Data Factory f\u00fcr die Bereinigung und Transformationen der Daten und deren Aggregation erfolgte direkt bei Avantgarde Labs.<\/p><p>Nach 6 Monaten erfolgte der Umzug des Data Warehouses in die Opseo Cloud.\u00a0F\u00fcr die <strong>Datenauswertungen und -analysen<\/strong> in Reportings und Dashboards wurde PowerBI gew\u00e4hlt.<\/p><p>Eine der gr\u00f6\u00dften Herausforderung im Datenmodell war die <strong>Umsetzung eines komplexen Berechtigungsmodells<\/strong> f\u00fcr die internen und externen Nutzergruppen, um dem sehr hohen Anspruch an Datenschutz f\u00fcr die sensiblen Daten Rechnung zu tragen. Das Berechtigungskonzept im PowerBI f\u00fcr die Erstellung von Dashboards und Reportings wurde aus der Azure Cloud \u00fcbernommen.<\/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>Mit Hilfe des Data Warehouse und der eingerichteten PowerBI L\u00f6sung haben sowohl die Opseo Gruppe als auch alle vereinten Pflegeunternehmen <b>tagesaktuell Dashboards und Reportings\u00a0<\/b>zur Verf\u00fcgung.<\/p><p>Die<b> Datenqualit\u00e4t und Vollst\u00e4ndigkeit\u00a0<\/b>der Daten konnten, bei einem erheblich gesenkten manuellen Aufwand f\u00fcr die Aktualisierung und Bereitstellung der Daten, iterativ verbessert werden.\u00a0<\/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>M\u00f6gliche fehlerhafte Daten sind in den Reports direkt erkennbar und k\u00f6nnen zeitnah in der automatisierten Datenbereitstellung aufbereitet werden.<\/p><p>Jeder Nutzergruppe werden durch das detaillierte Berechtigungsmodell die jeweils f\u00fcr sie relevanten Dashboard und Reports zur Verf\u00fcgung gestellt, um <b>verbesserte Gesch\u00e4ftsentscheidungen<\/b> zu erm\u00f6glichen.<\/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>Aufbau eines Data Warehouse und  PowerBI-Reporting f\u00fcr den Pflegedienstleister Opseo<\/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":[241,242,243],"cooperations":[25],"services":[82,60],"teams":[237,77],"class_list":["post-8409","case_studies","type-case_studies","status-publish","hentry","branche-gesundheitswesen","solutions-business-intelligence","solutions-data-integration-services","solutions-data-warehouse","cooperations-time-material","services-data-analytics","services-data-management","teams-entwickler","teams-projektmanager"],"acf":[],"_links":{"self":[{"href":"https:\/\/avantgarde-labs.com\/de\/wp-json\/wp\/v2\/case_studies\/8409","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":16,"href":"https:\/\/avantgarde-labs.com\/de\/wp-json\/wp\/v2\/case_studies\/8409\/revisions"}],"predecessor-version":[{"id":9213,"href":"https:\/\/avantgarde-labs.com\/de\/wp-json\/wp\/v2\/case_studies\/8409\/revisions\/9213"}],"wp:attachment":[{"href":"https:\/\/avantgarde-labs.com\/de\/wp-json\/wp\/v2\/media?parent=8409"}],"wp:term":[{"taxonomy":"branche","embeddable":true,"href":"https:\/\/avantgarde-labs.com\/de\/wp-json\/wp\/v2\/branche?post=8409"},{"taxonomy":"solutions","embeddable":true,"href":"https:\/\/avantgarde-labs.com\/de\/wp-json\/wp\/v2\/solutions?post=8409"},{"taxonomy":"cooperations","embeddable":true,"href":"https:\/\/avantgarde-labs.com\/de\/wp-json\/wp\/v2\/cooperations?post=8409"},{"taxonomy":"services","embeddable":true,"href":"https:\/\/avantgarde-labs.com\/de\/wp-json\/wp\/v2\/services?post=8409"},{"taxonomy":"teams","embeddable":true,"href":"https:\/\/avantgarde-labs.com\/de\/wp-json\/wp\/v2\/teams?post=8409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}