You are leaving our main website to go to our chinese website hosted in China. For legal reasons there will not be any links pointing back to the main website.
Background
Frederick Wildman & Sons, a leader in fine wine and spirits sourcing and distributing, was looking to optimize its database, reduce administration costs, and minimize maintenance efforts. The company was also looking to sunset their on-premise SQL 2008 database server, whose Microsoft support was running out.
As Keyrus assessed Frederick Wildman’s current IT and server environments, we determined that multiple on-premise servers meant a higher cost of maintenance and administration for the company. Their database administrators were spending a lot of time and effort on tasks that could be automated with the right platform.
In selecting the right solution, Frederick Wildman’s goals were to build a strong foundation for an analytics platform, improve data availability and scalability, reduce administrative costs, dismantle the SQL servers, and move their platform to the cloud.
Recommendation
Keyrus worked with Frederick Wildman to assess potential solutions. Comparing a Snowflake to Azure databases and to a hosted SQL Server, we determined that Frederick Wildman’s data usage meant they could save significantly by moving to Snowflake. For context, a sample pricing matrix for a small environment is below.
Snowflake would also allow our client to scale up usage in the future as enterprise requirements grow. Frederick Wildman can plan for greater concurrency by increasing Snowflake’s cluster count limit, plan for greater power by increasing Snowflake’s cluster size and track usage via built-in administration dashboards.
Solution
Frederick Wildman went forward with Snowflake’s fully-managed, cloud-based data warehouse solution, and Keyrus assisted in the migration. The Keyrus team implemented a production-ready platform on Snowflake, configured with full integration to an Azure active directory. First, we moved data from those SQL Servers into Snowflake via Alteryx’s Snowflake bulk connection which is built to load large data volumes quickly (see next section). We set up virtual warehouses for different departments to enable data storage and set up usage alerts to monitor costs. The Snowflake solution also significantly reduced administrative costs from manual effort previously required to maintain SQL databases (indexing, caching, encryption, etc) while simultaneously enabling elastic compute scaling to speed up query times.
Once the data was set up properly in Snowflake, we reconfigured existing Alteryx workflows to read from Snowflake and push curated data seamlessly to Tableau. Sales and marketing teams use Tableau to make decisions, and we cut over to the new data sources with no downtime. We also helped re-work some of the dashboards to be most effective to the business.
Spotlight - Snowflake Bulk Loader
Alteryx’s Snowflake Bulk Loader is used for writing large volumes of data at a high speed.
How does bulk loading work?
If you convert from one database management system to another, you would not want to waste time and resources reentering all the information (tables, columns, etc from all different departments) from the old database into the new one. Instead, this solution allows developers to dump the data from the old database into special files in AWS S3 buckets. The files are formatted to be read in parallel at high speeds to import data into a database on the Snowflake instance where tables are then created automatically.
Results
With Snowflake’s cloud platform and “pay as you go” pricing, Frederick Wildman was able to significantly cut administrative work and data warehousing costs. Frederick Wildman’s data is now governed and supported on a fully managed database, which includes Snowflake protecting their data through encryption, continuously backing it up, and providing a built-in disaster recovery solution.
Frederick Wildman’s new Alteryx workflows, adjusted by Keyrus to be compatible with Snowflake, can now run in parallel and faster than before. Snowflake’s smallest computing unit has more computing power than Frederick Wildman’s old servers, meaning Snowflake can handle more data extraction and data transformation than their previous environment could - and with fewer manual hours of maintenance. Finally, Frederick Wildman is paying less for a faster cloud-based data warehouse with more elastically scalable computing power.
Keyrus continues to assist Frederick Wildman & Sons in applying Snowflake’s best practices, ensuring that they get the most value out of their new data platform.
Never miss an insight
Stay updated on the latest articles, events, and more
Your email address is only used to send you the Keyrus newsletter and for commercial prospecting purposes. You can use the link in our emails to opt-out at any time. Learn more about the management of your data and your rights.
Continue reading
Press release
Keyrus named amongst Top B2B Companies on Clutch
The Keyrus team is excited to announce that we’ve been named one of the top 1000 companies on Clutch’s platform in 2022! This is the second year that Keyrus has been recognized by Clutch as a top company and B2B leader.
Webinar
PDF Parsing with Alteryx Intelligence Suite
In 20 minutes, we’ll teach you how to use Alteryx Intelligence Suite to eliminate common problems and inefficiencies in accessing data from .pdf files. In the past, you’d need to run custom Python and complex parsing logic to get any usable data from a pdf. Now, you can parse PDFs with out-of-the-box features in Alteryx Intelligence Suite.
Webinar
Modern Cloud Analytics in Action: Keyrus and Red Ventures
The cloud offers new opportunities to save you time and money, allowing you to shift focus from maintaining growing servers and upgrading infrastructure to making your data work for you and the success of your business. Watch the webinar and Q&A to learn how AWS, Tableau, and Keyrus worked together to help Red Ventures migrate to a powerful cloud BI tool that created new pathways for success and a modern data culture.
Event
Pharma/Biotech GTN Summit 2022
Keyrus & Anaplan Sponsor Life Science Gross-to-Net (GTN) Summit
Press release
Keyrus Achieves AWS Data and Analytics Competency Status
Keyrus achieved Amazon Web Services (AWS) Data and Analytics Competency. To receive the designation, AWS Partners must possess deep AWS expertise and deliver solutions seamlessly on AWS.
Webinar
Live Webinar: Lessons on workforce capacity planning and optimization from Optum (UnitedHealthcare)
Wednesday, November 9th, 2022 @ 12:00PM Central Time (US and Canada)
Webinar
Tableau Embedded Analytics: Optimizing insights from Salesforce data
Want to optimize your visual analytics in Salesforce? You need the right tools. Tableau Embedded Analytics can be used to help you build and visualize reports in Salesforce.
Success story
How C&S Wholesale Grocers maximized ROI with an analytics center of excellence
C&S Wholesale Grocers worked with Keyrus and Alteryx to implement an analytics center of excellence to help them efficiently and effectively achieve business objectives, maximize return on investment (ROI), and standardize best practices.
Success story
Implementing a cloud security automation tool at a global consulting firm
Keyrus partnered with a consulting firm to build an in-house cloud security solution that would automate their verification processes and keep their information safe.
Success story
Leveraging Salesforce to improve operations at Pajama Program
Keyrus partnered with Pajama Program, a nonprofit organization, to review their Salesforce architecture and improve overall operations.