Sample Store Data
Background
To start off my data analytics portfolio, my mentor gave me a sample store data set from a Tableau tutorial
​
She asked me to pivot out two more metrics to accompany the chart which is a month over month breakdown of performance.
The tools that were used to complete this task include Google Sheets and Tableau. The two metrics I decided to look into are Total Sales per Category and Total Sales per Region.
Metric #1: Total Sales per Category
The first metric I decided to look into was the total number of sales per category. The categories are Technology, Office Supplies, and Furniture. I wanted to see which categories reached 35% or more of grand total sales which is the target goal. I was able to come up with these numbers by creating a pivot table to find the total sales per category.
_edited.jpg)
We can see that Technology grossed the highest in grand total sales at 36.4% from 2018-2021. Although Office Supplies and Furniture are selling well, we see that there is still opportunity for growth.
Metric #2: Total Sales per Region
The next metric I decided to gather insights from was total sales per region and to determine which regions are earning more than 25% of total sales. In order to do this, I decided the best way to go about figuring this out is by creating a pivot table of total sales per region
I was able to learn that the East and West Coasts hit these targets whereas the South and Central states have opportunity for growth. Here's an interactive story of both metrics that I created on Tableau.
.png)
I can also ask or give customers the opportunity to take a consumer survey to help determine what it is that can be done to increase sales in the Office Supplies and Furniture sales categories.
Final thoughts
To help the South and Central states hit that 25% target, I would suggest further analysis be done to find out why sales are lower in these areas. Lack of physical stores could be a contributing factor. If this company is strictly online, we can create targeted ads centered around consumer needs. This cannot be confirmed until further analysis is completed