Get in Touch
 Duration 35 hours

Course Outline

Data Warehousing Fundamentals

  • Objectives, key components, and architectural structures of the warehouse
  • Data marts, enterprise warehouses, and lakehouse architectural patterns
  • Core differences between OLTP and OLAP and the importance of workload separation

Dimensional Modeling Strategies

  • Defining facts, dimensions, and data grain
  • Comparative analysis of star schema and snowflake schema designs
  • Classifying and managing Slowly Changing Dimensions (SCD)

ETL and ELT Workflows

  • Extracting data effectively from OLTP systems and APIs
  • Applying transformations, data cleansing, and conformance techniques
  • Load patterns, orchestration, and managing task dependencies

Data Quality and Metadata Governance

  • Implementing data profiling and validation rules
  • Aligning master data and reference data standards
  • Establishing lineage, data catalogs, and comprehensive documentation

Analytics Performance Optimization

  • Understanding cubing, aggregates, and materialized views
  • Leveraging partitioning, clustering, and indexing for faster analytics
  • Managing workloads, implementing caching, and tuning queries

Security and Data Governance

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

Modern Data Architectures

  • Utilizing cloud data warehouses for elasticity and scalability
  • Implementing streaming ingestion for near real-time analytics
  • Strategies for cost optimization and continuous monitoring

Capstone Project: Source to Star Schema

  • Translating a business process into a structured fact and dimension model
  • Developing a complete end-to-end ETL or ELT workflow
  • Creating dashboards and verifying metric accuracy

Course Summary and Recommended Next Steps

Requirements

  • Proficiency in relational databases and SQL
  • Practical experience with data analysis or reporting tasks
  • Foundational knowledge of cloud or on-premises data platforms

Target Audience

  • Data analysts aiming to advance into data warehousing roles
  • BI developers and ETL engineers
  • Data architects and technical team leaders

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories