In February 2018, I have the opportunity to speak at a conference in Auckland, NZ : the second edition of Difinity which will take place from February 12 to 14th with 10 all-day workshops and more than 50 sessions delivered by top-notch professionals (and me).
This will be by far the longest speaking journey I have undertaken as New Zealand is on the antipode of Western Europe give or take a few swims.
I will be speaking about one of my favourite topics: ETL and SSIS. But with a twist since the workshop I am delivering is all about Biml.
Business Intelligence Markup Language is a wake-up call
If your one of the 3 persons who read this blog, you probably have seen Biml mentioned on previous posts (like this one: https://theblobfarm.wordpress.com/2015/11/19/biml-online-beta-biml-without-the-software/)
And apart from my eternal gratitude for being one of the 3 readers, you know that Biml basically removes all the tedious work out of building SSIS packages for keeping only the business part.
Whenever I present on the topic, it is always a grateful experience. The gain in productivity is so obvious that attendees who don’t know Biml always are in for a wake-up call.
There is a lot more to Biml than building SSIS packages of course and this is what I will show in my workshop.
In the workshop we will build a complete metadata driven data warehouse and have a greater and deeper look at these elements of building the solution:
- Metadata driven: decoupling the metadata from the solution, seamlessly using MDS, Excel, Tables or event XML files for describing the transformations and relations
- Implementing DW specific features and patterns like: Inferred members, degenerate dimensions, Type 2, 3 and 4 historic
- Profiling you source data in a seamless way
- Doing Unit test and Integration testing
- Protecting your metadata code and IP by using C# class libraries
What you will leave this session with is the foundation for a BIML Script framework, which will allow you to tear-down and recreate your ETL process in minutes, instead of having to recode each package by hand.
If you are at Difinity come and say hello!
Happy biml’ing !