The primary goal of this project was to develop an advanced, visually engaging dashboard using Excel to analyze and enhance the understanding of a Boston-based bank's performance across its four branches. This tool aimed to amplify the bank's decision-making processes by offering comprehensive, data-driven insights.
Data Preparation and Cleansing: The project began with normalizing a dataset containing
over 105,000 records from the bank. This step was crucial for ensuring accurate analysis and generating
reliable insights.
Data Visualization: I used Pivot To provide a well-rounded understanding of the
bank's performance, I employed various types of data visualizations, including segmented data
widgets (sliders), shadow graphs, bar charts, and speedometers. Each visualization was designed for easy
readability and interpretability.
Interactive Reporting: The dashboard was designed to be interactive, allowing users to
change data periods and instantly visualize corresponding changes in data patterns.
-Alfredo S.
