Get in Touch
 Duration 35 hours

Course Outline

Data Warehousing Fundamentals

  • The role, key components, and structural architecture of warehouses
  • Data marts, enterprise-level warehouses, and lakehouse architectural patterns
  • Core differences between OLTP and OLAP, including workload segregation

Dimensional Modeling Strategies

  • Comparing star schemas and snowflake schemas
  • Types of Slowly Changing Dimensions and their management

ETL and ELT Workflows

  • Data extraction techniques from OLTP systems and APIs
  • Data transformation, cleansing, and conformance processes
  • Loading patterns, pipeline orchestration, and managing dependencies

Data Quality and Metadata Oversight

  • Data profiling techniques and validation rule implementation
  • Aligning master data and reference data
  • Managing data lineage, catalogs, and documentation

Analytics Optimization and Performance

  • Concepts of cubing, aggregations, and materialized views
  • Partitioning, clustering, and indexing strategies for analytical efficiency
  • Workload management, caching mechanisms, and query tuning

Security Frameworks and Governance

  • Implementing access control, roles, and row-level security
  • Addressing compliance requirements and auditing practices
  • Establishing backup, recovery, and reliability protocols

Contemporary Architectures

  • Cloud-based data warehouses and elastic scaling capabilities
  • Streaming data ingestion and near real-time analytics
  • Strategies for cost optimization and system monitoring

Capstone Project: From Source to Star Schema

  • Translating business processes into facts and dimensions
  • Constructing a comprehensive end-to-end ETL or ELT workflow
  • Deploying dashboards and validating key metrics

Conclusion and Future Directions

Requirements

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

Target Audience

  • Data analysts expanding their skills 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