EndorsedendorsedOngoing

Dashboard Development & BigQuery Optimization for Beanstalk Games

Services Covered:

Big Data Analytics and Business Intelligence • Business Consulting
Project hero — replace with case study imagery
Industry
Industry

Information Technology

Duration
Durationinfo-circle

6 months

Budget
Budget

10K - 49K

Start Date
Start Date

1 June 2024

Team Size
Team Size

1-5

Engagement Model
Engagement Model

Offshore

Project Capability Score (PCS)

gauge meter
75/100
Good

Project Capability Score (PCS) estimates how capable Ingsoftware is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS


Client

Beanstalk Games

mapSt. Louis, United States of America

Project Summary

Ingsoftware rebuilt and optimized analytics pipelines and dashboards for a mobile game developer, improving data flows from Firebase and GA4 into BigQuery and Looker Studio. They created many new, useful Looker Studio dashboards, filtered bot and hacker traffic to improve data quality, and reduced compute costs. The team responded quickly to requests and often completed tasks within 24 hours.

Key Challenges

  • Deep dive into analytics and custom dashboard work
  • BigQuery optimization for complex data flows
  • Replace broken Looker Studio dashboards and create many new data views

Project Deliverables

  • Data visualization dashboards
  • BigQuery data flow optimization
  • New data views
  • Bot and hacker data filtering

Project Solution

Ingsoftware audited and optimized the data flow from Firebase and GA4 into BigQuery and Looker Studio, rebuilt and added new Looker Studio dashboards, and implemented data filters to remove bot and hacker traffic. They reduced compute usage for large datasets and delivered many requested data views quickly, supported by a dedicated project manager and a small team (2 to 5 people).

Project Outcome

  • New data visualization dashboards
  • More efficient data flow and reduced compute costs
  • Bot and hacker data filtered from datasets improving data quality
  • Fast response times with many requests completed in under 24 hours

Platforms

  • CloudCloud
  • WebWeb

Tech Stack

  • FirebaseFirebase
  • Google AnalyticsGoogle Analytics
  • Google Cloud Platform (GCP)Google Cloud Platform (GCP)
  • Google Big QueryGoogle Big Query

Client Endorsement

Overall Review Rating

5star5 out of 5 stars

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

We got a solid set of dashboards from Ingsoftware, and they cleaned out bot and hacker traffic across our datasets. That cleanup made our pipelines more efficient and cut compute costs. They were fast to respond and often finished our requests within 24 hours.

Tim Hebel

Owner

Note: This endorsement is based on publicly available client feedback from external review sources.

More Projects by Ingsoftware