Data Strategy and leverage Microsoft Data Analytics

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

Ask Dyna

Free Solution Assessment
Get Free Solution Assessment Now