Data Warehousing Fundamentals
Program Information
- 🎓 Delivery Method:
- On-site (available now, on demand)
- Remote (live, on demand)
- Online (self-paced, coming soon)
Duration:- 1 day, 4 hours per day
- Custom options available for internal teams
- 🧩 Format:
- Interactive workshops
- Hands-on exercises
- 👨🎓 Maximum Participants:
- 12 per session (to ensure personalized interaction)
- 📋 Course Requirements:
- No prior technical background required.
- 📅 Scheduling:
- Flexible scheduling available on demand
- 📞 Contact to Schedule:
- 📧 training@vizacta.com
Course Description
Data Warehousing Fundamentals is a practical, beginner-friendly course designed to introduce you to the core principles, architecture, and implementation strategies of data warehousing. Whether you’re aspiring to become a data engineer, business intelligence analyst, or data architect, this course will give you the essential knowledge to build and manage efficient data warehouse solutions. You’ll learn the difference between OLTP and OLAP systems, explore dimensional modeling, and dive into ETL processes, all grounded in real-world practices and tools.
Course Curriculum
- What is a Data Warehouse?
- OLTP vs OLAP
- Benefits of data warehousing
- Inmon vs Kimball: methodologies, philosophies, comparisons
- DW layers: staging, integration, presentation
- Metadata and audit layers
- Architecture types: 2-tier, 3-tier, cloud-native
- Dimensional modeling: star vs snowflake schemas
- Fact vs dimension tables
- Slowly Changing Dimensions (SCD Types 1, 2, 3)
- Grain and additivity of facts
- ETL phases: Extract, Transform, Load
- Data cleansing and validation
- Workflow orchestration principles
- Tools overview: SSIS, Talend, ADF, dbt
- Requirement gathering and scoping
- Logical vs physical DW design
- Agile vs Waterfall implementation
- Error handling and audit logging
- Standard naming conventions for DW objects
- Schema organization strategies (staging, warehouse, mart)
- Surrogate keys and timestamp handling
- Documentation, versioning, metadata management