Neto, Miguel de Castro Simões FerreiraBatista, Luís Pedro LopesTeixeira, Daniel Leite2022-11-222022-11-222022-10-28http://hdl.handle.net/10362/145707Project Work presented as the partial requirement for obtaining a Master's degree in Information Management, specialization in Knowledge Management and Business IntelligenceTechnology is capable to support companies to reach their goals by making use data to take advantages from its analysis. Concerning public institutions, it is meaningful to deliver high-quality services and products to society, and technology may lead the organizations to a more efficient service provision. The purpose of this project is the implementation of a business intelligence system in Consultoria Jurídica da União (CJU) [Consultancy Office], the institution responsible for analyzing bidding processes in Brazil. The solution proposed by this work aims to store the business data and provide an analytical tool to display information in dashboards to provide insights to stakeholders, analyzing data trends and tendencies, preventing future unnecessary events, identifying best practices, to finally improve the public tenders to a better application of public funds and provide better services to society. To reach this project main objective, the technology that surrounds the BI system to be implemented includes the development of a scalable data warehouse to store the organization data and its schema modelling, the extraction-transform-load method to populate the data warehouse tables, and create the analytical tool, named dashboard, to answer the business needs providing the institution information. This business intelligence system intends to improve the legal bidding process in public agencies by making use of technology.engBusiness AnalyticsBusiness IntelligenceData WarehousingData Visualizationmaster thesis203103670