Build a PowerBI model using the data found here [login to view URL] for 2017-2019
Create basic visualizations that can filter by state and show fastest growing banks, banks with C&I loan growth and banks with increasing loans on non-accrual.
They have data for each year - should be in four quarters per year. I need this data downloaded (tab delimited) for each year (2017, 2018 and 2019). Import data files into PowerBI. Ensure data headers reflect the field names embedded in the first two rows of the data. Then ensure that fields are formatted correctly (strings for text, decimal for numbers). Create a query that merges all files together. Then create some basic visualizations of the data. Loan amounts by state. Or top ten banks by loan growth. Demonstrate that the model can be used for data visualization.