Move to Snowflake streamlines financial reporting for fast-growing coffee company

Consumer Goods & Services

US

An aging SQL Server infrastructure meant compiling POS reports in Excel spreadsheets for this growing coffee company. Finance lacked current, actionable data and IT didn’t possess the required expertise to implement a cloud solution on their own. Pythian worked closely with both teams to uncover a custom solution.

A Snowflake Data Cloud hosted on an Azure cloud was implemented and now processes more than half a billion POS records at near real-time speeds. Finance can drill into line-item order detail and IT can track and allocate cloud usage and costs–creating scalability and unlimited capacity for data analysis.

After just six months, the Snowflake Data Cloud already stores more than a half billion POS records for analysis. Finance loves the dramatically simplified reporting process. Instead of consuming days (or weeks) of manual work to compile data for analysis, the team can make decisions with near real-time data. 

IT likes the platform’s ease of use, which frees the limited team resources for other uses. The IT organization can now set up virtual data warehouses in Snowflake, which let them monitor activity by users and departments, and then charge back cloud computing costs accordingly.