Ernst & Young FOUND ATION " Case studies Analytics mindset Bank investment portfolios Part 2: Extract, transform and load relevant data and apply appropriate data analytics techniques In this part of the case, you will load your data into Tableau for analysis (your data has already been extracted and transformed for you). You will also apply appropriate data analytics techniques to your data. Required Load the data from Analytics_mindset case studies_Bank Investment Portfolio.xlex into Tableau. Make certain that the following data variables are categorized by Tableau as dimensions: RSSDID, bank type. 1. Develop a dashboard that includes visualizations that provide an analysis of the following: How the average amount of HTM investments held, as well as how the average amount of AFS investments held, has changed during the sample period. Perform this analysis for all banks and then separately for large banks and for small banks. Show each analysis separately and use different colors for each investment classification. Include trend lines. 2. Develop a dashboard that includes visualizations that provide an analysis of the following: How the composition of banks' investment portfolios has changed during the sample period. In particular, how the percentage of AFS and HTM investments that banks have classified as HTM (i.e., HTM percentage) has changed during the sample period. Show the analysis separately for all banks and together for large banks and small banks. Use different colors for each bank population. Include trend lines. 3. Develop a dashboard that includes visualizations for large banks only that provides an analysis of the following: For each individual bank, how the composition of the bank's investment portfolio has changed from 2013 to 2018 (the period after which the change in regulation took place). In particular, how the percentage of AFS and HTM investments that banks have classified as HTM has changed during this time period