DATA ENGINEERING AND DASHBOARDING ON MAJOR LIVE TITLES
AC&A structured big-data analysis across up to six live games, spanning billions of unaggregated player events over 5+ years. The work included ETL improvements, custom queries, aggregation pipelines, and dashboards for operational, tactical, strategic, and executive use.
Scope of Work Delivered:
- Project management
- ETL pipeline assessment, design, and development
- Evaluation of game analytics and recommendations to resolve data inconsistencies and missing data
- Analytics assessments and validation, including core products and DLC
- Dashboard design and development
- High-level executive dashboards and KPIs
- Game-specific dashboards
- Systems and infrastructure analysis of the data architecture that included:
- BigQuery
- APIs and services
- Compute Engine
- Cloud Storage
- VPC Network
- Kubernetes Engine clusters
- Retention KPI development
- Validation of anonymization mechanisms for personally identifiable information (PII)
- Implementation of a new ETL pipeline, including dbt integration
- Data modeling, design, and development
- Comprehensive analytics facilities and BI assessment, covering three primary dimensions
- Data quality
- Data governance
- Data architecture
- Operational systems assessment, including recommendations for product lifecycle processes
Restructuring billions of rows of data helped Avalanche Studios Group turn collected analytics into practical insight about player behavior and game performance. The dashboards and tools now support six live games and serve as a model for future project dashboards.
Would you like to see a meaningful increase in your game’s revenues?
Does your game include the latest monetization and economy best practices? Do you want to make the most of your funding with end-to-end development expertise? Schedule a free consultation with our team to see how AC&A can help your business today!
See more of our successful work.
Since 2008, Adrian Crook & Associates has helped over 300 developers of all sizes maximize the ROI of their freemium games.
As veteran product managers, economists, and designers, we guide each of our clients through an explicitly personalized, data-driven process. At every stage of a product’s lifecycle we provide actionable, innovative insights that deliver results.
