Building Blocks of Biml

This course teaches SQL Server Integration Services (SSIS) developers how to develop packages to perform extract-transform-load (ETL) operations for a data warehouse by using Business Intelligence Markup Language (Biml) as an alternative development approach.
Course info
Rating
(26)
Level
Beginner
Updated
December 29, 2015
Duration
4h 10m
Table of contents
Description
Course info
Rating
(26)
Level
Beginner
Updated
December 29, 2015
Duration
4h 10m
Description

It’s generally accepted that creating and maintaining ETL packages with SQL Server Integration Services (SSIS) is one of the more time-consuming steps in the data warehouse development process, but what if there was a way to save time that can be used to solve bigger problems or expand the data warehouse scope? Rather than spend seemingly endless hours working through repetitive SSIS package development tasks and more hours tweaking those packages as schemas evolve, you can use Biml to create a framework that gracefully adapts to changes and updates package designs in minutes. This course introduces you to the Biml language by progressively building out files to support a data warehouse environment until you have a complete solution for staging data and loading the staged data into target dimension and fact tables.

About the author
About the author

Stacia Misner Varga is a consultant, instructor, author, mentor, BI Partner for SQLSkills, and principal of Data Inspirations specializing in Microsoft business intelligence technologies for over 10 years. She is a frequent speaker at the PASS Summit, IT/Dev Connections conferences, and various SQL Saturday and Microsoft-related events worldwide.

More from the author
Getting Started with Power BI
Beginner
3h 14m
24 Jun 2016
Advanced Integration Services - Part 2
Intermediate
4h 44m
17 Mar 2015
MDX Fundamentals
Intermediate
3h 37m
19 Sep 2013
More courses by Stacia Misner Varga