Overview

I am employed at a government agency that is responsible for supervising financial institutions, and my primary responsibility is to monitor the number and degree of risk associated with the findings reported by my team on the financial institutions they assess. Each financial institution undergoes an annual review that contains one or more findings, such as violations that pose a risk to the agency. My supervisor has requested that I generate a Matrix visualization that displays the financial institutions in my program along with the number of findings they have received in each risk level. Additionally, I am expected to exercise my professional judgment to develop other visualizations that my supervisor may be interested in.

About the Dataset

The dataset was gathered from five financial institutions and includes the number and level of risk associated with the findings that were identified by my team during their evaluations. Each financial institution undergoes an annual review, which reveals one or more findings, and the presence of violations triggers alarms that are monitored by the government agency because of the potential risk caused by negative reviews.

Challenge Prompt (Recommended Analysis)

We will go through a brief case study that involves a government agency's obligation to supervise financial institutions by conducting regular risk assessments.

1. This will entail establishing and maintaining relationships between various data tables
2. Comprehending cardinality types (e.g., one-to-many)
3. Accessing the "Model View" to view the relationship diagram
4. Defining primary and foreign keys
5. Creating a Matrix visualization.

ETL and Data Modeling

The dataset derives from excel file loaded into Power BI and transformed in Power Query so that I may prepare the data for the visualizations.

Insights

By utilizing the Matrix visualization, we were able to identify three banks - Young Credit Union, State Bank, and First Bank - that have passed their annual reviews for both 2019 and 2020. These banks do not pose any risk to the agency. However, we discovered that Main St. Bank triggered an alarm after failing its 2020 annual review, and we also determined that Premier Bank failed not only its 2019 annual review but also its 2020 annual review. As these two banks represent a risk due to their annual review failures, we will report them to the agency.