Get in Touch
 Duration 35 hours

Course Outline

Core Foundations of Data Warehousing

  • The purpose, key components, and architectural elements of a warehouse.
  • Data marts, enterprise warehouses, and lakehouse patterns.
  • Fundamentals of OLTP vs OLAP and strategies for workload separation.

Dimensional Modeling

  • Understanding facts, dimensions, and data grain.
  • Comparing star schema and snowflake schema designs.
  • Managing Slowly Changing Dimensions (SCD) types.

ETL and ELT Workflows

  • Extraction strategies from OLTP sources and APIs.
  • Data transformation, cleansing, and conformance techniques.
  • Load patterns, orchestration, and managing dependencies.

Data Quality and Metadata Governance

  • Data profiling and establishing validation rules.
  • Aligning master and reference data.
  • Managing data lineage, catalogs, and documentation.

Analytics and Performance Optimization

  • Concepts of cubing, aggregation, and materialized views.
  • Techniques for partitioning, clustering, and indexing for analytics.
  • Workload management, caching, and query tuning.

Security and Governance

  • Implementing access control, roles, and row-level security.
  • Addressing compliance requirements and auditing practices.
  • Backup, recovery, and ensuring system reliability.

Modern Architectures

  • Cloud data warehouses and the benefits of elasticity.
  • Streaming ingestion and near real-time analytics.
  • Strategies for cost optimization and continuous 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 workflow.
  • Publishing dashboards and validating key metrics.

Recap and Future Directions

Requirements

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

Target Audience

  • Data analysts expanding their skillset into data warehousing.
  • BI developers and ETL engineers.
  • Data architects and team leaders.

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories