Question
The General manager of A mutli-branch gym is interested to count the number of subscribers and the revenue generated according to branches located in different
The General manager of A mutli-branch gym is interested to count the number of subscribers and the revenue generated according to branches located in different areas, cities, and countries. Also, they are asking to view the analysis according to subscribed provided services (weight room, sauna, pool, climbing wall , ..), Subscription timing(AM or PM), age ranges of the subscribers, Subscriber gender, Type of subscription (monthly, weekly, yearly, by visit). Analysis must be done according to subscription month and year. Question 1. Find the dimensions, measures, KPI 2. Generate some data records 3. Draw the star schema on Excel
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started