1.Convert the values in theintro_rate_periodcolumn to a decimal data type.

2.Delete columns for which there are more than 50% missing values or errors, or only one distinct value.

Exploratory Data Analysis Tasks:

Use Power BI to complete the EDA tasks below..

3.What factors influence whether a loan is originated or denied. Use a filter on all pages to only keep observations for which the action taken is equal to either "Loan originated", or "Application denied".

4.Produce a line chart that shows whether the total units change from 2018 to 2019 for each loan purpose value. Insert a text box below the plot,and briefly summarize two takeawa

5.Produce a chart that explores whether the distribution ofincomevaries between the values in theaction_taken.Insert a text box below the plot,and briefly summarize what the plot shows about the relationship between income and whether a loan was originated. Comment on whether this plot is consistent with your expectations and why or why not that is the case.

6.Prodcue a chart that explores the frequency or proportion ofoccupancy_typebetween the values in theaction_taken.Insert a text box below the chart and briefly summarize how helpfuloccupancy_typeis for determining whether an application is denied. In your summary, please make sure to reference the chart.

7.Produce a scatter plot that investigates howincomeis related todebt_to_income_ratioandaction_taken. Specifically, putincomeon the x-axis, and do not summarize those values. Putdebt_to_income_ratioon the y-axis and summarize values using the average. Putaction_takenin the Legend box. Use a filter on the visual to only show observations for which the income is less than 500,000 and greater than or equal to 0. Your scatter plot should look like the one in the image below.

Save your file as a .pbix file