Archives

Presenting Agile Datawarehouse Design With #Biml Tomorrow at #SQLSatOKC

Just a quick shout out that I’ll be at SQL Saturday Oklahoma City tomorrow to give an updated version of the following presentation.

Agile Data Warehouse Design with Biml

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 […]

Presenting Agile Datawarehouse Design With Biml Tonight at NTSSUG

If you are in the DFW area, come down to the North Texas SQL Server User Group tonight at the Microsoft Building in Irving. The meeting starts at 6pm CST. I’ll be giving an updated version of the following presentation.

Agile Data Warehouse Design with Biml

Business Intelligence Markup Language is literally changing the way we think […]

SQL Saturday Dallas Precon Vote

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 […]

I'm Giving Two Biml Presentations at SQL Saturday Houston!

If you’re in the Houston area this weekend, come see me present at SQL Saturday Houston #408! I’m going to head down Friday afternoon, and will be giving the following presentations.

Writing Your First BimlScript

In this highly interactive presentation, I’ll guide you through the process of creating your first BimlScript. During the process we’ll cover the […]

Teaching a Full Day of Biml Goodness For Tulsa School of Dev

Calling all Business Intelligence/Data Warehouse folks within driving distance of Tulsa, Oklahoma. A week from tomorrow, Friday 5/16, I’ll be presenting a full day of Biml Training at the Tulsa School of Dev, and for the low, low cost of….. FREE! Wait, did I read that right? Does that say Free? Yes, my friend the […]

Upcoming Biml Precon at SQL Saturday Phoenix

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 […]

My Biml Metadata Strategy

Now that we’ve discussed various common metadata strategies used in creating BimlScript, I’m going to explain exactly how the metadata in my sample BimlScript framework functions. Basically, I’m going to start to pull back the curtain and explain some of the “magic” involved in my Biml – The Next Step in Agile Data Warehousing presentation.

As […]

Strategies and Languages for Generating Biml

What are the best methods for generating Biml and what language should you use? Before I dive into this, let me begin with a disclaimer. I applaud anyone working with Biml to improve their productivity and eliminate needless, repetitive work. One of the primary advantages of Biml is its flexibility, which allows people to generate […]

Biml Metadata Options and Considerations

Simply put, metadata is data about data. Probably the most common way that SQL Server Professionals use metadata is when we query SQL Server System Views. In this article we’ll discuss using metadata to drive BimlScript automation. Before I start listing common metadata sources and methods, I need to briefly contrast two basic metadata philosophies […]

Agile Data Warehouse Development using Biml

Agile development is good, Waterfall is bad. We hear this all the time, along with un-documented statistics claiming that approximately 80% of Data Warehouse projects fail. So, we as Business Intelligence Professionals are told that we must be Agile. Whenever I taught Dimensional Modeling and Data Warehouse classes, I could count on at least one […]

Page 1 of 41234