Services
Data and reporting
We migrate data, build data platforms and prepare data so that reporting and analysis can rely on it.
Situation
- Reports are assembled from several exports and the figures differ from each other.
- Data sits in legacy systems that are due to be replaced.
- There is no common store that business teams and reporting can both use.
What we take on
- Recording the data sources, fields and responsibilities.
- Data migration from legacy systems, including validation and reconciliation runs.
- Build-up of the data platform on Databricks and Azure Data Services.
- Implementation of load paths and transformations with Python and SQL.
- Preparation of data models for reporting and analysis.
- Automated checks on completeness and plausibility of the load runs.
Approach
01
Source assessment
We record sources, fields and the business meaning of the data.
02
Model and target picture
We define the data model, the load paths and the platform set-up.
03
Build
We implement load paths and transformations and check results against the sources.
04
Handover
We document the model and its operation and hand over to your team.
Deliverables
- Register of data sources and fields
- Data model with business definitions
- Load paths and transformations in the repository
- Reconciliation report for the migrated data
- Reporting models as a basis for analysis
- Operating documentation for the platform
Engagement model
Fixed-price project
Defined scope, agreed deliverables and a fixed price. Suitable when requirements and interfaces are documented.
Time and materials
Billing by hours worked. Suitable when scope is refined during the work or priorities change.
Operations and maintenance retainer
An agreed monthly hour budget for maintenance, updates and small extensions to existing applications.
Subcontractor framework agreement
We work as a subcontractor within another provider's project. The basis is service and work contracts, not staff leasing.
Matching offering: Automation pilot · CHF 9'800.-
All services
Contact
You can reach us directly. Describe your situation and we will come back with an assessment.