The good folks putting on SQL Saturday Phoenix have asked me to give a full day Precon seminar on Friday March 28, 2014. This will be my first Precon focused on Biml (Business Intelligence Markup Language), and I’m really pumped about it.
Fast Track your Business Intelligence Projects with Biml – Precon
You’re a business intelligence developer or manager trying to provide quality data in a timely, cost-effective manner. Perhaps you’ve considered Agile methodology, but found that the details of ETL, the plumbing if you will, makes iterative development all but impossible. In just one day, you’ll learn how to leverage Business Intelligence Markup Language (Biml) to super charge your ETL efforts, alleviating the pain and tedium of data warehouse development.
You will Learn:
- How Biml makes Agile data warehouse development a reality.
- Understand the basic syntax and rules of Biml, the important role of meta data, and how to choose the right scripting language for you.
- Using BimlScript to dynamically create tables, views, and the SSIS packages to load them.
- How to change your development mindset and spot re-usable patterns which are ideal for using Biml.
- How to leverage BimlScript for ETL performance tuning.
As an added bonus, you’ll leave the precon with many BimlScripts and code samples you can adapt to use in your own environments. The entire seminar is geared toward getting you up to speed on BimlScript so you can stop wasting your time repeating the same old patterns. Come see why Biml is changing the way we build data warehouses.
Tickets can be purchased here. If you order by 2/28 the price is only $99 and is $125 after that. Keep in mind that there is a small processing fee as well.
SQL Saturday Phoenix Presentations
If you can’t attend the Precon, I’ll also be giving two presentations on Saturday which are free of charge (of course). If you’re in the area, come see me present:
Biml – The Next Step in Agile Data Warehousing
Business Intelligence Markup Language is literally changing the way we think about Data Warehouse design and ETL. In this interactive, demo focused presentation you’ll see how you can rapidly iterate through the Data Warehouse Development Cycle and provide ROI almost immediately. Learn how you can use Biml Script to automatically create staging tables, SSIS Packages, and other necessary objects during the modeling process.
Data Warehouse Mistakes You Can’t Afford to Make
Many data professionals understand the basics of Data Warehouse design, including Dimension and Fact Tables, slowly changing Dimensions, and the use of meaningless surrogate keys. However, it isn’t until you’ve created a dimensional model and put it into production, that you realize just how much of an impact seemingly trivial mistakes can make. They can hobble performance, allow inaccuracy, and perhaps worst of all, inhibit adoption and usage of the new system. Learn how to avoid many common mistakes, from someone who’s made them and then found ways to correct them.
More details about SQL Saturday Phoenix #279 can be found here. Hope to see a bunch of you there!