Case Study

A vendor customer of Accelerated Analytics who supplies to a large retailer was faced with the difficulty of analyzing EDI 852 on their items from over 1800 stores. The data would arrive on Sunday night which they would translate into a spreadsheet and then begin to identify slow selling stores and stores in a stock-out situation. The analysis was complex and took about 20 hours of administrative time each week. Worst of all, they have a dozen retail customers that were also offering to send EDI 852 data but they didn't have the time to analyze that much data. They knew they were missing valuable sales but they did not have any way to identify the problem stores and communicate with their buyers.

They then engaged the Accelerated Analytics service. Our team setup a custom database in our hosted data center and began translating the EDI 852 data and loading it into our reporting tools. With two weeks the vendor had customized reports by item and store showing units sales, and on-hand position. From these reports they were able to quickly determine which stores were causing the lost sales. Using our simple reports they scheduled a meeting with their buyer. It was a totally new experience for both the buyer and the vendor because they had quantitative reports isolating the problems stores. Together they determined that a 1200 store blanket order was the solution. It was the vendors largest order to date and without Accelerated Analytics they would have never been able to show the buyer where the problems were. The vendor estimates our reports increased their sales by over $5 million dollars in less than one month.