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 format. If this is not the case, then it is likely that you will need […]
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 and others end up with a wretched pile of filth? Anything that grows like Business […]
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 custom scripts, and let LeapFrogBI do all of the repetitive busy work. Simple select the […]
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 an acceptable level of accuracy is not quite as simple. The prioritized backlog of user […]
What is an EDW bus architecture? What is a bus matrix? This short video introduces the bus architecture.