New Case Study: 1010data Migration With Excel Add-In for Snowflake

The Client is a leading vitamin and supplement retailer with just under 800 stores across the United States. Additionally, the Client manages and distributes multiple top brands in its stores, including its own line of supplements. 

Challenge

The Client had been using 1010data for several years and it had become part of the fabric for how their organization evaluated their retail analytics. However, 1010data was becoming very slow, and the user adoption was very difficult to scale due to its custom query language. The consequence is that any changes to the queries required the attention of a very small number of XML query experts to be able to work on it. Additionally, building new content was very difficult due to the small number of resources that understood the query mechanisms.

Navigating Constraints

Snowflake was an obvious fix to this challenge however, the interactions with the data within their team were excel based. This was something that 1010data did natively which spurred the Excel culture internally at the Client. However, Snowflake did not have a direct connector to Excel. This lack of Excel support was a show stopper for many of their users.

The data within 1010data often had data quality issues related to the formatting of the data on entry and a lack of gatekeeping by 1010data’s schemas. Additionally, the quantity of data within 1010data was very high but the ability to extract that data was very low. A brute force method would take over 2 weeks of continuous loading to completely extract. If the extraction process failed during the 2 week period, it would have to be restarted from the beginning.

Check out our latest case study: https://view.attach.io/FEfY7M9r