Background Driving relevant conclusions from the data on hand is key to making the right business decisions. But for an organization to make an accurate decision, it has to have full information. The data needs to be collected and managed from diverse sources. That’s why many businesses today are turning to data warehousing as a way to organize data. Our client, GOAT Interactive needed a solution that would facilitate the growth of current business and potential new markets. Their request was to build a modern serverless data warehouse that would help them better understand and grow their product. The company wanted to understand business performance of their solutions both from marketing and business performance point. Prior to approaching Symphony, they were using an on-premise solution that had a low performance. Client GOAT Interactive is a part of the Editec Group. Its goal is to become the number one operator in the African market. It aims to fuse the world of football and betting, creating an authentic, highly engaging community of sports fans who love the thrill of a bet. The brand is closely partnered with renowned football club brands and leverages these partnerships to provide a unique player experience, enabling GOAT to provide unique betting propositions, content and events to the rapidly growing African market – an experience that brings fans closer to clubs, leagues, and the sport they love. Challenge Our client, being one of iGaming industry’s leaders, is receiving large amounts of data on market behavior, company business performance metrics, as well as some historical data. However, when they approached Symphony Solutions this data was not centralized. Thus, they were not able to correlate metrics to drive some insights and make the right business decisions on time. The list of tasks included the following: Migrate large amounts of data (about 10 TB) from on-premises databases. Build cloud data warehouse (DWH) and Data Lake on top of Google Cloud Platform (GCP) ecosystem. Create BI dashboards using Data Studio and Looker. Implement email reporting services to data stakeholders. Integrate DWH with CRM tools like Atlas, Optimove, and Raventrack. Implement real-time data streaming and analytics within DWH. Solution Based on client’s cloud preferences, Symphony started working on building data warehouse on Google Cloud. The initial stage was creating PoC, which was followed by adding detailed reports, migrating all data, enabling complex integrations with CRM providers thus empowering users’ data enrichment to be able to conduct more effective behavior analysis. Based on the client’s request, Symphony’s team set out to work on developing the following: DWH and Data Lake have been built on top of BigQuery and Google Cloud Storage / Dataproc respectively Cloud Composer is used for ETL pipelines orchestration Data Studio and Looker are used for BI dashboards Dataflow is used for real-time data streaming and analytics (in progress) As a next phase which is currently in progress, the work is evolving from batch processing to real-time data streaming as a way of improving the client’s services and automating business processes. Result The client obtained an automated, reliable and scalable solution. Their business process became robust and predictable with the built cloud data warehouse, including integrations with different CRM tools. The current list of outcomes includes: Automated cloud data warehouse with batch processing and real-time data analytics features. Our team accomplished 20 different important reports for 15 countries. We built more than 22 Data Studio dashboards. We built up to 10 models containing 30+ explores within Looker. Client Administrator can perform analytics in real-time. Cloud ecosystem allowed to get all the data in one place and orchestrate ETL pipelines in unified way, and prepare on-demand OLAP cubes. Migrated more than 10TB of external data. A reliable, scalable, and well maintainable solution. Currently, we are working on developing and extending real-time data streaming and providing the support of the existing solution. Download full case × Please, fill in form below to get Full Case I have read and accepted the privacy policy on symphony-solutions.com Δ
Symphony Solutions
Donate now