When information is scattered across several software packages, Excel files and applications, figures diverge and analysis becomes difficult. We design and organise the databases that hold your management information: data modelling, migration from legacy tools, a data warehouse bringing the sources together, and quality and access rules. Data is hosted according to your requirements, including locally where regulations or your policy require it.
Four workstreams
Data modelling
Structure of tables, relationships and master data (customers, suppliers, items, accounts), documented and suited to your processes.
Migration
Transfer of data from legacy software and files, with cleansing, de-duplication and migration checks reconciled to balances.
Data warehouse
A database that brings together the data of your various systems, fed automatically, for dashboards and analysis.
Quality and governance
Entry and control rules, data owners, access rights, logging and backups.
What we do
- Review of the existing set-up: databases, files, applications, data flows and duplicates.
- Modelling of the organisation’s data and master data.
- Implementation of relational databases (PostgreSQL, MariaDB) and their backups.
- Migration of data from legacy software and Excel files, with migration checks.
- Design and loading of a data warehouse for management reporting.
- Quality rules, automated checks and data correction procedures.
- Access rights, logging and database documentation.
Our approach
Assess
We list the data sources, how they relate and their weaknesses.
Design
The target model, master data and quality rules are defined with your teams.
Migrate
Data is transferred, cleansed and checked by reconciliation with existing balances and reports.
Maintain
Quality checks, backups and documentation keep the data reliable over time.
Reports and deliverables
- Data review report and action plan.
- Documented data model.
- Databases and data warehouse in production, with their backups.
- Data migration sign-off and control file.
