Faster Dimension Loads
This initial load of a dimension can be a resource intensive process. The situation gets even tougher when the dimension’s natural key is not optimal;
Selecting a Dimension Template
LeapFrogBI’s dimension templates are designed to handle a number of use cases. Below is a list of currently available templates, along with a short description
Dealing with Deletes in the Data Warehouse
Data warehousing has a clear set of objectives such as data persistence, single easy to navigate data model, fast query performance, etc… While it is
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.