Introduction: Implementing a Data Warehouse with MS SQL Server 2014 Training Course
The course aims to deal with how to build a data warehouse platform to support a Business Intelligence solution. Key outcomes include creating a data warehouse with Microsoft SQL Server 2014, ETL implementation (using SQL Server Integration Services), and data cleansing and validation with SQL Server Master Data Services and SQL Server Data Quality Services and.
Outline: Implementing a Data Warehouse with MS SQL Server 2014 Training Course
Johannesburg (Sandton), Cape Town, Durban, Port Elizabeth, Pretoria – South Africa
Key outcomes of the course include:
Module 1: Introduction to Data Warehousing
After completing this course, delegates will have an understanding of:
Knowledge of architecture and the concept of data warehousing.
For the data warehouse, knowledge to choose a hardware platform.
Implementing and designing the data warehouse, Data Flow/ Control flow in an SSIS Package.
Troubleshoot SSIS packages.
ETL solution implementation that supports incremental data extraction / loading.
Implementing Microsoft Data Quality Services to cleanse data.
Configuring and deploying SSIS packages.
Master Data Services implementing to enforce data integrity.
Custom scripts and components.
Understanding of how BI solutions utilize data from the data warehouse.
Course duration and fees: Implementing a Data Warehouse with MS SQL Server 2014 Training Course
Our two day training course is designed so that the knowledge acquired is applied practically, so that the business environment can be enhanced.
Please consult schedule for course costs or contact BOTI for a quote.
Recommended Prior Experience and Knowledge: Implementing a Data Warehouse with MS SQL Server 2014 Training Course
The course (Implementing a Data Warehouse with MS SQL Server 2014 Training Course) is designed for the following attendees:
This course is intended 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.
For the Implementing a Data Warehouse with MS SQL Server 2014 Training Course it is advisable that you have the following experience/knowledge:
Minimum two years’ experience of dealing with relational databases, including:
Relationships and creating tables and.
Normalized database design.
Basic programming constructs exposure (such as branching and looping).
Key business priorities such as profitability and financial accounting is advantageous
View Calendar for the latest course