Data Analytics Transformation Program
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