Project 3: Performing Data Analytics SCENARIO: You are an Advisory Senior Associate of a business analytics team at PwC and your manager wants to discuss with you on a new engagement with a client, Franklin Pizza.
Project 3: Performing Data Analytics
SCENARIO:
You are an Advisory Senior Associate of a business analytics team at PwC and your manager wants to discuss with you on a new engagement with a client, Franklin Pizza.
The Franklin Pizza restaurant has 4 locations in Franklin, MA. The company wants your team’s help in looking at the data related to number of quality pizzas made per person in the last 50 months and overall customer satisfaction index (CSI) for these months. CSI is measured on a scale of 1 to 10 with 10 indicating highest satisfaction. This data is as shown in the uploaded excel file below.
The company wants answers the following questions.
- Are all locations performing in a consistent manner to produce quality pizzas or there is a difference between them? If there is a difference, which location (s) is performing better than other locations?
- Is there a relation between the average pizzas/person corresponding to the four locations and the CSI? Can that relation be expressed with analytical model to predict CSI in future.
In addition, you tested your analytical model with 50 observations that are not part of model development. To keep things simple for explaining client, you will be using the following CSI range to distinguish satisfied and dissatisfied customers.
Satisfied: 9 to 10; Dissatisfied: less than 9
Using above scale, your model for test data has following performance measures:
Accuracy = 0.9; Precision = 0.87; Recall =0.91 and there are 20 true positives.
With this information, you need create a confusion matrix and provide explanation along with answers to above questions.
Based on above analysis, you need to provide a set of recommendations that includes
- answering client’s questions
- model performance aspects.
KEY TASKS
You need to write a report to client explaining your analysis. Be sure to include the following:
- Your final recommendations should include answering client’s questions using the given data.
- Your explanation should be based on analytical techniques used and model performance analysis.
- Any other considerations/additional information you feel are relevant to your recommendations.
WHAT TO SUBMIT:
A maximum of 2 pages report to the client (excluding the title page and references)
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
