Designing a target operating model and delivering a revolutionary approach to data gathering, processing and reporting
Who was the client?
Our client is a multi-national Venture Capitalist Fund.
What was the issue?
Our client’s data structure and processes were disjointed. So, they asked us to design a target operating model for their data future state. As well as provide guidance and support in order to implement the right software solutions. And finally design and deliver state of the art reporting capabilities in order to support their future business intelligence.
What did we do?
The process encompassed three distinct streams of work, which we project managed throughout.
Step 1: Defining the Target Operating Model
This involved revolutionising the firm’s current approach to collecting and reporting on all portfolio company data. So, we took both a short term and medium to long-term approach, defining data warehousing and the PowerBI reporting architecture.
In the short-term by a revitalised series of underlying Excel sheets. Thus allowing improved reporting outputs.
In the medium to long-term by newly implemented portfolio monitoring and cap table management systems. Which were selected following the completion of workstream two.
Crucially, the target operating model and associated work was built with a view to future-proofing operations. So we ensured the short-term revitalisation and build of the data extraction, ingestion and warehousing processes performed in a way that would allow the easy incorporation of the new systems.
Step 2: A full vendor selection process for a Portfolio Monitoring System and a Cap Table Management solution
The second work stream required the completion of a full RFP process across the complex needs of this data science led fund, in portfolio monitoring and cap table management. In order to develop and document the complex requirements, we worked closely with the key stakeholder for the project. Whilst leveraging input from others within the firm in relevant areas. This led to the development of a highly detailed RFP document, which was sent to a wide-range of vendors from across the software ecosystem.
The process included the identification and elimination of over 12 providers, with the formal assessment process being conducted across a variety of PE and VC specific solutions. Finally, the selection process was completed successfully and the chosen vendors are now working closely with us to deliver the required end-product.
Step 3: Building the data input and extraction processes, the data warehouse and the PowerBI reporting framework
The final work stream ensured data from multiple sources, including the new systems and external feeds (fund admin and FX,) could be combined and reported on from one centralised repository. Thus providing full oversight and clarity on its source and accuracy. The use of PowerBI was recommended by our team, given the flexibility and breadth of analysis available. The dashboards and reports were designed on a pixel perfect basis, using the client’s preferred branding and overall look and feel.
Our team of experts is ready and waiting to discuss your unique needs.