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
- Objectives, key components, and architectural structures of the warehouse
- Data marts, enterprise warehouses, and lakehouse architectural patterns
- Core differences between OLTP and OLAP and the importance of workload separation
Dimensional Modeling Strategies
- Defining facts, dimensions, and data grain
- Comparative analysis of star schema and snowflake schema designs
- Classifying and managing Slowly Changing Dimensions (SCD)
ETL and ELT Workflows
- Extracting data effectively from OLTP systems and APIs
- Applying transformations, data cleansing, and conformance techniques
- Load patterns, orchestration, and managing task dependencies
Data Quality and Metadata Governance
- Implementing data profiling and validation rules
- Aligning master data and reference data standards
- Establishing lineage, data catalogs, and comprehensive documentation
Analytics Performance Optimization
- Understanding cubing, aggregates, and materialized views
- Leveraging partitioning, clustering, and indexing for faster analytics
- Managing workloads, implementing caching, and tuning queries
Security and Data Governance
- Configuring access controls, roles, and row-level security
- Addressing compliance requirements and audit trails
- Best practices for backup, disaster recovery, and system reliability
Modern Data Architectures
- Utilizing cloud data warehouses for elasticity and scalability
- Implementing streaming ingestion for near real-time analytics
- Strategies for cost optimization and continuous monitoring
Capstone Project: Source to Star Schema
- Translating a business process into a structured fact and dimension model
- Developing a complete end-to-end ETL or ELT workflow
- Creating dashboards and verifying metric accuracy
Course Summary and Recommended Next Steps
Requirements
- Proficiency in relational databases and SQL
- Practical experience with data analysis or reporting tasks
- Foundational knowledge of cloud or on-premises data platforms
Target Audience
- Data analysts aiming to advance into data warehousing roles
- BI developers and ETL engineers
- Data architects and technical team leaders
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