SQL Saturday PreCon - BIML Bootcamp

SQL SQL Saturday Melbourne Pre-con Tracks

• Introduction to Business Intelligence Markup Language (Biml)
• Getting Started with BimlScript Transformers
• Mist and Biml for DBAs
• Real World ETL framework for Data Warehouse Automation (DWA)
• SQL Server BI Upgrades and Migrations using Mist
• Multi-dimensional modelling with Mist and Biml

Speakers

• Reeves Smith

Reeves Smith is a Microsoft Certified Master and a SQL Server Architect specializing in data warehouse projects. He has worked with SQL Server for more than 15 years, beginning with SQL Server 6.5. During that time he has worked on various development and data warehouse projects in industries like the U.S. government, Department of Defense (DoD), telecommunication, entertainment, oil and gas, manufacturing, travel, and banking. Reeves has contributed Guidance and Mentoring Services, Architectural Guidance and Implementation, Analytic Dashboards on projects large and small, from half-day training courses to lengthy conversion and implementation projects. Unlike large consulting firms wishing to sell, Reeves makes individual business needs his top priority.

• Peter Avenant

Peter Avenant is Director of Technology at Varigence Australia, an SSIS Developer, Certified Biml Trainer and data warehouse specialist. His background includes developing a metadata framework that integrates with BimlScript to create Kimball data warehouse. He is a contributor on BimlScript.com and have published multiple code samples and webinars to the Biml community. Peter was an early adopter of Biml and has given numerous community talks and training sessions on Biml in Australia and New Zealand. He has been working with SQL Server for over a decade, focusing primarily in ETL/SSIS, database development, reporting, and data quality.

• Warwick Rudd

Warwick Rudd is a SQL Server MVP, MCM – SQL 2008, Founder and Principal Consultant at SQL Masters Consulting. With over 15 years of experience beginning with the release of SQL Server 6.5 he has worked in both Australia and England from small start-ups to Multi-National Corporations. Warwick predominantly specializes in designing and implementing High Availability and Disaster Recoverable solutions. He is a frequent speaker at local SQL Server User Groups and SQL Saturday events in Australia and New Zealand. When not playing with the SQL Server stack, Warwick likes to get away to the cold and spend time snowboarding.

• Paul Schmidt

Paul Schmidt has gained more than 15 years’ experience implementing business intelligence solutions. He combines his hands-on technical knowledge and experience of business intelligence and his project management experience to plan, design, build, and deploy successful Business Intelligence solutions from inception to completion. Paul is General Manager for Varigence in Australia.

Introduction to Business Intelligence Markup Language (Biml)

Biml is a XML dialect for defining business intelligence (BI) assets. Biml authored BI assets can currently be used by the BIDS Helper add-on for Microsoft SQL Server Business Intelligence Development Studio (BIDS) and the Varigence Mist integrated development environment; both tools translate Biml metadata into SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) assets for the Microsoft SQL Server platform.
In this interactive, demo focused session you’ll learn about Biml and see how BimlScript can automatically create staging tables, SSIS Packages, and other necessary objects during the modelling process.

Getting Started with BimlScript Transformers

Mist and Biml is so powerful that you can even change the way BI assets are generated, giving you incredible power and flexibility.

Transformer BimlScript allow you to automatically enforce design patterns and frameworks at compile time without developer interaction.
In this session, we introduce the concept of Transformer BimlScript and demonstrate how this is applied in the real world.

Mist for DBAs

A traditional DBA is primarily responsible for the Administration and Day-to-Day running of the SQL Server environments.
Regular tasks include:

• Database Maintenance and Data Maintenance Plans
• Migrating data from a production to test / development environment

In this session we will be exploring how Mist and Biml can make your life as a DBA easier and “bust the myth” that Mist and Biml are only for BI.

Metadata driven ETL framework for Data Warehouse Automation (DWA)

Design patterns, standards, metadata, and reuse are the cornerstones of data warehouse automation.

• Design patterns can be coupled with architecture, design, and implementation standards and best practices to build reusable data warehousing components.
• Patterns, standards, and components are captured and described as metadata.

In this session, we walkthrough how a metadata driven ETL framework has been implemented using Mist.

SQL Server BI Upgrades and Migrations using Mist

With Mist’s ability to reverse engineer SQL Server SSIS packages, upgrades and migrations between SQL Server platforms is made easy. Why waste time with the SSIS Package Upgrade Wizard when you can save time using Mist and Biml to upgrade your SSIS packages to any SQL Server platform (SQL Server 2005 or later).
In this session we walkthrough a real world example of upgrading and migrating SSIS packages between SQL Server environments.

Multi-dimensional modelling with Mist and Biml

Deliver powerful multi-dimensional models from metadata generated in Mist and Biml.
In this session we walkthrough how metadata in Mist and Biml is used to generate multi-dimensional models.

• Multi-dimensional modelling with Mist and Biml