Get in Touch
 Duration 35 hours

Course Outline

Data Warehousing Fundamentals

  • Purpose, key components, and structural architecture of warehouses
  • Data marts, enterprise warehouses, and lakehouse designs
  • Core differences between OLTP and OLAP and strategies for workload separation

Dimensional Modeling Techniques

  • Understanding facts, dimensions, and data grain
  • Comparative analysis of star schema and snowflake schema
  • Managing Slowly Changing Dimensions (SCD) types and implementation

ETL and ELT Workflows

  • Extraction techniques from OLTP systems and APIs
  • Data transformation, cleansing, and conformance strategies
  • Loading patterns, orchestration methods, and handling dependencies

Data Quality and Metadata Governance

  • Applying data profiling and establishing validation rules
  • Aligning master data and reference data
  • Tracking lineage, maintaining catalogs, and documenting processes

Analytics and Performance Optimization

  • Concepts of cubing, aggregation, and materialized views
  • Implementing partitioning, clustering, and indexing for analytical speed
  • Managing workloads, leveraging caching, and tuning queries

Security and Governance Frameworks

  • Enforcing access controls, defining roles, and row-level security
  • Addressing compliance requirements and audit trails
  • Establishing backup, recovery, and high-availability practices

Modern Data Architectures

  • Utilizing cloud data warehouses and elastic scaling
  • Implementing streaming ingestion for near real-time insights
  • Strategies for cost efficiency and continuous monitoring

Capstone Project: Source to Star Schema

  • Translating business processes into fact and dimension tables
  • Constructing a complete end-to-end ETL or ELT workflow
  • Deploying dashboards and verifying metric accuracy

Course Summary and Career Progression

Requirements

  • Solid grasp of relational databases and SQL
  • Practical experience in data analysis or reporting
  • Foundational knowledge of cloud-based or on-premises data infrastructure

Target Audience

  • Data analysts aiming to transition into data warehousing roles
  • BI developers and ETL engineering specialists
  • Data architects and technical team leads

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories