Get in Touch
 Duration 35 hours

Course Outline

Data Warehousing Fundamentals

  • Purpose, key components, and overall architecture
  • Data marts, enterprise warehouses, and lakehouse designs
  • Core differences between OLTP and OLAP, plus workload isolation

Dimensional Modeling

  • Facts, dimensions, and data grain
  • Comparison of star and snowflake schemas
  • Managing Slowly Changing Dimensions and their types

ETL and ELT Workflows

  • Techniques for extracting data from OLTP sources and APIs
  • Transformation logic, data cleaning, and consistency checks
  • Loading strategies, orchestration, and handling dependencies

Data Quality and Metadata Governance

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

Analytics and Performance Optimization

  • Cube concepts, aggregations, and materialized views
  • Using partitioning, clustering, and indexing for analytical speed
  • Workload control, caching strategies, and query tuning

Security and Governance

  • Managing access control, roles, and row-level security
  • Addressing compliance requirements and audit trails
  • Best practices for backup, recovery, and system reliability

Contemporary Architectures

  • Cloud-based data warehouses and elastic scaling
  • Streaming data ingestion and near real-time analytics
  • Strategies for cost efficiency and performance monitoring

Capstone Project: From Source to Star Schema

  • Modeling a business process into facts and dimensions
  • Constructing a complete end-to-end ETL or ELT pipeline
  • Creating dashboards and validating key metrics

Recap and Future Directions

Requirements

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

Target Audience

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

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories