Welcome to the Utopia of Reporting; Reportopia
Welcome to Love Your Reports. My name is Paul Felix. I am your host and this podcast is dedicated to all of you business builders
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
An Introduction to Data Solutions
What are data solutions? At LeapFrogBI we use the term data solution to refer to the portion of the overall analytics system that acquires data
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.
Have you ever fished in a Data Lake?
Why build a data warehouse when you can have _____. Fill in the blank with the latest marketing epiphany.
Early Arriving Facts / Late Arriving Dimensions
A resilient ETL process deals with data quality issues without causing a process failure while also meeting business requirements. One issue that should be anticipated