Fortalecimiento del análisis y seguimiento de empresas en procesos de internacionalización a través de power BI

Abstract

The purpose of this report was to optimise the management and traceability of information relating to companies participating in internationalisation schemes, through the use of data analysis tools designed to improve the organisation and monitoring of this information. This objective was pursued in a context where the handling of information was inconsistent, due to a lack of centralisation, standardisation and traceability, which made it difficult to generate reports and analyse business performance. The methodology employed involved the review, cleansing and structuring of information relating to more than 1,200 companies, taking into account strategic variables such as production chains, company size, performance, participation in calls for proposals and allocation by advisor. Subsequently, two databases were consolidated: one focused on the general register of calls for proposals and the other on companies with export processes. Based on these databases, two dashboards were designed in Power BI to facilitate the visualisation and analysis of the information. The results demonstrated an improvement in data organisation, as well as enhanced traceability of companies and report generation, enabling a more efficient analysis of business performance and the achievement of targets by the advisors.Finally, it was concluded that the appropriate structuring of information, combined with the use of technological tools, helps to improve process efficiency and supports decision-making within internationalisation programmes.