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.
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.
SQL Server – the existing on-premises data warehouse was leveraged as a data source for Amazon Redshift
Amazon Redshift – operated as a ultra-fast “data-mart” solution for this client, returning high data volume queries within second
Tableau Server and Tableau Desktop were utilized to process terabytes of data in seconds to analyze sales and inventory KPIs for upper management
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!
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.
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.
Discover how we’ve helped our customers build Modern Data Organizations.
Global events and services provider discovers valuable financial insights
Global electronics & automation corporation provides valuable proof of concept for data streaming
Regenerative medicine company improves data-driven decision making across the organization