The Business Problem:
Our clients wanted to securely deliver data to the correct audience, in the correct format at the right time
- Deliver data exports and reports where access is control down to user permission levels custom user and group
- Automate repetitive report process from data sources through to an email delivery using SQL and/or VBA macro solution in MS Access, MS Excel and MS SQL Server
- Produce continuous, compliant, same format exports of data to file using SQL and/or VBA macro solution in MS Access, MS Excel and MS SQL Server
- Produce interactive on-line dashboard and analysis reports viewable in a web browser via XML or MS Excel and Flash
The aap3 Solution:
Example; Web Flash Rendered Report Example; File deliver by email (Time scheduled automated process)
The Business Benefits:
aap3 enabling solutions improve;
- Data security data can be control by or user, group down to individual data
value - Delivery reliability on time based on cycle
- Integration to process or technology by always delivering correct type and
format by same method - Ability to manage by freshest data/indicators available
aap3 enabling solutions reduce;
- Development cycle times were phased and “just in scope”
application/implementation - Support cost by using standard desktop infrastructure or small scale
additions - Human mistakes by delivering correct details first and every time.
