Expanded

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
(40)
Level
Beginner
Updated
Dec 29, 2015
Duration
4h 9m
Table of contents
Introducing Biml
Creating Your First Biml Files
Exploring Basic Biml Syntax in the Control Flow
Exploring Basic Biml Syntax in the Data Flow
Introducing Biml Automation
Automating Biml with Multiple Files
Building Biml for Data Warehousing - Part 1
Building Biml for Data Warehousing - Part 2
Description
Course info
Rating
(40)
Level
Beginner
Updated
Dec 29, 2015
Duration
4h 9m
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 an instructor, author, and principal consultant of Data Inspirations. Her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, she has provided consulting and education services for Microsoft’s data platform and authored or co-authored many books covering this topic. In addition, Stacia has been a frequent speaker over the years at technology conferences worldwide.

More from the author
Getting Started with Power BI
Beginner
4h 56m
Sep 3, 2021
Modeling Data in Power BI
Beginner
4h 56m
May 12, 2021
Building Your First Power BI Report
Beginner
1h 31m
Mar 1, 2021
More courses by Stacia Misner Varga