Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 35 hours
Course Outline
Core Principles of Data Warehousing
- Objectives, key components, and architectural structures
- Data marts, enterprise warehouses, and lakehouse patterns
- Fundamentals of OLTP vs OLAP and workload segregation
Dimensional Modeling Techniques
- Facts, dimensions, and defining grain
- Comparing star and snowflake schema designs
- Managing Slowly Changing Dimensions (SCD) types
ETL and ELT Methodologies
- Data extraction strategies from OLTP systems and APIs
- Transformation processes, data cleaning, and conformance
- Loading patterns, workflow orchestration, and dependency handling
Data Quality and Metadata Stewardship
- Data profiling techniques and validation rules
- Aligning master and reference data
- Data lineage, cataloging, and documentation practices
Analytical Performance Optimization
- Cubing concepts, aggregate management, and materialized views
- Partitioning, clustering, and indexing strategies for analytics
- Workload management, caching mechanisms, and query tuning
Security and Governance Frameworks
- Access controls, role definitions, and row-level security
- Compliance requirements and audit trails
- Backup procedures, recovery strategies, and reliability standards
Contemporary Architectures
- Cloud-based data warehouses and elastic scaling
- Streaming data ingestion and near real-time analytics
- Cost management and performance monitoring
Capstone Project: From Source to Star Schema
- Translating business processes into factual and dimensional models
- Constructing a complete end-to-end ETL or ELT workflow
- Deploying dashboards and validating key metrics
Recap and Future Directions
Requirements
- Solid understanding of relational databases and SQL
- Practical experience in data analysis or reporting
- Fundamental knowledge of cloud or on-premises data platforms
Target Audience
- Data analysts moving into data warehousing roles
- BI developers and ETL engineers
- Data architects and technical team leads
Testimonials (3)
Showing different ways to optimize our PySpark queries.
Ivan Abrashev - UBB + DZI (KBC GROUP)
Course - Efficient Data Processing on Kubernetes with PySpark, Pandas & Polars
A journey through the Spark world: a very intense course. DSL, spark sql, partitioning vs bucketing for me.
Georgiana Elisabeta
Course - Apache Spark Fundamentals
Hands on exercises. Class should have been 5 days, but the 3 days helped to clear up a lot of questions that I had from working with NiFi already