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
- Understanding the purpose, key components, and overall architecture of a warehouse.
- Exploring data marts, enterprise warehouses, and lakehouse patterns.
- The basics of OLTP versus OLAP and the importance of workload separation.
Dimensional Modeling
- Concepts of facts, dimensions, and grain.
- Comparing star schema and snowflake schema structures.
- Managing Slowly Changing Dimensions and their various types.
ETL and ELT Workflows
- Strategies for extracting data from OLTP systems and APIs.
- Performing transformations, data cleansing, and ensuring conformance.
- Load patterns, orchestration, and managing dependencies.
Data Quality and Metadata Stewardship
- Data profiling techniques and validation rules.
- Aligning master and reference data.
- Managing lineage, maintaining catalogs, and documenting processes.
Analytics and Performance Optimization
- Cubing concepts, aggregate management, and materialized views.
- Techniques for partitioning, clustering, and indexing to boost analytics.
- Workload management, caching strategies, and query tuning.
Security and Governance
- Implementing access controls, roles, and row-level security.
- Addressing compliance requirements and auditing processes.
- Best practices for backup, recovery, and reliability.
Modern Architectures
- Cloud data warehouses and the benefits of elasticity.
- Streaming ingestion and enabling near real-time analytics.
- Optimizing costs and continuous monitoring.
Capstone: From Source to Star Schema
- Modeling a business process into defined facts and dimensions.
- Constructing a complete end-to-end ETL or ELT workflow.
- Publishing dashboards and validating key metrics.
Course Summary and Recommended Next Steps
Requirements
- Solid understanding of relational databases and SQL.
- Practical experience in data analysis or reporting.
- Foundational knowledge of cloud-based or on-premises data platforms.
Target Audience
- Data analysts looking to expand their skills into data warehousing.
- 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