Professional Data Engineering Curriculum

Public curriculum preview for visitors and enrolled students. Use this page to evaluate module scope, outcomes, and learning path.

Download PDFBack to Course
Curriculum

Professional Data Engineering

Structured, hands-on learning path for Professional Data Engineering with detailed weekly outcomes and practical delivery.

Duration: 24 Weeks
Level: Advanced
Study Time: 2 hours/week + labs
School: Hexadigitall Academy
24 WeeksAdvancedProject-Based

Welcome to Professional Data Engineering! 🎓

This curriculum for Professional Data Engineering follows a Bloom-aligned progression from practical foundations to measurable professional outcomes, with weekly evidence, labs, and portfolio outputs matched to advanced expectations.

Each week advances from comprehension and application toward evaluation and creation, ensuring progressive learning and capstone readiness.

Your success is our priority. By the end, you will produce portfolio-ready artifacts and confidently explain your technical decisions. You will graduate with a professionally curated portfolio that demonstrates scope, depth, and delivery quality. You will graduate with a professionally curated portfolio that demonstrates scope, depth, and delivery quality. You will graduate with a professionally curated portfolio that demonstrates scope, depth, and delivery quality. You will graduate with a professionally curated portfolio that demonstrates scope, depth, and delivery quality.

Prerequisites

  • SQL proficiency: complex joins, window functions, query optimization, and performance analysis
  • Hands-on experience with data visualization tools (Tableau, Looker, Power BI, or similar)
  • Understanding of relational and dimensional modeling, fact/dimension tables, and star schema design
  • Familiarity with data quality frameworks: validation rules, anomaly detection, and completeness checks

Essential Resources

  • SQL optimization guides, query pattern library, and performance tuning references
  • Data modeling templates, dimensional design patterns, and quality framework schemas
  • Analytics cookbook with common calculations, transformations, and business metric definitions

Complementary Courses

Advanced Analytics & Machine Learning

Learn predictive modeling, statistical methods, and experimentation frameworks

Data Architecture & Engineering

Master ETL/ELT patterns, data warehouse design, and pipeline orchestration

Business Intelligence & Reporting

Deepen dashboard design, storytelling with data, and executive communication

Learning Roadmap

  • Early Weeks: SQL fundamentals, data modeling, and quality basics
  • Middle Weeks: Complex transformations, performance optimization, and BI tools
  • Late Weeks: Data governance, advanced analytics, and strategic reporting

Detailed Weekly Curriculum

Each week includes outcomes and practical lab work aligned to the curriculum structure.

Week 1

Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 1)

2 hours + labs
Learning Outcomes
  • Analyze the principles of Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 1) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Evaluate Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 1) in a guided scenario using realistic tools, constraints, and quality gates.
  • Design trade-offs, risks, and decision points for Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 1), then record rationale for stakeholder review.
  • Justify a portfolio-ready analytics quality workbook for Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 1) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 1) with schema/model decisions documented.
  • Run quality checks and performance tuning for Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 1) queries or transformations.
  • Publish Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 1) outputs to a dashboard/report with reproducible refresh steps.
Week 2

Professional Data Engineering: SQL and Data Modeling (Sprint 1)

2 hours + labs
Learning Outcomes
  • Analyze the principles of Professional Data Engineering: SQL and Data Modeling (Sprint 1) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Evaluate Professional Data Engineering: SQL and Data Modeling (Sprint 1) in a guided scenario using realistic tools, constraints, and quality gates.
  • Design trade-offs, risks, and decision points for Professional Data Engineering: SQL and Data Modeling (Sprint 1), then record rationale for stakeholder review.
  • Justify a portfolio-ready analytics quality workbook for Professional Data Engineering: SQL and Data Modeling (Sprint 1) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for Professional Data Engineering: SQL and Data Modeling (Sprint 1) with schema/model decisions documented.
  • Run quality checks and performance tuning for Professional Data Engineering: SQL and Data Modeling (Sprint 1) queries or transformations.
  • Publish Professional Data Engineering: SQL and Data Modeling (Sprint 1) outputs to a dashboard/report with reproducible refresh steps.
Week 3

Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 1)

2 hours + labs
Learning Outcomes
  • Analyze the principles of Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 1) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Evaluate Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 1) in a guided scenario using realistic tools, constraints, and quality gates.
  • Design trade-offs, risks, and decision points for Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 1), then record rationale for stakeholder review.
  • Justify a portfolio-ready analytics quality workbook for Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 1) with measurable success criteria and next actions.
Lab Exercise
  • Build a release workflow for Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 1) with automated checks, approvals, and artifact traceability.
  • Implement quality and security gates for Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 1) and enforce fail-fast criteria.
  • Execute a staged promotion for Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 1) and validate rollback safety under a controlled failure.
Week 4

Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 1)

2 hours + labs
Learning Outcomes
  • Analyze the principles of Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 1) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Evaluate Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 1) in a guided scenario using realistic tools, constraints, and quality gates.
  • Design trade-offs, risks, and decision points for Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 1), then record rationale for stakeholder review.
  • Justify a portfolio-ready analytics quality workbook for Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 1) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 1) with schema/model decisions documented.
  • Run quality checks and performance tuning for Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 1) queries or transformations.
  • Publish Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 1) outputs to a dashboard/report with reproducible refresh steps.
Week 5

Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 1)

2 hours + labs
Learning Outcomes
  • Analyze the principles of Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 1) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Evaluate Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 1) in a guided scenario using realistic tools, constraints, and quality gates.
  • Design trade-offs, risks, and decision points for Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 1), then record rationale for stakeholder review.
  • Justify a portfolio-ready analytics quality workbook for Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 1) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 1) with schema/model decisions documented.
  • Run quality checks and performance tuning for Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 1) queries or transformations.
  • Publish Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 1) outputs to a dashboard/report with reproducible refresh steps.
Week 6

Professional Data Engineering: Statistical Testing and Validation (Sprint 1)

2 hours + labs
Learning Outcomes
  • Analyze the principles of Professional Data Engineering: Statistical Testing and Validation (Sprint 1) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Evaluate Professional Data Engineering: Statistical Testing and Validation (Sprint 1) in a guided scenario using realistic tools, constraints, and quality gates.
  • Design trade-offs, risks, and decision points for Professional Data Engineering: Statistical Testing and Validation (Sprint 1), then record rationale for stakeholder review.
  • Justify a portfolio-ready analytics quality workbook for Professional Data Engineering: Statistical Testing and Validation (Sprint 1) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for Professional Data Engineering: Statistical Testing and Validation (Sprint 1) with schema/model decisions documented.
  • Run quality checks and performance tuning for Professional Data Engineering: Statistical Testing and Validation (Sprint 1) queries or transformations.
  • Publish Professional Data Engineering: Statistical Testing and Validation (Sprint 1) outputs to a dashboard/report with reproducible refresh steps.
Week 7

Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 1)

2 hours + labs
Learning Outcomes
  • Analyze the principles of Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 1) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Evaluate Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 1) in a guided scenario using realistic tools, constraints, and quality gates.
  • Design trade-offs, risks, and decision points for Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 1), then record rationale for stakeholder review.
  • Justify a portfolio-ready analytics quality workbook for Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 1) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 1) with schema/model decisions documented.
  • Run quality checks and performance tuning for Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 1) queries or transformations.
  • Publish Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 1) outputs to a dashboard/report with reproducible refresh steps.
Week 8

Professional Data Engineering: Data Governance and Documentation (Sprint 1)

2 hours + labs
Learning Outcomes
  • Analyze the principles of Professional Data Engineering: Data Governance and Documentation (Sprint 1) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Evaluate Professional Data Engineering: Data Governance and Documentation (Sprint 1) in a guided scenario using realistic tools, constraints, and quality gates.
  • Design trade-offs, risks, and decision points for Professional Data Engineering: Data Governance and Documentation (Sprint 1), then record rationale for stakeholder review.
  • Justify a portfolio-ready analytics quality workbook for Professional Data Engineering: Data Governance and Documentation (Sprint 1) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for Professional Data Engineering: Data Governance and Documentation (Sprint 1) with schema/model decisions documented.
  • Run quality checks and performance tuning for Professional Data Engineering: Data Governance and Documentation (Sprint 1) queries or transformations.
  • Publish Professional Data Engineering: Data Governance and Documentation (Sprint 1) outputs to a dashboard/report with reproducible refresh steps.
Week 9

Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 2)

2 hours + labs
Learning Outcomes
  • Evaluate the principles of Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 2) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Design Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 2) in a guided scenario using realistic tools, constraints, and quality gates.
  • Optimize trade-offs, risks, and decision points for Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 2), then record rationale for stakeholder review.
  • Justify a portfolio-ready analytics quality workbook for Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 2) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 2) with schema/model decisions documented.
  • Run quality checks and performance tuning for Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 2) queries or transformations.
  • Publish Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 2) outputs to a dashboard/report with reproducible refresh steps.
Week 10

Professional Data Engineering: SQL and Data Modeling (Sprint 2)

2 hours + labs
Learning Outcomes
  • Evaluate the principles of Professional Data Engineering: SQL and Data Modeling (Sprint 2) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Design Professional Data Engineering: SQL and Data Modeling (Sprint 2) in a guided scenario using realistic tools, constraints, and quality gates.
  • Optimize trade-offs, risks, and decision points for Professional Data Engineering: SQL and Data Modeling (Sprint 2), then record rationale for stakeholder review.
  • Justify a portfolio-ready analytics quality workbook for Professional Data Engineering: SQL and Data Modeling (Sprint 2) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for Professional Data Engineering: SQL and Data Modeling (Sprint 2) with schema/model decisions documented.
  • Run quality checks and performance tuning for Professional Data Engineering: SQL and Data Modeling (Sprint 2) queries or transformations.
  • Publish Professional Data Engineering: SQL and Data Modeling (Sprint 2) outputs to a dashboard/report with reproducible refresh steps.
Week 11

Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 2)

2 hours + labs
Learning Outcomes
  • Evaluate the principles of Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 2) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Design Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 2) in a guided scenario using realistic tools, constraints, and quality gates.
  • Optimize trade-offs, risks, and decision points for Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 2), then record rationale for stakeholder review.
  • Justify a portfolio-ready analytics quality workbook for Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 2) with measurable success criteria and next actions.
Lab Exercise
  • Build a release workflow for Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 2) with automated checks, approvals, and artifact traceability.
  • Implement quality and security gates for Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 2) and enforce fail-fast criteria.
  • Execute a staged promotion for Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 2) and validate rollback safety under a controlled failure.
Week 12

Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 2)

2 hours + labs
Learning Outcomes
  • Evaluate the principles of Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 2) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Design Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 2) in a guided scenario using realistic tools, constraints, and quality gates.
  • Optimize trade-offs, risks, and decision points for Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 2), then record rationale for stakeholder review.
  • Justify a portfolio-ready analytics quality workbook for Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 2) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 2) with schema/model decisions documented.
  • Run quality checks and performance tuning for Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 2) queries or transformations.
  • Publish Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 2) outputs to a dashboard/report with reproducible refresh steps.
Week 13

Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 2)

2 hours + labs
Learning Outcomes
  • Evaluate the principles of Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 2) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Design Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 2) in a guided scenario using realistic tools, constraints, and quality gates.
  • Optimize trade-offs, risks, and decision points for Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 2), then record rationale for stakeholder review.
  • Justify a portfolio-ready analytics quality workbook for Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 2) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 2) with schema/model decisions documented.
  • Run quality checks and performance tuning for Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 2) queries or transformations.
  • Publish Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 2) outputs to a dashboard/report with reproducible refresh steps.
Week 14

Professional Data Engineering: Statistical Testing and Validation (Sprint 2)

2 hours + labs
Learning Outcomes
  • Evaluate the principles of Professional Data Engineering: Statistical Testing and Validation (Sprint 2) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Design Professional Data Engineering: Statistical Testing and Validation (Sprint 2) in a guided scenario using realistic tools, constraints, and quality gates.
  • Optimize trade-offs, risks, and decision points for Professional Data Engineering: Statistical Testing and Validation (Sprint 2), then record rationale for stakeholder review.
  • Justify a portfolio-ready analytics quality workbook for Professional Data Engineering: Statistical Testing and Validation (Sprint 2) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for Professional Data Engineering: Statistical Testing and Validation (Sprint 2) with schema/model decisions documented.
  • Run quality checks and performance tuning for Professional Data Engineering: Statistical Testing and Validation (Sprint 2) queries or transformations.
  • Publish Professional Data Engineering: Statistical Testing and Validation (Sprint 2) outputs to a dashboard/report with reproducible refresh steps.
Week 15

Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 2)

2 hours + labs
Learning Outcomes
  • Evaluate the principles of Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 2) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Design Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 2) in a guided scenario using realistic tools, constraints, and quality gates.
  • Optimize trade-offs, risks, and decision points for Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 2), then record rationale for stakeholder review.
  • Justify a portfolio-ready analytics quality workbook for Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 2) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 2) with schema/model decisions documented.
  • Run quality checks and performance tuning for Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 2) queries or transformations.
  • Publish Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 2) outputs to a dashboard/report with reproducible refresh steps.
Week 16

Professional Data Engineering: Data Governance and Documentation (Sprint 2)

2 hours + labs
Learning Outcomes
  • Evaluate the principles of Professional Data Engineering: Data Governance and Documentation (Sprint 2) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Design Professional Data Engineering: Data Governance and Documentation (Sprint 2) in a guided scenario using realistic tools, constraints, and quality gates.
  • Optimize trade-offs, risks, and decision points for Professional Data Engineering: Data Governance and Documentation (Sprint 2), then record rationale for stakeholder review.
  • Justify a portfolio-ready analytics quality workbook for Professional Data Engineering: Data Governance and Documentation (Sprint 2) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for Professional Data Engineering: Data Governance and Documentation (Sprint 2) with schema/model decisions documented.
  • Run quality checks and performance tuning for Professional Data Engineering: Data Governance and Documentation (Sprint 2) queries or transformations.
  • Publish Professional Data Engineering: Data Governance and Documentation (Sprint 2) outputs to a dashboard/report with reproducible refresh steps.
Week 17

Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 3)

2 hours + labs
Learning Outcomes
  • Design the principles of Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 3) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Optimize Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 3) in a guided scenario using realistic tools, constraints, and quality gates.
  • Architect trade-offs, risks, and decision points for Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 3), then record rationale for stakeholder review.
  • Defend a portfolio-ready analytics quality workbook for Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 3) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 3) with schema/model decisions documented.
  • Run quality checks and performance tuning for Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 3) queries or transformations.
  • Publish Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 3) outputs to a dashboard/report with reproducible refresh steps.
Week 18

Professional Data Engineering: SQL and Data Modeling (Sprint 3)

2 hours + labs
Learning Outcomes
  • Design the principles of Professional Data Engineering: SQL and Data Modeling (Sprint 3) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Optimize Professional Data Engineering: SQL and Data Modeling (Sprint 3) in a guided scenario using realistic tools, constraints, and quality gates.
  • Architect trade-offs, risks, and decision points for Professional Data Engineering: SQL and Data Modeling (Sprint 3), then record rationale for stakeholder review.
  • Defend a portfolio-ready analytics quality workbook for Professional Data Engineering: SQL and Data Modeling (Sprint 3) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for Professional Data Engineering: SQL and Data Modeling (Sprint 3) with schema/model decisions documented.
  • Run quality checks and performance tuning for Professional Data Engineering: SQL and Data Modeling (Sprint 3) queries or transformations.
  • Publish Professional Data Engineering: SQL and Data Modeling (Sprint 3) outputs to a dashboard/report with reproducible refresh steps.
Week 19

Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 3)

2 hours + labs
Learning Outcomes
  • Design the principles of Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 3) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Optimize Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 3) in a guided scenario using realistic tools, constraints, and quality gates.
  • Architect trade-offs, risks, and decision points for Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 3), then record rationale for stakeholder review.
  • Defend a portfolio-ready analytics quality workbook for Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 3) with measurable success criteria and next actions.
Lab Exercise
  • Build a release workflow for Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 3) with automated checks, approvals, and artifact traceability.
  • Implement quality and security gates for Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 3) and enforce fail-fast criteria.
  • Execute a staged promotion for Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 3) and validate rollback safety under a controlled failure.
Week 20

Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 3)

2 hours + labs
Learning Outcomes
  • Design the principles of Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 3) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Optimize Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 3) in a guided scenario using realistic tools, constraints, and quality gates.
  • Architect trade-offs, risks, and decision points for Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 3), then record rationale for stakeholder review.
  • Defend a portfolio-ready analytics quality workbook for Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 3) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 3) with schema/model decisions documented.
  • Run quality checks and performance tuning for Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 3) queries or transformations.
  • Publish Professional Data Engineering: Exploratory Analysis and Story Framing (Sprint 3) outputs to a dashboard/report with reproducible refresh steps.
Week 21

Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 3)

2 hours + labs
Learning Outcomes
  • Design the principles of Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 3) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Optimize Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 3) in a guided scenario using realistic tools, constraints, and quality gates.
  • Architect trade-offs, risks, and decision points for Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 3), then record rationale for stakeholder review.
  • Defend a portfolio-ready analytics quality workbook for Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 3) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 3) with schema/model decisions documented.
  • Run quality checks and performance tuning for Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 3) queries or transformations.
  • Publish Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 3) outputs to a dashboard/report with reproducible refresh steps.
Week 22

Professional Data Engineering: Statistical Testing and Validation (Sprint 3)

2 hours + labs
Learning Outcomes
  • Design the principles of Professional Data Engineering: Statistical Testing and Validation (Sprint 3) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Optimize Professional Data Engineering: Statistical Testing and Validation (Sprint 3) in a guided scenario using realistic tools, constraints, and quality gates.
  • Architect trade-offs, risks, and decision points for Professional Data Engineering: Statistical Testing and Validation (Sprint 3), then record rationale for stakeholder review.
  • Defend a portfolio-ready analytics quality workbook for Professional Data Engineering: Statistical Testing and Validation (Sprint 3) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for Professional Data Engineering: Statistical Testing and Validation (Sprint 3) with schema/model decisions documented.
  • Run quality checks and performance tuning for Professional Data Engineering: Statistical Testing and Validation (Sprint 3) queries or transformations.
  • Publish Professional Data Engineering: Statistical Testing and Validation (Sprint 3) outputs to a dashboard/report with reproducible refresh steps.
Week 23

Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 3)

2 hours + labs
Learning Outcomes
  • Design the principles of Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 3) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Optimize Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 3) in a guided scenario using realistic tools, constraints, and quality gates.
  • Architect trade-offs, risks, and decision points for Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 3), then record rationale for stakeholder review.
  • Defend a portfolio-ready analytics quality workbook for Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 3) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 3) with schema/model decisions documented.
  • Run quality checks and performance tuning for Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 3) queries or transformations.
  • Publish Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 3) outputs to a dashboard/report with reproducible refresh steps.
Week 24

Professional Data Engineering: Data Governance and Documentation (Sprint 3)

2 hours + labs
Learning Outcomes
  • Design the principles of Professional Data Engineering: Data Governance and Documentation (Sprint 3) and link them to course outcomes at advanced depth with architecture-level decision quality.
  • Optimize Professional Data Engineering: Data Governance and Documentation (Sprint 3) in a guided scenario using realistic tools, constraints, and quality gates.
  • Architect trade-offs, risks, and decision points for Professional Data Engineering: Data Governance and Documentation (Sprint 3), then record rationale for stakeholder review.
  • Defend a portfolio-ready analytics quality workbook for Professional Data Engineering: Data Governance and Documentation (Sprint 3) with measurable success criteria and next actions.
Lab Exercise
  • Implement a working data workflow for Professional Data Engineering: Data Governance and Documentation (Sprint 3) with schema/model decisions documented.
  • Run quality checks and performance tuning for Professional Data Engineering: Data Governance and Documentation (Sprint 3) queries or transformations.
  • Publish Professional Data Engineering: Data Governance and Documentation (Sprint 3) outputs to a dashboard/report with reproducible refresh steps.

Capstone Projects

Project 1: Professional Data Engineering Foundation Build

Deliver a concrete foundation implementation covering the first phase of the curriculum.

  • Implement and validate Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 1).
  • Integrate Professional Data Engineering: SQL and Data Modeling (Sprint 1) with reusable workflow standards.
  • Publish evidence for Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 1) with test and quality artifacts.

Project 2: Professional Data Engineering Integrated Systems Build

Combine mid-program competencies into a production-style integrated workflow.

  • Build an end-to-end flow around Professional Data Engineering: Data Foundations and Quality Assurance (Sprint 2) and Professional Data Engineering: SQL and Data Modeling (Sprint 2).
  • Add controls, observability, and rollback paths for reliability.
  • Document architecture decisions and trade-offs tied to Professional Data Engineering: Transformation and Pipeline Hygiene (Sprint 2).

Project 3: Professional Data Engineering Capstone Delivery

Ship a portfolio-ready capstone with measurable outcomes and stakeholder-ready presentation.

  • Deliver a complete implementation centered on Professional Data Engineering: Dashboard Design and KPI Communication (Sprint 3).
  • Validate readiness for Professional Data Engineering: Statistical Testing and Validation (Sprint 3) using objective acceptance checks.
  • Present final defense and roadmap based on Professional Data Engineering: Forecasting and Scenario Analysis (Sprint 3) outcomes.