08. Data Project Tools

This section combines documents and resources useful for a data advisory engagement.

Project handover from BD

• Leave handover template
• Avaza setup instructions: TBD

Requirements gathering

• Data collection requirements: TBD
• Dashboard requirements gathering form

Data collection

• TBD
• Form creation best practices: TBD

Canopy

• TBD: Superset setup / upgrade
• Connector documentation
• Python script for re-labeling columns from connector

Database design

• Tidy data framework

Internal tools

• Managing GitHub commit signature verification

dbt

• Introduction to dbt
• Installing and configuring dbt-cli
• Installing the dbt-cli VS Code Extension
• Migrating a legacy Ona project into dbt checklist

QGIS

• GeoJSON transformations

Data visualization / dashboards

• Dashboard QA checklist
• How-To's

Project management / evaluation

• Process framework for building data visualization outputs

• Post project satisfaction survey (WIP)

• OpenVPN Connect for Windows