{"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\/fr\/resource\/solution-de-veille-strategique-pour-lunification-et-lanalyse-historique-des-projets-de-construction\/","title":{"rendered":"Solution de veille strat\u00e9gique pour l'unification et l'analyse historique des projets de construction"},"content":{"rendered":"<h2 style=\"text-align: center;\">D\u00e9tails cl\u00e9s<\/h2>\n<p>Solution d'intelligence \u00e9conomique pour l'analyse unifi\u00e9e des donn\u00e9es de construction.<\/p>\n<div>\n<ul>\n<li>\n<div>D\u00e9fi<\/div>\n<div>Analyse holistique de donn\u00e9es provenant de multiples sources cloisonn\u00e9es et de divers formats de donn\u00e9es structur\u00e9es et non structur\u00e9es<\/div>\n<\/li>\n<li>\n<div>Solution<\/div>\n<div>Solution de veille strat\u00e9gique pour des rapports et des analyses intelligents en temps r\u00e9el<\/div>\n<\/li>\n<li>\n<div>Technologies et outils<\/div>\n<div>PowerBI, Azure, Data Lake, Databricks<\/div>\n<\/li>\n<\/ul>\n<\/div>\n<h2 style=\"text-align: center;\">Client<\/h2>\n<p>Le client est une soci\u00e9t\u00e9 de gestion de centres de donn\u00e9es de renomm\u00e9e mondiale. L'entreprise avait besoin d'un <a href=\"http:\/\/localhost\/essidsolutions\/service\/big-data-analytics-services\">solution robuste de big data<\/a> pour permettre une analyse unifi\u00e9e de tous les projets de construction (en cours et historiques). La fonctionnalit\u00e9 suppose une analyse en temps r\u00e9el des donn\u00e9es avec une visualisation instantan\u00e9e des KPI d\u00e9taill\u00e9s et des graphiques pour soutenir la gestion avec une visibilit\u00e9 multidimensionnelle sur tous les projets de construction, l'historique des prix et, en fin de compte, aider \u00e0 prendre des d\u00e9cisions fond\u00e9es sur des donn\u00e9es.<\/p>\n<h2 style=\"text-align: center;\">D\u00e9fi : les donn\u00e9es non structur\u00e9es \u00e9taient cloisonn\u00e9es dans l'ensemble de l'organisation, ce qui rendait impossible une analyse holistique en temps r\u00e9el.<\/h2>\n<p>Le probl\u00e8me \u00e9tait que le stockage existant du client ainsi que l'approche du traitement des donn\u00e9es non structur\u00e9es en silos \u00e9taient inefficaces. La transformation num\u00e9rique \u00e9tait n\u00e9cessaire pour construire une <a href=\"http:\/\/localhost\/essidsolutions\/service\/business-intelligence\">solution d'intelligence \u00e9conomique<\/a> bas\u00e9 sur l'architecture sans serveur du lac de donn\u00e9es pour une collecte rapide des donn\u00e9es et un traitement en temps r\u00e9el. La port\u00e9e du projet supposait les types de donn\u00e9es suivants : documents de tous les d\u00e9partements sur chaque projet, documents historiques de Google Workspaces (word, complex layout xlsx, pdf et SAP).<\/p>\n<h2 style=\"text-align: center;\">Solution : un lac de donn\u00e9es sans serveur bas\u00e9 sur la plateforme Azure pour des analyses commerciales en temps r\u00e9el et des rapports intelligents.<\/h2>\n<p>Apr\u00e8s avoir analys\u00e9 les besoins du client, notre \u00e9quipe d'ing\u00e9nieurs big data a r\u00e9alis\u00e9 le projet en deux phases : validation du concept et d\u00e9ploiement de la production :<\/p>\n<ul>\n<li>D\u00e9ploiement d'un lac de donn\u00e9es centralis\u00e9 sur <a href=\"http:\/\/localhost\/essidsolutions\/service\/azure-data-analytics-services\">Architecture sans serveur Azure<\/a><\/li>\n<li>Donn\u00e9es ing\u00e9r\u00e9es \u00e0 partir de Google Workspace et de SAP<\/li>\n<li>R\u00e9alisation de l'ETL de donn\u00e9es non structur\u00e9es <a href=\"http:\/\/localhost\/essidsolutions\/service\/databricks-managed-services\">utiliser Azure Databricks<\/a><\/li>\n<li>Mise en place de tableaux de bord dans PowerBI - pour permettre une vision globale de la tarification des projets pass\u00e9s et \u00e0 venir, du calendrier, des donn\u00e9es sur les fournisseurs, etc.<\/li>\n<\/ul>\n<p>Le pipeline de donn\u00e9es traite et met \u00e0 jour des centaines de fichiers par centre de donn\u00e9es et par jour.<\/p>\n<p>Le d\u00e9veloppement de la solution de veille strat\u00e9gique a pris 2 semaines pour le PoC et 2 mois pour la production en direct.<\/p>\n<p>Examinez de plus pr\u00e8s l'architecture de la solution d\u00e9velopp\u00e9e pour comprendre comment les donn\u00e9es ont \u00e9t\u00e9 trait\u00e9es :<\/p>\n<p><img alt=\"Solution de veille strat\u00e9gique\" 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>Au cours de ce travail, nous avons ing\u00e9r\u00e9, stock\u00e9, trait\u00e9 et visualis\u00e9 des donn\u00e9es provenant de diverses sources.<\/p>\n<p><img alt=\"Solution de veille strat\u00e9gique\" 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;\">R\u00e9sultat : des rapports en temps r\u00e9el gr\u00e2ce \u00e0 la BI<\/h2>\n<p>Au cours du projet, notre \u00e9quipe de data scientists et d'ing\u00e9nieurs a r\u00e9alis\u00e9 <a href=\"http:\/\/localhost\/essidsolutions\/service\/big-data-development\">D\u00e9veloppement du Big Data<\/a>.<\/p>\n<p>En cons\u00e9quence, nous avons d\u00e9velopp\u00e9 une solution de business intelligence personnalis\u00e9e pour unifier et analyser les donn\u00e9es historiques des projets de construction en utilisant les donn\u00e9es cloisonn\u00e9es de l'entreprise du client. D\u00e9sormais, gr\u00e2ce \u00e0 notre solution technologique, le client peut prendre des d\u00e9cisions commerciales fond\u00e9es sur des donn\u00e9es, en s'appuyant sur l'analyse de masses de donn\u00e9es agr\u00e9g\u00e9es \u00e0 partir de diverses sources, dans un rapport actualis\u00e9 bas\u00e9 sur des donn\u00e9es pertinentes.<\/p>","protected":false},"excerpt":{"rendered":"<p>D\u00e9tails cl\u00e9s Solution de Business Intelligence pour l'analyse unifi\u00e9e des donn\u00e9es de construction. D\u00e9fi Analyse holistique des donn\u00e9es provenant de multiples sources cloisonn\u00e9es et de divers formats de donn\u00e9es structur\u00e9es et non structur\u00e9es Solution Solution de Business Intelligence pour le reporting et l'analyse intelligents en temps r\u00e9el Technologies et outils PowerBI, Azure, Data Lake, Databricks Client Le client est une soci\u00e9t\u00e9 de gestion de centres de donn\u00e9es de renomm\u00e9e mondiale. L'entreprise ... Lire plus <a title=\"Solution de veille strat\u00e9gique pour l&#039;unification et l&#039;analyse historique des projets de construction\" class=\"read-more\" href=\"https:\/\/esisoc.com\/fr\/resource\/solution-de-veille-strategique-pour-lunification-et-lanalyse-historique-des-projets-de-construction\/\" aria-label=\"Read more about Business Intelligence Solution for Unification and Historical Construction Projects Analysis\">Lire plus<\/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\/fr\/resource\/solution-de-veille-strategique-pour-lunification-et-lanalyse-historique-des-projets-de-construction\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\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 ... Lire plus\" \/>\n<meta property=\"og:url\" content=\"https:\/\/esisoc.com\/fr\/resource\/solution-de-veille-strategique-pour-lunification-et-lanalyse-historique-des-projets-de-construction\/\" \/>\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=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\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\":\"fr-FR\",\"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\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/esisoc.com\/#organization\",\"name\":\"ESISOC | ESSID Solutions\",\"url\":\"https:\/\/esisoc.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@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\/fr\/resource\/solution-de-veille-strategique-pour-lunification-et-lanalyse-historique-des-projets-de-construction\/","og_locale":"fr_FR","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 ... Lire plus","og_url":"https:\/\/esisoc.com\/fr\/resource\/solution-de-veille-strategique-pour-lunification-et-lanalyse-historique-des-projets-de-construction\/","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":{"Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"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":"fr-FR","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":"fr-FR"},{"@type":"Organization","@id":"https:\/\/esisoc.com\/#organization","name":"ESISOC | ESSID Solutions","url":"https:\/\/esisoc.com\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@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\/fr\/wp-json\/wp\/v2\/resource\/2845"}],"collection":[{"href":"https:\/\/esisoc.com\/fr\/wp-json\/wp\/v2\/resource"}],"about":[{"href":"https:\/\/esisoc.com\/fr\/wp-json\/wp\/v2\/types\/resource"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/esisoc.com\/fr\/wp-json\/wp\/v2\/media\/2846"}],"wp:attachment":[{"href":"https:\/\/esisoc.com\/fr\/wp-json\/wp\/v2\/media?parent=2845"}],"wp:term":[{"taxonomy":"industry","embeddable":true,"href":"https:\/\/esisoc.com\/fr\/wp-json\/wp\/v2\/industry?post=2845"},{"taxonomy":"expertise","embeddable":true,"href":"https:\/\/esisoc.com\/fr\/wp-json\/wp\/v2\/expertise?post=2845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}