Overview
You have recently been hired as a business analyst for Financial Charm Bank, a large retail bank operating in the United States. The bank’s headquarters are located in Charlotte, North Carolina, and the bank earns most of its revenues from its operations in the East Coast and Midwest. In the Q4 review, it was observed that one of the larger branches in Florida failed to meet the earnings guidance. Originally, senior management had tasked the business analysis team to conduct a comparative review of the three largest branches in Florida, but after initial review, have decided to add an additional branch for analysis.
The vice president of business analytics has tasked you with the initial data analysis and to compose a final report for stakeholders. The purpose of this analysis is as follows:
Determine how products and services are performing at each branch location
Review customer traffic at the drive-up and lobby areas to ensure staff availability of each branch location
Prescribe optimal business outcomes by applying simple predictive algorithms
The vice president has also added an additional purpose for this analysis, which is to analyze online banking versus in-person banking utilization for each of the four branch locations.
In addition to the cleaned data set from Milestone One, the data team has provided you with the data set for the added branch, the data set for online versus in-person banking, a set of business rules, and additional product and service information.
Prompt
In this project, you will use Power BI as a visualization tool to communicate your analysis effectively. In your final report, include the following criteria:
Using the Financial Charm Project Data Set Online vs In-Person Banking as well as the Financial Charm Project Data – New Zip Code, merge the two data sets with the cleaned Financial Charm Project Data Set from Milestone One.
Explain the techniques that you used to merge the data sets together.
Using the merged data set as well as the Financial Charm Bank Branch Product and Service Information document, create three different visualizations that best represent the descriptive patterns and trends in the data set. Justify your reasoning for using each visualization. You must include a visualization of each of the following:
Type of transaction by hour to ensure staff availability at each branch
Product and service performance at each branch
Online versus in-person banking at each branch
Using the Project Business Rules document, conduct a quality assurance process on the data set using the given set of business rules.
Do the business rules help ensure data integrity and quality when being collected? Explain your reasoning.
Explain how a data quality process should be applied to clean the data for later use.
Determine the impact of the data attributes on business decisions. Explain your reasoning.
Explain whether the data is useful for meeting business needs.