Case Study: Sports Betting Innovative Analytics takes optimized aggregation to the next level with Studio 3T

Sports Betting Innovative Analytics manages 350 aggregation pipelines with Studio 3T

Sports Betting Innovative Analytics (SBIA), an analytics business delivering sports performance insights, faced the challenge of processing large amounts of data through MongoDB after migrating from a SQL-based environment. Their team needed to quickly create optimized data aggregations, convert them to Python code for their workflows, and effectively onboard new employees who primarily had SQL skills. They turned to Studio 3T to address these needs.

Studio 3T provided a solution with its GUI and IDE tools, including an Aggregation Editor that allows for rapid iteration and a feature that automatically converts aggregations into Python code for live updates. The SQL query tool was instrumental in helping SQL-skilled new hires learn MongoDB. As a result, SBIA efficiently scaled its operations, using Studio 3T to manage 350 aggregation pipelines querying 1.5TB of data, with the largest single pipeline generating 49,000 lines of Python code.

Sports Betting Innovative Analytics