Alletec helps UK based Actis LLP establish their Data Strategy and leverage Microsoft Data Analytics

About the Client

  • ACTIS LLP (ACTIS) is recognized as a leading private equity investor in emerging markets and has been investing exclusively in these markets for nearly 60 years. ACTIS has its presence in over 20+ countries across the globe.
  • ACTIS operates via a centralized back-office, with this team churning out more than 800 reports on a Monthly, Quarterly, Half-Year and an Annual basis to the Board, Senior Management and Investors.
  • Reporting requires compilation of data from all organizational functions: Funds, Finance, Operations, HR etc.
  • Multiple disjoint business applications used across the organization make this Reporting highly complex and time consuming.

Highlights

  • Develop a ‘Data’ strategy with the Actis Business and IT stakeholders, in line with the Business and Financial KPIs – storage, compilation, slicing and dicing, visualization being the key aspects
  • Architect an Enterprise Data Warehouse (EDW) using Microsoft Technologies like SQL and Azure – build complex cubes getting data from the backend Dynamics ERP.
  • Build a seamless data integration layer from the ERP to the EDW – utilizing off peak business hours
  • Use SSRS and Power BI to build the needed visualizations and complex data calculations.
Get In Touch
Icon
Free Solution Assessment
Close button
Get Free Solution Assessment Now
Icon
Hybrid Agile Framework
Close button
Download Hybrid Agile Framework now for free