Insightful data visualizations help $56B global bank analyze data faster with more accuracy
Business Challenges
- Manual and Inconsistent Dashboards – Dashboards were manually created using Excel with basic visualizations and copied into PowerPoint for reporting, leading to inconsistencies in formatting and display
- Unlinked Data - Dashboards were sourced from a large number of different data sets across multiple tabs within Excel and were linked manually, thus requiring time consuming data massaging and reconciliation
- Limited View of Business - Business Units and Lines of Business had limited ability to view metrics through dynamic parameter selection
Solution
- Insightful Visualizations - Developed a multi-page dashboard solution to consume and access vital information with added ability to include commentary
- Real-Time Updates - Created a solution that pulls the latest data from the source file and populates the dashboard automatically
- Connected Data - Normalized multiple tabs of data from Excel into a more manageable Tableau Data Source to support dashboards and a hierarchy-driven navigation
- Created Dynamic Custom Views - Created a clean and standardized format of all dashboards and provided the business the ability to view metrics by Business Unit and Line of Business dynamically
Impact
- More Analysis with Less Effort - Reduced the number of hours spent creating visuals in Excel and PowerPoint, allowing for more analysis with less manual effort
- Faster Access to Data - Accelerated the time to create an established business analysis function
- Real-Time Accuracy - The dashboards are automatically updated whenever new data is saved to the source file, decreasing the chance for human error in including latest data in the visuals
