Scribd
Upload
8 views2 pages

Assignment Explanation

The document outlines the requirements for a sales data visualization, including a table/matrix displaying customer-wise sales amounts and units purchased, sorted by customer name. It also specifies the addition of two slicers: one for 'Top Customers' with options for filtering by the top 10, 20, or 30 customers based on total sales, and another for selecting a date range. The format of the data presentation is emphasized as crucial, with specific instructions on how it should be displayed.

Uploaded by

Rashid Malik
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
8 views2 pages

Assignment Explanation

The document outlines the requirements for a sales data visualization, including a table/matrix displaying customer-wise sales amounts and units purchased, sorted by customer name. It also specifies the addition of two slicers: one for 'Top Customers' with options for filtering by the top 10, 20, or 30 customers based on total sales, and another for selecting a date range. The format of the data presentation is emphasized as crucial, with specific instructions on how it should be displayed.

Uploaded by

Rashid Malik
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

Dataset: A sample “Sales Data” has been attached in the email which contains 5 columns – Sale Date,

Type of Sale, Customer Name, Amount, and No. of Units Purchased.

Final Output – Add a Table/Matrix + 2 Slicers on the page

1. (Table/Matrix):
- Show Customer wise Sale Amount and No. of Units purchased – Online and Offline in the
following format as shown in the image below.
- Sorting order is not mandatory for time being. But it would be great if the visual is sorted by
Customer Name from Ascending to Descending order (as shown below)

Note: Format in which the data should be shown is most important. Please don’t show it in any other
format other than the below shown format, i.e. rows should contain Customers and columns should
contain Total Amount and Total Units by Online and Offline.

2. (Slicers):
- Add 2 slicers on the same page – “Top Customers” slicer and “Date Range” slicer

Functionality:

Top Customers – This slicer contains 3 values – [Top 10, Top 20, Top 30].
If someone clicks on Top 10, only those Customers should get filtered whose Total amount (Offline +
Online combined) is falling in Top 10 (by descending order).
Similarly, if Top 20 is clicked, then top 20 customers by total amount should be filtered, etc.

Date Slicer – Create a Date range slicer based on the sale date
The Final output should look something similar to this.

Additional screenshot:

--If someone clicks on “Top 10” in the Top Customers slicer, then, only Top 10 customers by Total
Amount should be filtered as shown in the below screenshot

You might also like