{"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\/pt\/resource\/solucao-de-business-intelligence-para-unificacao-e-analise-historica-de-projectos-de-construcao\/","title":{"rendered":"Solu\u00e7\u00e3o de Business Intelligence para unifica\u00e7\u00e3o e an\u00e1lise hist\u00f3rica de projectos de constru\u00e7\u00e3o"},"content":{"rendered":"<h2 style=\"text-align: center;\">Principais pormenores<\/h2>\n<p>Solu\u00e7\u00e3o de Business Intelligence para an\u00e1lise unificada de dados de constru\u00e7\u00e3o.<\/p>\n<div>\n<ul>\n<li>\n<div>Desafio<\/div>\n<div>An\u00e1lise hol\u00edstica de dados a partir de m\u00faltiplas fontes isoladas e de v\u00e1rios formatos de dados estruturados e n\u00e3o estruturados<\/div>\n<\/li>\n<li>\n<div>Solu\u00e7\u00e3o<\/div>\n<div>Solu\u00e7\u00e3o de Business Intelligence para relat\u00f3rios e an\u00e1lises inteligentes em tempo real<\/div>\n<\/li>\n<li>\n<div>Tecnologias e ferramentas<\/div>\n<div>PowerBI, Azure, lago de dados, Databricks<\/div>\n<\/li>\n<\/ul>\n<\/div>\n<h2 style=\"text-align: center;\">Cliente<\/h2>\n<p>O cliente \u00e9 uma empresa de gest\u00e3o de centros de dados de renome mundial. A empresa precisava de um <a href=\"http:\/\/localhost\/essidsolutions\/service\/big-data-analytics-services\">solu\u00e7\u00e3o robusta de grandes volumes de dados<\/a> para permitir uma an\u00e1lise unificada de todos os projectos de constru\u00e7\u00e3o (em curso e hist\u00f3ricos). A funcionalidade pressup\u00f5e a an\u00e1lise de dados em tempo real com visualiza\u00e7\u00e3o instant\u00e2nea de KPIs e gr\u00e1ficos detalhados para apoiar a gest\u00e3o com visibilidade multidimensional de todos os projectos de constru\u00e7\u00e3o, hist\u00f3rico de pre\u00e7os e, em \u00faltima an\u00e1lise, ajudar a tomar decis\u00f5es baseadas em dados.<\/p>\n<h2 style=\"text-align: center;\">Desafio: os dados em formato n\u00e3o estruturado estavam isolados em toda a organiza\u00e7\u00e3o, o que impossibilitava uma an\u00e1lise hol\u00edstica em tempo real<\/h2>\n<p>O problema era que o armazenamento existente no cliente, bem como a abordagem para processar dados n\u00e3o estruturados em silos, eram ineficientes. A transforma\u00e7\u00e3o digital era necess\u00e1ria para criar uma <a href=\"http:\/\/localhost\/essidsolutions\/service\/business-intelligence\">solu\u00e7\u00e3o de intelig\u00eancia empresarial<\/a> com base na arquitetura sem servidor do lago de dados para recolha r\u00e1pida de dados e processamento em tempo real. O \u00e2mbito do projeto pressupunha os seguintes tipos de dados: documentos de todos os departamentos em todos os projectos, documentos hist\u00f3ricos do Google Workspaces (word, xlsx de layout complexo, pdf e SAP).<\/p>\n<h2 style=\"text-align: center;\">Solu\u00e7\u00e3o: um lago de dados sem servidor baseado na plataforma Azure para an\u00e1lise empresarial em tempo real e relat\u00f3rios inteligentes<\/h2>\n<p>Depois de analisar os requisitos comerciais do cliente, a nossa equipa de engenharia de grandes volumes de dados entregou o projeto em duas fases: prova de conceito e implementa\u00e7\u00e3o de produ\u00e7\u00e3o:<\/p>\n<ul>\n<li>Implementou um lago de dados centralizado em <a href=\"http:\/\/localhost\/essidsolutions\/service\/azure-data-analytics-services\">Arquitetura sem servidor do Azure<\/a><\/li>\n<li>Dados ingeridos do Google Workspace e do SAP<\/li>\n<li>Efectuou ETL de dados n\u00e3o estruturados <a href=\"http:\/\/localhost\/essidsolutions\/service\/databricks-managed-services\">utilizando o Azure Databricks<\/a><\/li>\n<li>Configurar pain\u00e9is de controlo empresariais no PowerBI - para permitir uma vis\u00e3o hol\u00edstica dos pre\u00e7os de projectos passados e futuros, calend\u00e1rio, dados de fornecedores, etc.<\/li>\n<\/ul>\n<p>O pipeline de dados processa e actualiza centenas de ficheiros por centro de dados e por dia.<\/p>\n<p>O desenvolvimento da solu\u00e7\u00e3o de intelig\u00eancia empresarial inteligente demorou 2 semanas para o PoC e 2 meses para a produ\u00e7\u00e3o em direto.<\/p>\n<p>Analise mais detalhadamente a arquitetura da solu\u00e7\u00e3o desenvolvida para compreender como os dados foram processados:<\/p>\n<p><img alt=\"Solu\u00e7\u00e3o de Business Intelligence\" 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 o trabalho, ingerimos, armazen\u00e1mos, process\u00e1mos e visualiz\u00e1mos dados de v\u00e1rias fontes.<\/p>\n<p><img alt=\"Solu\u00e7\u00e3o de Business Intelligence\" 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: relat\u00f3rios em tempo real com BI<\/h2>\n<p>Durante o projeto, a nossa equipa de cientistas e engenheiros de dados realizou <a href=\"http:\/\/localhost\/essidsolutions\/service\/big-data-development\">Desenvolvimento de grandes volumes de dados<\/a>.<\/p>\n<p>Como resultado, desenvolvemos uma solu\u00e7\u00e3o de Business Intelligence personalizada para unificar e analisar dados hist\u00f3ricos de projectos de constru\u00e7\u00e3o utilizando os dados isolados da empresa do cliente. Agora, utilizando a nossa solu\u00e7\u00e3o tecnol\u00f3gica, o cliente pode tomar decis\u00f5es comerciais baseadas em dados, apoiadas pela an\u00e1lise de grandes quantidades de dados agregados de v\u00e1rias fontes num relat\u00f3rio atualizado baseado em dados relevantes.<\/p>","protected":false},"excerpt":{"rendered":"<p>Detalhes principais Solu\u00e7\u00e3o de Business Intelligence para an\u00e1lise unificada de dados de constru\u00e7\u00e3o. Desafio An\u00e1lise hol\u00edstica de dados de v\u00e1rias fontes em silos e v\u00e1rios formatos de dados estruturados e n\u00e3o estruturados Solu\u00e7\u00e3o Solu\u00e7\u00e3o de Business Intelligence para relat\u00f3rios e an\u00e1lises inteligentes em tempo real Tecnologias e ferramentas PowerBI, Azure, Data Lake, Databricks Cliente O cliente \u00e9 uma empresa de gest\u00e3o de centros de dados mundialmente conhecida. A empresa ... Ler mais <a title=\"Solu\u00e7\u00e3o de Business Intelligence para unifica\u00e7\u00e3o e an\u00e1lise hist\u00f3rica de projectos de constru\u00e7\u00e3o\" class=\"read-more\" href=\"https:\/\/esisoc.com\/pt\/resource\/solucao-de-business-intelligence-para-unificacao-e-analise-historica-de-projectos-de-construcao\/\" aria-label=\"Leia mais sobre Business Intelligence Solution for Unification and Historical Construction Projects Analysis\">Ler mais<\/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\/pt\/resource\/solucao-de-business-intelligence-para-unificacao-e-analise-historica-de-projectos-de-construcao\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\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 ... Ler mais\" \/>\n<meta property=\"og:url\" content=\"https:\/\/esisoc.com\/pt\/resource\/solucao-de-business-intelligence-para-unificacao-e-analise-historica-de-projectos-de-construcao\/\" \/>\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=\"Tempo estimado de leitura\" \/>\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\":\"pt-PT\",\"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\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/esisoc.com\/#organization\",\"name\":\"ESISOC | ESSID Solutions\",\"url\":\"https:\/\/esisoc.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@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\/pt\/resource\/solucao-de-business-intelligence-para-unificacao-e-analise-historica-de-projectos-de-construcao\/","og_locale":"pt_PT","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 ... Ler mais","og_url":"https:\/\/esisoc.com\/pt\/resource\/solucao-de-business-intelligence-para-unificacao-e-analise-historica-de-projectos-de-construcao\/","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":{"Tempo estimado de leitura":"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":"pt-PT","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":"pt-PT"},{"@type":"Organization","@id":"https:\/\/esisoc.com\/#organization","name":"ESISOC | ESSID Solutions","url":"https:\/\/esisoc.com\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@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\/pt\/wp-json\/wp\/v2\/resource\/2845"}],"collection":[{"href":"https:\/\/esisoc.com\/pt\/wp-json\/wp\/v2\/resource"}],"about":[{"href":"https:\/\/esisoc.com\/pt\/wp-json\/wp\/v2\/types\/resource"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/esisoc.com\/pt\/wp-json\/wp\/v2\/media\/2846"}],"wp:attachment":[{"href":"https:\/\/esisoc.com\/pt\/wp-json\/wp\/v2\/media?parent=2845"}],"wp:term":[{"taxonomy":"industry","embeddable":true,"href":"https:\/\/esisoc.com\/pt\/wp-json\/wp\/v2\/industry?post=2845"},{"taxonomy":"expertise","embeddable":true,"href":"https:\/\/esisoc.com\/pt\/wp-json\/wp\/v2\/expertise?post=2845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}