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

GETTING STARTED WITH DATA ANALYTICS

By
dashboard Businesses need data specialists now more than ever. With a surge in demand for data professionals, many people are undergoing self training to fill the vacancies in the data space. There are many roles in the field of data. Data scientists, data engineers and data analysts are some roles in data analytics with high demand for skilled workers.  Many people are willing to dive into the field of data analytics. However, the question remains, 'how can one become a self-trained data analyst'? In this article, we shall look at the essential skills that are needed to get started as a data analyst. Having gone through this process myself, I have noted some key things that may be essential to every aspiring data analyst.  TECHNICAL SKILLS  There are different schools of thought on which technical skills are necessary and in which order one should learn them. Having been here myself and after making so many mistakes in my journey before finding my foot, these are the tec...
Post a Comment
Read more

WILL ARTIFICIAL INTELLIGENCE RENDER DATA ANALYSTS USELESS?

By
  Introduction Artificial Intelligence (AI) has rapidly evolved and permeated numerous aspects of our lives, revolutionizing industries such as healthcare, finance, and transportation. With its ability to process vast amounts of data, draw insights, and make predictions, it is natural to wonder if AI will render human data analysts obsolete. In this blog post, we will explore the role of AI in data analysis and examine whether it will make data analysts useless or create new opportunities for collaboration. The Rise of AI in Data Analysis AI has significantly enhanced the capabilities of data analysis by automating repetitive tasks, accelerating data processing, and uncovering patterns that humans may overlook. Machine learning algorithms can quickly analyze large datasets, identify correlations, and generate accurate predictions. Additionally, AI-powered tools can handle complex statistical analyses, perform sentiment analysis on text, and even generate natural language summaries ...
Post a Comment
Read more