Optimización analítica y control del gasto: Move control tower pepsico

Abstract

The main objective of this undergraduate project was to optimize the financial management and operational visibility of the Move Control Tower at PepsiCo, through the restructuring of Business Intelligence dashboards and the standardization of data update processes. The problem identified at the beginning of the internship consisted of a lack of updates for more than a year in expense reports, which prevented effective monitoring of all accounts at a national level. The methodology employed was based on technical development under the framework of Management Information Systems. An exhaustive cleanup of historical SAP databases was performed, and advanced visual tools were designed in Power BI, including a waterfall chart for variance analysis and a master table with a heat map for national monitoring. Additionally, technical procedure manuals were developed to ensure the sustainability of the system. The results achieved included the reactivation of two obsolete reports and the creation of two new dashboards that allowed for the identification of root causes of budget deviations in accounts such as Utilities, R&M Fleet, and Travel Expenses. It was concluded that the transformation of raw data into analytical information strengthened decision-making in monthly management committees. Finally, it was determined that the documentation of the process mitigated the risk of operational obsolescence, ensuring that the Move Control Tower maintains precise and efficient long-term financial control.