Profile Multi-Set Select Statements
At times we need to select from two or more sources and stage the selected source. As an example, you may want to collect all
TDWI Conference – Agile Data Warehousing 101
I’m happy to be attending the TDWI Agile BI conference in San Diego this week. Today, Sunday, kicks off a series of great learning sessions.
Introducing Pattern Based Development
Building a data mart often follows the 80/20 rule. 80% of development follows a standard design pattern. The remaining 20% requires custom logic to be
Working With Excel Source Data
It is less than ideal, but at time we need to collect data that is stored in Excel. Working with Excel can be a little
How to Avoid Business Intelligence Catastrophe – Part 1
Part 1: Start from a Data Driven Culture This is the first in a series of posts about the often-overlooked elements of successful BI. Why
Dynamic Date Dimensions
Nearly all data warehouses include at least one date dimension. LeapFrogBI makes generating this important dimension extremely easy while also offering a number of time
Planning Poker & Data Warehousing
Teams that choose to take an agile approach to data warehousing will be faced with a planning meeting at beginning of each iteration. The goal
Skip PSA
PSA serves a vital role. However, there are also cases when we want to build something as fast as possible without worrying about a consolidation
Forget about Tools. Agile DW Means…
Agile software development has become the preferred methodology of countless teams worldwide. The principles behind the agile manifesto serve as the rule book for those of us
ETL Design Patterns – The Foundation
Data warehouses provide organizations with a knowledgebase that is relied upon by decision makers. ETL (extract, transform, load) is the process that is responsible for