Lavanya Naik | BMS College of Engineering
Abstract
Business Relationship with the stakeholders is important for any organization to grow in their business. This is evaluated based on Key Performance Indicators (KPIs) that is set in the beginning of the financial year. Hence it is important to track the KPIs in regular intervals so that organization do not end up in trouble last moment. Manual processes for tracking and analyzing KPIs are often time- consuming and prone to errors, which can lead to inaccurate data and poor decision-making. The proposed approach is the automating the process of calculating actuals and forecast for the current month. This solution is achieved using ETL process of relevant data and writing stored procedures in PostgreSQL and thereby coming up with automated view for KPI setting process. The major factor is to finalize the models in order to calculate the forecast values for the remaining day of the month. Forecasts provide valuable insights into future trends, allowing individuals and organizations to make informed and strategic decisions. This in turn gives streamlined solution proving efficient solution both in terms of reduction in error and time.
