Dashboard and Storytelling
Rashmi Kalra
Global Superstore Data
1.Introduction
The Global Superstore dataset is data from a global retail chain that sells office supplies, Furniture and Technology Stuff. This data is downloaded from Tableau Public Resource page and uploaded to my repository on Github.
The Github link for the data is: click hereThe above data has three tabs (Orders, Returns and People ) . We are using the Orders data for our visualization. The Variables present in the dataset are mentioned below:
- Row ID
- Order ID
- Order Date
- Ship Date
- Ship Mode
- Customer ID
- Customer Name
- Segment
- City
- State
- Country
- Postal Code
- Market
- Region
- Product ID
- Category
- Sub-Category
- Product Name
- Sales Quantity
- Discount
- Profit
- Shipping
- Cost
- Order Priority
2.Dashboard
For creating the dashboard we have created the different worksheets in Tableau and then merged that into single which is named as Dashboard.The dashboard represents the Total sales and Profit for various categories, subcategories and Segment.
The visualizations used for this tableau are:
- Map showing the Total Sales by Country
- Distribution of Sales/Profit by Sub-categories.
- Donut chart showing distribution of Total sales by category
- Scatter plot showing the relationship between Sales and Profit
- Box Plot showing the Year wise Sales and Profit in different segments
Also, the below dashboard is reactive with the Filter “Market”
The web link for the Dashboard visualization created on Tableau Public is: click here
Observations made on the basis of Visualization:
1.Looking at the Map of countries, we can see that maximun sales are from the United States.
2.Based on the Donut chart, all the three categories — Furniture, Office Supplies and Technology make similar amount of sales.Technology is Best Selling and is the Most Profitable too.
3.Looking at the Bar Plots we can see that :
Copiers produces most profit, followed by Phones, Bookcase, Chairs and Appliances On the other end Tables made losses because of the high discount offered in this category.
4.Looking at the Box Plots we can see that Consumer segment is most profitable, followed by Corporate Segment and Home Office. Hence, marketing strategy has to target or place more focus on retaining Consumer and Corporate Segment customers.