* Two key performance indicators- sales performance and profit contribution by product – were selected as the first phase.
* Within a short period, the requirements analysis was complete, and a prototype was ready for review by regional and store managers.
* All the information will be collected and stored at one centralized database from number of stores.
* Step by step, additional regions were added to the data warehouse, resulting I the successful consolidation of sales data for the entire company.
* The process to gather data and consolidate data is now performed on a daily basis in the hours during which an individual store is closed.
* The data is captured from the point-of –sale devices in the store early each morning and stored in a proprietary transaction log format that is collected at corporate headquarters.
Solution Benefits
* Access to information has enabled management to take specific steps to improve the day-to-day operations of the business through performance improvements, data quantity improvements, loss prevention and productivity gains.
--> Improved Sales Performance
--> Improved Data Quality
--> Fraud and Loss Prevention
--> Improved Productivity
--> Project Challenges
--> Data Volumes
--> Data Integration
--> Lessons Learned
Future Plans......
