Why Dimensional Modeling?
In a requirements gathering session I was asked a question that I should have knocked out of the park. A subject matter expert asks, “Why
Interactive Graph Navigation Legend
One of the most powerful features that LeapFrogBI offers is the ability to visually describe a project in the form of an interactive graph. Users
6 Source System Data Mart Built in 2 Days
Over the past few weeks Alan & I have had the pleasure of working with a small team to build an AR data mart. The
ODBC Data Collection Made Easy
LeapFrogBI makes collecting data from an ODBC (Open Database Connectivity) data sources a simple process. Profile your source and stage your profiled data. Establish a
Collect Data via ODBC
LeapFrogBI makes collecting data from an ODBC Data Source a simple process. Profile your source and stage your profiled data. Parameterize your profile query to
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