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
Essentials of Data Warehousing
- Objectives, key components, and structural design of warehouses
- Patterns for data marts, enterprise-wide warehouses, and lakehouses
- Core differences between OLTP and OLAP, and strategies for workload isolation
Dimensional Modeling Techniques
- Defining facts, dimensions, and data grain
- Comparing star and snowflake schema structures
- Managing Slowly Changing Dimensions (SCD) types
ETL and ELT Workflows
- Methods for extracting data from OLTP systems and APIs
- Applying transformations, data cleansing, and conformance rules
- Implementing load strategies, orchestration, and dependency tracking
Data Quality and Metadata Oversight
- Profiling data and establishing validation criteria
- Aligning master and reference data
- Tracking lineage, managing catalogs, and maintaining documentation
Analytics and Performance Optimization
- Understanding cubing, aggregations, and materialized views
- Utilizing partitioning, clustering, and indexing for analytical speed
- Managing workloads, leveraging caching, and tuning queries
Security and Governance Frameworks
- Implementing access controls, role definitions, and row-level security
- Addressing compliance requirements and audit trails
- Establishing backup, recovery, and high-availability protocols
Contemporary Architectural Trends
- Leveraging cloud data warehouses and elastic scaling
- Enabling streaming ingestion and near real-time analysis
- Strategies for cost efficiency and system monitoring
Capstone Project: Source to Star Schema
- Translating business processes into fact and dimension tables
- Constructing a complete ETL or ELT pipeline
- Deploying dashboards and ensuring metric accuracy
Conclusion and Path Forward
Requirements
- A solid grasp of relational database systems and SQL syntax
- Prior experience in data analysis or reporting workflows
- Foundational knowledge of cloud-based or on-premises data infrastructure
Target Audience
- Data analysts looking to specialize in data warehousing
- BI developers and ETL engineering specialists
- Data architects and technical 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