Business summary
Needs and pain points consolidated by business activity.
Deliverables
The deliverables and their scope.
A summary of needs, a glossary, responsibility matrices, and documented target architecture.
Deliverables
Governance
Glossary and RACI matrices to assign responsibilities.
dbt prototype
Transformations and tests within a pilot scope.
Platform reviewed and prototype built
Existing warehouse
Snowflake
Existing orchestration
Airflow
Existing reporting
Tableau
Streamlit
Transformation prototype
dbt
- Excel files
- Business documents and exports
- Booking and management tools
Metrics to track
- Duplicate entry
- Count the handling steps eliminated in a priority workflow.
- Consistency
- Compare the same metric across departments using a reference dataset.
- Traceability
- Verify that a total can be explained from source data.