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 architectural overview of warehouses
- Data marts, enterprise warehouses, and lakehouse methodologies
- Core differences between OLTP and OLAP, and separating workloads
Dimensional Modeling
- Understanding facts, dimensions, and grain
- Comparison of star schema versus snowflake schema
- Managing various types of Slowly Changing Dimensions
ETL and ELT Workflows
- Strategies for extracting data from OLTP systems and APIs
- Data transformation, cleansing, and conformance
- Loading patterns, orchestration, and handling dependencies
Data Quality and Metadata Governance
- Data profiling techniques and validation rules
- Aligning master and reference data
- Tracking lineage, maintaining catalogs, and documentation
Analytics and Performance Optimisation
- Concepts of cubing, aggregation, and materialized views
- Using partitioning, clustering, and indexing for analytical gains
- Workload management, caching strategies, and query tuning
Security and Governance
- Implementing access control, roles, and row-level security
- Addressing compliance needs and auditing processes
- Practices for backup, recovery, and system reliability
Modern Architectures
- Cloud-based data warehouses and their elastic capabilities
- Streaming ingestion for near real-time analytics
- Cost optimisation strategies and continuous monitoring
Capstone Project: From Source to Star Schema
- Modeling a business process into facts and dimensions
- Creating an end-to-end ETL or ELT workflow
- Deploying dashboards and validating key metrics
Summary and Path Forward
Requirements
- Solid grasp of relational databases and SQL
- Prior experience in data analysis or reporting
- Basic knowledge of 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.
- 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 7250 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (3)
Data governance
Ignacio Jimenez - Contraloria General de la Republica
Course - Data Warehousing: Concepts, Design, and Implementation
Machine Translated
information security
Patricia Quezada - Contraloria General de la Republica
Course - Data Warehousing: Concepts, Design, and Implementation
Machine Translated
The learning was more conceptual: better understanding what Data Warehousing entails, the processes involved, the differences between OLTP and OLAP databases, between local, cloud, and hybrid storage, as well as mentioning some open-source tools for application.
Edgar Luis Vasquez Arauz - Contraloria General de la Republica
Course - Data Warehousing: Concepts, Design, and Implementation
Machine Translated