age uk case study 500x536

Data Warehouse Development for Age UK

Brief

Datawarehouse Development

Solution

Adroit helped redevelop Age UK's internal data warehouse, and worked in partnership with Age UK's development team and Business Analyst over a 2 year plus period to support the new design, development, ETL developments, data migration, and redevelopment of the FastStats design and application. Overall integration with a new front-end MS CRM Dynamics solution.

Outcome

Due to the size and complexity of the project, there were several learnings and dependencies on other suppliers, so overall project management was key, albeit some slippage occurred. High levels of specification and documentation were involved. The sheer volume meant that it is difficult in a project of this scale for anyone individual to have a full overview of all components. High levels of testing and UAT are therefore important to ensure that business rules don't conflict.

Technologies Used

FastStatssql-logo-no-version