Level Up! From Basic Biml to Automated Data Warehouse Frameworks

SQLSaturday Chicago 2018

This is a pre-conference workshop before SQLSaturday Chicago 2018, 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.

Level Up! From Basic Biml to Automated Data Warehouse Frameworks

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

• Basic Biml and BimlScript
• Biml Tools and Code Management
• Create and Load a Staging Environment

Part 2: Beyond Basic Biml

• Introduction to C# in BimlScript
• Practical Programming with C# Classes and Methods
• Create and Load a Dimensional Model

Part 3: Metadata and Frameworks

• Designing and Consuming Metadata
• Metadata Modeling in Biml
• Create a Metadata-driven Data Warehouse Framework

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 :)

Speaker

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.