The Business Problem:
Our clients wanted to automate and implement back office procedures and data solutions to enable better business performance.
- Database/Data stores/Data relationships in MS SQL, MS Access, My SQL, XML data files & MS Excel
- Data connections/linkages/unstructured elements in ODBC, indirect/staged query, LDAP & SQL databases including from multiple sources/types
- Data preparation/cleaning/transformation with Database ETL tools and VBA/Macros
- Data calculation/structures/Hierarchies in MS SQL AS, PivotTables, Database schemas and MS Excel
- Manipulations with VBA/Macros from MS Excel, MS Access and other MS Office products
- Document store, search and repository solutions
The aap3 Solutions:
Tailored custom defined back office applications and solutions for data handling, validation and storage.
- Single source of truth MS Access with VBA/Macros combining three data sources from sales/services, manufacturing and product testing databases. This was used to identify equipment to be replaced or needing supporting maintenance services.
- Replace a manual mapping of organization structure for employee performance review. An SQL database used to import, validate data from an HR system to build the Employee/Manager/Country/Measure data relationships and the associated calculations and role up rules.
Example; MS Access Solution Single Source of Truth Example Data Import, Report Automation
The Business Benefits:
aap3 enabling solutions improve;
- Productivity through removing manual tasks
- Data quality through cleaning and structuring procedures
aap3 enabling solutions reduce;
- Development cycle times were phased and “just in scope”
application/implementation - Support cost by using standard desktop infrastructure
- Data availability by joining multiple sources and defining the structure
