CCNP Enterprise
-
COURSE DATES AND LOCATIONS
DATE
Duration
LOCATION
FEES
Book Now
-
INTRODUCTION
Business intelligence (BI) development is an increasingly important role across organizations of all sizes. A data warehouse is the central repository of information for data analysis, artificial intelligence, and machine learning.
-
COURSE OBJECTIVES
At the end of this course you will be able to:
- Describe how to consume data from the data warehouse.
- Create ETL Solution
- Design a data warehouse
- Load Data
- Deploy SSIS
- Enforce Data Quality
- Cleanse data
- Analysis data
- Troubleshoot and Debug SSIS package
- Sort out duplicates
- Extract Data
-
COURSE AUDIENCE
This course is made for database professionals who need to create and support a data warehousing solution. Primary responsibilities include:
•Implementing a data warehouse.
•Developing SSIS packages for data extraction, transformation, and loading.
•Enforcing data integrity by using Master Data Services.
•Cleansing data by using Data Quality Services.
-
COURSE OUTLINE
Day One
- Deploy and Configure SSIS packages.
- Download and installing SQL Server 2014.
- Download and attaching Adventureworks2014 database.
Day Two
- Download and installing Visual studio.
- Describe data warehouse concepts and architecture considerations.
- Design and implement a data warehouse.
- Implement Data Flow in an SSIS Package.
Day Three
- Implement Control Flow in an SSIS Package.
- Debug and Troubleshoot SSIS packages.
- Implement Master Data Services to enforce data integrity.
Day Four
- Extend SSIS with custom scripts and components.
- Databases vs. Data warehouses.
- Explore source data.
- Implement data flow.
Day Five
- Debug an SSIS package.
- Extract and load modified data.
- Consume data in a data warehouse.
Keyword
Training Subject
Training Location