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 purpose, key components, and architectural elements of a warehouse.
- Data marts, enterprise warehouses, and lakehouse patterns.
- Fundamentals of OLTP vs OLAP and strategies for workload separation.
Dimensional Modeling
- Understanding facts, dimensions, and data grain.
- Comparing star schema and snowflake schema designs.
- Managing Slowly Changing Dimensions (SCD) types.
ETL and ELT Workflows
- Extraction strategies from OLTP sources and APIs.
- Data transformation, cleansing, and conformance techniques.
- Load patterns, orchestration, and managing dependencies.
Data Quality and Metadata Governance
- Data profiling and establishing validation rules.
- Aligning master and reference data.
- Managing data lineage, catalogs, and documentation.
Analytics and Performance Optimization
- Concepts of cubing, aggregation, and materialized views.
- Techniques for partitioning, clustering, and indexing for analytics.
- Workload management, caching, and query tuning.
Security and Governance
- Implementing access control, roles, and row-level security.
- Addressing compliance requirements and auditing practices.
- Backup, recovery, and ensuring system reliability.
Modern Architectures
- Cloud data warehouses and the benefits of elasticity.
- Streaming ingestion and near real-time analytics.
- Strategies for cost optimization and continuous 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 workflow.
- Publishing dashboards and validating key metrics.
Recap and Future Directions
Requirements
- A 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 expanding their skillset into data warehousing.
- 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