Working With Excel Source Data
It is less than ideal, but at time we need to collect data that is stored in Excel. Working with Excel can be a little tricky. This post assumes that you have Excel data that is in a standard tabular
Monthly Archives: July 2013
How to Avoid Business Intelligence Catastrophe – Part 1
Part 1: Start from a Data Driven Culture
This is the first in a series of posts about the oft -overlooked elements of successful BI. Why do some companies get so much out of their Analytics and Business Intelligence investments
Dynamic Date Dimensions
Nearly all data warehouses include at least one date dimension. LeapFrogBI makes generating this important dimension extremely easy while also offering a number of time saving features such as auto dimension growth & common attribute generation. Stop wasting time creating
Planning Poker & Data Warehousing
Teams that choose to take an agile approach to data warehousing will be faced with a planning meeting at beginning of each iteration. The goal of this meeting is pretty straight forward; plan the upcoming iteration. Accomplishing this task with
Bus Architecture
What is an EDW bus architecture? What is a bus matrix? This short video introduces the bus architecture.