ETL Design Patterns – The Foundation
Data warehouses provide organizations with a knowledgebase that is relied upon by decision makers. ETL (extract, transform, load) is the process that is responsible for
Agile BI Equals Successful BI (Yet another Example)
A quick Google search on “Failed BI Project” will yield more results than any normal human can read in a lifetime. Sure, many of these
Selecting a BI Consulting Firm: 5 Pitfalls to Avoid
Building a business intelligence solution requires specialized skillsets such as data modeling, data integration, data analytics, and visualization design. Leveraging a consulting firm’s services can
Don’t Let Your BI Project Fail: 3 Must Have Traits of a Successful Team
If you are preparing to start a business intelligence and/or data warehousing project, then you probably already know that BI project failure is not uncommon.
The Dirtiest of all ‘Dirty Jobs’: Data Warehousing Front Lines
Ok, so you probably already know that Mike Rowe never shot a Dirty Jobs episode on data warehousing, but if he had there is no
Do You Make These 5 Data Warehousing Mistakes?
You know how there are times in life when you see something, and you know from experience that someone is headed for a world of
Top 3 Reasons to Always use Surrogate Keys in Data Warehousing
There are many things about data warehousing that are subjective. The use of surrogate keys is clearly not one of them. Let’s start with a
Quick Review–ACID
One of the foundation concepts that all database workers should keep in the back (or maybe front) of their mind is ACID. This small and
LeapFrogBI Success Story
I get asked on occasion to quantify the efficiency that the LeapFrogBI data warehouse automation platform offers. Below are a few measures that were collected
Before Development Begins…
It probably goes without saying that BI and data warehouse projects can be very complex. Taking a bottom up & agile approach breaks the larger