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.
Course Outline
Foundations of Data Warehousing
- The purpose, components, and architecture of warehouses.
- Data marts, enterprise warehouses, and lakehouse patterns.
- Fundamental differences between OLTP and OLAP, and workload separation.
Dimensional Modelling
- Facts, dimensions, and defining grain.
- Comparing star schema versus snowflake schema approaches.
- Managing Slowly Changing Dimensions (SCD) types and handling.
ETL and ELT Processes
- Strategies for extracting data from OLTP systems and APIs.
- Transformation techniques, data cleansing, and conformance.
- Loading patterns, orchestration, and managing dependencies.
Data Quality and Metadata Management
- Data profiling and establishing validation rules.
- Aligning master and reference data.
- Lineage tracking, data catalogues, and documentation.
Analytics and Performance
- Concepts of cubing, aggregates, and materialised views.
- Partitioning, clustering, and indexing strategies for analytics.
- Workload management, caching mechanisms, and query tuning.
Security and Governance
- Access control, role definition, and row-level security.
- Compliance requirements and auditing practices.
- Backup, recovery, and reliability protocols.
Modern Architectures
- Cloud data warehouses and elastic scaling.
- Streaming ingestion and near real-time analytics capabilities.
- Cost optimisation strategies and monitoring.
Capstone: From Source to Star Schema
- Modelling a business process into facts and dimensions.
- Constructing an end-to-end ETL or ELT workflow.
- Publishing dashboards and validating key metrics.
Summary and Next Steps
Requirements
- A working understanding of relational databases and SQL.
- Practical experience in data analysis or reporting.
- Foundational knowledge of cloud-based or on-premises data platforms.
Intended Audience
- Data analysts looking to transition into data warehousing.
- BI developers and ETL engineers.
- Data architects and team leads.
35 Hours
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