(SSIS) SQL Server Integration Services

Duration: 3 Days

Objectives

Delegates attending this course will have requirements to implement SQL Server Integration Services (SSIS) to export and import data between mixed data sources, catering for simple exchanges and more complex requirements involving transformation of data before it reaches its destination (such as in the cases of loading a Data Warehouse). Delegates will learn how to carry out data cleansing tasks such as de-duplicating and fuzzy lookups, converge heterogeneous data sources through transformations such as merge and union, split single data sources into many with transformations such as conditional split, handle multiple import files with containers such as for and foreach loops, and much more. In this course you will learn about the Microsoft SQL Server Visual Studio development environment for design, creation and management of SSIS packages, and work with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling, and logging techniques. This course, along with the (SSAS) SQL Server Analysis Services Course, helps to prepare delegates for the Microsoft 70-463 exam: Implementing a Data Warehouse with Microsoft SQL Server 2012. This exam credits towards MCSA and MCSE certifications. It should be noted, however, that all course attendances should be complemented by reference to the skills measured by the exam, a period of self-study and test exams before sitting the actual exam. This course is suitable for delegates working with all versions of SQL Server from SQL Server 2008 through to SQL Server 2014.

Pre-requisites

This course assumes no prior knowledge of SQL Server Integration Services. This course does assume prior knowledge of SQL Server 2008, 2012 or 2014 database environments and the use of SQL Server Management Studio for development and administrative tasks. You should be familiar with database querying using SQL to the level of the SQL Server Database Querying Course.

Course includes

A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.

Course outline

Introduction to Business Intelligence

  • OLTP databases
  • OLAP databases
  • Data Warehouses
  • SSIS ETL, SSRS and SSAS

Introduction to PowerPivot and Analysis Services Tabular Mode

  • What Is PowerPivot?
  • PowerPivot Deployment Options
  • Self-Service Business Intelligence (SSBI)
  • Differences between SSAS Tabular Mode and Multidimensional
  • Power Pivot Data Models
  • Pivot Tables and Charts

A First Look at Tabular BISM

  • Using Visual Studio and working with Projects
  • The Tabular Designer
  • Importing Data
  • Relationships
  • Calculations
  • Browsing Models
  • Modelling and Deploying
  • Administering Tabular Models with SSMS

Enhancing Your Tabular BISM

  • Refining the Tabular Model
  • Hierarchies
  • Measures
  • KPIs
  • Perspectives
  • Partitions
  • Processing a Tabular Database
  • Creating and Applying Security Roles

Introduction To DAX

  • DAX Fundamentals
  • DAX Operators
  • DAX Functions
  • DAX as a Query Language

Advanced Topics in DAX

  • Parent-Child Hierarchies
  • Cross Filtering with Many-to-Many Relationships
  • Multiple Relationships Between Tables
  • Time Based Analysis
  • Non-Aggregatable Columns

Analysing Tabular BISMS in Excel

  • Pivot Tables
  • Sheet Data Reports
  • Pivot Charts
  • Local Cubes
  • Excel Services

Reporting on Tabular Models with SSRS

  • PowerPivot
  • PowerPivot Add-In for Excel
  • PowerPivot data model

Course Dates

London CentralLondon GreenwichBristol

The new course schedule is currently being updated and will be ready shortly. Please phone us on 0208 269 4260 or email us for the latest dates.

All our courses run in London and Bristol, or can be tailored to requirements at your own offices. For alternative dates, please email or call us on 0208 269 4260
All prices are per person and are subject to VAT
15% discount for groups of four delegates.
10% discount for groups of three delegates.
(This offer applies for delegates on the same public scheduled course on the same date.)


"Fantastic! Everything was explained very clearly."

Sothebys

"Brilliant. Exactly what was needed."

NHS

"Our trainer worked at a great pace and was very easy to understand."

Clarks International



 

 

© Transmedia . 277 Greenwich High Road London SE10 8NB  UK . 0208 269 4260
Designed by Transmedia's Web Team