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
Why Analytics Projects are a Mistake
Before you go and start a new analytics project, consider these sobering statistics. As far back as 2005 Gartner began ringing the warning bells. ”More
The Key to Analytics That Everyone Should Understand
(This is the final part of a three-part series illuminating the challenges of data analytics and describing a proven solution to the problem.) In part one,
Five Reasons Your Data Analyst Can’t Analyze
In part one of this series, Measuring the Cost of Doing Business with Insufficient Analytics, I referenced a series of studies conducted over the past five
Measuring the Cost of Doing Business With Insufficient Analytics
A recent survey conducted by CrowdFlower and summarized on Forbes found data scientists spend most of their time massaging rather than modeling or mining data for
What you should know before you go sailing on the data lake
The ”data lake”, a catchy new buzzword in analytics circles, has many people wondering if they still need a data warehouse. You may have heard
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