Don’t Miss These Critical ETL Considerations
Anyone who has been involved with data warehousing knows that there are plenty of things that can go wrong. Mistakes can be made when researching
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