DV mini3

Data Visualization Mini project2

Top N/ Bottom N to Display Most and Least Popular Products

The top 10 popular products by revenue and the least 10 popular products by revenue were

visualized to help in quick insights and decision making. The graph showed that Canon

imageCLASS 2200 Advanced Copier was the most popular product with $49,280K sales. The

second most popular product was Fellowes PB500 Electric Punch Plastic Comb Binding Machine

with Manual Bind whose revenue was $29,225K. The least popular product was the Eureka

Disposable Bags for Sanitaire Vibra Groomer | Upright Vac with only $2K sales revenue.

Calculations were first done as follows.

Calculate sales Revenue variable by; [Order Quantity] * [Prices]

Calculate total cost by; [Order Quantity] * [Costs]

Calculate Profits by; [Sales Revenue] – [Total Cost]

The Top N parameter was created using by clicking on drop down in the Data and selecting

“Create Parameter …”. The following fields were filled as shown.

The Top N parameter was duplicated, and Bottom N Parameter was created. Two sets were

created (Top N by Parameter) and (Bottom N by Parameter). The two sets are combined to form

(Top N and Bottom N). Drag “product name” to Rows and “Sales Revenue” to columns. Drag the

combined set (Top N and Bottom N) to Filters.

This helped in reducing the audience strain to read through all the values in order to understand

the most and the least popular products of the organization. Without the visualization, it meant

the audience will have to go through all products which is tedious and time consuming.

Top N/Bottom N to Display Most and Least Profitable Items

Visualization was done to determine the most profitable and the least profitable products in

order for the organization to draw valid conclusions. Figure 2 showed the results of the analysis

from Tableau.

Figure 2

The visualization showed that Canon imageCLASS 2200 Advanced Copier was the most profitable

product with $23,878K profit. The second most profitable product was Cisco TelePresence System

EX90 Videoconferencing Unit with a profit of $15,542K. The least profitable product was the

Eureka Disposable Bags for Sanitaire Vibra Groomer | Upright Vac with only $1K profits.

In order to come up with the graph, Drag “product name” to Rows and “Profits” to columns. Drag

the combined set (Top N and Bottom N) that was created in part 1 to Filters.

Profit of an organization is one of the most important items used in decision making. The

audience use this item to make decisions like investment and buying of the business. Giving them

a graph representation will save their time and they will have a clear understanding of the

products’ profitability situation. They can easily see the products that are letting the company

down.

Threshold

A threshold was created in order to indicate months which had “good” and “bad” profits. An

average threshold of $100 was set. Any month with profits less than $100 are considered “Bad”

months while those above were considered “Good” months. Figure 3 showed the results of the

analysis.

Figure 3

The blue bars indicate bad months while the brown indicates good months. According to the

analysis, February, May, and June did not meet the threshold and considered bad months while

January, March, April, July, August, September, October, November, and December were all good

months. March had the highest average profits of $150.

The following codes were set in Tableau to calculate the condition of the threshold.

IF AVG([Profits]) >= 100 THEN "Good" ELSE "Bad" END

Drag “Order Date” to Columns and “AVG(Profits)” to Rows. Move the calculated field named

“Good/ Bad Month” to Filters and Colors to get the visual representation above.

The audience at times would like to examine the months where the company makes the most

profits. Given a threshold, they can easily tell which months the best and which ones are where

the worst in terms of making profits. This gives them a clear identification of the required

information.

Shipping Date Threshold

The shipping time is vital in order to ensure customers get the products they ordered in time. The

data consist of shipping dates from 2018 to 2022. A date is such that orders done before the date

are considered early shipments while those after the date are considered late shipments. In order

to do so, a variable named “Threshold Time” was created using the formula; DATE

("05/05/2020") which sets 05/05/2020 as the time threshold. The following codes were used to

create “Early and Late Shipment”.

IF [Ship Date] < [Threshold Time] THEN "Early" ELSE "Late" END

Tables were created to show some of the dates that were early and late as shown in Table 1

below.

Table 1

Bonus Question

Top N% parameter was created to show the top products in terms of sales revenue. Figure 4

showed the results of the graphical representation.

Figure 4

According to the graphical representation, Canon imageCLASS 2200 Advanced Copier had the

highest percentage (20.90%) of the total sales revenue.

This was calculated by dragging Sales Revenue to Columns and Product Name to Rows. The Top N

Parameter created in part 1 is used to make a filter in this case. The sales revenue was changed to

percentages by clicking the following.

A graphical representation gives the audience a vivid explanation of the relationships in any

comparisons. In this case, the audience can easily determine the product with the highest

percentage of sales revenue. This eases the process of decision making and better understanding

of given scenario compared to looking at tables and figures.

Parameters that allow quick view and interaction

Create a parameter name “Placeholder 1 selector” with the following fields.

First, calculate a field we named “Placeholder 1” with the following code.

CASE [Placeholder 1 Selector]

WHEN "Order Qty" THEN [Order Qty]

WHEN "Sales Revenue" THEN [Sales Revenue]

WHEN "Profits" THEN [Profits]

END

Drag “Order Date” to columns and “Placeholder 1” to Rows.

Right click on “Placeholder 1 Selector” and click “Show Parameter”

Audience can hence select the between sales, profits and quantity ordered. The following graph

will change depending on the item selected.