Movie and game retailer supercharges analytics processes

When critical workflows and processes slow to a crawl, it’s difficult for stakeholders to extract valuable insights that guide strategic decision-making.


Data analytics can be a major boon for any organization.

But when critical workflows and processes slow to a crawl, it’s difficult for stakeholders to extract valuable insights that guide strategic decision-making.

That was the case for one of our clients, a movie and game retailer, as its Strategy and Analytics team frequently encountered query runtimes that stretched on for hours and sometimes even days at a time. Turnaround times on new analyses were significantly delayed as a result, preventing the organization from realizing the full value of big data analytics.



Our solution

Constructing a fast and responsive data warehouse

OneSix sat down with our client’s key stakeholders to identify their most pressing pain points as well as the underlying causes. Our expert team determined that Amazon Redshift could support the business’s data warehouse and analytics needs, transitioning away from its existing on-premise SQL Server environment. We gathered requirements for content and structural changes to those sources in their new environment before loading data into the new solution.

Our team also converted the client’s existing Tableau workbooks so they would be compatible with the Amazon Redshift Data Warehouse solution. In some cases, these workbooks were rebuilt from the ground up and tested using Tableau. This new arrangement takes advantage of Amazon Redshift’s superior processing power to aggregate queries as quickly as possible.

As a result, the rebuilt Tableau workbooks displayed performance improvements that were orders of magnitude above their SQL Server-based predecessors. Tens of billions of records are now available for Strategy and Analytics teams to quickly run queries against.

Technologies implemented


Thanks to OneSix’s expert assistance, our client finally has a data warehouse solution that can support its high-volume data sources and deliver true business value.

No longer is our client running a query and coming back after their lunch hour to see the results.


My experience was fantastic with OneSix. They listen to your query carefully and then are able to solve your issues within the correct time frame and reasonable price. Super knowledgeable team!

Ayush J.
SEP 28 2022

One of my favorite things about One Six is their willingness to work with us on whatever we need. Early on in the project, we determined we needed an additional tactical resource instead of an advisory one, and One Six happily switched out resources for us, ensuring we had what we needed to complete the project.

Pamela E.
NOV 8 2021

They dig in and help understand the problem, how to think about it, provide the best technical options of how to solve it, then execute as quickly as possible. This is by far the best way to help me make sure we're successful, and that I know what's being done and how to support it once they're finished.

Brandon H.
OCT 20 2020

Transform your data org

Schedule a free consultation with the team.