SQL and Power BI Data analysis project:

Avocado sales in USA

In this project I analized the avocado sales in USA in the period between 2015 and 2019 using SQL and visualized the sales statistics with Power BI

Starting from the dataset in excel format, I cleaned up the data using SQL and then calculated the sales statistics with SQL. For example, to calculate the average price increase of avocado each year I used the following code:

The full SQL code can be viewed here.

I visualized this data using Power BI interactive dashboard:

(click here for the online version)

The dashboard shows sales statistics such as price and sales volume increase over several years, organic versus conventional avocado statistics and top sales regions in USA.

Data sources: The Price and Sales of Avocado (https://www.kaggle.com/datasets/alanluo418/avocado-prices-20152019). Avocado icon, Checkout icon, Usa icon and Price icon by Icons8. Photo by Eddie Pipocas on Unsplash