Case Study: Interactive Microsoft Power BI dashboard for global data transformation consultancy
Isosceles’ private equity-backed client is a global professional services company specialising in the provision of data migration and transformation services.
Its service combines an ERP product, AI and machine learning together with its consultants’ extensive big data expertise; helping its clients to make the most of their data assets.
The company has nearly 1,000 data specialists in over 20 offices around the world.
As the potential of big data has changed, the client’s core focus has evolved to include data quality, data replication, information governance, and data strategy.
This Isosceles client wanted to reduce working capital in the business. They felt they could be more efficient with cash but had never been able to pin-point the areas to focus on with concrete data.
Similarly, the management team also wanted to enhance and overhaul existing reporting models which analysed how well-utilised staff were on client projects and how that was converting into revenue.
To do this, they needed to analyse global revenue by region, line of business and resource at a very granular level. They also needed to gain a definitive data-driven understanding of key revenue drivers, which would empower them to feedback into the business planning and decision-making process.
To undertake this ambitious project, they required an experienced partner that could model and present this information visually and interactively.
Isosceles has a positive track record with this client, having supported them with various projects over the last seven years.
"In recent years, Isosceles has expanded its Microsoft Power BI capabilities and invested in the development of a specialist technology team. Our accounting, finance and HR professionals have worked with this long-standing client and its management team on a range of complex projects over a seven-year period. This experience has given Isosceles a unique opportunity to develop a granular understanding of the client's profit and cost drivers and support them with our technical skills, systems knowledge, and data analysis expertise. I am particularly proud of how our technology team has supported the client's management team in critical business decision-making through rigorous Power BI modelling and analysis. I am excited about the potential of Power BI and how it can be deployed across our entrepreneurial client base."Mike O'Connell, CEO, Isosceles Finance
Isosceles’ technology team worked with the client’s management team during the COVID-19 global pandemic to deploy Microsoft Power BI models and interactive visual analytics dashboards.
Working capital analysis
On the working capital solution, the client captures the key dates in the end-to-end cycle from task performance through timesheets to invoices and ultimately to cash collection. Then, Isosceles’ solution transforms the raw data, using Power BI, into a reporting suite which enables the client to identify key points within the entire working capital cycle where efficiencies could be realised.
Global revenue and utilisation
A similar process is followed on the global revenue and utilisation analysis; the client’s system tracks operational data and Isosceles feeds this information into Power BI to generate key revenue and utilisation insights. Our solution continues to deliver easily consumable global revenue and utilisation reports into the hands of management, thereby enabling the leadership team to unlock the desired insights from a large volume of data.
Against the backdrop of current Coronavirus challenges, Isosceles’ implementation of Microsoft Power BI delivers through visual dashboards:
- Detailed and granular views of global revenue and utilisation across the company. This has allowed management to feed back into the decision-making process.
- A breakdown of the entire working capital cycle. As a result, specific areas of focus are now highlighted, enabling the client to identify and rectify issues and drive down the time from completion of work through to receipt of payment, thereby reducing the amount cash tied up in the business.
- A framework empowering management actions built upon data-driven insights. The combination of data from operational and financial systems is crucial to support these management-level decisions.