Problem Overview

Department and project managers of ST Electronics are required to update various financial reports which are currently stored locally in the managers’ laptops. Due to complex correlation logics and absence of a database, there is a need for a data ingestion process to form up a data repository in order to correlate disparate data into useful information. This further leads to the manual referencing and navigation for report updating. Additionally, current forecasting methods employed such as averaging does not provide sufficient actionable insights.

Info Portal

An Automated Report Management and Analytics System

A one-stop system that not only stores data from financial reports in a centralised database through an automated data ingestion process, but also enables users to view and edit up to two reports in a single screen, as well as export reports of their choice. Furthermore, it is equipped with a data analytics function that allows users to choose from various models and forecast future sales based on historical data. A Tableau dashboard is also designed to visualise historical and predicted sales, providing meaningful insights which aid in future sales plans.