Fresh Water Systems is a leader in water filters, water filtration, purification and treatment. The company offers thousands of water treatment products by top manufacturers. Fresh Water Systems was founded over 25 years ago, but the company recently modernized and amplified its data management capabilities.
The Challenge: Inflexible Legacy Systems
John Wessel is the Director of IT and Data Manager at Fresh Water Systems and he led the implementation of a cloud data management platform at the company. Before Fresh Water Systems implemented a cloud data warehousing solution, its data was managed using a legacy system. This system was inflexible, making new integrations and connections to other data sources resource-intensive. As Fresh Water Systems has grown, the amount of data and platforms they leverage has increased. The company needed a data warehouse that would adapt and grow with them into the future.
Solution: A Data Warehouse Upgrade
Wessel helped spearhead the project to modernize the company’s data management . He analyzed the current systems and determined its data infrastructure needs. Wessel described the company’s ideal data stack, “We wanted something fully hosted, columnar and we preferred Panoply because it’s built as a layer on top of Amazon Redshift.”
When implementing Panoply, Wessel immediately noticed its speed and ease of use. Of the setup process, he shared, “Once I started using Panoply, when I added data sources and data was pulled in and accessible within minutes….I realized I had to do zero ETL. That was HUGE.”
In addition to Panoply, Fresh Water Systems also implemented Stitch Data for ETL which opened up many data sources for easy access. Throughout its data management, the company uses many of Panoply’s native data connectors.
Results: More Data in Less Time
For Fresh Water Systems, the benefits of implementing a cloud data warehouse solution include time-savings, resource management, and data democratization.
Now that Fresh Water Systems operates on a cloud-based data management solution, the company has reduced its IT team from 7 to 3 employees, according to Wessel.
He also shared, “We don’t need a DBA or a networking engineer. We have strategic partners now such as Panoply and have saved many costs and long-term headaches.”
The company has also been able to access its ecommerce data seamlessly. Fresh Water Systems utilizes Shopify, and with a few clicks, the business was able to access its data for querying and analysis. Wessel said, “I easily saved two months of work with that single data integration alone.”
Finally, the company’s marketing department is able to access data easily and frequently for KPI monitoring and reports. Company executives have even begun exploring data because it is now so much more accessible and accurate.