What you'll learn:
- Deploy and Configure SSIS packages.
- Design and implement a data warehouse
- Implement Data Flow in an SSIS Package
- Implement Control Flow in an SSIS Package
- Debug and Troubleshoot SSIS packages.
- Implement an ETL solution that supports incremental data extraction
- Implement data cleansing by using Microsoft Data Quality Services.
- Implement Master Data Services to enforce data integrity
- Extract and load modified data
- Consume data in a data warehouse
This beginner-friendly course guides you through building an enterprise data warehouse solution using Microsoft SQL Server, SQL Server Integration Services (SSIS), and SQL Server Data Tools (SSDT).
You’ll gain hands-on experience designing, implementing, and managing a data warehouse, with a focus on ETL processes, data modeling, and reporting. Step-by-step labs help you set up your environment, create SSIS packages, and transform raw data into valuable business insights.
What You’ll Learn
Set up SQL Server , SSDT, and Visual Studio
Attach and explore the AdventureWorksDW sample database
Understand data warehouse concepts, architecture, and hardware considerations
Design and implement fact and dimension tables
Choose between star and snowflake schema designs
Build ETL solutions with SSIS, including incremental extraction and loading
Create and debug SSIS packages (control flow, data flow, logging, error handling)
Cleanse data using Data Quality Services (DQS) and enforce integrity with Master Data Services (MDS)
Deploy, configure, and execute SSIS packages
Consume and analyse data with SSRS and SSAS
By the End of This Course
You’ll have the skills to design and implement a complete data warehouse solution, build robust ETL pipelines, and deliver business intelligence using Microsoft’s data platform.
What you’ll build
An operational data warehouse with SQL Server
ETL solutions supporting incremental loads
Reports and analytics with SSRS/SSAS
Who this course is for
Aspiring data warehouse or BI developers
SQL Server users who want to expand into ETL and data warehousing
Anyone interested in learning data warehousing with Microsoft tools
