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 oft -overlooked elements of successful BI.
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
Why all the Fuss about Metadata Driven ETL?
Building anything from houses to software applications requires that we make decisions about how to efficiently convert raw materials into the desired product. Building a
Automated Notifications
LeapFrogBI projects include the option to enable automated notifications per lifecycle based on load process events; start, complete, and failure. To setup the solution simply navigate to