Author profile
Ramón Lastres
CTO at GameAnalytics
1 min read
#Engineering
Improving funnels processing from ~20 mins to seconds
Editor’s note: we recently shared details of a major GameAnalytics update which includes a substantial overhaul to our product and infrastructure. Check it out for more context. At GameAnalytics we have been using Apache Druid and Imply (Imply.io) for over four years to power our analytical backend, allowing us to achieve a responsive frontend experience for our users. This is due to the low latency querying that Druid enables through the usage of approximation algorithms. Recently we had the opportunity to present the work behind our Druid implementation in the BigDataLDN 2022 event, where we covered our new funnels feature and the usage of the Theta Sketch algorithm from the Apache DataSketches library (https://datasketches.apache.org/). Here’s a recording of the talk. Enjoy!
8 min read
#Interviews
How to Build a Data Warehouse for Games from Scratch
Over our last couple of blogs around data warehouses, we’ve explained how they let you analyze data from across your portfolio and look at what insights you can gather from them. Now, we’ll dive into how to build a data warehouse. What steps do you need to take and what resources will you need? To figure this out, we’ve rounded up the costs, steps, and tools we think you’ll need to get started. Please note, that we haven’t included the cost of running an engineering department (which you’ll need), which can end up being a lot of $$$. What do I need to get started? Before you start, you’ll need to ensure you have the right people. You’ll likely need a software or data engineer, and perhaps an architect or DevOps engineer. You’ll also need to budget for tools like...