Learn Biml Today: Start Using It Tomorrow

2016

TL; DR

Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your SQL, SSIS, and SSAS development time. In this session, learn everything you need to start using Biml immediately.

Session Details

Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your SQL, SSIS, and SSAS development time. In this session, Scott Currie (the creator of Biml) and Biml Heroes Andy Leonard and Cathrine Wilhelmsen will guide you through learning Biml - from installing free Biml tools to creating advanced Biml automation solutions. The session will be largely demonstration driven, and reusable sample code will be distributed for you to use in your own projects. Best practices will also be a major focus of the session, so even Biml enthusiasts may enjoy the session as a refresher.

A preliminary agenda includes:

8:15am – 9:00am Registration
9:00am – 9:30am Opening Comments
9:30am – 10:30am Biml Syntax and Structure
10:30am – 10:45am Break
10:45am – 11:30am C# & VB.NET Syntax Accelerator
11:30am – 12:15pm Create & Load A Staging Environment In One Hour
12:15pm – 1:00pm Lunch
1:00pm – 2:00pm A Real-World Metadata Framework
2:00pm – 2:15pm Break
2:15pm – 3:15pm Managing Large Solutions and Organizing Your Code
3:15pm – 3:45pm Deployment & Automation
3:45pm – 4:00pm Break
4:00pm – 4:15pm Team Development
4:15pm – 4:30pm Biml in the Cloud
4:30pm – 4:45pm The Biml Ecosystem
4:45pm – 5:00pm Ask the Experts

3 things you'll get out of this session

Cathrine Wilhelmsen's previous sessions

Website Analytics in My Pocket Using Microsoft Fabric

Join this session to see how easy it is to create a pocket-sized dashboard for your website analytics. First, learn how to automatically collect statistics from an API and store it in a central location. Then, see how quickly you can visualize the data in a mobile-friendly way using Power BI. 📈

Choosing between Microsoft Fabric, Azure Synapse Analytics and Azure Data Factory

Learn the pros and cons of Microsoft Fabric, Azure Synapse Analytics and Azure Data Factory, and how to choose the right Data Integration solution for your project.

"I can't keep up!" - Turning Discomfort into Personal Growth in a Fast-Paced World

Are you struggling to keep up with all the latest product changes and new technologies? Awesome! That means you have ambitions. You can do anything if you set your mind to it. It just might not be easy. Are you ready to turn your "I can't keep up" into "I can't believe I did all of that in just one year"?

Stressed, Depressed, or Burned Out? The Warning Signs You Shouldn't Ignore

Stress barges through your door and yells "hey, it's me!", while depression and burnout silently sneak in and gradually make adjustments until one day you turn around and realize that you no longer recognize your house. What are the warning signs you need to be aware of in yourself or your loved ones?

6 Tips for Building Confidence as a Public Speaker

In this session, I share the top tips I have learned over the years. All it takes is a little preparation and practice.

Lessons Learned: Implementing Azure Synapse Analytics in a Rapidly-Changing Startup

What happens when you mix one rapidly-changing startup, one data analyst, one data engineer, and one hypothesis that Azure Synapse Analytics could be the right tool of choice?

Biml Tips and Tricks: Not just for SSIS packages!

Biml is not just for generating SSIS packages! Come and see how you can use Biml to save time and speed up other Data Warehouse development tasks like T-SQL development, test data creation, and dimension population.

Level Up Your Biml: Best Practices and Coding Techniques

Attend this session for an overview of Biml best practices and coding techniques. Learn how to centralize and reuse code, simplify logic, and create your own C# classes and methods. Improve your code and level up your Biml in no time!

Tools and Tips: From accidental to efficient DWH developer

As data warehouse developers we deliver data to business users... but we don't deliver data as fast as we want. There are many things you can do to increase your own productivity and become a more efficient data warehouse developer.

Andy Leonard's previous sessions

Learn tips and tricks to make SSIS perform better.

Designing an SSIS Framework

In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging.