SQL Server Data Warehousing Fundamentals

The Microsoft SQL Server Data Warehousing Fundamentals course provides step-by-step instructions on how to perform a variety of Microsoft Data Warehousing implementation activities including E-T-L (Extract, Transform and Load) and Self-Service Reporting tasks using Microsoft SQL Server Integration and Reporting Services. 

In this course, you will learn the tools needed to create managed enterprise business intelligence (BI) solutions including data modeling, analysis services, and reporting services. You will then learn how to create and publish reports using reporting services, report execution and delivery.

You will learn how to plan, build and deploy a Data warehouse in an Microsoft Database 2014 to 2022 environment using Microsoft SSIS  as your primary ETL Tool for developing Extract, Transform and Load processes.

On successful Completion of this course you will be able to:

• Understand the Data Warehouse and ETL Development Lifecycle
• Understand the BI and Warehouse Development Process
• Understand Data Warehousing Concepts
• Understand Dimension Modelling
• Understand SQL Server Warehouse Capabilities
• Understand Data warehouse concepts and architecture considerations
• Design and implement a data warehouse
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the SQL Server Integration Service system
• Select an appropriate hardware platform for a data warehouse
• Implement data flow and control flow in a SSIS package
• Define Integration Processes
• Manage metadata in SQL Server Integration Service
• Enforce data quality constraints in a Package
• Debug and troubleshoot SSIS packages
• Implement a SSIS incremental data warehouse loads and extracting data
• Deploy and configure SSIS packages