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