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

8 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 8 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 - Adhoc Analysis

Perform simple ad-hoc analysis on your Bank Cash Flow data set: analyze any of your KPIs across any dimension

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

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!

Bank Cash Flow dashboard Live Demo

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).