KBDgroup

Case study · Health data & automation

Canadian Clinical
Drug Dataset

Making a monthly data process more reliable.

KBD maintained, enhanced, and automated data pipelines for a client responsible for underlying PrescribeIT infrastructure, supporting Canada’s e-prescribing service.

The workflow

A repeatable route through changing data.

  1. 01 / SourceMonthly data updates
  2. 02 / ProcessGeneration scripts & error investigation
  3. 03 / OutputClinical drug dataset
Workflow overview · A simplified view of KBD’s project approach.
Sector
Health data
KBD contribution
Data pipeline automation
Update cycle
Monthly dataset generation

The challenge

Changing data.
Recurring deadlines.

The clinical drug dataset needed monthly updates. Source data could arrive with new formatting or inconsistencies that interrupted the pipeline and required script fixes and manual intervention.

KBD was asked to automate this process while helping the client identify and resolve recurring data errors.

KBD’s contribution

Support across the data pipeline.

01 / Automate generation

Build the scripts

Created scripts to automate data generation and monitored monthly runs for opportunities to improve efficiency and reduce errors.

02 / Investigate errors

Trace issues upstream

Groomed data and investigated recurring problems further up the pipeline, supporting fixes to scripts and workflows.

03 / Support the team

Coordinate across languages

Supported workflows across multiple languages so industry experts could coordinate data operations across time zones.

Your next project

Ready to improve
a recurring process?

Tell us about your data sources, recurring tasks, and the workflows that need attention.

Start a conversation