Blog
LeapFrogBI’s employee blog where we discuss data solutions, Power BI, managed analytics teams, business intelligence tools, and industry trends.
![](https://www.leapfrogbi.com/wp-content/uploads/2017/02/image.axd-6-300x73.png)
Working With Data Sources That Do Not Track Changes
Data sources come in all shapes and sizes. Some include all of the features needed
Paul B. Felix
August 18, 2012
![](https://www.leapfrogbi.com/wp-content/uploads/2012/08/Screen-Shot-2017-02-15-at-8.40.40-PM-300x64.png)
Accumulated Snapshot Fact Table
Breakdown of an Accumulated Snapshot Fact Table When creating a model to describe a process
Paul B. Felix
August 5, 2012
![](https://www.leapfrogbi.com/wp-content/uploads/2017/09/LFBI-mark-300x300.jpg)
Why You Need A Persistent Staging Area (PSA)
Data warehousing closely resembles life in general. Just about when we feel like everything is
Paul B. Felix
August 5, 2012
![](https://www.leapfrogbi.com/wp-content/uploads/2017/09/LFBI-mark-300x300.jpg)
SSIS Package Execution Precedence
SQL Server Integration Services offers developers a powerful toolset capable of performing a wide range
Paul B. Felix
July 30, 2012
![](https://www.leapfrogbi.com/wp-content/uploads/2017/09/LFBI-mark-300x300.jpg)
Dimension Load Using the MERGE Statement
The T-SQL MERGE statement was introduced in SQL Server 2008, and in many ways simplified
Paul B. Felix
July 23, 2012
![](https://www.leapfrogbi.com/wp-content/uploads/2017/01/MultipleDimensionLoad-198x300.png)
Loading Dimensions From Multiple Sources
Dimensions records are often derived from multiple sources. When these sources are in sync, it
Paul B. Felix
June 15, 2012