​​ Build a Governed Crop Metrics Hub with dbt, MetricFlow and PostgreSQL
How It Works
Capstone Project

Build a Governed Crop Metrics Hub with dbt, MetricFlow and PostgreSQL

Group: Capstone Project

Product Category: Cloud & Data Engineering

Sub Category: Data Build Tool (DBT)

Solution Available

Source code, datasets, and other related files for the solution will be provided.

Prerequisites

SQL basics relational modeling basic analytics concepts production engineering basics cloud fundamentals testing and observability concepts

About this Product

Build a Governed Crop Metrics Hub with dbt, MetricFlow and PostgreSQL is an analytics engineering capstone that builds Verdantrail Crop Metrics Hub, a contract-first dbt project for a fictional agritech company with 250 crop parcels. Five raw feeds land in PostgreSQL, move through staging, intermediate, mart, and semantic layers, and end in seven governed metrics defined once. Bad records never reach the marts: they are quarantined with a reason code and shown on a quality scorecard. It runs locally with dbt and PostgreSQL, so no cloud warehouse is needed.

With this product, you’ll build a project that can:

  • Generate seeded daily source drops with injectable faults and a fault manifest
  • Check each drop against a source contract and reject schema drift without blocking other sources
  • Load raw data idempotently into range-partitioned PostgreSQL tables
  • Clean and deduplicate in staging with enforced dbt model contracts, quarantining bad rows with reason codes
  • Model a parcel-day star schema with a type 2 dimension and a versioned mart (v1 to v2)
  • Define seven governed metrics in a MetricFlow semantic layer
  • Test every layer with severity policy, reconciliation tests, and a quality scorecard
  • Speed up the daily build with incremental merge models and indexes, proven by a benchmark report
  • Log every run and document it with ADRs, a runbook, and dbt docs

Building this product gives you hands-on experience in:

  • dbt project design
  • Data contracts
  • Semantic layer
  • Data quality engineering
  • Performance engineering

It uses Python, dbt-core, dbt-postgres, dbt-metricflow, PostgreSQL, psycopg, Faker, and pytest, and runs on Windows or macOS with Docker optional.

Why this product matters: analytics engineering roles are about trusted, consistent numbers. This capstone teaches how to define a KPI once, protect marts from bad data, and change models safely.

Resources

1/4
Build a Governed Crop Metrics Hub with dbt, MetricFlow and PostgreSQL Application Requirement Document
Build a Governed Crop Metrics Hub with dbt, MetricFlow and PostgreSQL Application Requirement Document
| PDF

The complete Build a Governed Crop Metrics Hub with dbt, MetricFlow and PostgreSQL Business Requirements Document (BRD) is available as a Read-Only attachment. It provides the complete project specification for Verdantrail Crop Metrics Hub, including the business context, objectives, scope, requirements, use cases, and design expectations. Review the BRD carefully before starting the implementation.

Asset Contents:

  • Project overview and business objectives
  • In-scope and out-of-scope definitions
  • Functional and non-functional requirements 
  • Business rules and metric definitions
  • Key use cases and workflows
  • Actors, data model, and layer contracts
  • Failure scenarios, architecture, and fault catalogue
  • Acceptance criteria and requirements traceability
Enroll to Access
Build a Governed Crop Metrics Hub with dbt, MetricFlow and PostgreSQL
50% OFF

Topics

Analytics Engineering Data Contracts & Versioning Semantic Layer & Governed Metrics Data Quality & Quarantine Dimensional Modeling Incremental Modeling & Performance

Skills

Python dbt MetricFlow PostgreSQL SQL Data Contracts Star Schema Data Quality Incremental Models psycopg Faker pytest

Languages

English

Level

Advance

Business Domain

Agriculture & Agritech

$4.00 $8.00

Labs • Projects • Practice

Similar Products

> more hands-on labs picked for you_

50% OFF
Build a Real Time Hospital KPI Streaming Pipeline with Kafka, Spark and CDC
Capstone Project

Build a Real Time Hospital KPI Streaming Pipeline with Kafka, Spark and CDC

Build a Real-Time Hospital KPI Streaming Pipeline with Kafka, Spark and CDC is a streaming data engineering capstone that builds …

Real-Time Stream Processing Change Data Capture Effectively-Once Processing Dead Letter Queues & Replay Schema Management & Validation Observability & Failure Testing +4 more +3 more +2 more +1 more

Level

Advance

Time

40.0 hrs

Language

English

42% OFF
Build a Guarded Multi Model Shopper Personalization API with FastAPI and PostgreSQL
Business Requirement

Build a Guarded Multi Model Shopper Personalization API with FastAPI and PostgreSQL

Build a Guarded Multi-Model Shopper Personalization API with FastAPI and PostgreSQL is a GenAI business requirement lab that builds Kestrel …

Multi-Model Orchestration AI Guardrails & Safety Resilience Patterns LLM Evaluation API Security & Rate Limiting Observability & Privacy +4 more +3 more +2 more +1 more

Level

Advance

Time

18.0 hrs

Language

English

40% OFF
Build a Harvest Lot Allocation and Traceability API with FastAPI, PostgreSQL and Redis
Capstone Project

Build a Harvest Lot Allocation and Traceability API with FastAPI, PostgreSQL and Redis

Build a Harvest Lot Allocation and Traceability API with FastAPI, PostgreSQL and Redis is a backend capstone that builds Tillmark …

Async API Development Concurrency Control Caching & Idempotency Data Traceability API Security & Rate Limiting Observability & Resilience +4 more +3 more +1 more

Level

Intermediate

Time

30.0 hrs

Language

English

37% OFF
Build a Governed Pricing Lakehouse Control Plane with Delta Lake, DuckDB and FastAPI
Business Requirement

Build a Governed Pricing Lakehouse Control Plane with Delta Lake, DuckDB and FastAPI

Build a Governed Pricing Lakehouse Control Plane with Delta Lake, DuckDB and FastAPI is an advanced, 36-hour business capability lab …

Lakehouse Platform Design Data Governance & Catalog Access Control & Column Masking Workload Isolation & Quotas Data Lineage Platform Observability +4 more +3 more +1 more

Level

Advanced

Time

36.0 hrs

Language

English

33% OFF
Build a Warehouse Event Streaming Pipeline with Kafka and SQL
Capstone Project

Build a Warehouse Event Streaming Pipeline with Kafka and SQL

Build a Warehouse Event Streaming Pipeline with Kafka and SQL is a data engineering capstone that builds Pallet Pulse, a …

Event Streaming Kafka Producers & Consumers Idempotent Event Processing Dead Letter Queues Data Validation & Quality SQL Reporting +4 more +3 more +2 more

Level

Beginner

Time

16.0 hrs

Language

English

50% OFF
Build an After Sales Service Lakehouse with PySpark, Delta Lake, Airflow and dbt
Capstone Project

Build an After Sales Service Lakehouse with PySpark, Delta Lake, Airflow and dbt

Build an After-Sales Service Lakehouse with PySpark, Delta Lake, Airflow and dbt is a data engineering capstone that builds Torquepath …

Lakehouse Architecture Batch Data Pipelines Data Quality & Quarantine Workflow Orchestration Dimensional Modeling with dbt Observability & Data Governance +4 more +3 more +2 more +1 more

Level

Advanced

Time

36.0 hrs

Language

English

33% OFF
Build a Stockout Risk Scoring Service with LightGBM and SHAP
Use Case

Build a Stockout Risk Scoring Service with LightGBM and SHAP

Build a Stockout Risk Scoring Service with LightGBM and SHAP is a machine learning use case lab that builds a …

Imbalanced Classification Feature Engineering Hyperparameter Tuning Model Calibration Model Explainability Batch & Online Inference +4 more +3 more +2 more

Level

Advanced

Time

8.0 hrs

Language

English

33% OFF
Build a Stock Availability Model Release Pipeline with MLflow and Docker
Use Case

Build a Stock Availability Model Release Pipeline with MLflow and Docker

Build a Stock Availability Model Release Pipeline with MLflow and Docker is a MLOps use case lab that builds a …

MLOps Model Registry & Versioning Container Deployment CI/CD for Machine Learning Model Drift Monitoring API Security & Audit +4 more +3 more +2 more

Level

Intermediate

Time

6.0 hrs

Language

English

50% OFF
Build a Farm Water RAG Copilot with Qdrant and FastAPI
Business Requirement

Build a Farm Water RAG Copilot with Qdrant and FastAPI

Build a Farm Water RAG Copilot with Qdrant and FastAPI is a GenAI business requirement lab that builds Rillmark Water …

Retrieval-Augmented Generation Vector Databases Chunking & Retrieval LLM Evaluation API Security & Access Control +3 more +2 more +1 more

Level

Intermediate

Time

12.0 hrs

Language

English

33% OFF
Build a Governed Student Intervention Agent Team with Python
Use Case

Build a Governed Student Intervention Agent Team with Python

Build a Governed Student Intervention Agent Team with Python is an advanced, GenAI use case lab that builds Beacon, a …

Multi-Agent Orchestration Tool Governance Human-in-the-Loop Workflows LLM Evaluation Observability & Tracing AI Safety & Guardrails +4 more +3 more +2 more +1 more

Level

Advanced

Time

10.0 hrs

Language

English

44% OFF
Design a Shipment Tracking Data Model and Pipeline with PostgreSQL
Capstone Project

Design a Shipment Tracking Data Model and Pipeline with PostgreSQL

Shipment Tracking Data Model and Pipeline with PostgreSQL is a beginner-level data engineering project for a fictional freight logistics company. …

Data Modeling ETL Pipeline Design Relational Database Design Data Validation & Quality Exception Detection SQL Reporting +4 more +3 more +2 more

Level

Beginner

Time

24.0 hrs

Language

English

50% OFF
Build a Property Pricing Data Warehouse with DuckDB and Python
Capstone Project

Build a Property Pricing Data Warehouse with DuckDB and Python

Build a Property Pricing Data Warehouse with DuckDB and Python is a data engineering product that builds CompVantage — a …

Data Engineering Dimensional Modeling Medallion Architecture Data Governance ETL Pipeline Design Data Quality & Validation +4 more +3 more +2 more +1 more

Level

Intermediate

Time

24.0 hrs

Language

English

44% OFF
Build a Governed Fleet Route Data Platform with Python and DuckDB
Capstone Project

Build a Governed Fleet Route Data Platform with Python and DuckDB

Build a Governed Fleet Route Data Platform with Python and DuckDB is a data engineering product that builds the complete …

Data Engineering Batch Pipeline Design DAG Orchestration Data Governance Data Quality & Validation Observability & Monitoring +4 more +3 more +1 more

Level

Beginner

Time

16.0 hrs

Language

English

50% OFF
Build a Real Time Retail Sales Pipeline with Kafka Python and Google BigQuery
Use Case

Build a Real Time Retail Sales Pipeline with Kafka Python and Google BigQuery

Build a Real Time Retail Sales Pipeline with Kafka, Python and Google BigQuery is a data engineering product that builds …

Event Streaming Data Engineering Kafka Consumer Design Google BigQuery Integration Idempotent Data Loading Data Validation & DLQ +4 more +3 more +2 more

Level

Intermediate

Time

4.0 hrs

Language

English

33% OFF
Build a Real Time Retail Sales Pipeline with Kafka PySpark and PostgreSQL
Use Case

Build a Real Time Retail Sales Pipeline with Kafka PySpark and PostgreSQL

Build a Real Time Retail Sales Pipeline with Kafka, PySpark and PostgreSQL is an intermediate-level data engineering product that builds …

Event Streaming Data Engineering PySpark Structured Streaming Idempotent Data Loading Data Validation & DLQ Kafka Integration +4 more +2 more

Level

Intermediate

Time

4.0 hrs

Language

English

32% OFF
Enterprise Data Security & Governance Implementation using Snowflake
Business Requirement

Enterprise Data Security & Governance Implementation using Snowflake

Enterprise Data Security & Governance Implementation using Snowflake is a practical implementation guide that teaches you how to build a …

Snowflake Security Data Governance Role-Based Access Control (RBAC) Dynamic Data Masking Row Access Policies Data Classification Audit Logging Regulatory Compliance Healthcare Analytics +7 more +5 more +4 more +3 more +2 more

Level

Advanced

Language

English

33% OFF
Enterprise Sales Analytics Data Warehouse Design with Kimball Modeling & SCD Implementation
Business Requirement

Enterprise Sales Analytics Data Warehouse Design with Kimball Modeling & SCD Implementation

Enterprise Sales Analytics Data Warehouse Design with Kimball Modeling & SCD Implementation is a practical implementation guide that teaches you …

Data Warehousing Kimball Dimensional Modeling Star Schema Slowly Changing Dimensions Change Data Capture SQL Data Engineering Business Intelligence Real-Time Analytics +7 more +6 more +5 more +3 more +2 more +1 more

Level

Advanced

Language

English

33% OFF
Enterprise Customer 360 Data Platform Implementation using Natural Keys, Row Hashes & Medallion Architecture
Business Requirement

Enterprise Customer 360 Data Platform Implementation using Natural Keys, Row Hashes & Medallion Architecture

Enterprise Customer 360 Data Platform Implementation using Natural Keys, Row Hashes & Medallion Architecture is a practical implementation guide that …

Customer 360 Data Engineering ETL Pipeline Design Medallion Architecture Entity Resolution Natural Key Matching Data Integration Data Warehousing Master Data Management +7 more +6 more +5 more +4 more +3 more +2 more

Level

Advanced

Language

English

40% OFF
Historical Dimension Tracking & SCD Pipeline Implementation Using PySpark and PostgreSQL
Capstone Project

Historical Dimension Tracking & SCD Pipeline Implementation Using PySpark and PostgreSQL

Historical Dimension Tracking & SCD Pipeline Implementation Using PySpark and PostgreSQL is a practical implementation guide that teaches you how …

PySpark Slowly Changing Dimensions (SCD) PostgreSQL Data Warehousing Dimensional Modeling Temporal Data Modeling Data Engineering ETL Pipeline Development +6 more +5 more +4 more +3 more +1 more

Level

Intermediate

Time

10.0 hrs

Language

English

37% OFF
Real Time Kafka Consumer Data Ingestion into RAW Layer Using PySpark
Business Requirement

Real Time Kafka Consumer Data Ingestion into RAW Layer Using PySpark

Real-Time Kafka Consumer Data Ingestion into RAW Layer Using PySpark is a practical implementation guide that teaches you how to …

PySpark Structured Streaming Apache Kafka Streaming Data Engineering Real-Time Data Ingestion Kafka Consumers ETL Pipeline Development +4 more +3 more +2 more

Level

Intermediate

Language

English

40% OFF
Healthflow Analytics Platform with Snowflake & Medallion Architecture
Capstone Project

Healthflow Analytics Platform with Snowflake & Medallion Architecture

Healthflow Analytics Platform with Snowflake & Medallion Architecture is a healthcare data engineering capstone project that demonstrates how to build …

Snowflake Data Engineering Healthcare Analytics ETL Pipeline Design Medallion Architecture Data Governance Data Warehousing Snowflake Administration +5 more +4 more +3 more +1 more

Level

Intermediate

Time

8.0 hrs

Language

English

30% OFF
FinTech Banking ETL Pipeline with PySpark Delta Lake and Medallion Architecture
Capstone Project

FinTech Banking ETL Pipeline with PySpark Delta Lake and Medallion Architecture

NovaPay ETL Pipeline is an advanced data engineering capstone project that builds a production-grade ETL pipeline for a fictional digital …

Data Engineering ETL Pipeline Design Medallion Architecture Data Quality & Validation Incremental Processing Delta Lake & Lakehouse +4 more +3 more +2 more

Level

Advanced

Language

English

40% OFF
Full Stack IPL Cricket Analytics Dashboard and Statistics Platform
Capstone Project

Full Stack IPL Cricket Analytics Dashboard and Statistics Platform

IPL Analytics Dashboard is an advanced, full-stack capstone project that transforms 17 years of Indian Premier League ball-by-ball match data …

Full Stack Development Data Ingestion & Pipeline REST API Development Database Design Data Visualization User Authentication +4 more +3 more +1 more

Level

Advanced

Language

English

Demo

View
50% OFF
Retail Banking EDA & Transaction Analytics Platform
Capstone Project

Retail Banking EDA & Transaction Analytics Platform

Retail Banking EDA & Transaction Analytics Platform is an advanced, full-stack capstone project that takes you through the complete data …

Data Engineering Exploratory Data Analysis Full Stack Development Database Design Regulatory Compliance REST API Design Data Visualization +5 more +4 more +2 more +1 more

Level

Intermediate

Time

8.0 hrs

Language

English

Demo

View
40% OFF
AI Powered Meeting Notes Generator
Capstone Project

AI Powered Meeting Notes Generator

AI Powered Meeting Notes Generator is an intermediate-level, full-stack capstone project that transforms raw meeting recordings and transcripts into clean, …

AI Integration Full Stack Development Speech-to-Text LLM Prompt Engineering Async Processing REST API Design +4 more +3 more

Level

Intermediate

Time

8.0 hrs

Language

English

Demo

View
40% OFF
Full Stack Service Booking Marketplace with Consultant Subscription Model
Capstone Project

Full Stack Service Booking Marketplace with Consultant Subscription Model

BookMyService is a beginner-friendly, full-stack capstone project that simulates a real-world two-sided service marketplace — where users can discover and …

Full Stack Development SaaS Marketplace Authentication & Security Subscription Management Role-Based Access Control REST API Design +4 more +3 more +2 more

Level

Intermediate

Time

8.0 hrs

Language

English

Demo

View

Expert Guidance

Similar Services

1:1 help from industry experts who can guide you through labs like this one.

Finding the best experts for you...

Learner Feedback

Top User Reviews

Loading reviews...