Solutions
- Home
- Solutions
- Microsoft
Distribution Data Analysis
This solution allows distributors to collect data down to the store and item level. Weekly data feeds are collected in XML format on an FTP server. The data is then cleansed and validated through a browser based adminstrative application and added to the data warehouse. Business Intelligence tools are overlayed to give users the ability to do data analysis, trending, and forecasting. This is accomplished through OLAP (On Line Analytical Processing) software and other Reporting tools.
Some of the Key Benefits of the solution are the following:
- Provides Distributors with timely draw, return, sales and efficiency % for each of their SKUs on a dealer, retail banner/chain, class of trade and geographic region.
- Distributors are able to compare competitive SKUs draw, return, sale and efficiency on a per issue, dealer, retail banner/chain, class of trade and geographic region based on pre-defined competitive title assignments.
- Distributors are able to better manage supply chain forecasting with or without seasonality balancing.







