Get in Touch
 Duration 35 hours

Course Outline

Core Data Warehousing Principles

  • Warehouse objectives, key components, and structural design
  • Data marts, enterprise warehouses, and lakehouse patterns
  • OLTP and OLAP basics, including workload segregation

Dimensional Modeling

  • Defining facts, dimensions, and data grain
  • Comparing star and snowflake schemas
  • Types of Slowly Changing Dimensions (SCD) and management strategies

ETL and ELT Workflows

  • Extraction techniques from OLTP sources and APIs
  • Data transformation, cleansing, and conformance
  • Load patterns, orchestration, and dependency handling

Data Quality and Metadata Oversight

  • Data profiling and validation rules
  • Alignment of master and reference data
  • Lineage tracking, data catalogs, and documentation

Analytics and Performance Optimization

  • Cubing concepts, aggregations, and materialized views
  • Partitioning, clustering, and indexing strategies for analytics
  • Workload management, caching mechanisms, and query tuning

Security and Governance

  • Access control, role-based permissions, and row-level security
  • Compliance requirements and audit trails
  • Backup, disaster recovery, and reliability protocols

Contemporary Architectures

  • Cloud data warehouses and elastic scaling
  • Streaming ingestion and near real-time analytics
  • Cost efficiency and performance monitoring

Capstone: Source to Star Schema

  • Modeling a business process into facts and dimensions
  • Developing a complete ETL or ELT pipeline
  • Deploying dashboards and verifying metrics

Recap and Future Steps

Requirements

  • Knowledge of relational databases and SQL
  • Prior experience in data analysis or reporting
  • Foundational understanding of cloud or on-premises data platforms

Target Audience

  • Data analysts moving into data warehousing roles
  • BI developers and ETL engineers
  • Data architects and team leaders

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories