Course Introduction

Implementing a Data Warehouse with Microsoft SQL Server (M20463) course describes ways to implement a data warehouse platform for supporting BI solution to delegates. During this 5 day course, participants will learn creating a data warehouse, implement ETL using Microsoft SQL Server 2014. Additionally, validating and cleansing data with Microsoft SQL Server data quality services and SQL Server master data services will be included in the course.

Implementing a Data Warehouse with Microsoft SQL Server

This  training class describes how to implement a data warehouse platform to support a BI solution. Delegates will know how to develop 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.This training  is meant for database delegates who need to create and support a data warehousing solution.

Course Content

Data warehousing overview

  • An introduction- Data warehousing
  • Data warehousing solution consideration
  • Explore data sources and ETL process
  • Explore data warehouse

Planning Data Warehouse Infrastructure

  • Data Warehouse infrastructure considerations
  • Hardware planning

Designing and Implementing a Data Warehouse

  • Design Overview of Data warehouse
  • Dimension tables designing
  • Design fact tables
  • Data warehouse physical design
  • Implement star schema and snowflake schema
  • Implement time dimension

Creating an ETL Solution with SSIS

  • ETL with SSIS Introduction
  • Data Sources exploration
  • Implement data flow
  • Data sources exploration
  • Transfer data by making use of Data Flow Task
  • Use Transformations in a Data Flow

Implementing Control Flow in an SSIS Package

  • Control Flow introduction
  • Dynamic Packages creation
  • Use containers
  • Consistency Management
  • Use Tasks and Precedence in Control Flow
  • Use Variables, Parameters and Containers
  • Use transactions and checkpoints

Debugging and Troubleshooting SSIS Packages

  • Debugging SSIS Package
  • Logging SSIS Package Events
  • Handle Errors in an SSIS Package
  • SSIS Package debugging
  • Logging SSIS Package Execution
  • Event Handler implementation
  • Handle errors in a Data Flow

Implementing a Data Extraction Solution

  • Data extraction planning
  • Modified data extraction
  • Using data time column and change date capture
  • Using CDC control task and change tracking

Loading Data into a Data Warehouse

  • Data tools planning
  • Using SSIS for incremental loads
  • Using Transact-SQL loading techniques
  • Data loading from CDC output tables
  • Using Lookup Transformation for Inserting or Updating Dimension Data
  • Implement a Slowly Changing Dimension
  • Using MERGE Statement

Enforcing Data Quality

  • Data Quality introduction
  • Use data quality services to cleanse Data
  • Create a DQS knowledge base
  • Making use of DQS Project to Cleanse Data
  • Using DQS in an SSIS Package

Master Data Services

  • Master Data Service’s introduction
  • Master Data Services Model implementation
  • Managing Master Data
  • Creating a Master Data Hub
  • Master Data Services Model creation
  • Using Master Data Services Add-in for Excel
  • Business Rules enforcing
  • Loading Data into a Model
  • Consuming Master Data Services Data

Extending SQL Server Integration Services

  • Using scripts in SSIS
  • Using Custom Components in SSIS

Deploying and Configuring SSIS Packages

  • SSIS Deployment Overview
  • SSIS projects deployment
  • SSIS catalogue creation
  • Running SSIS package in SQL Server Management Studio
  • Schedule SSIS Packages with SQL Server Agent

Consuming Data in a Data Warehouse

  • Business Intelligence Introduction
  • Exploring an Enterprise BI Solution
  • Exploring a Self-Service BI Solution

Note: Lab is provided for this course for participant’s hands on practice.

Prerequisites

Delegates prior taking the course must carry at least two years of experience working with relational databases which comprises:

  • Designing normalised database.
  • Create tables and its relationships.
  • Query using transacts SQL.
  • Some exposure of basic programming constructs (Such as looping, branching, etc.)
  • Knowledge of the main business points such as revenue, profitability and financial accounting can be beneficial.

Target Audience

Implementing a Data Warehouse with Microsoft SQL Server (M20463) is designed for database professionals who need to create as well as support data warehousing solutions.

Primary focus will be on learning the following responsibilities:

  • Implement data warehouse.
  • Using data quality service to cleanse data.
  • Using Master data services enforcing data integrity.
  • Develop SSIS package for extracting data, transformation and loading data.

Delegates Will Learn How To

Paticipants will be learning the following:

  • Ability to Describe data warehouse concepts and architecture.
  • Learning to select suitable hardware platform for the data warehouse.
  • Designing as well as implement data warehouse.
  • Implementing data flow and control flow in SSIS packages.
  • Debug as well as troubleshoot SSIS packages.
  • Implementing ETL solution which supports incremental data extraction and data loading.
  • Implementing master data services for promoting and implementing integrity.
  • Extending SSIS using custom scripts and components.
  • Configuring and Deploying SSIS packages.
  • Explaining how BI solutions can make use of data from the data warehouse.

Training Solutions at Your Convenience

Our objective has always been to address and resolve the problems of our learners in an efficient manner and improve their learning prospects. We are accustomed in providing training courses as per our learner’s convenience. We love every opportunity to use our experience to resolve difficulties confronted by learners.

Implementing a Data Warehouse with Microsoft SQL Server Training Calender

Filters

arrow

Implementing a Data Warehouse with Microsoft SQL Server

Contact Us for Date and Price

Enquire Nowup-arrow

---- OR ----

Reach Us at +44 161 884 3134 or info@bestpracticetraining.com for more information.

Implementing a Data Warehouse with Microsoft SQL Server

Contact us for Date and Price

Enquire up-arrow

---- OR ----

Reach Us at +44 161 884 3134 or info@bestpracticetraining.com for more information.

Implementing a Data Warehouse with Microsoft SQL Server

hours

40 Hours (on average)

days

90 Days Access

administration

40 Hours (on average)

  • Course Price

    £2745

  • add-ons Price

    £0

  • Sub-Total

    £2745

foundation-call Enquire Now

Upon purchase you will receive a password via the email you used to purchase the course.

You will then be able to login to our online learning platform with your email and password.

You will have access to the platform for 90 days from the date of purchase.

ONSITE ENQUIRY?

Fill up the form below and we will get back to you!

name name-red
email email-red
phone-call phonecall-red
house house-red
book book-red
position position-red
house house-red
comment comment-red
conference

Video Conferencing

We provide the best web conferencing platform(s) to facilitate our learners to enhance their communication with the instructor.

whiteboard

Digital Whiteboards

Our courses include the real-time demonstration of figures, diagrams and other interactive material through digital whiteboards.

messaging

Instant Messaging

During the Virtual Classroom session, learners can raise their queries through instant messaging and follow up on their doubts.

control

Participation Controls

Through participating effectively in training, individuals can easily discuss their views, mute their surroundings and virtually "raise" their hands.

Features of Our Virtual Classroom Courses

future

How to Choose and Attend Your Ideal Course?

FIND COURSES

We provide 400+ courses covering broader aspects of personal and professional development training needed by any individual. You can choose any course as per your need or requirement. Our courses are designed to fulfil the current organisational and job marketplace requirements.

search}

Select the Course

Choose the course you want to attend to fulfil your desired goals.

details}

Attend the Course

Attend the training with your prefered method at your convenience.

book}

Get Certification

Upon finishing the course, you will get the completion certificate validating your learning.

Implementing a Data Warehouse with Microsoft SQL Server

£ 2745 £ 2695

Benefits of Attending Our Online Courses

We provide a variety of certification programmes or courses for individuals to master a skill set and pursue a full-time career in management, IT, or other domains through the online method to provide them with the convenience of learning. Our dedicated staff works tirelessly to assure the availability of courses with eminence quality that's not found anywhere with benefits like:

skilled

Get Tailored Programmes

affordable

Quick Delivery

flexible

Scalability and Consistency

access

90 Days Access

Learn a New Skill From Onsite Training

Adaptable Courses

We provide onsite courses modified according to our client's organisational needs.

Cost-Effective Learning

Onsite training helps you to reduce travelling and venue expenses.

Learn in Familiar Surroundings

Training at your convenient place can be ideal for learning new skills.

Team Building Opportunity

Attending onsite training with your team can help to improve your team dynamics tremendously.

name

name name-red
phone-call phonecall-red
email email-red
email email-red
comment comment-red
up-arrow
LOADING