At **** we want to understand the impact of new features on our customer base, in as much detail as possible. As we attempt to build new channels to connect the in store to the online we develop new products and build on existing features. One of these new products is referred to as ‘One to One Appointments Booking’, which is a pre-booking system designed to schedule calls in advance. Customers can book, cancel or modify their booking prior to the scheduled launch of the 2 way video call.
Imagine you have been asked to give a 15 minute presentation to ***** senior leadership team. You have been asked to report on the performance of the new Appointments channel.
- How has the new Appointment feature performed overall? What are the key takeaways?
- What variables contribute to successful and converting Appointments? Are there any pitfalls evident in the data? How could the service be improved? How could we better inform our clients to help them use the service better?
We have provided you with a fictional sample of Appointment data csv with a field description explainer attached in an excel.
In this test we are looking for you to:
- Manipulate data to draw insights & then communicate these insights effectively to senior non-technical colleagues
- Consider and deal with ‘edge cases’ or ‘irregularities’ in the data
- Present your findings in a clear and concise manner relevant to briefings for senior executives
- Discuss what you’d do next, such as what other data would you have liked to bring this research to life more
- You can undertake the analysis using whichever tools or techniques you like (e.g. R, Python, Power BI, Excel etc..). We suggest you use the tools you are most familiar and comfortable with.
- The output of your work should be appropriate for your imaginary audience (eg. Senior Leadership Team).
- Don’t over complicate it.