Data warehousing success depends on properly designed ETL. In this short video we walk though the foundation design pattern step-by-step.
Some of the most challenging data warehousing situations come in the form of external data mashups. Because the term “data mashup” has taken on a number of meanings over the past few years, I’ll clarify how the term is used in this post. External Data Mashup Source Data Description Systems of record are not in […]
Anyone who has been involved with data warehousing knows that there are plenty of things that can go wrong. Mistakes can be made when researching the data sources, collecting requirements, designing a dimensional model, etc… Assuming all of the analyst and modeling work has been done perfectly, we still need to be sure that the […]
Data warehousing has a clear set of objectives such as data persistence, single easy to navigate data model, fast query performance, etc… While it is not the role of the data warehouse to mimic the data in source systems, the data warehouse clearly must account for changes in the source system. Three types of changes […]
In a requirements gathering session I was asked a question that I should have knocked out of the park. A subject matter expert asks, “Why dimensional modeling?” I knew that there was no time to go into a long description of exactly what dimensional modeling is, nor did anyone (other than me) really care. I […]
Series about Avoiding BI Disaster. First look at reports by Gartner and others over the years that show high rate of failures and disappointments in business intelligence projects. Then take a look at the first error: not understanding decision culture. Start with the decision in mind.
Watch this short video to learn how LeapFrogBI is transforming traditional data warehouse development into a fast and flexible process.
I’m happy to be attending the TDWI Agile BI conference in San Diego this week. Today, Sunday, kicks off a series of great learning sessions. I chose to start the conference by attending Ralph Hughes’s Agile DW 101 all day session. In this session Mr. Hughes starts out describing the very basics and moves though […]
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 […]
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 […]
Agile software development has become the preferred methodology of countless teams worldwide. The principles behind the agile manifesto serve as the rule book for those of us who claim to be part of this paradigm shift. A quick read through these 12 principles will make it very obvious that agile is about much more than tools. Agile […]
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 ensuring the data warehouse is reliable, accurate, and up to date. This post presents a design pattern that forms the foundation for ETL processes. What are the goals? Before jumping […]