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
Core Foundations of Data Warehousing
- The objective, key elements, and structural design of a warehouse
- Data marts, enterprise-level repositories, and lakehouse architectures
- The distinction between OLTP and OLAP environments and workload isolation
Dimensional Modeling Strategies
- Understanding facts, dimensions, and data grain
- Comparative analysis of star schema versus snowflake schema
- Classifying and managing Slowly Changing Dimensions (SCD)
ETL and ELT Workflows
- Techniques for extracting data from OLTP sources and APIs
- Data transformation, cleansing, and conformance standards
- Loading patterns, orchestration logic, and managing dependencies
Data Quality and Metadata Oversight
- Profiling data and establishing validation rules
- Aligning master and reference data entities
- Tracking lineage, maintaining catalogs, and documenting assets
Analytics and System Performance
- Concepts of cubing, aggregation, and materialized views
- Optimization through partitioning, clustering, and indexing
- Managing workloads, implementing caching, and query optimization
Security Protocols and Governance
- Managing access control, defining roles, and enforcing row-level security
- Addressing compliance requirements and audit trails
- Strategies for backup, disaster recovery, and system reliability
Contemporary Architectures
- Utilizing cloud data warehouses and elastic scaling
- Ingesting streaming data for near real-time insights
- Monitoring operations and optimizing cost efficiency
Capstone Project: From Source to Star Schema
- Translating business processes into factual and dimensional structures
- Implementing a complete end-to-end ETL or ELT process
- Generating dashboards and verifying metric accuracy
Course Summary and Future Pathways
Requirements
- Proficiency with relational database systems and SQL queries
- Prior exposure to data analysis or reporting workflows
- Foundational knowledge of cloud-based or on-premises data infrastructure
Target Learners
- Data analysts expanding their skill set into warehouse architecture
- BI developers and ETL specialists
- Data architects and technical 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