Skip to main content

SUPER STORE SALES DASHBOARD

By






The dataset was scrapped from kaggle. 

This analysis was undertaken by Walter Boat, Lead Data Analyst at Data Driven Consult.


Purpose

  • The purpose of this analysis is to  determine the top selling product categories of the business.
  •  The analysis is to determine the percentage of revenue that resulted in profit. 
  • The company wants to find out the geographical location of their customers in order to determine where to invest their advertising budget. 
  • The profit trend over the 4 years period was another paramount insight needed by the company to forecast future revenue.

Getting the dataset

This dataset was scrapped from kaggle.com in csv format. 

Cleaning the data

Data cleaning was done using Microsoft Power Query. The data was moderately clean for analysis except for some few fields that do not affect the analysis. Fields such as customer name, customer ID and product ID were deleted. A new field (Year) was created from the order date to extract only the year from the order date.

Creating the Visuals

The data visualization was created using Microsoft Power BI.

Insights

  • Overall Sales is currently at 9476278.88. Sales for Country United States and other segments are significantly higher than others.
  • Overall Profit is currently at 1089913.14. 4 segments have significantly lower Profit than others, and 16 segments have significantly higher Profit.
  • Consumer products constitute 51% of company`s sales.
  • Quantity sold in the Africa region is encouraging but large shipping costs depleted the net profit from this region.
  • Only 11% of revenue resulted in profit due to high shipping costs. 


Labels:

Comments

Post a Comment

Popular posts from this blog

WHAT IS DATA ECOSYSTEM

By
An ecosystem, to put it simply, is a collection of components that communicate with one another. The jungle in a tropical rainforest or the amazon rain forest are examples of vast ecosystems. The germs on your skin may also be small, like tadpoles in a puddle. Additionally, data has its own ecology, just like the kangaroos and koala bears that reside in the Australian desert. Data is produced, managed, stored, organized, analyzed, and shared through the interaction of many different parts that make up data ecosystems. These components include the people who use the tools, as well as the technology and software. The cloud is another place where data can be found. Instead of storing data on a computer hard disk, you can use the cloud. So, data is accessed through the internet rather than being stored somewhere inside your company's network. As a data analyst, it is your responsibility to make the most of the cloud's role in the data ecosystem, locate the pertinent data, and offer...
Post a Comment
Read more