Data analysis using powerpivot
$30-250 AUD
Paid on delivery
Tara King, a production manager at JSOE has suggested that around 10% of JSOE
product range should no longer be sold (dropped) by JSOE.
• Which products would you suggest that Tara King consider dropping? Justify
your suggestions.
• Do you recommend that all/some of these products be dropped? Justify your
recommendation (based on your limited knowledge of the business).
b) A few months ago, a column named CustValueRating was added to the customer
table. The rating values are intended to reflect the 'value' of the customer to the
business based on sales history. A score of 1 indicates that the customer is highly
valued while a score of 4 indicates that the customer is in the group that should be
least valued by the JSOE. Emma Peel, JSOE's leading sales person has doubted
the validity of the values in the database.
• Is Emma correct in doubting the CustValueRating values? Why?
If Emma’s doubting is correct, create a new CustValueRating value and
show the top 20 (or thereabouts) customers. Describe the method used to
calculate new values.
Project ID: #13548589
About the project
8 freelancers are bidding on average $146 for this job
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More
Dear I am an Excel spreadsheet professional having hands on expertise in developing spreadsheets for various purposes. besides that I am an MBA with sound knowledge on cost management accounting. your project is purely More
