Supermarket analysis
Tags: analyst, database, powerbi, beginners
Published: 2023-01-22 17:11:03

**Introduction**
For the months of January, February and March 2019, a supermarket data set has been made available to see how the supermarket is blooming. Mrs. Ruby, the chief growth officer would delight to see the supermarket analysis generate insights. Elizabeth was hired by Mrs. Ruby to work as a data analyst to analyze, visualize, and produce insights.

Derived data will consist of **;**

**-** Total quality
**-** Total unit price
**-** Top 5 product line by the total 
**-** Total by branch 
**-** Quality by product line and month
**-** Gross Margin percentage by payment
 
**Data Preparation**
The data came in CSV format and formatted as shown in the diagram below;



![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/u2u0jee01bq3jsoxa014.png)

The column headers were made to stand out in order to make the data appear more appealing.

**Data Analysis**
I had to start by identifying the main performance measures, which were the total quality and the unit price. The diagram below demonstrates how I was able to identify these KPIs using DAX and PowerBI's card visualization.

- **Total quality**: The SUM function was used to get the total sum of the total quality 

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/fha7l3cpak0djg25mfms.png)
 
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/c1so83bpb16lb8cs03ky.png)


- **Total unit price:** The SUM function was also used here to get the sum of the unit price


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/i4r43oufcoe3srqvquy1.png)

      
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/akn4bdz37vy9mzmd8o3z.png)


- **Top five (5) product line by total:**

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ztrj5s16yw2df75fuwys.png)

According to the data above, consumers were more inclined to buy these top five products overall, with food and beverages having the highest overall preference and health and beauty having the lowest overall preference.
 

- **Quality by product and month**



![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/tr37hf817nkvbs2jn1bm.png)



The relationship between product quality and month is seen in the graph above. According to this graph, January had the largest sales of sports-related products and goods with a value above.
  
**Total by branch**

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ghohd1eyx4mqz3lldux4.png)


- **Gross margin percentage by payment**

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ov0vk6dk9jevxpjryqsz.png)

Following the gross margin by payment, eWallet has the greatest rate, with credit cards having the lowest. The eWallet's popularity as a method of payment may be due to how convenient it is to use when traveling or it is convenient to use while on the go


**DASHBOARD**



![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/0b19wwt3ij8lmckm6unm.png)


You may access the project dataset file here.


  


Thanks for reading.