Publicação
Implementing an SQL Based ETL Platform for Business Intelligence Solution
| Resumo: | The exponential growth and development of information technology in the last twenty years has compelled most industry segments to shift from focusing on core business to adopting digitally sophisticated and data-driven processes. Those who have followed its growth have benefited, but unfortunately, just a small percentage of them do. Having information systems that just hold a vast volume of data is no longer sufficient for businesses. To gain a competitive advantage, these businesses must make well-informed decisions. Every firm, regardless of industry, has access to a wealth of data that it can utilize to its advantage. This is where Business Intelligence comes in. Business intelligence enables these companies to make better use of their data by providing previously unusable data in an intelligible and interpretable format. This internship report aims to cover the development of the data warehousing and data analytics for HROps, a product owned by BI4ALL. HROps is being developed with the goal of facilitating, centralizing, and making people management processes in organizations more efficient. I will be working on a low-cost SQL based ETL Framework using T-SQL for developing standard ETL processes. I will also be working and creating Power BI dashboards and reports to gather useful information from the data collected. |
|---|---|
| Autores principais: | Silva, André Vieira da |
| Assunto: | Data Business Intelligence Analytics Data Visualization |
| Ano: | 2023 |
| País: | Portugal |
| Tipo de documento: | dissertação de mestrado |
| Tipo de acesso: | acesso aberto |
| Instituição associada: | Universidade Nova de Lisboa |
| Idioma: | inglês |
| Origem: | Repositório Institucional da UNL |
Registos relacionados
school IMPLEMENATION OF A BUSINESS INTELIGENCE & ANALYTICS REPORTING SOLUTION FOR THE EXPORT AND IMPORT SECTOR A CASE STUDY ON THE FREIGHT FORWARDING INDUSTRY
por: Salvador, Guilherme da Costa
Publicado em: (2023)
por: Salvador, Guilherme da Costa
Publicado em: (2023)
school Leveraging business intelligence through ETL processes and Power BI dashboard development
por: Santos, Leonor Barbosa Leal Simões dos
Publicado em: (2024)
por: Santos, Leonor Barbosa Leal Simões dos
Publicado em: (2024)
school A client focused business intelligence & analytics solution for the hospitality sector
por: Santos, Ana Rita Albuquerque
Publicado em: (2020)
por: Santos, Ana Rita Albuquerque
Publicado em: (2020)
school Business intelligence solution for the economic and financial area
por: Brito, João Renato Figueiredo
Publicado em: (2018)
por: Brito, João Renato Figueiredo
Publicado em: (2018)
school Business intelligence practices in the modern retail industry
por: Santos, Noemi Alexandra Rodrigues dos
Publicado em: (2024)
por: Santos, Noemi Alexandra Rodrigues dos
Publicado em: (2024)
school A Business Intelligence Solution For Ticket Sales Management In Sintra’s UNESCO Cultural Heritage
por: Song, Yu
Publicado em: (2023)
por: Song, Yu
Publicado em: (2023)
article Promoting students success with a business intelligence system
por: Piedade, Maria Beatriz
Publicado em: (2010)
por: Piedade, Maria Beatriz
Publicado em: (2010)
school The adoption of business intelligence tools in organizational decision making
por: Vieira, Catarina Gonçalves
Publicado em: (2024)
por: Vieira, Catarina Gonçalves
Publicado em: (2024)
groups Bringing Human Factor to Business Intelligence
por: Sapateiro, Cláudio
Publicado em: (2019)
por: Sapateiro, Cláudio
Publicado em: (2019)
school Building a business intelligence model for “Steelouette”
por: Najem, Gerard
Publicado em: (2023)
por: Najem, Gerard
Publicado em: (2023)
article Business intelligence supporting the teaching-learning process
por: Piedade, Maria Beatriz Guerra da
Publicado em: (2009)
por: Piedade, Maria Beatriz Guerra da
Publicado em: (2009)
school How can business intelligence help a company make decisions more efficiently
por: Pinto, Mónica Paulino
Publicado em: (2023)
por: Pinto, Mónica Paulino
Publicado em: (2023)
school Business intelligence : an overview of the process and its applications to healthcare
por: Santos, Pedro Miguel Paiva França
Publicado em: (2016)
por: Santos, Pedro Miguel Paiva França
Publicado em: (2016)
article NoSQL no suporte à análise de grande volume de dados
por: Alexandre, Joel
Publicado em: (2013)
por: Alexandre, Joel
Publicado em: (2013)
school Using HDF5 as best practices for a business intelligence initiative
por: Pombeiro, Tiago Cardoso Pereira Fialho
Publicado em: (2017)
por: Pombeiro, Tiago Cardoso Pereira Fialho
Publicado em: (2017)
school Business intelligence em aplicações FCUL
por: Simões, Ricardo Jorge da Costa
Publicado em: (2016)
por: Simões, Ricardo Jorge da Costa
Publicado em: (2016)
article Pervasive business intelligence as a competitive advantage
por: Guarda, Teresa
Publicado em: (2016)
por: Guarda, Teresa
Publicado em: (2016)
groups NoSQL como suporte à análise de dados não-normalizados e de grande volume
por: Alexandre, Joel
Publicado em: (2014)
por: Alexandre, Joel
Publicado em: (2014)
school Cost Analysis in Dentistry: Implementation of a Business Intelligence Solution in a dental clinic to perform cost analysis using stock details
por: Vieira, Tomás Simões da Silva
Publicado em: (2024)
por: Vieira, Tomás Simões da Silva
Publicado em: (2024)
article Business intelligence in higher education: Managing the relationships with students
por: Piedade, Maria Beatriz Guerra da
Publicado em: (2009)
por: Piedade, Maria Beatriz Guerra da
Publicado em: (2009)
article A SMART Platform for Mail Management
por: Raminhos, Ricardo
Publicado em: (2016)
por: Raminhos, Ricardo
Publicado em: (2016)
school Estágio Curricular nos Departamentos de Data Science e Software Development no Sport Lisboa e Benfica
por: Alcarva, Rodrigo Heliodoro Vilaça Santos
Publicado em: (2021)
por: Alcarva, Rodrigo Heliodoro Vilaça Santos
Publicado em: (2021)
school Business intelligence numa consultora de seguros : um projeto de reformulação e implementação
por: Gonçalves, Leandro Magalhães
Publicado em: (2018)
por: Gonçalves, Leandro Magalhães
Publicado em: (2018)
school A Business Intelligence Framework to support a sales department: The use of Business Intelligence to aid business decisions
por: Reis, Luis Filipe Lima Tavares Campos dos
Publicado em: (2023)
por: Reis, Luis Filipe Lima Tavares Campos dos
Publicado em: (2023)
article Business Intelligence in higher education: Enhancing the teaching-learning process with a SRM system
por: Piedade, Maria Beatriz
Publicado em: (2010)
por: Piedade, Maria Beatriz
Publicado em: (2010)
school Cloud data warehousing solution in the banking sector
por: Silvestre, João Diogo Miguel
Publicado em: (2023)
por: Silvestre, João Diogo Miguel
Publicado em: (2023)
school Estudo Comparativo de Soluções de Data Analytics e Business Intelligence: o papel da Inteligência Artificial em visualização de dados
por: Pereira, Thayná Alves
Publicado em: (2025)
por: Pereira, Thayná Alves
Publicado em: (2025)
school Solar boats in the amazon: a cloud data warehouse solution
por: Eguiguren, Daniel Esteban Enriquez
Publicado em: (2025)
por: Eguiguren, Daniel Esteban Enriquez
Publicado em: (2025)
article Business intelligence no suporte a decisões sobre comunicações : descrição de um caso
por: Mendes, Armando B.
Publicado em: (2008)
por: Mendes, Armando B.
Publicado em: (2008)
school Empowering the Circular Economy and E-waste Management: A Business Intelligence Solution to support E-waste Management in Portugal
por: Heinrich, Ann-Kathrin
Publicado em: (2023)
por: Heinrich, Ann-Kathrin
Publicado em: (2023)
school A Symbiotic relationship between Geospatial Intelligence and Business Intelligence
por: Viana, Gonçalo Gualter Marques Duarte
Publicado em: (2024)
por: Viana, Gonçalo Gualter Marques Duarte
Publicado em: (2024)
school Analysis of Lisbon startups’ business intelligence capabilities
por: Neves, João Miguel Rodrigues Martins e
Publicado em: (2018)
por: Neves, João Miguel Rodrigues Martins e
Publicado em: (2018)
school Data Warehouse & Business Intelligence SAPA: sistema de atribuição de produtos de apoio - SAPA
por: Tavares, Carlos
Publicado em: (2017)
por: Tavares, Carlos
Publicado em: (2017)
school A collaborative platform for ETL processes and data analysis
por: Paradinha, Ana Raquel Fonseca
Publicado em: (2025)
por: Paradinha, Ana Raquel Fonseca
Publicado em: (2025)
school Measurement and improvement of a football ecosystem via social media monitoring and audience engagement: content analysis and best practices
por: Almeida, Henrique Manuel Vecino Vieira de
Publicado em: (2025)
por: Almeida, Henrique Manuel Vecino Vieira de
Publicado em: (2025)
school Produção de informação de suporte à decisão utilizando uma ferramenta de BI
por: Oliveira, Filipe António Santos
Publicado em: (2019)
por: Oliveira, Filipe António Santos
Publicado em: (2019)
school A qualidade dos dados no apoio à tomada de decisão em ambientes complexos - data warehousing e business intelligence
por: Fernandes, António Correia
Publicado em: (2005)
por: Fernandes, António Correia
Publicado em: (2005)
school Forecast and analysis of the Portuguese car fleet and automotive aftermarket using time-series modelling
por: Pires, João Miguel Nascimento Oliveira Sancho
Publicado em: (2021)
por: Pires, João Miguel Nascimento Oliveira Sancho
Publicado em: (2021)
school Manutenção corretiva de um sistema de business intelligence numa empresa de telecomunicações
por: Pinto, Ricardo Marques
Publicado em: (2021)
por: Pinto, Ricardo Marques
Publicado em: (2021)
article ETL^2 - Educational tool for learning ETL
por: Oliveira, Rui
Publicado em: (2015)
por: Oliveira, Rui
Publicado em: (2015)
Registos relacionados
-
school IMPLEMENATION OF A BUSINESS INTELIGENCE & ANALYTICS REPORTING SOLUTION FOR THE EXPORT AND IMPORT SECTOR A CASE STUDY ON THE FREIGHT FORWARDING INDUSTRY
por: Salvador, Guilherme da Costa
Publicado em: (2023) -
school Leveraging business intelligence through ETL processes and Power BI dashboard development
por: Santos, Leonor Barbosa Leal Simões dos
Publicado em: (2024) -
school A client focused business intelligence & analytics solution for the hospitality sector
por: Santos, Ana Rita Albuquerque
Publicado em: (2020) -
school Business intelligence solution for the economic and financial area
por: Brito, João Renato Figueiredo
Publicado em: (2018) -
school Business intelligence practices in the modern retail industry
por: Santos, Noemi Alexandra Rodrigues dos
Publicado em: (2024)