The Situation

An IT services business was operating multiple operational support platforms across Sales and Marketing, Managed Services, Professional Services, Human Resources Management and Billing & Finance

The Task

Design and develop a data warehouse and reporting solution to enable data driven decision making across the business

The Action / Approach

  • Build Business Case and Secure Executive Board Sign-Off
  • Define Product Requirements
  • Define Project Delivery Methodology – Hybrid Agile
  • Select Data Warehouse Technology – Microsoft SQL
  • Select Data Extraction & Transformation Vendor – Microsoft Azure Synapse Pipeline and Custom Connectors
  • Select Data Visualisation Technology – Microsoft Power BI
  • Build Delivery Team – Data Scientist & Developers, Departmental Stakeholders

 

The Result

Full set of executive and departmental dashboards and detailed reports delivered in 3 months

Relevant Business Perspectives

Relevant Industries