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 Principles of Data Warehousing
- Purpose, essential components, and architectural overview
- Data marts, enterprise warehouses, and lakehouse designs
- Distinguishing OLTP from OLAP and isolating workloads
Dimensional Modeling Strategies
- Understanding facts, dimensions, and data grain
- Comparing star and snowflake schema structures
- Managing Slowly Changing Dimensions (SCD) and their types
ETL and ELT Workflow Management
- Data extraction techniques from OLTP systems and APIs
- Data transformation, cleansing, and conformance standards
- Loading patterns, workflow orchestration, and dependency control
Data Quality and Metadata Governance
- Data profiling techniques and validation rule creation
- Aligning master and reference data across systems
- Tracking lineage, maintaining catalogs, and documenting data assets
Analytical Performance and Optimization
- OLAP concepts, aggregate creation, and materialized views
- Optimizing through partitioning, clustering, and indexing
- Managing workloads, caching strategies, and query performance tuning
Security Frameworks and Governance
- Implementing access controls, role management, and row-level security
- Addressing compliance requirements and audit trails
- Ensuring backup, recovery, and system reliability
Cutting-Edge Architectural Patterns
- Leveraging cloud data warehouses and elastic scaling
- Streaming data ingestion for near real-time analytics
- Strategies for cost efficiency and continuous monitoring
Capstone Project: Source to Star Schema
- Translating business processes into factual and dimensional models
- Constructing a comprehensive end-to-end ETL or ELT workflow
- Deploying dashboards and verifying metric accuracy
Course Summary and Recommended Next Steps
Requirements
- Solid grasp of relational databases and SQL
- Practical experience in data analysis or reporting
- Foundational knowledge of cloud-based or on-premises data platforms
Target Audience
- Data analysts seeking 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