Top 3 Data Warehousing Mistakes

Many organizations have built data warehouses successfully, and some have failed. There’s no reason at all for you to learn the hard way. In this

Precedence Field “JobNotify” Legend

The field [dbo].[Precedence].[JobNotify] in the LeapFrogBI console database is used by the poll job to determine which email to send and when to send it.  The package named “BI_Nofity.dtsx” (step 2 of the poll agent job) consumes and sets these values.  Here’s what the values represent.

Bridge Tables

Dimensional modeling (DM) places and emphasis on the end user’s experience.  The goal is to create a data model that performs well and is simple

An Introduction to Data Solutions

At LeapFrogBI we use the term data solution to refer to the portion of the overall analytics system that acquires data and makes it report-ready.