Analysis of Superstore Sales Dataset Using Excel

Excel is a useful tool for data analysis and visualization. It provides a variety of options for importing data from many sources, including databases, text files, excel, and the web. After importing the data, Excel allows you to present the data in a clear and aesthetically acceptable way by using a range of data visualization tools, such as charts, graphs, and pivot tables. By emphasizing patterns, trends, and relationships within the data, these visualizations make it easier to evaluate and analyze the data. One advantage of utilizing Excel is that, after completing more analysis and acquiring profound insights from the data, it enables us to visually present our results by constructing a story.

In this article, I made use of a four-year Superstore sales dataset that I obtained from Kaggle. Since the data is in a text(CSV) format I was able to easily import it into Excel, then I cleaned the data using the the following process:

-Checking for missing values.

-Using the proper formatting to achieve consistency and uniformity. This entails changing date formats, applying numeric forms, and converting text to proper case.

-Also, In order to do majority of the analysis, I introduced new columns.

-Lastly, I Checked for blank rows and columns.

After performing an exploratory analysis on the data, I was able to draw the following insights:

· New York city had the highest sales of $ 252,463 with total contributions of 46.58%.

· According to the category and total sales as seen in the chart below, furniture had the highest contribution to sales.

· The majority of sales occurred in the west region.

· After analyzing the sales in respect to segment, I discovered that the consumers accounted for a higher percentage of sales compared to other segments.

. The standard class of ship mode has shown to be the most used option. This finding indicates that a majority of customers prefer the standard shipping option for their orders.

. The Top 10 products according to their contribution to sales.

· The trend in sales over the years, shows that the year 2018 experienced significant growth in sales with a total sales of $722,052, compared to 2017, which had a sales of $600,193. The least sales was made in the year 2016 with a total sales of $459,436 while 2015 had a sales of $479,856.

Below is my final Dashboard drawn out from the Dataset.

Thank you.