Business dashboard template: BANK CASH FLOW

/uploads/galerie/000283/Cash Flow Cockpit.PNG

Providea workbookcontaining at least6 attributes

Geta ready-to-use,best-in-marketBANK CASH FLOW dashboard

Bank Cash Flow Home

Get a Home Page for your Bank Cash Flow dashboard

Bank Cash Flow Cockpit

Get a quick overview of your bank accounts cash flow

Cash Flow & Balance

Visually assess the impact of your cash flow on your final balance

Bank Cash Flow Top KPIs Breakdown

Get a transverse view on your top 6 Bank Cash Flow KPIs, split by the dimension of your choice

6 required attributes

Bank
Account #
Transaction #
Transaction Date
Debit Amount
Credit Amount

14 KPIs

10 dashboard pages

Detailed presentation of the BANK CASH FLOW dashboard

Your BANK CASH FLOW dashboard will contain 14 KPIs

Cash Flow"Total Debit Amount" minus "Total Credit Amount"
Total Debit AmountTotal amount of Debit Transactions
Total Credit AmountTotal amount of Credit Transactions
Daily Cash FlowAverage Cash Flow per day"
Daily DebitAverage Debit Amount per day"
Daily CreditAverage Credit Amount per day"
Avg Debit TransactionAverage amount of Debit Transactions
Avg Credit TransactionAverage amount of Credit Transactions
TransactionsNumber of Transactions
Debit TransactionsNumber of Debit Transactions
Credit TransactionsNumber of Credit Transactions
Transactions per dayAverage number of Transactions per day"
Debit Transactions per dayAverage number of Debit Transactions per day"
Credit Transactions per dayAverage number of Credit Transactions per day"

and 10 dashboard pages

Home

Bank Cash Flow Home

Get a Home Page for your Bank Cash Flow dashboard

Cockpit

Bank Cash Flow Cockpit

Get a quick overview of your bank accounts cash flow

Bank Cash Flow Top KPIs Breakdown

Get a transverse view on your top 6 Bank Cash Flow KPIs, split by the dimension of your choice

Bank Cash Flow Top KPIs Trends

Visualize how your Bank Cash Flow KPIs are evolving (Month-to-Date, Year-to-Date)

Bank Cash Flow Performance Cockpit

Visualize the performance on your top 4 Bank Cash Flow KPIs, how this performance evolves over time and who contributes to this performance

Cash Flow Analytics

Cash Flow & Balance

Visually assess the impact of your cash flow on your final balance

Behavioral Analytics

Bank Cash Flow KPI Performance

Visualize the overall performance of any of your Bank Cash Flow KPIs: what is the performance, how does this performance evolve, who contributes to this performance

Trends Analytics

Bank Cash Flow Trends Analysis

Visualize the evolution of any of your Bank Cash Flow KPIs: Trends, Performance & Year over Year

Distribution Analytics

Bank Cash Flow Segmentation Analysis

Visualize the value of any of your Bank Cash Flow KPIs, split by the dimension you selected (market share analysis)

Bank Cash Flow Pareto Analysis

Perform a Pareto Analysis on any of your Bank Cash Flow KPIs: the 80/20 rule.

Creating your BANK CASH FLOW dashboard Step-by-Step

You want to get a clear understanding on your Bank Cash Flow results? You want to build a Tableau dashboard to better understand your Bank Cash Flow data?

Using LinPack-for-Tableau.com, you can generate an eye-catching, fit-for-purpose Tableau Dashboard on your Bank Cash Flow data in less than 5 minutes!

1st STEP: Create the initial Tableau workbook file

Create a Tableau workbook in which you map your Bank Cash Flow data (whether it comes from: ERP, database, Excel, CSV file...)

You must retrieve at least the following attributes (it is ok if the names don't match, and it is better to add additional attributes to analyze):

Bank Name of the Bank
Account # Account Number
Transaction # Transaction Unique Identifier
Transaction Date Date of the transaction (Date used for time-series analysis)
Debit Amount Debit Amount [positive values expected; Null expected is Credit Transaction]
Credit Amount Credit Amount [positive values expected; Null expected is Debit Transaction]

2nd STEP: Upload your Tableau workbook file

On LinPack-for-Tableau.com, select 'create dashboard from template: Bank Cash Flow' and upload your Tableau workbook (note: your data is NOT uploaded).