Inventory Management

Victoria's Secret Stores makes inventory every 6 months and it hires a datawarehouse to do its inventory. Today, Victoria's Secret is using MicroStrategy's DSS Agent a relational On-Line Analytical Processing (OLAP) server optimized for very large database (VLDB) analysis. This system help the company to manage inventory, analyze market demand and gather information about the sales and inventory levels for each item in each store. In addition, using DSS Agent, reduce the time and personnel required to perform ad hoc analysis.

DSS Agent has enabled Victoria's Secret to reduce out-of-stock instances on selected items from 20% to 5%, by tracking daily movement figures and minimizing inventory shortfalls. DSS Agent is providing Victoria's Secret with a better understanding of critical information such as size selling patterns and how they vary by geography. For example, using DSS Agent, merchandisers were able to determine that Miami-area consumers buy ivory bras 10 times more often than black bras and that in New York, demand for size 32 bras is 20 times higher than the company average. By improving the in-stock situation, Victoria's Secret avoids lost sales and more efficiently allocates its inventory to its stores