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
- The role, constituent parts, and overall architecture of data warehouses
- Patterns for data marts, enterprise-level warehouses, and lakehouses
- Core distinctions between OLTP and OLAP, along with workload segregation strategies
Dimensional Modeling
- Defining facts, dimensions, and data grain
- Comparing star schemas against snowflake schemas
- Managing Slowly Changing Dimensions (SCD) and their various types
ETL and ELT Workflows
- Strategies for extracting data from OLTP systems and APIs
- Applying transformations, cleansing data, and ensuring conformance
- Establishing load patterns, orchestrating processes, and managing dependencies
Data Quality and Metadata Oversight
- Implementing data profiling and validation rules
- Aligning master and reference data
- Tracking lineage, maintaining catalogs, and documenting data assets
Analytics and Performance Optimization
- Concepts of cubing, aggregations, and materialized views
- Using partitioning, clustering, and indexing to enhance analytics
- Managing workloads, leveraging caching, and tuning queries
Security and Governance
- Configuring access controls, roles, and row-level security
- Addressing compliance requirements and auditing practices
- Ensuring reliability through backup and recovery procedures
Contemporary Architectures
- Utilizing cloud data warehouses and their elastic capabilities
- Enabling streaming ingestion for near real-time analytics
- Optimizing costs and monitoring system health
Capstone Project: From Source Data to Star Schema
- Translating business processes into structured facts and dimensions
- Developing a comprehensive end-to-end ETL or ELT workflow
- Deploying dashboards and verifying metric accuracy
Course Summary and Recommended Next Steps
Requirements
- Foundational knowledge of relational database systems and SQL
- Prior experience in data analysis or reporting functions
- Basic acquaintance with cloud-based or on-premises data infrastructure
Target Audience
- Data analysts looking to expand into data warehousing roles
- BI developers and ETL engineering specialists
- Data architects and senior 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