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, key components, and structural architecture of warehouses
- Data marts, enterprise-level warehouses, and lakehouse architectural patterns
- Core differences between OLTP and OLAP, including workload segregation
Dimensional Modeling Strategies
- Comparing star schemas and snowflake schemas
- Types of Slowly Changing Dimensions and their management
ETL and ELT Workflows
- Data extraction techniques from OLTP systems and APIs
- Data transformation, cleansing, and conformance processes
- Loading patterns, pipeline orchestration, and managing dependencies
Data Quality and Metadata Oversight
- Data profiling techniques and validation rule implementation
- Aligning master data and reference data
- Managing data lineage, catalogs, and documentation
Analytics Optimization and Performance
- Concepts of cubing, aggregations, and materialized views
- Partitioning, clustering, and indexing strategies for analytical efficiency
- Workload management, caching mechanisms, and query tuning
Security Frameworks and Governance
- Implementing access control, roles, and row-level security
- Addressing compliance requirements and auditing practices
- Establishing backup, recovery, and reliability protocols
Contemporary Architectures
- Cloud-based data warehouses and elastic scaling capabilities
- Streaming data ingestion and near real-time analytics
- Strategies for cost optimization and system monitoring
Capstone Project: From Source to Star Schema
- Translating business processes into facts and dimensions
- Constructing a comprehensive end-to-end ETL or ELT workflow
- Deploying dashboards and validating key metrics
Conclusion and Future Directions
Requirements
- Solid grasp of relational databases and SQL proficiency
- Practical experience in data analysis or reporting
- Foundational knowledge of cloud-based or on-premises data platforms
Target Audience
- Data analysts expanding their skills 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