Developing Integrated Performance Dashboards Visualisations Using Power BI as a Platform

• Published in: Information (Basel) Vol. 14; no. 11; p. 614
• Main Authors: Gonçalves, Célia Talma, Gonçalves, Maria José Angélico, Campante, Maria Inês
• Format: Journal Article
• Language: English
• Published: Basel MDPI AG 01-11-2023
• Subjects: Business competition; Business intelligence; Business metrics; Customer relationship management; Dashboards; Data warehouses; Decision making; decision-support systems; Enterprise resource planning; Forecasts and trends; Information management; Intelligence (information); KPI; Management decisions; Marketing; Power; Sales; Small & medium sized enterprises-SME; Supply chain management; Visualization (Computers); Web sites; Portugal
• ISSN: 2078-2489; 2078-2489
• DOI: 10.3390/info14110614

The rapid advance of business technologies in recent years has made knowledge an essential and strategic asset that determines the success or failure of an organisation. Access to the right information in real time and with high selectivity can be a competitive advantage in the business environment. Business intelligence systems help corporate executives, business managers, and other operational workers make better and more informed business decisions. This study aimed to assess the impact of using business intelligence tools on the decision-making process in organisations, specifically in sales marketing. The methodology applied to realise the study’s objective was the Vercellis methodology. A set of data available on the sales marketing website SuperDataScience was used to implement a set of pressing KPIs for the business decision-making process in the area. Using these data, a complete business intelligence system solution was implemented. A data warehouse was created using the ETL (extract–transform–load) process, and the data were then explored using a set of dynamics dashboards with a view of the business metrics. The results showed the use of business intelligence systems that allow the integration and transformation of data from various sources stored in data warehouses, where it is possible to implement KPIs and carry out quick, concise, easy-to-interpret graphical analyses. This paper contributes to a better understanding of the importance of data-integrated dashboard visualisation for the decision-making process.