San Francisco, California
London, United Kingdom
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 Hero Andy Leonard 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:
- Basic Biml and BimlScript
- Create and Load a Staging Environment
- C# & VB.NET Syntax Accelerator
- Business Logic and Unique SSIS Patterns
- Metadata Modeling and Frameworks
- Create and Load a Dimensional Model / Data Vault
- How to adopt Biml gradually
- Working with Biml in a Team
- Operations and Deployment
- Biml in the Cloud
- The Biml Ecosystem
- Ask the Experts
Andy Leonard is a Data Philosopher at Enterprise Data & Analytics, an SSIS Trainer, Consultant, and developer; a Business Intelligence Markup Language (Biml) developer and BimlHero; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server Integration Services Design Patterns, and author of Managing Geeks - A Journey of Leading by Doing, and the Stairway to Integration Services.
Scott Currie is the founder and CEO of Varigence, Inc. At Varigence, Scott has led the development of the Business Intelligence Markup Language (Biml) and the Mist IDE. Before founding Varigence, Scott worked for seven years at Microsoft on the .NET Framework, Visual Studio, the C++ compiler, various customer connection initiatives, and internal BI/DW projects.