Tableau Superstore Dataset is a sample Dataset provided by Tableau which includes data for the Sales of multiple products sold by a company along with subsequent information related to geography, Product categories, and subcategories, sales, and profits, segmentation amongst the consumers, etc.
Dataset Description:
Superstore dataset contains the hierarchical data column Order date & ship date in the form of Year-Month-Week. Also for geographical form Region-State-Country-City. In this project I have connected the superstore dataset to the tableau. After importing the dataset in tableau I have represented the analysis in the form of a dashboard.
- Superstore dataset includes three types of products categories i.e. Technology, Office Supplies & Furniture. Total sales was $2.30M with total 9994 orders & 1862 type of products which ordered by total 793 customers. The total quantity sold was 37873.
- For the office supplies product category total 6026 orders were placed by 788 customers with total quantity of 22906. Overall sales for the office supplies product category was $719.05K.
- For the technology product category total 1847 orders were placed by 687 customers with total quantity of 6939. Overall sales for the technology product category was $836.15K which is more than any other category.
- For the furniture product category total 2121 orders were placed by 707 customers with total quantity of 8028. Overall sales for the furniture product category was $742.00K.
- Chairs has maximum share in the sales, but there is not much difference between the Chairs and the Book cases. Storage has maximum share in the sales. Additionally, around 50% of the share in Office supplies is accounted by Storage and Appliances. There is a huge gap in the contribution between the first Two and the others. Phones has maximum share in the sales and followed by the Copiers- which together account for 50% of total Technology sales.
- West region is the most profitable region as compare to other regions. Total sales for the West region was $725.46K with total orders of 3203 ordered by 686 customers.
- New York City was at the top in terms of profit(62K) with total 256.37K Sales follwed by Los Angeles with 30.44K Profit.
- I visualized and analyzed various use cases in the superstore dataset. I got some insightful results about profit and sales that can be used to improve future policies. I also found a trend over the year, so preparations in stores and warehouses for the next year can be made accordingly, and sales and profit can increase. Stores must focus on other regions, such as the South and Central, to increase sales in these areas. We can now confidently pick up more datasets to define use cases for and visualize them in Tableau.
No comments: