Get in Touch
 Duration 35 hours

Course Outline

Data Warehousing Foundations

  • Purpose, key components, and architectural overview of the warehouse
  • Data marts, enterprise warehouses, and lakehouse patterns
  • Core differences between OLTP and OLAP, including workload separation

Dimensional Modeling

  • Comparing star schemas and snowflake schemas
  • Managing various types of Slowly Changing Dimensions

ETL and ELT Workflows

  • Extraction methods from OLTP sources and APIs
  • Data transformation, cleansing, and conformance strategies
  • Loading patterns, orchestration, and managing dependencies

Data Quality and Metadata Governance

  • Profiling data and establishing validation rules
  • Aligning master and reference data
  • Managing lineage, catalogs, and documentation

Analytics and Performance Optimization

  • Understanding cubing, aggregates, and materialized views
  • Applying partitioning, clustering, and indexing for analytics
  • Workload management, caching strategies, and query tuning

Security and Governance

  • Implementing access controls, roles, and row-level security
  • Addressing compliance requirements and auditing
  • Best practices for backup, recovery, and reliability

Modern Architectures

  • Cloud-based data warehouses and elastic scaling
  • Streaming ingestion for near real-time analytics
  • Cost optimization and continuous monitoring

Capstone Project: From Source to Star Schema

  • Translating business processes into facts and dimensions
  • Constructing an end-to-end ETL or ELT workflow
  • Creating dashboards and validating key metrics

Summary and Recommended Next Steps

Requirements

  • A solid grasp of relational databases and SQL
  • Practical experience in data analysis or reporting
  • Foundational knowledge of cloud or on-premises data platforms

Target Audience

  • Data analysts looking to transition into data warehousing roles
  • BI developers and ETL engineers
  • Data architects and team leaders

Testimonials (2)

Upcoming Courses

Related Categories