FlowTracker advantages : repeatable, better, faster, cheaper, verifiable performance analytics
FlowTracker advantages
Simply put, FlowTracker software will help you focus resources on growing your business better, faster, repeatably and with a lower total cost of ownership than in-house development or ad-hoc analysis can.
We designed FlowTracker to be the optimal solution to the challenges of measuring attrition, new money acquisition, cross-sales, product cannibalization and inter-branch transfer flows of funds. Here are the reasons FlowTracker should be your solution...
Precise and efficient
- Over 7 years of business logic development
- Verifiable output in every dimension
- Highly scalable, fast processing runtime
A great deal of care has gone into making sure FlowTracker has been designed optimally. Flow type x account level detail is created consistently across time periods at lightning speed. FlowTracker provides complete analysis of half a million accounts analyzed in 3 minutes using a standard (P4) desktop computer... faster on your server... enabling you to analyze your whole portfolio every day.
Repeatable process
- Run on any cycle
- Backfill history as far back as data available
Efficient design enables FlowTracker to be tailored to run on any cycle - daily, weekly, monthly etc. to match your data refresh cycle. FlowTracker can analyze any point-to-point time period as a single interval as well.
Minimization of data requirements and purity or business logic design enable FlowTracker to be applied retroactively to your data - giving you the option to backfill history for trending and data analytics without waiting months and even years to build up your history base.
“Thin” data requirements
- Spot (period end) balances
- Product ID
- Branch ID
- Account ID
- Customer ID
This is the
complete list of data requirements for FlowTracker, all of which is likely already in your customer information database. No transaction data is required in order to derive the flow of funds within each account using FlowTracker's unique business logic. Branch ID is optional, useful for identifying flows among branches.
“Bolt-on” solution integrates easily with existing platform
- Data mart or warehouse
- Reporting and analysis tools
- Existing SAS installation
- No new languages or databases to worry about
FlowTracker has been written in Base SAS language to enable integration with virtually any pre-existing data environment - Unix, Linux, Sun Sparc, Oracle, Tradata, DB2, Microsoft SQL Server etc.
FlowTracker also creates information rather than reports, so it can be fed into any reporting suite you use for reporting, analysis and business intelligence including Business Objects, Cognos, SAS, SPSS, KXEN and others.
Perhaps best of all technical features, FlowTracker will not introduce any new languages or databases to your bank that require additional support in your IT department.
Minimal maintenance cost
- Core business logic is unchanged by introducing new products and services
- Business rules are easily entered and verified
- Open code for loading data and exporting results
Adding new products and services into the FlowTracker analysis process is as simple as adding a row to a spreadsheet and uploading the data. FlowTracker will prompt you when there are mismatches between the business rules and data so you know when updates are required before processing takes place.
Extract, transformation and load into and out of FlowTracker is all handled by open code SAS-SQL so you can easily maintain it in-house. No need for ongoing external support when you change source tables in your data warehouse or data mart. Similarly on the output side, data fed back into your warehouse can be tailored to your needs and changed as required in-house.
Subscribe to FTAI
