Skip to content

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

  1. 01

    Source assessment

    We record sources, fields and the business meaning of the data.

  2. 02

    Model and target picture

    We define the data model, the load paths and the platform set-up.

  3. 03

    Build

    We implement load paths and transformations and check results against the sources.

  4. 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.

Send an enquiry