Tableau project description (invoice management in Home Loan Department)
This is a tableau dashboards project for home loan department for bank. There is SLQ2CQ internal management system requires tons of tableau dashboards to sure the proper data in order to track the performance of each employee in each department. This project is for invoice management department and there are several sections with it. There visual management, people management, and department management. Each team will have this tree types of dashboards and tells with different kinds of data metrics. Here is an example of how this dashboards look. The first two are same dashboards with different filtering. And 3rd one is the dashboard for compliance view, which has summary information with calculation of metrics up there and loan level detail down there.
The currant and historical data are all needed to show by different sets of breakdown.
When click on one table on upper right, one chart which tells detail should be showing and when click on the other the chart down there should be changing into the other two like the second chart showing below.
In the table on the right, there is a column shows the date range and on the other side of the chart the same column will be used as color code with different name.
The chart on the left lower side should show the number of invoices by each associate and filter with three different conditions: yesterday, average MTD and MTD%< 15 days.