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 overall architecture
- Data marts, enterprise warehouses, and lakehouse designs
- Core differences between OLTP and OLAP, plus workload isolation
Dimensional Modeling
- Facts, dimensions, and data grain
- Comparison of star and snowflake schemas
- Managing Slowly Changing Dimensions and their types
ETL and ELT Workflows
- Techniques for extracting data from OLTP sources and APIs
- Transformation logic, data cleaning, and consistency checks
- Loading strategies, orchestration, and handling dependencies
Data Quality and Metadata Governance
- Profiling data and establishing validation rules
- Aligning master and reference data
- Tracking lineage, maintaining catalogs, and documentation
Analytics and Performance Optimization
- Cube concepts, aggregations, and materialized views
- Using partitioning, clustering, and indexing for analytical speed
- Workload control, caching strategies, and query tuning
Security and Governance
- Managing access control, roles, and row-level security
- Addressing compliance requirements and audit trails
- Best practices for backup, recovery, and system reliability
Contemporary Architectures
- Cloud-based data warehouses and elastic scaling
- Streaming data ingestion and near real-time analytics
- Strategies for cost efficiency and performance monitoring
Capstone Project: From Source to Star Schema
- Modeling a business process into facts and dimensions
- Constructing a complete end-to-end ETL or ELT pipeline
- Creating dashboards and validating key metrics
Recap and Future Directions
Requirements
- A solid grasp of relational databases and SQL
- Background in data analysis or reporting
- Foundational knowledge of cloud or on-premises data platforms
Target Audience
- Data analysts moving into data warehousing roles
- BI developers and ETL engineers
- 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