Get in Touch
 Duration 35 hours

Course Outline

Data Warehousing Fundamentals

  • The role, constituent parts, and overall architecture of data warehouses
  • Patterns for data marts, enterprise-level warehouses, and lakehouses
  • Core distinctions between OLTP and OLAP, along with workload segregation strategies

Dimensional Modeling

  • Defining facts, dimensions, and data grain
  • Comparing star schemas against snowflake schemas
  • Managing Slowly Changing Dimensions (SCD) and their various types

ETL and ELT Workflows

  • Strategies for extracting data from OLTP systems and APIs
  • Applying transformations, cleansing data, and ensuring conformance
  • Establishing load patterns, orchestrating processes, and managing dependencies

Data Quality and Metadata Oversight

  • Implementing data profiling and validation rules
  • Aligning master and reference data
  • Tracking lineage, maintaining catalogs, and documenting data assets

Analytics and Performance Optimization

  • Concepts of cubing, aggregations, and materialized views
  • Using partitioning, clustering, and indexing to enhance analytics
  • Managing workloads, leveraging caching, and tuning queries

Security and Governance

  • Configuring access controls, roles, and row-level security
  • Addressing compliance requirements and auditing practices
  • Ensuring reliability through backup and recovery procedures

Contemporary Architectures

  • Utilizing cloud data warehouses and their elastic capabilities
  • Enabling streaming ingestion for near real-time analytics
  • Optimizing costs and monitoring system health

Capstone Project: From Source Data to Star Schema

  • Translating business processes into structured facts and dimensions
  • Developing a comprehensive end-to-end ETL or ELT workflow
  • Deploying dashboards and verifying metric accuracy

Course Summary and Recommended Next Steps

Requirements

  • Foundational knowledge of relational database systems and SQL
  • Prior experience in data analysis or reporting functions
  • Basic acquaintance with cloud-based or on-premises data infrastructure

Target Audience

  • Data analysts looking to expand into data warehousing roles
  • BI developers and ETL engineering specialists
  • Data architects and senior team leaders

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories