Industry
Manufacturing
Type
Analytical Modeling
Technology
Azure Databricks
What did they need?
The company needed to transfer an analysis model that evaluated how economic and political factors impacted its EBITDA to a modern, scalable cloud platform like Microsoft Azure. This model, built in @Risk, EViews, and Excel, considered variables such as exchange rates, inflation, unemployment, marginal rates, and risk premiums to predict EBITDA six months into the future. The migration required a comprehensive reconfiguration, enabling more efficient and flexible processing in the cloud.
How did we support and what was achieved?
- Selection of Optimal Models: We identified the most effective model through thorough testing.
- Transformation of Complex Process: We simplified a complex process, addressing challenges in predicting economic and political variables with advanced strategies.
- Inclusion of Sales for Comprehensive Perspective: We improved accuracy by incorporating sales as an independent variable to predict EBITDA, filling a gap in the ability to forecast future sales and their impact on the EBITDA indicator.
- Efficient Automation: We established an automated process for immediate results and informed decision-making.
- Integration of Updated Data and Results: We implemented a solution that allows for agile data updates in SharePoint, ensuring our predictions and analyses are always based on the most recent information.