Data Integration of Multiple Sales Files – for a large Telecommunications Company
A telecom company sells products through 3rd party retail locations across the country. For all types of sales analysis purposes, every week each location sends a sales report to corporate headquarters, which is merged with all types of other corporate data for analysis. Scores of files are sent to one person who needs to integrate them into a clean, single report. Before FreeSight, efforts to streamline this process resulted in reducing the manual processing time down to four or five hours to complete the integration task.
But, then, our customer created a FreeSight process that automatically imports all of the individual reports and integrates them into one merged and cleaned dataset. It now takes one click and less than five minutes to import over 100 files into one data table for analysis.