Level Up! From Basic Biml to Automated Data Warehouse Frameworks

Cathrine Wilhelmsen

<H2>SQLSaturday Chicago 2018</H2>
This is a pre-conference workshop before <A HREF="http://www.sqlsaturday.com/719/" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">SQLSaturday Chicago 2018</A>, which is a free one-day training event for Microsoft Data Platform and Business Intelligence professionals. You must register for SQLSaturday Chicago separately on their website.
<H2>Level Up! From Basic Biml to Automated Data Warehouse Frameworks</H2>
Have you ever wanted to build a Data Warehouse simply by pushing a button? It might not be quite that simple yet, but gone are the days of repetitive development. Biml (Business Intelligence Markup Language) helps you create powerful Data Warehouse frameworks using SSIS in just days instead of months.
This full-day workshop will give you a solid understanding of Biml and how you can use it to improve your own work day: From the basics of Biml, to generating hundreds of SSIS packages using BimlScript, to creating metadata-driven frameworks for automating Data Warehouse development. Along the way, you will learn about best practices, coding techniques and how you can gradually adopt Biml in existing small or large projects.
Part 1: Introduction to Biml
<UL>
<LI>Basic Biml and BimlScript</LI>
<LI>Biml Tools and Code Management</LI>
<LI>Create and Load a Staging Environment</LI>
</UL>
Part 2: Beyond Basic Biml
<UL>
<LI>Introduction to C# in BimlScript</LI>
<LI>Practical Programming with C# Classes and Methods</LI>
<LI>Create and Load a Dimensional Model</LI>
</UL>
Part 3: Metadata and Frameworks
<UL>
<LI>Designing and Consuming Metadata</LI>
<LI>Metadata Modeling in Biml</LI>
<LI>Create a Metadata-driven Data Warehouse Framework</LI>
</UL>
Bring your laptop to get some hands-on experience, participate in discussions with your fellow attendees, and learn how to work better with Biml. If you're a new SSIS Developer or an experienced Data Warehouse Architect, working in-house or as a consultant, or even if you're a Jack of All Trades - you will leave this workshop with new ideas for your projects :)
<H2>Speaker</H2>
<IMG ALT="Cathrine Wilhelmsen" SRC="https://cdn.evbuc.com/eventlogos/84912227/cathrinewilhelmsen2017150x200.jpg">
Cathrine Wilhelmsen is a Norwegian who loves teaching and sharing knowledge. She works as a consultant, technical architect and developer, focusing on Data Warehouse and Business Intelligence projects. Her core skills are ETL, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she's active in the SQL Server and PASS communities as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer.

Goodwin Hall 211, Daniel L. Goodwin Hall of Business, Benedictine University & College

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}