RAPID DATA INTEGRATION & DASHBOARDS Next Case Study

Client Organization:

World's top-2 computer networking company, California, USA

Project Owner:

Head Of Sales

The Problem:

Sales reports from all over the world arrive as Excel files with substantial variability, from substantially different sales entities. Aggregating these reports and creating a unified view was a tedious and time taking job.

The Solution:

Quadratyx created a platform to rapidly unify tens of thousands of such files without much domain help, and build attractive, interactive, aggregation dashboards on the unified data for various levels of decision makers with proper authentication & authorization functionalities. We used Pentaho ETL tool for integration and transformation of the data. We used Tableau to create four business dashboards. The dashboards displayed the sales data & facilitated at-a-glance understanding of profitability, with views presented by geography, product category, customer segment, year on year and quarter on quarter percentage growth with top customers and top products highlighted. Each dashboard offers deep layers of information, allowing customer to identify specific problems and offers in minutes.

Tools & Technologies:

Excel macros, Pentaho, Tableau, MySQL.