Avocado Price Analytics with Power BI Using Infographic view, Lollipop chart and Histogram

A complete guided case study in Power BI based on the Kaggle data set.

Image from Unsplash

Today I was trying to prepare some tasty salad and going to some food blogs. I found a good recipe with avocado. As we know avocado is a very good source of vitamins and helps to protect from heart disease. After having a good salad, I couldn’t come out from avocado and found a popular data set in the Kaggle. I started to plan to do some data analysis.

In this blog, I am going to explain to you how I have completed one case study using the avocado price data set using Power BI.

Table of Contents

1. Data Set

2. Abstraction

3. Learning Objective

4. Import Data

5. Transform Data

6. Data Visualization

7. Conclusion


Data Set

I have taken Avocado Prices data from Kaggle for this project.

https://www.kaggle.com/neuromusic/avocado-prices

Abstraction

The data set has 14 columns.

Image by Author

Some relevant columns in the dataset:

  • Date – The date of the observation
  • AveragePrice – the average price of a single avocado
  • type – conventional or organic
  • year – the year
  • Region – the city or region of the observation
  • Total Volume – Total number of avocados sold
  • 4046 – Total number of avocados with PLU 4046 sold
  • 4225 – Total number of avocados with PLU 4225 sold
  • 4770 – Total number of avocados with PLU 4770 sold

Learning Objective

The primary objective of this case study is to learn the following things

  1. Avacado Price Analytics project with sample visuals
  2. How to create Histogram
  3. How to create an Infographic view with customized image
  4. How to create Lollipop Bar Chart.
  5. Customize theme
  6. Adding image as the page background

Import Data

  • Let’s start with the Get Data option under the Home tab. As this is a CSV file, select the Text/CSV option from the drop-down list
  • Select the file named avocado.csv
  • After selecting the file, data will be displayed with options Load, Transform Data.
  • Click on Transform Data and Power Query Editor will open.

Transform Data

In Power Query editor, you need to do the following changes.

  1. Click on “Use First Row as Headers” from the Transform group under the Home tab and observe that the table header is created.
  2. Give a proper name for column 1, for example, SL No.
  3. Rename the last 3 column names as Type, Year and Region.
  4. Click on Close and Apply to save.
  5. Update Summarization properties for Average Price from Sum to Average.
  6. Change to “Don’t Summarize” for SL No and Year.
  7. Update data formatting to decimal number for all the measures fields.
  8. If you want to verify these above changes or any doubt, please have look at the below video.
Import and Transform Data

Data Visualization

Power BI offers different advanced visuals. These are all supported by 3rd party providers.

We need to first import required visuals from AppSource after clicking “Get more visuals” under the visualization section.

Get More Visuals

  1. Click on Get more visuals under the Visualization section → Click on Get more visuals out of the displayed 4 options.
  2. Power BI Visuals box opens. Please check, by default AppSource tab should be selected.
  3. Now in the search box, first type “Infographic” and click on the search icon. Select the first Infographic Designer view
  4. Similarly, you get the other two custom visual ” Lollipop Bar” and “Histogram”.
  5. If you face any problem, please check the below video
Get Custom Visual

Create Histogram, Line and Donut Chart

Histogram:

To create a Histogram, please follow the below steps.

  1. Select Histogram visual from the pane.
  2. Add Total Bags in the Values and Frequency section.
  3. Click on the Format section and update Display Units for X-axis, Y-axis. Display Data Label and Give a proper title with some formatting.

Line Chart

For the Line chart, please follow the below steps.

  1. Keep Month from Date hierarchy in Axis.
  2. Add the Type in Legend and Average Price in Values

Donut Chart

For this chart, add the Type in legend and Average Price in values.

Are you facing any difficulties? , Don’t worry. Here is a video for you.

Histogram, Line and Donut chart

Lollipop Bar Chart

To create a Lollipop Bar chart, please follow the below steps.

  1. Select Lollipop Bar Chart visual from the pane.
  2. Add Region in Axis, Average Price in Values and Total Bags in Tooltips box
  3. Copy the same formatting from the above chart using Format painter

Here is the video to make you comfortable.

Lollipop Bar Chart

Infographic View

To create an Infographic view, please follow the below steps.

  1. Select Infographic Designer visual from the pane.
  2. Add Year in Category, Type in Legend and Total Volume in Measure box.
  3. For formatting, there are many steps. Here is a video to help you to do that.
Infographic

Customize Page Background and Theme

To make your report more representable, you can add an image as a page background as well as customize the theme colour.

How to do that? Please have a look at this video.

Customize Page Background and Theme

Download Code

Please find the code file (Price Analytics) in the below location

https://github.com/arpitag1/Power-BI

Complete Report

Conclusion

I am sure you are happy with this project after looking at your report.

If you have any questions related to this project, please feel free to post your comments.

You can check my Medium Profile for other related blogs and please like, share comments if you feel it will help others to learn.

Please like, comment and subscribe to my YouTube channel which you have already seen. 🙂 Keep Learning.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: