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
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
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
New Feature – Precedence Graphs
Users can now view a visual representation of functional constraints via the Precedence Graph option.
Easy Access To Recent History
At times it is useful to retrace your navigation steps within a project. Now you can.
New Expression Type – LTrim(RTrim(…))
Trim both sides of a string in one step using the new Left Trim & Right Trim combined expression type.