Banks distinguish themselves by the quality of their service. With Tableau you can offer customers a new level of insight and stand out from the competition. Customers from RBC Wealth Management to the Macquarie Group to Fifth Third Bank use Tableau for their banking analytics and bank business intelligence. Banks use Tableau to:
- Provide web-based tools for clients and salespeople to track the value of savings and investments
- Provide what-if analysis to help clients understand the effects of changes in investment decisions
- Monitor loans and manage risk across geographies with interactive bank dashboards
- Dynamically produce reports on outstanding accounts that require attention
Loan default is one of the biggest risks for any loan provider. Those who excel at managing these risks have a strong advantage in the marketplace.
Developed by Tableau partner Teknion Data Solutions, this dashboard provides a great platform for loan providers to manage this risk. The first view projects the potential charge offs over a 24–month period, based on borrower credit ratings. It also shows the percentage each portfolio item represents as a part of the total balance at risk. In the second view, you can oversee the distribution of your loans across credit rating tiers—insight critical to your risk management. The credit scores are broken down into six tiers, from Tier A+ as the best and X as the worst. To the right, you can see the projected 24 month charge off over time and how your X Level balance correlates directly to your total risk.
Don’t forget: this visualization is highly interactive. You can use the filter panel at the top to drill down to specific time periods or click anywhere in the visualization to filter.
Loan delinquency is an early warning sign of loan default. Monitoring and managing loan delinquency rates are a critical component of lenders’ risk management programs.
Developed by Tableau partner Teknion Data Solutions, this dashboard lets you see all of your loan delinquencies by business segments, location and time. You can view your delinquency by severity, with delinquencies sorted into 1-30 days, 31-60 days, 61-90 days, 91-120 days and 120+days and color-coded for at-a-glance understanding. To drill down into a particular for more information, click within the visualization or click the color legend to highlight all the information based on your selection.
Want to adjust your lending policies? Start your discussion from here.
In most cases, a major goal for bank business intelligence is to keep a steady eye on exactly what is happening at every level of the business. This is true for those who work both at the corporate level and the branch level – simple transparency allows you to see areas for improvement more clearly.
With Tableau you can create bank dashboards to monitor your loans sales across the country and where you can reduce risk, either by improving collections or adjusting your product mix. You can also produce reports on the fly for salespeople to identify and contact important accounts.
This dashboard allows you to drill through your loan portfolio at different levels of detail to discover what is happening in your portfolio. You can dynamically select whether to summarize results based on different geographical levels (Region, State, or Branch), whether the map shows Days Outstanding or Loan Types, and whether to focus on All Loans, Paid Loans or Outstanding Loans.
Right click on any mark to generate a detailed report for that location on the next tab.
Understanding which customer segments drive the most revenue and profits is fundamental to your business success and future strategy. But getting this insight requires slicing your customer data in many different ways to get to the true trends hiding beneath the surface.
Tableau lets you explore and analyze your data within minutes. For example, this workbook lets you create five customer-related views through a simple drag-and-drop process. And changes like switching measures or swapping chart types are just a few clicks away. This gives you great flexibility to analyze your data from different angles and significantly reduces the amount of time you need for the exploration.
After you decide which views are valuable, creating a bank dashboard for reporting is simple. In this example, we segment the revenue and profit by business segment, marketing channel, customer location, tenure, and age. With this information, we can form our future marketing and business strategies to capitalize on the most profitable segments while addressing the least profitable areas.
Often, banks will have hundreds of different customer profiles and dozens of products across their credit portfolio. In order to keep losses to a minimum, their bank business intelligence needs to tell them what is happening in their portfolio at all times.
This visualization is part of a credit tracking system that allows bankers to identify problem accounts and recognize opportunities. The first tab is a view of inventory by RMS status. The user can select a code and then view average balance over time.
The second tab profiles credit usage by age group and state. Users can analyze measures like balance, number of cards, utilization and credit limit.