Implementing SQL Data Warehouse
-
COURSE DATES AND LOCATIONS
DATE
Duration
LOCATION
FEES
Book Now
-
INTRODUCTION
This course describes how to implement a data warehouse solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
-
COURSE OBJECTIVES
By the end of the course, you‘ll be able to:
- Describe how to consume data from the data warehouse.
- Enforce Data Quality
- Cleanse data
- Analysis data
- Generate reports
- Create ETL Solution
- Design a data warehouse
- Troubleshoot and Debug SSIS package
- Sort out duplicates
- Extract Data
- Load Data
- Deploy SSIS
-
COURSE AUDIENCE
This course is made for
- Database professionals who need to fulfill a BI developer role focused on hands-on work by creating BI solutions, including data warehouse implementation, ETL and data cleansing
-
COURSE OUTLINE
Day One
- Describe the key elements of a data warehouse solution
- Considerations for building a data warehouse
- Implementing a logical design for a data warehouse
- Implement a physical design for a data warehouse
Day Two
- Implementing an Azure SQL Data Warehouse
- Describe the key features of SSIS
- Implement a data flow by using SSIS
- Create dynamic packages that include variables and parameters
- Debug SSIS packages
- Describe the considerations of implement an ETL Solution
- Implement Data Quality Services
Day Three
- Implement a Master Data Service model
- Describe how you can use custom components to extend SSIS
- Deploy SSI projects
- Describe BI and common BI scenarios
Keyword
Training Subject
Training Location