Profit & Sales Analysis of Superstore

Project Title :

Profit & Sales Analysis of Superstore - Data visualization

Project Description :

Analysing the data for understanding the trends and patterns associated with Profit and sales of Superstore with the help of Data visualization tool - Tableau.

The trends and patterns derived will give insight and insights will lead to recommendations help in business to strategies for growth.

Link to the Dashboard

Dashboard

Data preview

Dataset contains 21 columns and are like -

1. Row ID : A distinct row number of each record.
2. Order ID : A distinct code given to each order placed. Code contain alphanumeric characters.
3. Order Date : Date on which order was placed.
4. Ship Date : Date on which order was delivered.
5. Ship Mode : Mode through which order was delivered.
6. Customer ID : A unique/distinct id for each Customer.
7. Customer Name : Name of the Customer.
8. Segment : Segment the Product belong to.
9. Country : Name of Country
10. City : Name of city order delivered.
11. State : Name of State.
12. Postal Code : Postal code of location
13. Region : Country is divided into different regions.
14. Product ID : Unique Id of each Product for identification.
15. Category : Name of the Category Product belong to.
16. Sub-Category : Name of the Sub-Category.
17. Product Name : Product name.
18. Sales : Amount Product sold on.
19. Quantity : Number of Product sold at a time.
20. Discount : Discount Product on sale.
21. Profit : Profit gained on sale of the Product.

Questions we are going answers with this data :

1. Understanding the demographic data of states.
2. Is there seasonality in the buying pattern of the Customers?
3. Year on Year profit and sales growth.
4. Which Category is profitable.
5. Understanding the pattern about the profitability of Product.

Tools and Language :

Excel : Used for basic understanding like structure of data (row and columns), null values etc.

Tableau : For visualization of data,interactivity and seamless experience that comes with the dashboard.

Want to talk about the project, Please connect with me on LinkedIn and aniketrtm114@gmail.com