Quantitative Methods for Business
You are currently working at an event management firm. You have been assigned to a new client who is having adestination event with an international guest list. You have been tasked with managing their guest list throughout theplanning process of their event. Additionally, an intern will start working with you approximately 1 month before the eventbegins and must be onboarded to your project quickly as well as the client will be asking you questions about thesummary of their event throughout the planning process. The start date of your event is May 21st, 2020 with the mainevent being May 23rd, 2020 and guest departure being on May 24th, 2020. Follow the data below(attachment)
spreadsheet
Your guest list manager must have the following capabilities:
- Data dictionary.
- Track RSVPs of your guests.
- Track arrival and departure information of your guests.
- Track gifts from your guests.
- Add a new feature that you believe is crucial to the successful completion of your event. Impute the data and be sure to include as part of your dashboard and analysis.
- Create at least four visualizations of your data.
- Am I able to contact the ones who have not RSVP’ed? Can I use their email, phone or both?
- Answer the following for all guests, attending guests and not attending guests.
- What is the average gift?
- What is the variance of gifts?
2.Merge all datasets into a master guest list.
3.Create a dashboard, write formulas that enable you to:
document (example——attachment )
Provide answers to the following questions.
1.Readme documentation.
2.Total guests on the guest list
3.How many have missing addresses for invitations.
4.How many have missing emails AND phone, email OR phone for contact information
5.How many are attending, not attending, have not RSVP’ed.
6.How many guests are staying for 1, 2, 3 or all days?
a.What is the average stay of the guests?
7.How many guests provided a gift?
ii.What is the range of gifts?
presentation
Create a presentation around the story behind your event. Provide a background and context and utilize visualizations toprovide insights to the data you have collected and analyzed. Be sure to use your dashboard to answer any questions andshow that you can track the various data points of your guest list.
Your presentation should address the following aspects:
-Background & Context – what is the story?
-Data – what data are we collecting/tracking and why?
-Insights – what did you discover?
-Conclusion & Next Steps – where can the project go from here?
0 comments