Data platforms and integration
One set of numbers the whole organization works from, built from the systems you already run. A governed data platform in your cloud, under your access rules, with integrations that are monitored.
- Typical length
- Three to six months, discovery included
- Platforms
- Microsoft Fabric, Snowflake, Databricks, Google Cloud and Amazon Web Services data services
- Investment basis
- Fixed price discovery, build confirmed after it
01 In practice
How data reaches a report
Example. The actual design is set during discovery.
Source systems
Finance, CRM, case management and the spreadsheets people rely on.
Monitored pipelines
Scheduled and event driven loads, with every failure logged and alerted.
Governed model
Shared definitions, so a measure means the same thing everywhere.
Reports
Dashboards and extracts built on the model, checked against source totals.
02 Who it is for
- Reporting assembled by hand from several systems each month
- Different departments quoting different numbers for the same measure
- Systems that need to exchange data reliably, not through exported files
- Data that must stay in Canada and under named access rules
03 What you get
- 01
Source inventory
Each system, its data, its owner and how it can be reached.
- 02
Data model
The shared definitions and structures the reporting is built on.
- 03
Pipelines and integrations
Scheduled and event driven loads, with failures logged and alerted.
- 04
Reporting layer
The first set of reports and dashboards, built on the governed model.
- 05
Access and residency design
Who sees what, and where the data is stored and processed.
- 06
Runbook
How to add a source, fix a failed load and change a definition.
04 Investment
Indicative investment
Canadian dollars, before tax. Confirmed after discovery, based on complexity, integration requirements, delivery scope and your environment.
Scope assumptions. The lower end is a few source systems and a first set of reports. The upper end is many sources, event driven integrations and a wider reporting layer.
05 How we deliver
One consistent approach, set for this work
Discover
Source systems, a data quality sample, priority reports, access rules and residency requirements.
Build
Platform, model, pipelines and first reports built in a mirror environment and tested against source totals.
Release
Reconciliation against the source systems, release record approved, report owners trained.
Run
A handover to your team, a fixed transition period of close support, or a monthly service for pipeline monitoring and new sources.
06 What we need from you
- A data owner for each source system
- Read access to the sources, or extracts while access is arranged
- A cloud subscription in a Canadian region, or a decision on one
- The reports people rely on today, to test the new numbers against
07 Start
Discuss your project
Tell us what needs to change and when. If the work fits, we propose a fixed price discovery.