Exercises

What gets built in class

Everything runs on open health data: real administrative records, with the mess and ambiguity that entails. No sample datasets, and no patient data.

  • Hospital bed occupancy from open REM data, in SQL over DuckDB.
  • Normalising free-text diagnoses and procedures with regular expressions.
  • Processing tables of millions of care episodes on a personal computer, with no server.
  • Statistical modelling and survival analysis over cohorts built from open data.

Where I teach

One postgraduate programme and two open schools

2022

Diplomado en Salud Digital, UNAB

Postgraduate teaching in digital health strategy leadership and management.

Faculty on the Postgraduate Diploma in Digital Health Strategy Leadership and Management at Universidad Andrés Bello, aimed at professionals who will lead digital transformation inside health institutions.

2024

Hazla con Datos

Data analysis material built on open health data rather than marketing case studies.

Analytics is almost always taught with examples from marketing, commercial logistics or finance. For health staff that introduces a concrete methodological friction: the procedure may be right, but the data structure looks nothing like what they handle at work.

The Hazla con Datos material was built on open health data — the ministry’s REM and DEIS series and the national open data portal — which are real administrative records, not sample sets: they carry the same coding, quality and volume problems staff face at work.

2018

OpenSalud LAB

Open health data science bootcamp, with all its material in a public repository.

OpenSalud LAB was created in 2018 as a citizen laboratory for open innovation in public health services. Its main output was the Health Data Science bootcamp, hosted entirely in a public GitHub repository.

The programme gathered over 100 hours of video training and more than 200 hours of practical resources, covering R programming, exploratory analysis, statistical modelling, process management and technical reproducibility, built with R-Ladies Concepción and Data UC at the Pontifical Catholic University of Chile.

Contents

Methods and tools I teach

The technical syllabus, from command-line tooling fundamentals through to natural language processing over clinical text.

ModuleContentsToolingClinical application
01FoundationsCoding mindset, project path hygiene, algorithmic logic and pseudocode.Markdown · Obsidian · WSL · BashLogical structuring of analytical thinking, without operational barriers to entry.
02Data wranglingHealth-specific regular expressions, clinical spreadsheet processing and cleaning.R (tidyverse) · Python · RegexNormalising ICD-10 diagnoses and cleaning administrative health tables.
03Large-scale processingEmbedded OLAP engines, data transformation schemes and SQL querying.DuckDB · SQL · Apache Parquet · dbtAbility to process tables of millions of care episodes on personal computers.
04Statistical modellingBiostatistics, inference, regression and survival analysis with machine learning.R (survival, tidymodels) · Python (scikit-learn)Estimating survival curves, proportional hazards and interpreting uncertainty.
05Architecture and NLPNatural language processing and pseudonymisation schemes.Transformers · DockerEntity extraction from free clinical text, and techniques for protecting confidentiality.

Record

Where this work has been presented

Peer-reviewed conferences and public-sector training venues.

Conference

Public sector

  • 2021

    Speaker at the International Telemedicine Congress

    Ministry of Health of Peru

  • 2021

    Lead facilitator of the Health Data Science workshop and workshop leader in the Public Innovators Network

    Laboratorio de Gobierno, Chile

Media

  • 2019–2026 Salud 4.0 podcast · Acceso Salud, Radio Universidad de Chile · Dbox Radio — Health innovation, communities of practice and applied data science
  • 2019–2020 Coverage of the SmartSalud open innovation challenge — FayerWayer · INACAP · InterSystems