Case Studies
Privately Held Wholesale Distributor Achieves Comprehensive View Into Overall Businesses With Informer
Overview
Analytics & Modeling - Predictive Analytics Application Infrastructure & Middleware - Data Exchange & Integration Application Infrastructure & Middleware - Data Visualization | |
Business Operation Quality Assurance Sales & Marketing | |
Inventory Management | |
Data Science Services System Integration Training | |
Operational Impact
The BI Director started using Informer 5 in July 2017 and immediately began generating ad-hoc reports and visualizations for several managers and executives. | |
To consolidate data necessary for analysis, he worked with the newly acquired company’s IT team to extract data from their FileMaker database and import it into Informer as separate Datasets. These Datasets range in size from 2K rows for the customer set to 3.7 million rows for the line item detail set. After the consolidation process, the core data file resulted in 700K rows with around twenty columns. | |
With this data now blended, he generates graphics and KPI reports that the business development team uses for board meetings. | |
Quantitative Benefit
The core data file resulted in 700K rows with around twenty columns after the consolidation process. | |
The line item detail set from the newly acquired company’s FileMaker database contained 3.7 million rows. | |
The customer set from the newly acquired company’s FileMaker database contained 2K rows. | |