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.
More New Features – Custom Connection Attributes & Faster Build Access
Custom Connection Attributes This new feature adds a connection attributes dialog to connection string definitions enabling users to define custom attributes at design time. Faster
New Expression Type – Custom Script
Have you ever wanted to just type some t-sql instead of using the fully validated LeapFrogBI expression builder? Well, you are in luck. You can