Project Description

Data Platform Selection and Implementation – Azure

Project Description

The client is a large national leisure, hospitality and entertainment business. The group functions  needed a reporting and analytics capability enabled in a unified enterprise data lake to understand Customer Profitability, determine ROMI ( Return On Marketing Investment), and better manage the >8000 person customer facing workforce.

What We Did

  • Implemented an enterprise data platform with real time data updates (CDC), self service analytics and reporting capabilities, pre-canned reports and dashboards for senior management with defined business KPI’s
  • POC for cloud platform selection and POC for Microsoft Azure Platform architecture for batch loading and streaming of data
  • The solution was built on the Microsoft Azure cloud platform with data sourced into the Data Lake from 17 different sources, ~600 tables, ~6Tb data with different file formats and multiple ingestion patterns.
  • Defined and validated business requirements and processes through workshops with business SMEs and completed source to target mapping for ~120 measures (KPI’s) and 25 dimensions across the business functions
  • Designed and developed data conversion patterns and ETL jobs to move data in Data Lake to Azure Data Warehouse and to the reporting layer using PowerBI
  • Delivery approach enabled the project to deliver the business requirements in an iterative manner using agile delivery methodologies.
  • Provided the technical foundations for streaming, advanced analytics, 3rd party access, and modelling
  • Designed and delivered the Data Governance Framework and Data Analytics Operating Model and Service Support Model

Outcomes Delivered

  • Provided the capability for the client to achieve revenue uplift and cost reduction targets identified in the business case
  • Client is able to get an accurate view on following business capabilities: Customer Profitability – Finance and Customer Loyalty; Campaign Effectiveness – Marketing; Workforce Supply & Demand Management – Workforce Management
  • Data governance framework and model
  • Data Analytics Operating Model
  • An operating data analytics platform that can support future use cases
  • Decreased cost to deliver compared to traditional Datawarehouse methods
  • Real time data capture

Project Details

  • IndustryLeisure and Entertainment
  • Service LineData Strategy, Data Engineering