HOME / Case Study / Power BI dashboard suite for Overheads Cost analytics

Power BI dashboard suite for Overheads Cost analytics

The client was an FMCG major with its operations in almost all countries across the world with a very complex technology landscape. The client had disparate transactional sources housing their own data, making management reporting difficult and time intensive. There was a lack of end-to-end visibility on overhead cost expenditure. Intensive manual work was performed to bring together cost, forecast and budget in a single view leading to delays as well as errors. There was a lack of uniformity across the organization due to different countries using their own formats for reporting.

Thoucentric managed the end-to-end delivery of the Power BI dashboard suite to streamline the Overheads Cost reporting for the client. Working closely with finance partners from different countries, Thoucentric proposed a Power BI dashboard suite of only 13 access-controlled dashboards meeting the needs of entire finance function from finance controller in the countries to the CFO. Thoucentric partnered with business to understand the business requirements and translated them into functional specification for the development team. Thoucentric also performed the project management ensuring that all the project milestones are met within the agreed timeline and cost. Thoucentric consultants also acted as a shadow business user to test and validate the Power BI dashboards before releasing the same to business, leading to a significant reduction in UAT defects and the consequent time for their resolution.

Post the successful implementation of the Power BI dashboard suite, the entire Overheads cost reporting for the client was streamlined. A single platform provided holistic view to business on the overhead expenditure, and its comparison with the budget, forecast and turnover for different time slices. Role based access control allowed the same report to be made available for different user’s basis the role requirement. Linkage to transactional data was established via Fiori, allowing the finance users to navigate from aggregated data to the relevant transactional data to perform focused analysis on the transaction.

Post a Comment