We take pride in delivering quality solutions...

Data Lakes and Warehouses

Trade Association’s Analytics Platform

What was the problem?

Our client is the nation’s leading trade association representing the boating industry and provides data and insights to manufacturers within its membership. Their data strategy involved moving away from manual, static report building to an automated solution that supports interactive data exploration.  

How we helped?

The One Six Solutions team supported the selection and implementation of products enabling the data strategy for both the client’s membership as well as internal departments. We provided a solution that is sustainable and easy to maintain for an organization that has a small IT team.

What were some of the tools used?

The data architecture started with a custom web application for members to upload data files built using Microsoft Azure. The files were processed with validation rules and moved to Amazon S3 for initial storage. After data replication into Snowflake enabled by Fivetran, the loaded extracts were transformed via Matillion ELT to create the data model.  Power BI provided users with interactive visualizations of the industry data sets. These architecture components were automated to process data incrementally as new data arrives.    

What were the results?

Our client was empowered to manage data in the the modern analytics environment we helped create and freed to consider new problems that can be solved. The scalable solution allows the organization to operate with cost-effectiveness.  Members can explore their data against the industry now in ways previously not possible. The internal departments can  plan to build a holistic solution in the near future to analyze consumer engagement through multiple channels. Two legacy platforms and their associated maintenance costs were  sunset by the new solution.