As my fellow board member Ryan Adams mentioned recently, the North Texas SQL Server User Group is choosing SQL Saturday #447 precons by popular vote. The voting went live this weekend, and I urge everyone who may attend our SQL Saturday to take part. Each person is only allowed to vote for one precon, and your vote does not obligate you to actually attend one. Each of the 10 submission abstracts can be found here.
To vote, please email firstname.lastname@example.org and include the session name in the subject line. I submitted the following abstract and would like your vote.
Fast Track your Business Intelligence Projects with Biml
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 Biml 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.
As an added bonus, you’ll leave the precon with several production quality BimlScript frameworks and code samples to use in your own environments. None of these samples require special software or third party tools. These samples will enable you to:
- Dynamically create and load an Operational Data Store with historical tracking.
- Dynamically create and load an Enterprise Data Warehouse using Agile Methodology.
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.