This workshop is a hands-on technical closing session for 2025 and a strategic starting point for a solid 2026 analytics roadmap, guiding participants through the design and implementation of a modern data warehouse using PostgreSQL, Trino, and dbt Core. Using a real-world shipment and logistics analytics case study, the session explores how to structure raw operational data in PostgreSQL, scale query performance with Trino as a distributed SQL engine, and apply dbt Core for robust, version-controlled SQL transformations. Participants will learn best practices for staging layer design, building dimension tables with Slowly Changing Dimension Type 1,2, constructing fact tables, and designing analytics-ready data marts that serve reporting and advanced analytics needs, while reinforcing the role of the data warehouse as a single source of truth and closing with a project quiz to validate practical understanding.