Get in Touch
 Duration 35 hours

Course Outline

Data Warehousing Fundamentals

  • Understanding the purpose, key components, and overall architecture of a warehouse.
  • Exploring data marts, enterprise warehouses, and lakehouse patterns.
  • The basics of OLTP versus OLAP and the importance of workload separation.

Dimensional Modeling

  • Concepts of facts, dimensions, and grain.
  • Comparing star schema and snowflake schema structures.
  • Managing Slowly Changing Dimensions and their various types.

ETL and ELT Workflows

  • Strategies for extracting data from OLTP systems and APIs.
  • Performing transformations, data cleansing, and ensuring conformance.
  • Load patterns, orchestration, and managing dependencies.

Data Quality and Metadata Stewardship

  • Data profiling techniques and validation rules.
  • Aligning master and reference data.
  • Managing lineage, maintaining catalogs, and documenting processes.

Analytics and Performance Optimization

  • Cubing concepts, aggregate management, and materialized views.
  • Techniques for partitioning, clustering, and indexing to boost analytics.
  • Workload management, caching strategies, and query tuning.

Security and Governance

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

Modern Architectures

  • Cloud data warehouses and the benefits of elasticity.
  • Streaming ingestion and enabling near real-time analytics.
  • Optimizing costs and continuous monitoring.

Capstone: From Source to Star Schema

  • Modeling a business process into defined facts and dimensions.
  • Constructing a complete end-to-end ETL or ELT workflow.
  • Publishing dashboards and validating key metrics.

Course Summary and Recommended Next Steps

Requirements

  • Solid understanding 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 looking to expand their skills into data warehousing.
  • BI developers and ETL engineers.
  • Data architects and technical team leads.

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories