Proposta de implementação do Power BI e SSAS para o auxílio na análise de dados para área comercial com foco em Real-Time Data Streaming Caso de Estudo: Fonte Capital Moçambique

Abstract

The evolution of companies towards data analysis has been a transformative journey driven by technological advances, changing business scenarios and growing recognition of the intrinsic value of data. Initially, this evolution moved from manual record keeping to more sophisticated data-driven decision making. Today, this transformation continues to advance, driven by emerging technologies and improved data analytics capabilities. In the commercial banking area, the application of data analysis is fundamental. It enables a deeper understanding of customers, product sales dynamics, market analysis and new product development. Using a Data Warehouse as an integrated data repository is vital to support analysis. It is derived from different operational data sources and is designed to support decision- making processes through analytical information. The components of a Data Warehouse include the data preparation area, which involves extraction, transformation and loading (ETL) processes, and the data presentation area, where users access information organized in data marts. Furthermore, Business Intelligence (BI) plays a crucial role in transforming data into valuable insights. It offers a global view of the business, providing consistent and updated information to support strategic decisions. The organization's information systems infrastructure is critical to ensuring that BI is integrated with underlying data sources, providing relevant and useful information to end users. In short, the evolution of companies towards data analysis is continuous, with the implementation of advanced technologies, improved processes and the growing understanding that well-analyzed and interpreted data is vital to driving business innovation, efficiency and competitiveness.