Objectives
In an effort to migrate, modernize databases, and implement a self serve analytical solution, a leading US casino entertainment client engaged BizAnalytica (now part of the Mastek Group LLC) to build and implement a reference architecture that will utilize state-of-the-art tools and quickly transition to the cloud strategy.
The client wanted to provide their business users with self serve analytical capabilities for real time decision making.
The Challenges
- Non-availability of real time data for analytical decision making
- Data loading into on-prem servers taking 6-7 hours, no real error handling mechanism in place
- Administrative challenges due to managing multiple databases
Why Mastek
- Proven expertise in implementing Snowflake with AWS Cloud
- Expertise in implementing a self serve BI solution for end users
- Model to reduce high maintenance cost and slow application development
- Experience to minimize data movement to improve performance
Benefits
- Self Serve reporting/dashboarding capabilities enabled for all business users
- Performance – 12x improvement in performance in batch processing
- Affordability – 27% reduction is server and storage costs and 24% reduction in operational costs (~$1.8M per year)
- Agile Processing – Implemented a re-usable framework with open-source tools
