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

Detailed presentation of the BANK CASH FLOW dashboard

Your BANK CASH FLOW dashboard will contain 14 KPIs

and 10 dashboard pages

Home

Bank Cash Flow Home

Bank Cash Flow Home
Bank Cash Flow HomeBank Cash Flow Home
Get a Home Page for your Bank Cash Flow dashboard

Cockpit

Bank Cash Flow Cockpit

Bank Cash Flow Cockpit
Bank Cash Flow CockpitBank Cash Flow Cockpit
Get a quick overview of your bank accounts cash flow

Bank Cash Flow Top KPIs Breakdown

Bank Cash Flow Top KPIs Breakdown
Bank Cash Flow Top KPIs BreakdownBank 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

Bank Cash Flow Top KPIs Trends
Bank Cash Flow Top KPIs TrendsBank 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

Bank Cash Flow Performance Cockpit
Bank Cash Flow Performance CockpitBank 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

Cash Flow & Balance
Cash Flow & BalanceCash Flow & Balance
Visually assess the impact of your cash flow on your final balance

Behavioral Analytics

Bank Cash Flow KPI Performance

Bank Cash Flow KPI Performance
Bank Cash Flow KPI PerformanceBank 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

Bank Cash Flow Trends Analysis
Bank Cash Flow Trends AnalysisBank 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

Bank Cash Flow Segmentation Analysis
Bank Cash Flow Segmentation AnalysisBank 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

Bank Cash Flow Pareto Analysis
Bank Cash Flow Pareto AnalysisBank 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):

  • string
    Bank Name of the Bank
  • string
    Account # Account Number
  • string
    Transaction # Transaction Unique Identifier
  • date
    Transaction Date Date of the transaction (Date used for time-series analysis)
  • numeric
    Debit Amount Debit Amount [positive values expected; Null expected is Credit Transaction]
  • numeric
    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).

3rd STEP: Map your attributes

Map the attributes of your workbook on the attributes of the template.

Finally, click 'Confirm & Download'... and your Bank Cash Flow dashboard is already downloading :-)

Open the Tableau workbook file you received, it will automatically reconnect to your data sources.

Your Bank Cash Flow dashboard is now ready to be used or customized!