{"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\/es\/resource\/solucion-de-inteligencia-empresarial-para-la-unificacion-y-el-analisis-historico-de-proyectos-de-construccion\/","title":{"rendered":"Soluci\u00f3n de Business Intelligence para la unificaci\u00f3n y el an\u00e1lisis hist\u00f3rico de proyectos de construcci\u00f3n"},"content":{"rendered":"<h2 style=\"text-align: center;\">Detalles clave<\/h2>\n<p>Soluci\u00f3n de inteligencia empresarial para el an\u00e1lisis unificado de datos de construcci\u00f3n.<\/p>\n<div>\n<ul>\n<li>\n<div>Desaf\u00edo<\/div>\n<div>An\u00e1lisis hol\u00edstico de datos procedentes de m\u00faltiples fuentes aisladas y diversos formatos de datos estructurados y no estructurados.<\/div>\n<\/li>\n<li>\n<div>Soluci\u00f3n<\/div>\n<div>Soluci\u00f3n de inteligencia empresarial para informes y an\u00e1lisis inteligentes en tiempo real<\/div>\n<\/li>\n<li>\n<div>Tecnolog\u00edas y herramientas<\/div>\n<div>PowerBI, Azure, Data Lake, Databricks<\/div>\n<\/li>\n<\/ul>\n<\/div>\n<h2 style=\"text-align: center;\">Cliente<\/h2>\n<p>El cliente es una empresa de gesti\u00f3n de centros de datos conocida en todo el mundo. La empresa necesitaba un <a href=\"http:\/\/localhost\/essidsolutions\/service\/big-data-analytics-services\">soluci\u00f3n robusta de big data<\/a> para permitir un an\u00e1lisis unificado de todos los proyectos de construcci\u00f3n (en curso e hist\u00f3ricos). La funcionalidad presupone el an\u00e1lisis de datos en tiempo real con visualizaci\u00f3n instant\u00e1nea de indicadores clave de rendimiento y gr\u00e1ficos detallados para ofrecer a la direcci\u00f3n una visibilidad multidimensional de todos los proyectos de construcci\u00f3n, el historial de precios y, en \u00faltima instancia, ayudar a tomar decisiones basadas en datos.<\/p>\n<h2 style=\"text-align: center;\">Reto: los datos en formato no estructurado estaban aislados en toda la organizaci\u00f3n, lo que imped\u00eda un an\u00e1lisis hol\u00edstico en tiempo real.<\/h2>\n<p>El problema era que el almacenamiento existente del cliente, as\u00ed como el enfoque para procesar los datos no estructurados en silos, eran ineficaces. La transformaci\u00f3n digital era necesaria para construir una <a href=\"http:\/\/localhost\/essidsolutions\/service\/business-intelligence\">soluci\u00f3n de inteligencia empresarial<\/a> basado en una arquitectura sin servidor de lago de datos para una r\u00e1pida recopilaci\u00f3n de datos y procesamiento en tiempo real. El alcance del proyecto inclu\u00eda los siguientes tipos de datos: documentos de todos los departamentos de cada proyecto, documentos hist\u00f3ricos de Google Workspaces (word, xlsx de dise\u00f1o complejo, pdf y SAP).<\/p>\n<h2 style=\"text-align: center;\">Soluci\u00f3n: un lago de datos sin servidor basado en la plataforma Azure para anal\u00edtica empresarial en tiempo real e informes inteligentes<\/h2>\n<p>Tras analizar los requisitos empresariales del cliente, nuestro equipo de ingenier\u00eda de big data entreg\u00f3 el proyecto en 2 fases: prueba de concepto e implantaci\u00f3n en producci\u00f3n:<\/p>\n<ul>\n<li>Despliegue de un lago de datos centralizado en <a href=\"http:\/\/localhost\/essidsolutions\/service\/azure-data-analytics-services\">Arquitectura sin servidor de Azure<\/a><\/li>\n<li>Ingesta de datos de Google Workspace y SAP<\/li>\n<li>Realizaci\u00f3n de ETL de datos no estructurados <a href=\"http:\/\/localhost\/essidsolutions\/service\/databricks-managed-services\">utilizando Azure Databricks<\/a><\/li>\n<li>Configurar cuadros de mando empresariales en PowerBI - para permitir una visi\u00f3n hol\u00edstica de los precios de proyectos pasados y futuros, calendario, datos de proveedores, etc.<\/li>\n<\/ul>\n<p>La canalizaci\u00f3n de datos procesa y actualiza cientos de archivos por centro de datos al d\u00eda.<\/p>\n<p>El desarrollo de la soluci\u00f3n de inteligencia empresarial inteligente llev\u00f3 2 semanas para la PoC y 2 meses para la producci\u00f3n en directo.<\/p>\n<p>Eche un vistazo a la arquitectura de la soluci\u00f3n desarrollada para entender c\u00f3mo se procesaron los datos:<\/p>\n<p><img alt=\"Soluci\u00f3n de inteligencia empresarial\" 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>Durante el trabajo, ingestamos, almacenamos, procesamos y visualizamos datos de diversas fuentes.<\/p>\n<p><img alt=\"Soluci\u00f3n de inteligencia empresarial\" 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;\">Resultado: informes en tiempo real con BI<\/h2>\n<p>Durante el proyecto, nuestro equipo de cient\u00edficos e ingenieros de datos realiz\u00f3 <a href=\"http:\/\/localhost\/essidsolutions\/service\/big-data-development\">Desarrollo de Big Data<\/a>.<\/p>\n<p>Como resultado, hemos desarrollado una soluci\u00f3n de inteligencia empresarial personalizada para unificar y analizar los datos hist\u00f3ricos de los proyectos de construcci\u00f3n utilizando los datos aislados de la empresa del cliente. Ahora, gracias a nuestra soluci\u00f3n tecnol\u00f3gica, el cliente puede tomar decisiones empresariales basadas en datos y respaldadas por el an\u00e1lisis de masas de datos agregados de diversas fuentes en un informe actualizado basado en datos relevantes.<\/p>","protected":false},"excerpt":{"rendered":"<p>Detalles clave Soluci\u00f3n de inteligencia empresarial para el an\u00e1lisis unificado de datos de construcci\u00f3n. Reto An\u00e1lisis hol\u00edstico de datos a partir de m\u00faltiples fuentes aisladas y diversos formatos de datos estructurados y no estructurados Soluci\u00f3n Soluci\u00f3n de inteligencia empresarial para informes y an\u00e1lisis inteligentes en tiempo real Tecnolog\u00edas y herramientas PowerBI, Azure, Data Lake, Databricks Cliente El cliente es una empresa de gesti\u00f3n de centros de datos conocida en todo el mundo. La empresa ... Leer m\u00e1s <a title=\"Soluci\u00f3n de Business Intelligence para la unificaci\u00f3n y el an\u00e1lisis hist\u00f3rico de proyectos de construcci\u00f3n\" class=\"read-more\" href=\"https:\/\/esisoc.com\/es\/resource\/solucion-de-inteligencia-empresarial-para-la-unificacion-y-el-analisis-historico-de-proyectos-de-construccion\/\" aria-label=\"Leer m\u00e1s sobre Business Intelligence Solution for Unification and Historical Construction Projects Analysis\">Leer m\u00e1s<\/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\/es\/resource\/solucion-de-inteligencia-empresarial-para-la-unificacion-y-el-analisis-historico-de-proyectos-de-construccion\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\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 ... Leer m\u00e1s\" \/>\n<meta property=\"og:url\" content=\"https:\/\/esisoc.com\/es\/resource\/solucion-de-inteligencia-empresarial-para-la-unificacion-y-el-analisis-historico-de-proyectos-de-construccion\/\" \/>\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=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\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\":\"es\",\"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\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/esisoc.com\/#organization\",\"name\":\"ESISOC | ESSID Solutions\",\"url\":\"https:\/\/esisoc.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\/es\/resource\/solucion-de-inteligencia-empresarial-para-la-unificacion-y-el-analisis-historico-de-proyectos-de-construccion\/","og_locale":"es_ES","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 ... Leer m\u00e1s","og_url":"https:\/\/esisoc.com\/es\/resource\/solucion-de-inteligencia-empresarial-para-la-unificacion-y-el-analisis-historico-de-proyectos-de-construccion\/","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":{"Tiempo de lectura":"2 minutos"},"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":"es","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":"es"},{"@type":"Organization","@id":"https:\/\/esisoc.com\/#organization","name":"ESISOC | ESSID Solutions","url":"https:\/\/esisoc.com\/","logo":{"@type":"ImageObject","inLanguage":"es","@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\/es\/wp-json\/wp\/v2\/resource\/2845"}],"collection":[{"href":"https:\/\/esisoc.com\/es\/wp-json\/wp\/v2\/resource"}],"about":[{"href":"https:\/\/esisoc.com\/es\/wp-json\/wp\/v2\/types\/resource"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/esisoc.com\/es\/wp-json\/wp\/v2\/media\/2846"}],"wp:attachment":[{"href":"https:\/\/esisoc.com\/es\/wp-json\/wp\/v2\/media?parent=2845"}],"wp:term":[{"taxonomy":"industry","embeddable":true,"href":"https:\/\/esisoc.com\/es\/wp-json\/wp\/v2\/industry?post=2845"},{"taxonomy":"expertise","embeddable":true,"href":"https:\/\/esisoc.com\/es\/wp-json\/wp\/v2\/expertise?post=2845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}