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 Foundations
- Purpose, key components, and architectural overview of the warehouse
- Data marts, enterprise warehouses, and lakehouse patterns
- Core differences between OLTP and OLAP, including workload separation
Dimensional Modeling
- Comparing star schemas and snowflake schemas
- Managing various types of Slowly Changing Dimensions
ETL and ELT Workflows
- Extraction methods from OLTP sources and APIs
- Data transformation, cleansing, and conformance strategies
- Loading patterns, orchestration, and managing dependencies
Data Quality and Metadata Governance
- Profiling data and establishing validation rules
- Aligning master and reference data
- Managing lineage, catalogs, and documentation
Analytics and Performance Optimization
- Understanding cubing, aggregates, and materialized views
- Applying partitioning, clustering, and indexing for analytics
- Workload management, caching strategies, and query tuning
Security and Governance
- Implementing access controls, roles, and row-level security
- Addressing compliance requirements and auditing
- Best practices for backup, recovery, and reliability
Modern Architectures
- Cloud-based data warehouses and elastic scaling
- Streaming ingestion for near real-time analytics
- Cost optimization and continuous monitoring
Capstone Project: From Source to Star Schema
- Translating business processes into facts and dimensions
- Constructing an end-to-end ETL or ELT workflow
- Creating dashboards and validating key metrics
Summary and Recommended Next Steps
Requirements
- A solid grasp 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 looking to transition into data warehousing roles
- BI developers and ETL engineers
- Data architects and 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