Data Warehousing
0 weeks
·Live Course
Your Instructor
Sahil Goyal
Course Overview
This course provides a comprehensive introduction to Data Warehousing, Business Intelligence, ETL, Testing, and Project Management concepts essential for modern data-driven projects. It begins with the fundamentals of Data Warehousing, including architectures, data models, dimensions, and facts.
Learners will explore key Business Intelligence concepts like KPIs and metrics, followed by a deep dive into ETL processes, tools, and load types. The course also covers essential software development methodologies including SDLC and Agile, with practical insights into Scrum and design thinking.
A strong emphasis is placed on testing, including manual, automated, and ETL-specific testing techniques. Real-world case studies and hands-on exercises ensure practical understanding, preparing learners for roles in data engineering, QA, and analytics.
What you'll get out of this course
Learn Data Warehousing Basics: Understand key concepts like dimensions, facts, data models, schemas (Star, Snowflake), and the architecture of a data warehouse including staging and ODS layers.
Understand BI and ETL Fundamentals: Grasp the basics of Business Intelligence, KPIs, and metrics, along with ETL processes like extraction, transformation, and loading, including load types and snapshot tables.
Explore Project Management and SDLC: Learn about project management principles, SDLC models, Agile methodology, Scrum basics, and how design thinking and risk management are applied in projects.
Gain Testing Knowledge: Understand types of software testing, test lifecycle, defect management, and the difference between manual, automated, and ETL testing across different data layers.
Apply Concepts Through Case Studies: Reinforce learning with real-world case studies in dimensional modeling, ETL implementation, testing scenarios, and Agile project workflows.
Course content
Week 1
5 items
Your Instructor
Sahil Goyal
Frequently Asked Questions
- What are the prerequisites for this course?
- Will I get hands-on practice?
- Is this course suitable for beginners?
- What roles can I aim for after completing this course?
© Copyright 2025 — Gisul
