In business intelligence, you are often required to create pie charts and tree maps. A pie chart is a circular graph divided into slices to show the composition of the whole data in parts. Each constituent of a pie chart is represented in percentages, and the sum of all the parts is equal to hundred.

Tree map is another technique used for displaying hierarchical data using nested figures, usually rectangles. The space in the visualization chart is divided into rectangles per the size and order of a numerical variable.

This guide will demonstrate how to create a pie chart and a tree map in Power BI desktop.

Data

In this guide, you will work with a fictitious data set of bank loan disbursal across years. The data contains 3,000 observations and 17 variables. You can download the dataset here. The major variables are described below:

1. Date: Loan disbursal date.
2. Income: Annual Income of the applicant (in US dollars).
3. Loan_disbursed: Loan amount (in US dollars) disbursed by the bank.
4. Age: The applicant’s age in years.
5. Gender: Whether the applicant is female (F) or male (M).
6. Interest_rate: Annual interest rate, in percentage, charged for the disbursed loan.
7. Purpose: Purpose for which loan was taken.
8. Month: Month in which loan was disbursed.

You will start by loading the data.

#powerbi