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
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
Testimonials (3)
Managing priorities, time management and productivity performance
Va Ros - Swiss Cooperation Office and Consular Agency in Laos
Course - Advanced Productivity Enhancement for Programme Professionals
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