Colorado DA ETL

Public and Internal Dashboard Development

• Dashboard and visualization is decoupled
• Iframes are made individually
• Exploratory work completed in researcher preferred tools
• Next step -> production

Orchestrator in a single CJIS compliant server.

Create

Features

Extract

Tables

Bulk

Extracts

Update Viz

With API

The SYstem Now

• Staff will need ability to work with python and SQL
• Each step is idempotent and decoupled
  • e.g. if you later want to directly query a OLAP database
• ETL will have clearly documented data lineage