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
- Objectives, key components, and architectural structures of the warehouse
- Data marts, enterprise warehouses, and lakehouse patterns
- Core principles of OLTP versus OLAP and workload segregation
Dimensional Modelling
- Defining facts, dimensions, and data grain
- Comparative analysis of star and snowflake schemas
- Classifications and management of Slowly Changing Dimensions
ETL and ELT Processes
- Extraction methodologies from OLTP sources and APIs
- Data transformation, cleansing, and conformance strategies
- Loading patterns, orchestration, and dependency control
Data Quality and Metadata Management
- Data profiling techniques and validation rule implementation
- Alignment of master and reference data
- Data lineage, catalogue management, and documentation standards
Analytics and Performance
- Concepts of cubing, aggregates, and materialized views
- Application of partitioning, clustering, and indexing for analytics
- Workload management, caching strategies, and query tuning
Security and Governance
- Access control mechanisms, role management, and row-level security
- Compliance requirements and auditing procedures
- Best practices for backup, recovery, and reliability
Modern Architectures
- Cloud data warehouses and the benefits of elasticity
- Streaming ingestion techniques for near real-time analytics
- Cost optimisation strategies and monitoring frameworks
Capstone: From Source to Star Schema
- Translating business processes into facts and dimensions
- Developing a comprehensive end-to-end ETL or ELT workflow
- Deploying dashboards and verifying metric accuracy
Recap and Future Steps
Requirements
- Solid comprehension of relational databases and SQL
- Practical experience in data analysis or reporting
- Foundational knowledge of cloud or on-premises data platforms
Target Audience
- Data analysts advancing into data warehousing roles
- BI developers and ETL engineers
- Data architects and team leads
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized 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 6500 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
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
