Publicação
Implementation of a Business Intelligence Solution Using Kimball Lifecycle: A Case Study in Sales Management
| datacite.subject.fos | Ciências Naturais::Ciências da Computação e da Informação | pt_PT |
| dc.contributor.advisor | Jardim, João Bruno Morais de Sousa | |
| dc.contributor.author | Caraus, Valeria | |
| dc.date.accessioned | 2024-11-15T11:03:27Z | |
| dc.date.embargo | 2027-11-05 | |
| dc.date.issued | 2024-11-05 | |
| dc.description | Dissertation presented as the partial requirement for obtaining a Master's degree in Information Management, specialization in Knowledge Management and Business Intelligence | pt_PT |
| dc.description.abstract | Nowadays, Business Intelligence systems play an important role in companies, as they provide valuable information that improves decision-making. Within the context of sales management, there is a big difference between collecting data and using it for analytical purposes, therefore BI is crucial to transform large amounts of data into actionable information that answers business questions. In this work, we develop a full BI solution to help Company X manage sales data of a new product line. As the current reporting is not based on a structured data warehouse model, we used the Kimball Lifecyle approach to build a new data model dedicated to storing sales data and to develop interactive dashboards adapted to Company X's requirements. With this work, we provide the company with a new structured model that can aid in the quick monitoring of the sales transactions at different levels. Additionally, the use of BI tools used in this work, such as Oracle Data Integrator for ETL processes and MicroStrategy for creating dashboards, are not widely explored in the literature, therefore we enriched the BI literature applied to sales management by combining the Kimball methodology with these tools. | pt_PT |
| dc.identifier.tid | 203777654 | pt_PT |
| dc.identifier.uri | http://hdl.handle.net/10362/175282 | |
| dc.language.iso | eng | pt_PT |
| dc.rights.uri | http://creativecommons.org/licenses/by/4.0/ | pt_PT |
| dc.subject | Business Intelligence | pt_PT |
| dc.subject | Sales | pt_PT |
| dc.subject | Data Warehouse | pt_PT |
| dc.subject | ETL | pt_PT |
| dc.subject | Dashboard | pt_PT |
| dc.subject | Oracle | pt_PT |
| dc.subject | SDG 8 - Decent work and economic growth | pt_PT |
| dc.subject | SDG 9 - Industry, innovation and infrastructure | pt_PT |
| dc.title | Implementation of a Business Intelligence Solution Using Kimball Lifecycle: A Case Study in Sales Management | pt_PT |
| dc.type | master thesis | |
| dspace.entity.type | Publication | |
| rcaap.rights | embargoedAccess | pt_PT |
| rcaap.type | masterThesis | pt_PT |
| thesis.degree.name | Mestrado em Gestão de Informação, especialização em Gestão do Conhecimento e Inteligência de Negócio | pt_PT |