Author: Paul B. Felix

Love Your Reports Podcast

Three Critical Questions

Welcome to Love Your Reports. I’m Paul Felix, your host, and this is episode number four. This week, I want to continue the conversation about

Love Your Reports Podcast

Where’s the Value?

Welcome to Love Your Reports.  I’m Paul Felix, your host, and this is episode number three.  In today’s episode I want to talk about value.

Love Your Reports Podcast

What Does Reportopia Cost?

Hello and welcome to Love Your Reports. My name is Paul Felix. I’m your host. And this is episode number two. In this episode, we’re

Love Your Reports Podcast

On the Road to Reportopia

Welcome to Love your Reports. My name is Paul Felix, I’m your host.  And this is episode number one.  I am really excited to get

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. I’m going

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