{"id":2845,"date":"2024-02-18T15:29:24","date_gmt":"2024-02-18T15:29:24","guid":{"rendered":"https:\/\/esisoc.com\/resource\/business-intelligence-solution-for-unification-and-historical-construction-projects-analysis\/"},"modified":"2024-02-18T15:29:24","modified_gmt":"2024-02-18T15:29:24","slug":"business-intelligence-solution-for-unification-and-historical-construction-projects-analysis","status":"publish","type":"resource","link":"https:\/\/esisoc.com\/de\/resource\/business-intelligence-losung-fur-die-vereinheitlichung-und-analyse-historischer-bauprojekte\/","title":{"rendered":"Business Intelligence-L\u00f6sung f\u00fcr die Vereinheitlichung und Analyse historischer Bauprojekte"},"content":{"rendered":"<h2 style=\"text-align: center;\">Wichtige Details<\/h2>\n<p>Business-Intelligence-L\u00f6sung f\u00fcr die einheitliche Analyse von Baudaten.<\/p>\n<div>\n<ul>\n<li>\n<div>Herausforderung<\/div>\n<div>Ganzheitliche Datenanalyse aus mehreren isolierten Quellen und verschiedenen strukturierten und unstrukturierten Datenformaten<\/div>\n<\/li>\n<li>\n<div>L\u00f6sung<\/div>\n<div>Business Intelligence-L\u00f6sung f\u00fcr intelligente Berichte und Analysen in Echtzeit<\/div>\n<\/li>\n<li>\n<div>Technologien und Werkzeuge<\/div>\n<div>PowerBI, Azure, Datensee, Databricks<\/div>\n<\/li>\n<\/ul>\n<\/div>\n<h2 style=\"text-align: center;\">Kunde<\/h2>\n<p>Der Kunde ist ein weltweit bekanntes Unternehmen f\u00fcr die Verwaltung von Rechenzentren. Das Unternehmen ben\u00f6tigte einen <a href=\"http:\/\/localhost\/essidsolutions\/service\/big-data-analytics-services\">robuste Big-Data-L\u00f6sung<\/a> um eine einheitliche Analyse aller Bauprojekte (der laufenden und historischen) zu erm\u00f6glichen. Die Funktionalit\u00e4t setzt eine Echtzeit-Analyse der Daten mit sofortiger Visualisierung detaillierter KPIs und Diagramme voraus, um das Management mit mehrdimensionaler Transparenz \u00fcber alle Bauprojekte und die Preisgestaltung zu unterst\u00fctzen und letztlich datengesteuerte Entscheidungen zu treffen.<\/p>\n<h2 style=\"text-align: center;\">Die Herausforderung: Daten in unstrukturiertem Format waren in der gesamten Organisation isoliert, so dass eine ganzheitliche Echtzeitanalyse nicht m\u00f6glich war.<\/h2>\n<p>Das Problem bestand darin, dass die bestehende Speicherung des Kunden sowie der Ansatz zur Verarbeitung unstrukturierter, siloartiger Daten ineffizient waren. Die digitale Transformation war erforderlich, um eine <a href=\"http:\/\/localhost\/essidsolutions\/service\/business-intelligence\">Business-Intelligence-L\u00f6sung<\/a> basierend auf einer serverlosen Data-Lake-Architektur f\u00fcr schnelle Datenerfassung und Echtzeitverarbeitung. Der Projektumfang umfasste die folgenden Datentypen: Dokumente aus allen Abteilungen zu jedem Projekt, historische Dokumente aus Google Workspaces (Word, komplexes Layout xlsx, pdf und SAP).<\/p>\n<h2 style=\"text-align: center;\">L\u00f6sung: ein Data Lake ohne Server auf der Azure-Plattform f\u00fcr Echtzeit-Gesch\u00e4ftsanalysen und intelligentes Reporting<\/h2>\n<p>Nach der Analyse der Gesch\u00e4ftsanforderungen des Kunden lieferte unser Big-Data-Engineering-Team das Projekt in 2 Phasen: Proof on Concept und Produktionseinsatz:<\/p>\n<ul>\n<li>Bereitstellung eines zentralisierten Data Lake auf <a href=\"http:\/\/localhost\/essidsolutions\/service\/azure-data-analytics-services\">Azure serverlose Architektur<\/a><\/li>\n<li>Eingespielte Daten aus Google Workspace und SAP<\/li>\n<li>Durchf\u00fchrung von ETL f\u00fcr unstrukturierte Daten <a href=\"http:\/\/localhost\/essidsolutions\/service\/databricks-managed-services\">mit Azure Databricks<\/a><\/li>\n<li>Einrichten von Unternehmens-Dashboards in PowerBI - f\u00fcr einen ganzheitlichen \u00dcberblick \u00fcber die Preisgestaltung vergangener und anstehender Projekte, Zeitpl\u00e4ne, Lieferantendaten usw.<\/li>\n<\/ul>\n<p>Die Datenpipeline verarbeitet und aktualisiert t\u00e4glich Hunderte von Dateien pro Rechenzentrum.<\/p>\n<p>Die Entwicklung der intelligenten Business-Intelligence-L\u00f6sung dauerte 2 Wochen f\u00fcr den PoC und 2 Monate f\u00fcr die Live-Produktion.<\/p>\n<p>Schauen Sie sich die entwickelte L\u00f6sungsarchitektur genauer an, um zu verstehen, wie die Daten verarbeitet wurden:<\/p>\n<p><img alt=\"Business Intelligence-L\u00f6sung\" decoding=\"async\" height=\"242\" loading=\"lazy\" src=\"https:\/\/essidsolutions.com\/wp-content\/uploads\/2022\/01\/case-study-bi-solution-graphic.png\" width=\"1000\"\/><\/p>\n<p>W\u00e4hrend unserer Arbeit haben wir Daten aus verschiedenen Quellen aufgenommen, gespeichert, verarbeitet und visualisiert.<\/p>\n<p><img alt=\"Business Intelligence-L\u00f6sung\" decoding=\"async\" height=\"304\" loading=\"lazy\" src=\"https:\/\/essidsolutions.com\/wp-content\/uploads\/2022\/01\/case-study-bi-solution-tech-architecture-data-centers.png\" width=\"1000\"\/><\/p>\n<h2 style=\"text-align: center;\">Ergebnis: Echtzeit-Berichterstattung mit BI<\/h2>\n<p>W\u00e4hrend des Projekts f\u00fchrte unser Team von Datenwissenschaftlern und Ingenieuren Folgendes durch <a href=\"http:\/\/localhost\/essidsolutions\/service\/big-data-development\">Entwicklung von Big Data<\/a>.<\/p>\n<p>Daraufhin haben wir eine ma\u00dfgeschneiderte Business-Intelligence-L\u00f6sung entwickelt, um die Daten historischer Bauprojekte zu vereinheitlichen und zu analysieren, indem wir die siloartigen Daten des Unternehmens des Kunden nutzen. Mit unserer technischen L\u00f6sung kann der Kunde nun datengest\u00fctzte Gesch\u00e4ftsentscheidungen treffen, die durch die Analyse von Datenmassen aus verschiedenen Quellen in einem aktuellen Bericht auf der Grundlage relevanter Daten unterst\u00fctzt werden.<\/p>","protected":false},"excerpt":{"rendered":"<p>Key Details Business-Intelligence-L\u00f6sung f\u00fcr die einheitliche Analyse von Baudaten. Herausforderung Ganzheitliche Datenanalyse aus mehreren siloartigen Quellen und verschiedenen strukturierten und unstrukturierten Datenformaten L\u00f6sung Business-Intelligence-L\u00f6sung f\u00fcr intelligente Berichte und Analysen in Echtzeit Technologien und Tools PowerBI, Azure, Data Lake, Databricks Kunde Der Kunde ist ein weltweit bekanntes Unternehmen f\u00fcr die Verwaltung von Rechenzentren. Das Unternehmen ... Weiterlesen ... <a title=\"Business Intelligence-L\u00f6sung f\u00fcr die Vereinheitlichung und Analyse historischer Bauprojekte\" class=\"read-more\" href=\"https:\/\/esisoc.com\/de\/resource\/business-intelligence-losung-fur-die-vereinheitlichung-und-analyse-historischer-bauprojekte\/\" aria-label=\"Mehr Informationen \u00fcber Business Intelligence Solution for Unification and Historical Construction Projects Analysis\">Weiterlesen &#8230;<\/a><\/p>","protected":false},"featured_media":2846,"template":"","industry":[63],"expertise":[64,65,66],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.9 (Yoast SEO v21.9.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Business Intelligence Solution for Unification and Historical Construction Projects Analysis - ESISOC | ESSID Solutions<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/esisoc.com\/de\/resource\/business-intelligence-losung-fur-die-vereinheitlichung-und-analyse-historischer-bauprojekte\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Business Intelligence Solution for Unification and Historical Construction Projects Analysis\" \/>\n<meta property=\"og:description\" content=\"Key Details Business intelligence solution for unified construction data analytics. Challenge Holistic data analysis from multiple siloed sources and various structured and unstructured data formats Solution Business intelligence solution for real-time smart reporting and analytics Technologies and tools PowerBI, Azure, Data Lake, Databricks Client The client is a world-known data center management company. The company ... Weiterlesen ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/esisoc.com\/de\/resource\/business-intelligence-losung-fur-die-vereinheitlichung-und-analyse-historischer-bauprojekte\/\" \/>\n<meta property=\"og:site_name\" content=\"ESISOC | ESSID Solutions\" \/>\n<meta property=\"og:image\" content=\"https:\/\/esisoc.com\/wp-content\/uploads\/2024\/02\/75e1c91b959942dcab353a21e2868e02.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"839\" \/>\n\t<meta property=\"og:image:height\" content=\"514\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"2\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/esisoc.com\/resource\/business-intelligence-solution-for-unification-and-historical-construction-projects-analysis\/\",\"url\":\"https:\/\/esisoc.com\/resource\/business-intelligence-solution-for-unification-and-historical-construction-projects-analysis\/\",\"name\":\"Business Intelligence Solution for Unification and Historical Construction Projects Analysis - ESISOC | ESSID Solutions\",\"isPartOf\":{\"@id\":\"https:\/\/esisoc.com\/#website\"},\"datePublished\":\"2024-02-18T15:29:24+00:00\",\"dateModified\":\"2024-02-18T15:29:24+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/esisoc.com\/resource\/business-intelligence-solution-for-unification-and-historical-construction-projects-analysis\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/esisoc.com\/resource\/business-intelligence-solution-for-unification-and-historical-construction-projects-analysis\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/esisoc.com\/resource\/business-intelligence-solution-for-unification-and-historical-construction-projects-analysis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/esisoc.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Business Intelligence Solution for Unification and Historical Construction Projects Analysis\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/esisoc.com\/#website\",\"url\":\"https:\/\/esisoc.com\/\",\"name\":\"ESISOC | ESSID Solutions\",\"description\":\"Data Science Consulting and AI | Online Books, Videos, Courses and more\",\"publisher\":{\"@id\":\"https:\/\/esisoc.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/esisoc.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/esisoc.com\/#organization\",\"name\":\"ESISOC | ESSID Solutions\",\"url\":\"https:\/\/esisoc.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/esisoc.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/esisoc.com\/wp-content\/uploads\/2024\/02\/logo-esisoc.png\",\"contentUrl\":\"https:\/\/esisoc.com\/wp-content\/uploads\/2024\/02\/logo-esisoc.png\",\"width\":350,\"height\":63,\"caption\":\"ESISOC | ESSID Solutions\"},\"image\":{\"@id\":\"https:\/\/esisoc.com\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Business Intelligence Solution for Unification and Historical Construction Projects Analysis - ESISOC | ESSID Solutions","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:\/\/esisoc.com\/de\/resource\/business-intelligence-losung-fur-die-vereinheitlichung-und-analyse-historischer-bauprojekte\/","og_locale":"de_DE","og_type":"article","og_title":"Business Intelligence Solution for Unification and Historical Construction Projects Analysis","og_description":"Key Details Business intelligence solution for unified construction data analytics. Challenge Holistic data analysis from multiple siloed sources and various structured and unstructured data formats Solution Business intelligence solution for real-time smart reporting and analytics Technologies and tools PowerBI, Azure, Data Lake, Databricks Client The client is a world-known data center management company. The company ... Weiterlesen ...","og_url":"https:\/\/esisoc.com\/de\/resource\/business-intelligence-losung-fur-die-vereinheitlichung-und-analyse-historischer-bauprojekte\/","og_site_name":"ESISOC | ESSID Solutions","og_image":[{"width":839,"height":514,"url":"https:\/\/esisoc.com\/wp-content\/uploads\/2024\/02\/75e1c91b959942dcab353a21e2868e02.webp","type":"image\/webp"}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"2\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/esisoc.com\/resource\/business-intelligence-solution-for-unification-and-historical-construction-projects-analysis\/","url":"https:\/\/esisoc.com\/resource\/business-intelligence-solution-for-unification-and-historical-construction-projects-analysis\/","name":"Business Intelligence Solution for Unification and Historical Construction Projects Analysis - ESISOC | ESSID Solutions","isPartOf":{"@id":"https:\/\/esisoc.com\/#website"},"datePublished":"2024-02-18T15:29:24+00:00","dateModified":"2024-02-18T15:29:24+00:00","breadcrumb":{"@id":"https:\/\/esisoc.com\/resource\/business-intelligence-solution-for-unification-and-historical-construction-projects-analysis\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/esisoc.com\/resource\/business-intelligence-solution-for-unification-and-historical-construction-projects-analysis\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/esisoc.com\/resource\/business-intelligence-solution-for-unification-and-historical-construction-projects-analysis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/esisoc.com\/"},{"@type":"ListItem","position":2,"name":"Business Intelligence Solution for Unification and Historical Construction Projects Analysis"}]},{"@type":"WebSite","@id":"https:\/\/esisoc.com\/#website","url":"https:\/\/esisoc.com\/","name":"ESISOC | ESSID Solutions","description":"Data Science Consulting and AI | Online Books, Videos, Courses and more","publisher":{"@id":"https:\/\/esisoc.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/esisoc.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/esisoc.com\/#organization","name":"ESISOC | ESSID Solutions","url":"https:\/\/esisoc.com\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/esisoc.com\/#\/schema\/logo\/image\/","url":"https:\/\/esisoc.com\/wp-content\/uploads\/2024\/02\/logo-esisoc.png","contentUrl":"https:\/\/esisoc.com\/wp-content\/uploads\/2024\/02\/logo-esisoc.png","width":350,"height":63,"caption":"ESISOC | ESSID Solutions"},"image":{"@id":"https:\/\/esisoc.com\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/esisoc.com\/de\/wp-json\/wp\/v2\/resource\/2845"}],"collection":[{"href":"https:\/\/esisoc.com\/de\/wp-json\/wp\/v2\/resource"}],"about":[{"href":"https:\/\/esisoc.com\/de\/wp-json\/wp\/v2\/types\/resource"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/esisoc.com\/de\/wp-json\/wp\/v2\/media\/2846"}],"wp:attachment":[{"href":"https:\/\/esisoc.com\/de\/wp-json\/wp\/v2\/media?parent=2845"}],"wp:term":[{"taxonomy":"industry","embeddable":true,"href":"https:\/\/esisoc.com\/de\/wp-json\/wp\/v2\/industry?post=2845"},{"taxonomy":"expertise","embeddable":true,"href":"https:\/\/esisoc.com\/de\/wp-json\/wp\/v2\/expertise?post=2845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}