Victoria’s Secret has used an "average store" concept in its inventory management system. Today the company uses a joint data warehouse and intranet application system. The result is based on MicroStrategy's DSS Server, a relational On-Line Analytical Processing (OLAP) server optimized for very large database (VLDB) analysis. The data warehouse that drives the application contains detailed information about the sales and inventory levels for each item in each store. The application enables associates to make decisions to improve their in-stock position and create individualized color/size models for each store. MicroStrategy's DSS Web has an access to the database and helps communication between the data warehouse and the browser. About 20 million rows of data are loaded into the system weekly. Over 1,000 queries are run each week, with the most frequently-executed queries coming from intranet users.
Victoria’s Secret has about 20 percent growth rate per month in users. When a user queries the data warehouse and receives an answer, guided walk-throughs, tutorials, and customized help screens gives instructions for what actions to take based on the results of those analyses. New intranet application program lets associates access detailed information and take action based on the info they receive from the data. It makes easier to adjust to reorder products based on store's selling patterns and inventory.
Victoria’s Secret plans to use DSS Web and the data warehouse to use a point-of-sale decision support system and using Web terminal in every store. When a product is sold out, the employee can see the situation (is the product in transit and if nearby stores have that particular product in inventory).
Victoria’s Secret has about 20 percent growth rate per month in users. When a user queries the data warehouse and receives an answer, guided walk-throughs, tutorials, and customized help screens gives instructions for what actions to take based on the results of those analyses. New intranet application program lets associates access detailed information and take action based on the info they receive from the data. It makes easier to adjust to reorder products based on store's selling patterns and inventory.
Victoria’s Secret plans to use DSS Web and the data warehouse to use a point-of-sale decision support system and using Web terminal in every store. When a product is sold out, the employee can see the situation (is the product in transit and if nearby stores have that particular product in inventory).
No comments:
Post a Comment