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.
Course Outline
Foundations of Data Warehousing
- Warehouse purpose, components, and architecture.
- Data marts, enterprise warehouses, and lakehouse patterns.
- Fundamentals of OLTP vs OLAP and workload separation.
Dimensional Modeling
- Facts, dimensions, and data grain.
- Star schema versus snowflake schema.
- Types and handling of Slowly Changing Dimensions.
ETL and ELT Processes
- Extraction strategies from OLTP systems and APIs.
- Transformations, data cleansing, and conformance.
- Load patterns, orchestration, and dependency management.
Data Quality and Metadata Management
- Data profiling and validation rules.
- Alignment of master and reference data.
- Lineage, catalogs, and documentation.
Analytics and Performance
- Cubing concepts, aggregates, and materialized views.
- Partitioning, clustering, and indexing for analytics.
- Workload management, caching, and query tuning.
Security and Governance
- Access control, roles, and row-level security.
- Compliance considerations and auditing.
- Backup, recovery, and reliability practices.
Modern Architectures
- Cloud data warehouses and elasticity.
- Streaming ingestion and near real-time analytics.
- Cost optimization and monitoring.
Capstone: From Source to Star Schema
- Modeling a business process into facts and dimensions.
- Building an end-to-end ETL or ELT workflow.
- Publishing dashboards and validating metrics.
Summary and Next Steps
Requirements
- Understanding of relational databases and SQL.
- Experience in data analysis or reporting.
- Basic familiarity with cloud or on-premises data platforms.
Audience
- Data analysts transitioning to data warehousing.
- BI developers and ETL engineers.
- Data architects and team leads.
35 Hours
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 (1)
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
