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 Essentials
- Purpose, key components, and structural design of warehouses
- Data marts, enterprise-level repositories, and lakehouse approaches
- Core differences between OLTP and OLAP and workload isolation
Dimensional Modeling Techniques
- Understanding facts, dimensions, and data grain
- Comparing star and snowflake schema structures
- Managing Slowly Changing Dimensions and their variations
ETL and ELT Workflows
- Data extraction methods from OLTP sources and APIs
- Transformation logic, data cleansing, and conformance standards
- Loading strategies, orchestration, and handling dependencies
Data Quality and Metadata Oversight
- Profiling data and establishing validation rules
- Aligning master and reference data
- Tracking lineage, maintaining catalogs, and documenting assets
Analytics and System Performance
- Cube concepts, aggregate creation, and materialized views
- Optimizing through partitioning, clustering, and indexing
- Managing workloads, caching strategies, and query refinement
Security and Governance Frameworks
- Implementing access controls, roles, and row-level security
- Addressing compliance needs and audit trails
- Ensuring backup, recovery, and high availability
Contemporary Architectures
- Cloud-based data warehouses and elastic scaling
- Ingesting streaming data for near real-time insights
- Strategies for cost efficiency and performance monitoring
Capstone Project: Source to Star Schema
- Modeling business processes into factual and dimensional tables
- Constructing a complete ETL or ELT pipeline
- Deploying dashboards and verifying metric accuracy
Recap and Future Directions
Requirements
- Solid grasp of relational databases and SQL
- Practical experience in data analysis or reporting
- Familiarity with cloud-based or on-premises data infrastructures
Target Learners
- Data analysts moving into warehousing roles
- BI developers and ETL specialists
- Data architects and technical team leads
Testimonials (3)
Data governance
Ignacio Jimenez - Contraloria General de la Republica
Course - Data Warehousing: Concepts, Design, and Implementation
Machine Translated
information security
Patricia Quezada - Contraloria General de la Republica
Course - Data Warehousing: Concepts, Design, and Implementation
Machine Translated
The learning was more conceptual: better understanding what Data Warehousing entails, the processes involved, the differences between OLTP and OLAP databases, between local, cloud, and hybrid storage, as well as mentioning some open-source tools for application.
Edgar Luis Vasquez Arauz - Contraloria General de la Republica
Course - Data Warehousing: Concepts, Design, and Implementation
Machine Translated