About Client
The Client is Europe’s biggest online lottery provider and operates across the UK, Europe and American markets accumulating over 300 million in revenue as of 2016.
Background
Having data stored in silos limits an organization from leveraging their data. For example, you can track hot leads and payments separately but integrating the data sources increases visibility. You get a full picture of a customer’s journey which in turn allows room for improvement and new opportunities.-
A BI platform integrates data from all disparate systems and drives an improved and effective data strategy with faster and more reliable analytics.
- Business Intelligence helps the senior management get a more holistic view of the organization and the needs of each department much better. It improves the efficiency of the entire organization by providing ‘a single source of truth’.
- Self-service analytics enables any business personnel to run queries and prepare BI reports of their own with minimal dependency on the IT team thanks to smart and convenient dashboarding and reporting features. Self-service analytics and business intelligence empowers almost every business user in an organization by equipping them with an easy data access interface.
Challenge
- The client runs its online lottery platform with multiple disparate systems which includes a marketing automation & email marketing system, a web analytics application, an affiliate management software and a multichannel payments system.
- The decision support system required consolidation of information across these applications. Without a data warehouse, this results in sub-optimal allocation of resources and delays the decision-making process for the client.
-
The client was looking for process improvement and realization of better ROI through a Business Intelligence solution
Our Solution
A BI strategy was developed according to the client’s requirements and future objectives. This included Discovery, Infrastructure Architecture & a high-level Implementation Plan- A thorough evaluation of market tools that offered business users an agile, intuitive, scalable interface was done and presented to the client. The result was a combination of enterprise & open-source BI technology stack complementing the client’s IT infrastructure
- The implementation phase included design of a Data Warehouse, development of an ETL architecture and automation with industry specific Reporting & Analytics
Outcome
- A set of Dashboards & Analytical Reports were developed and deployed to facilitate better reporting mechanisms for the client. This enabled business users to traverse through the data with few mouse clicks.
- A single point of truth across the business using modern dashboards enabled the decision makers for quick and timely decision making.
The Data Integration Resulted In A BI Layer With Four Core Areas:
Product
Customer
Campaign
Web Insights
with an integrated view of data from the core lottery, marketing,
Web Analytics and payment systems.
Ad Hoc Reporting
Capabilities Allowed Business Users To Create Custom Reports On Their Own, Thus, Reducing Dependency On IT Time And Cost Of Report Development.
The Complete BI Infrastructure Was Conceptualized, Developed & Deployed In Just
14 Weeks
With A Low Total Cost Of Ownership
