Scribd
Upload
15 views2 pages

Sales Data Analysis and Dashboard Guide

The document outlines various practical questions related to sales data analysis using pivot tables and dashboards. It includes inquiries about product sales by specific salespeople in different countries, sales trends, and revenue generation by region. Additionally, it requests the creation of a bonus column for salespeople based on total sales and emphasizes the need for a consolidated dashboard with charts and slicers.

Uploaded by

Bhargav D.S.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
15 views2 pages

Sales Data Analysis and Dashboard Guide

The document outlines various practical questions related to sales data analysis using pivot tables and dashboards. It includes inquiries about product sales by specific salespeople in different countries, sales trends, and revenue generation by region. Additionally, it requests the creation of a bonus column for salespeople based on total sales and emphasizes the need for a consolidated dashboard with charts and slicers.

Uploaded by

Bhargav D.S.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Practical Questions

Pivot Table Shipping Sheet:-

Q. I want to know how many products Michael have sold in Finland, Germany & Ireland? 37

Q. I want to know about the information of Salesperson and the quantity of products sold to
around the horn with the product name? 650

Q. There is a sales person with the name Anne Dodsworth. Let me know the company name
and number of products sold in Brazil, Canada & Germany? 31

Q. What is the quantity of products sold by Anne Dodsworth in Quarter1 & Quarter 3? 1551

Q Without making any changes in the source data kindly create a column of Bonus for
Salesperson where If Total Sales made by salesperson is greater than 150000, the salesperson
should get 4% of difference from Total Sales.

Sales Dashboard Practice File (Need to create Pivot table along with the appropriate charts)

Q I want to see the revenue generated region wise

Q I want to see the monthly sales trend

Q Kindly showcase the revenue generated by each sales person in descending form (highest at
the top) & same should be replicated in the chart as well.

Q Dashboard should also contain the data of our Top 5 customers

Q Transaction count by invoice keeping the interval range of $2000

**All the above charts should be presented in a single sheet as dashboards connected with the
slicer of products and Salesperson

You might also like