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 Data Warehousing Principles
- Warehouse objectives, key components, and structural design
- Data marts, enterprise warehouses, and lakehouse patterns
- OLTP and OLAP basics, including workload segregation
Dimensional Modeling
- Defining facts, dimensions, and data grain
- Comparing star and snowflake schemas
- Types of Slowly Changing Dimensions (SCD) and management strategies
ETL and ELT Workflows
- Extraction techniques from OLTP sources and APIs
- Data transformation, cleansing, and conformance
- Load patterns, orchestration, and dependency handling
Data Quality and Metadata Oversight
- Data profiling and validation rules
- Alignment of master and reference data
- Lineage tracking, data catalogs, and documentation
Analytics and Performance Optimization
- Cubing concepts, aggregations, and materialized views
- Partitioning, clustering, and indexing strategies for analytics
- Workload management, caching mechanisms, and query tuning
Security and Governance
- Access control, role-based permissions, and row-level security
- Compliance requirements and audit trails
- Backup, disaster recovery, and reliability protocols
Contemporary Architectures
- Cloud data warehouses and elastic scaling
- Streaming ingestion and near real-time analytics
- Cost efficiency and performance monitoring
Capstone: Source to Star Schema
- Modeling a business process into facts and dimensions
- Developing a complete ETL or ELT pipeline
- Deploying dashboards and verifying metrics
Recap and Future Steps
Requirements
- Knowledge of relational databases and SQL
- Prior experience in data analysis or reporting
- Foundational understanding of cloud or on-premises data platforms
Target Audience
- Data analysts moving 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