Author: Paul B. Felix

New Component – Execute Process

Need to execute a batch file?  Visual Basic Script?  EXE?  You are in luck.  Use the new s9502 (Execute Process) stage component to execute any

LeapFrogBI DWA Supports SQL Server 2017

Simple as that.  LeapFrogBI Data Warehouse Automation now supports SQL Server 2017.  Existing clients can upgrade their projects without writing a single line of code

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

Dimensional Modeling: Introduction

What is a dimensional model? What is a data warehouse? This video introduces dimensional modeling while setting the stage for the series of dimensional modeling training videos to follow.

Calculate Workbook

When using several of the LeapFrogBI component types, configuration information is stored in Excel.  This architecture is used in cases where it is not feasible