Reference no: EM133035900
Relevant Information
Are-You-Fit-Gym (AYFG) provides a clean, friendly, and non-intimidating atmosphere where exercise can be enjoyed 24 hours a day every day. Their services include free weights, cardiovascular equipment, juice bar, pro shop, sauna and locker facilities. While membership fee is their primary source of revenue, other sources of revenue include one day passes and sales of items (in pro shop and juice bar).
Ms. Swarzginger, the wife of the CEO, Mr. Swarzginger, has recently started organizing corporate events. For organizing corporate events (and renting some equipment of AYFG), corporate customers are charged a fixed fee - see details in Table 1. Thus, rental fee has recently become an additional source of revenue.
By better understanding their customers and their buying patterns, AYFG wants to improve its revenue generating performance. The CEO believes that to achieve this goal, improved decisions that relate merchandize and customers to revenue (and quantity sold) over time are required. He is very enthusiastic about the idea of a data warehouse, which -- according to you -- would support a much better analysis revenue. You conducted interviews and found goals and business questions that are important for AYFG.
|
Goals
|
Questions
|
|
Identify the "types of customers" (and "customers") that AYFG should focus on.
|
- Which "customer type" (i.e., individual and corporate) generates the most revenue? What is the trend over quarters?
- Who are the "customers" that generate the most revenue over quarters?
|
|
Identify what AYFG should focus on selling.
|
- Which "merchandise type" (i.e., item, membership, one-day-pass and event) is the largest revenue generating? How is the revenue generating pattern of "merchandise type" been changing over time (dates, quarter and year)?
- In terms of quantity, what is the best selling "merchandise[1]"? How is that changing over time (dates, quarter, year)?
|
[1] Note that anything that generates revenue is referred to as merchandise.
My Question:
How would you go about creating the fact/qualifier matrix?