### **📋 Overview**
**Task:** [Task Name]
**Task Owner:** \@[Person Name]
**Budget Name:** [e.g. Sprint #8 - Product Metrics Kick-off]
**Budget link:** [Budgets](https://airtable.com/appF0pxDtxF1fVm6O/pagAUp6JIhtCV63U9 "")
**Due Date:** YYYY-MM-DD
**Summary:**
> [a 1–2 sentence description of what we’re building or fixing]
### 🎯 Objectives & Deliverables
- **Objectives:**
1. [e.g. increase upsell revenue by adding attributes to metric X]
2. [e.g. reduce future development cost by refactoring dbt]
3. [e.g. reduce administrative costs by adding 2 quality tests]
- **Deliverables:**
- [e.g. DB schema diagrams, DAG code, docs, tests, dashboard]
### 📐 Design
- **Deliverable 1:**
- Design specification 1a
- Design specification 1b
- Design specification 1c
- **Deliverable 2:**
- Design specification 2a
- Design specification 2b
- Design specification 2c
### ⏰ Effort Estimate
- **Requirements:**
1. Kickoff & discovery meeting: X hrs
2. Write/validate specs: X hrs
- **Design:**
- Data model & entity diagrams: X hrs
- Dashboards and report hierarchy: X hrs
- **Environment**
- Application enrolment and setup: X hrs
- User access security setup: X hrs
- **Development:**
- Build extraction pipeline: X hrs
- Transformation & modeling: X hrs
- Building semantic models: X hrs
- **Testing**
- Unit & Integrity tests: X hrs
- Freshness logging and warning mechanism: X hrs
- **Total**
- Task hour estimate: XYZ hrs
### 🔗 Dependencies
- [e.g. link to related task, card, doc]
- [e.g. link to upstream or downstream asset/system]
### ⚠️ Assumptions & Risks
- [e.g. assumes full data integrity in upstream assets. When it requires fixing, updated hour estimate should be made and agreed upon with client contact]
- [e.g. risk that upstream asset Z is not operational before due date. +/-30% chance that task due date will be 1 month later]
### 📎 Attachments
- [e.g. [Data Quality Setup](https://docs.maxqanalytics.io/Demos/Internal+Analytics#Data+Quality "") Example]
- [e.g. [Data Model Diagram](https://dbdiagram.io/d/Semantic-Nexus-Data-Model-67dc092275d75cc844d3983e "") Template]
- [e.g. Request for Proposal Document]
- [e.g. Requirements Conversation in Slack]
- [e.g. Video recording + Notes of scope meeting]