Questions are posted below and excel to help with the questions are uploaded

Analytics mindset

Part 1

Required:

► Review these questions to gain insights and prepare responses for each of the questions that were identified by using appropriate charts, graphs, and summaries in a concise, brief, and clear manner.

►   Provide two recommendation to management to support their business strategy.

1.   Reduce inventory of slow-moving and obsolete products

a.        How do the sales of Tablets compare withforecasts?

b.       How do the sales of Tablets compare with prior yearsales?

c.        How are the sales of Venezuela compared with that of the United States (total sales, price per unit)?

d.       How are the returns of Bangladesh compared with forecasts with that of the United States, specifically about selling DVDplayers?

e.        If there is a particular product not selling well, is this specific to any particularregion?

2.   Enhance the marketing strategy by producttype

a.        Why do United States sales have a higher change in sales than the rest of theworld?

b.       Pick a product which performs poorly in a high-performing country. How is this product performing compared with the sales in othercountries?

c.        Why is the U.S. increasing rapidly in comparison with the Globalsales?