Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

hii just need introduction and recommendations as females are more than males Assignment You are a Research consultant to Bestlife Fitness Club, your task is

hii just need introduction and recommendations as females are more than males image text in transcribed
Assignment You are a Research consultant to Bestlife Fitness Club, your task is to analyze the customer data provided and generate insights and recommendations to help BFC increase its revenues at its existing facility Download the Bestlife Fitness Club Excel Customer database from Blackboard / Assignments Using the Excel tools learnt of Sort, Filter, Tables, Charts and Pivot tables, use different chart types as appropriate to answer the following questions. All charts must include clear titles data labels and percentages. Colour is preferred for graphs. Copy your charts, tables and comments to your report, either in Word or Powerpoint Include a cover page with your name, student number, Assignment, course, professor, date. Include an introduction and a summary of your recommendations (See Rubtic) Club Member 1. Identify existing club member demographics (gender, age. Pivot Charts Demographics Income, education), Show numbers in pivot charts. Add clear Bullet points and Usership chart title and data labels. Explain bullet points using %'s or averages 2. Identify club member activity usage patterns. Which services Pivot Tables are most frequently used by AGE and GENDER? Add clear titles Bullet points to Pivot Tables, which areas of the Fitness Club should be developed? 3. Which customer INCOME and EDUCATION groups contribute Pivot Tables more to the Club's revenues? Which groups should be targeted to Bullet points improve BFC revenues? Add clear titles to Pivot Tables 4. Analyze club visit frequency and time of day when members Pivot Tables come to the club using pivot tables. How could BFC increase its Bullet points rovence Ru 0 1 C DII $ Prtsen F PrtScn Home End FO F4 FS F6 F & Assignment You are a Research consultant to Bestlife Fitness Club, your task is to analyze the customer data provided and generate insights and recommendations to help BFC increase its revenues at its existing facility Download the Bestlife Fitness Club Excel Customer database from Blackboard / Assignments Using the Excel tools learnt of Sort, Filter, Tables, Charts and Pivot tables, use different chart types as appropriate to answer the following questions. All charts must include clear titles data labels and percentages. Colour is preferred for graphs. Copy your charts, tables and comments to your report, either in Word or Powerpoint Include a cover page with your name, student number, Assignment, course, professor, date. Include an introduction and a summary of your recommendations (See Rubtic) Club Member 1. Identify existing club member demographics (gender, age. Pivot Charts Demographics Income, education), Show numbers in pivot charts. Add clear Bullet points and Usership chart title and data labels. Explain bullet points using %'s or averages 2. Identify club member activity usage patterns. Which services Pivot Tables are most frequently used by AGE and GENDER? Add clear titles Bullet points to Pivot Tables, which areas of the Fitness Club should be developed? 3. Which customer INCOME and EDUCATION groups contribute Pivot Tables more to the Club's revenues? Which groups should be targeted to Bullet points improve BFC revenues? Add clear titles to Pivot Tables 4. Analyze club visit frequency and time of day when members Pivot Tables come to the club using pivot tables. How could BFC increase its Bullet points rovence Ru 0 1 C DII $ Prtsen F PrtScn Home End FO F4 FS F6 F &

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Focus On Personal Finance

Authors: Jack Kapoor, Les Dlabay, Robert J. Hughes, Melissa Hart

7th Edition

1265521972, 978-1265521974

More Books

Students also viewed these Finance questions