Mining the Data Warehouse Alana Smith is a senior buyer for a large wholesaler that sells different types of arts and crafts to greeting card stores such as Hallmark. Smith's latest marketing strategy is to send all of her customers a new line of handmade picture frames from Russia.
All of her information supports her decision for the new line. Her analysis predicts that the frames should sell an average of 10 to 15 per store, per day. Smith is excited about the new line and is positive it will be a success. One month later Smith learns the frames are selling 50 percent below expectations and averaging between five and eight frames sold daily in each store.
She decides to access the company's data warehouse information to determine why sales are below expectations.
Identify several different dimensions of information that Smith will want to analyze to help her decide what is causing the problems with the picture frame sales.