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. Senior management has tasked the business analysis team to conduct a comparative review of the four largest branches in Florida.
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.
Analyze online banking versus in-person banking utilization for each branch location.
Prescribe optimal business outcomes by applying simple predictive algorithms.
The data team has provided you with the raw data set, a set of business rules, and additional product and service information, which is located in the Supporting Materials section.
Directions
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:
Identify and analyze any data anomalies in the data set.
Choose two columns and create a visualization for each column that highlights the anomalies.
Include a screenshot of this visual in your report.
Explain the impact of the identified anomalies on the integrity of the data set.
Include appropriate screenshots from Power BI to help support your reasoning.
Explain whether you would include these anomalies in reporting, as this data is used to drive business decisions. Justify your reasoning.
Based on the anomalies identified, use Excel to manually correct the data set.
Identify the data points you corrected. Explain your reasoning.
Identify the data points you did not correct. Explain your reasoning.
Explain which manual correction techniques you used. Explain your reasoning.
Using the corrected data set, update the Power BI report to assess the impact of the updated anomalies.
Compare the updated visualizations to those prior to correcting the data set. How do they differ? Explain your reasoning.
Include appropriate screenshots from Power BI to help support your reasoning.
Using the Financial Charm Project Data Set Online vs. In-Person Banking as well as the Financial Charm Project Data-New Zip Code located in the supporting materials section, 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 located in the supporting materials section, 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 located in the supporting materials section, 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 to meet business needs.
Analyze the data using statistical models.
Identify the statistical model(s) you used for each analysis. Justify your reasoning for its use.
Describe the results of the statistical analysis.
Include counts, averages, forecasts, or other approaches used.
Provide a screenshot of the model output in Power BI.
Based on your findings, provide recommendations for next steps for the following criteria:
Create a new visualization that forecasts type of transaction (Type_of_Last_Transaction) by hour to ensure staff availability at each branch
For this visual, describe how this forecast can be used to optimize branch staffing levels.
Include a screenshot of this visual in your final report.
Create a new visualization that forecasts products and services performance (Type_of_Last_Transaction) at each branch by month and year to identify shifts in services being used over time.
For this visual, describe how this trend analysis can shape the future service offerings by the banking institution.
Include a screenshot of this visual in your final report.
Create a new visualization that forecasts online versus in-person banking (Type_of_Last_Transaction) at each branch by month and year to ensure staff availability at each branch.
For this visual, explain how this trend analysis can be used to optimize branch staffing levels.
Include a screenshot of this visual in your final report.
