Case Studies | Analytics, BI, Data Integration, Cloud Services, ERP

Case Study: Networking Hardware Company - IoT Reporting with Tableau and Snowflake

Written by KPI Partners News Team | Apr 7, 2020 12:36:59 AM

 About Networking Hardware Company

Customer is a leading manufacturer of networking equipment with annual revenues of $1.4 billion and over 1,000 employees.

Customer Need / Business Driver

Our client business is providing their customers with network hardware in retail, commercial, and as a service. In order to maintain the quality of these products and services, prompt and accurate reporting on the data from these devices is required at all times.

Approx. 80-90 GB JSON data is generated per day from Customer’s routers. Customer’s previous Router Analytics IoT application was loaded to Hadoop and relied upon Tableau querying the Hadoop / Hive data. Tableau reports were taking over 20 minutes to return results which was unacceptable to the Customer business teams.

Selection Process

Customer evaluated AWS Red Shift, Google Big Query and Snowflake for cloud data platforms and selected Snowflake for its ease of use, architecture and low TCO. 

Customer selected KPI for their expertise in Hadoop, Snowflake, and Tableau, whilst providing a blended shore team, is part of a multi-year engagement with Customer to evaluate, develop, and support their analytical efforts across multiple regions. KPI’s expertise, experience, and offshore project centers greatly minimize cost and risk for Customer.

What KPI Delivered

In order to address the report performance issues, KPI proposed Snowflake on AWS. Snowflake’s capacity and usage pricing for its Massively Parallel Performance (MPP) complemented the Hadoop Data Lake without the need for expensive alternative solutions.

This approach allows the KPI team to crunch real-time data, prepare, model, and visualize in Tableau in a short period of time with a set of orchestrated events.

By leveraging Snowflake with Hadoop, Tableau report performance has increased from 20 minutes to less than 7 seconds allowing users do true speed of thought data exploration and analysis.

Business Benefits

Ad-hoc / Real-time analysis is a key feature for Big Data Visualization. By complementing the Hadoop Data Lake with Snowflake the  re-architected Router Analytics provide near real-time analysis in Tableau. This solution allows Customer business users to visualize millions of records and supports growth and customer satisfaction goals for their business teams.