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
Fundamentals of Data Warehousing
- The role, key components, and architecture of a data warehouse.
- Data marts, enterprise warehouses, and the lakehouse pattern.
- Core principles of OLTP versus OLAP and the separation of workloads.
Dimensional Modelling
- Facts, dimensions, and defining grain.
- Comparing star schemas against snowflake schemas.
- Handling Slowly Changing Dimensions (SCD) and their various types.
ETL and ELT Workflows
- Extraction strategies from OLTP systems and APIs.
- Transformations, data cleansing, and conformance.
- Load patterns, orchestration, and managing dependencies.
Data Quality and Metadata Management
- Data profiling and establishing validation rules.
- Aligning master and reference data.
- Lineage, data catalogues, and documentation standards.
Analytics and Performance Optimisation
- Concepts of cubing, aggregation, and materialised views.
- Partitioning, clustering, and indexing for enhanced analytics.
- Workload management, caching strategies, and query tuning.
Security and Governance
- Access control, role-based permissions, and row-level security.
- Compliance considerations and auditing practices.
- Backup, recovery, and reliability protocols.
Modern Architectures
- Cloud data warehouses and the benefits of elasticity.
- Streaming ingestion for near real-time analytics.
- Cost optimisation and performance monitoring.
Capstone Project: From Source to Star Schema
- Modelling a specific business process into facts and dimensions.
- Constructing a complete end-to-end ETL or ELT workflow.
- Publishing dashboards and validating key metrics.
Summary and Recommended Next Steps
Requirements
- A solid understanding of relational databases and SQL.
- Practical experience in data analysis or reporting.
- Familiarity with either cloud-based or on-premises data platforms.
Target Audience
- Data analysts moving into data warehousing roles.
- BI developers and ETL engineers.
- Data architects and team leaders.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customised Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from £8000 + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (3)
Showing different ways to optimise 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