Brief Problem

Effective data management is a crucial part of sound decision making. However, the data is often sensitive and scattered over multiple documents, making it difficult for the decision maker to simultaneously evaluate and generate reports. Moreover, preparing reports takes a noteworthy amount of time. Therefore, Streams Tech aided the business by creating an interactive revenue forecasting dashboard rather than using spreadsheets or other tools for better decision making.

Solutions

Streams Tech had created an interactive forecasting dashboard aimed at revenue forecasting. We were able to develop a simple and effective dashboard using Power BI that used data straight from the data source, filtered it, and created a visual report that gave the CFO a forecast summary in minutes. Moreover, information like goal indicators, goal conditions, revenue per day, hours allotted per resource, and cost, among other things, can be viewed in tabular and graphical formats, removing the need to review various data types. The managers and CFOs got insight into the project budget, identified whether the objectives and goals were being met or not, and knew where they had room for improvement by collecting all the financial data in one place. The dashboard was quick, easy to use, and gave a complete picture of the company compared to any variance report.

Moreover, Streams Tech provided necessary orientation training to the division, district and upazila-level officials of LGED. At present, the portal is accessible at: www.gis.lged.gov.bd.