Survey Results on ETL-Based Data Warehouses

During 2012 we have been surveying TDWI World Conference attendees about their data warehousing investments. We wanted to know their thoughts and experiences on a variety of topics, ranging from whether they felt like IT and “the business” are on the same page in terms of keeping the warehouse up to date with the latest requirements, how long it takes to keep the warehouse current, and how many resources they expended on supporting their environment. We’ve received a little over 400 responses from events in Las Vegas, Chicago, San Diego and Boston. Read more

The Big Data Conundrum

Another article appeared last week in Forbes on the future of Big Data. No “v” words this time, but a much more practical discussion: how prepared is your IT organization to support big data? Read more

Are you even (nearly) ready for Big Data?

Big Data.  What is it? Those of us who have helped organizations improve competitiveness through more effective use of information know that most data has value. The trick is in defining that value, determining how best to get at it and then executing a process to extract it. Every few years it seems we have to create a rally point for more focus on just how impactful information is, and for the past several that rally point is Big Data. If you believe what you read and hear, it can be pretty much anything you want it to be. But there is at least one shred of truth in what we call it; it is BIG. Read more

Training in the Cloud

In my last post I poked a bit of fun at the Big Data marketing hype and this week I figured, why stop there? So today’s topic is the cloud – except this post is relevant to the cloud! Read more

Delivering on “The Other BI”

I read a really good article in Information Management this week on BI entitled “The Other BI.” The idea in the article is that “business involvement” is the “other BI” that is critical to ensuring success of your business intelligence deployment based on a data warehouse. Read more

The Lengthening Shadows for ETL for Data Warehousing

Today at the Teradata PARTNERS Conference in San Diego we announced a major new release of the Kalido Information Engine. Version 9 further extends our business-model-driven automation to cover more data integration tasks than ever before. We believe the impact of this is the need for separate, purpose-built ETL tools for data warehousing is quickly setting into the sun, and in some cases clients won’t need to use them at all. Read more

Keep your shoes on – Business/IT alignment is not the issue

I’ve been thinking about the article and punditry around a recent discussion on IT/business alignment, and I’ve finally been inspired to respond after seeing this post today.  Wendy compares IT to the TSA and suggests that IT has a similar image problem with its customers – the non-IT part of your business – and that these business users are constantly trying to circumvent IT. It’s worth thinking about why IT’s customers feel that way and react as Wendy describes. Read more

Achieving Fully Governed Master Data

This is my third and final post in my series about what to look for in your master data management solution. The first topic was about modeling your master data, the second was mastering the data, and this one is about governing the master data. Read more

How to be the master of mastering your master data

In my last post, I discussed how important it is to be able to effectively model your master data. In this, the second in a series on the topic of master data, I want to discuss how you need to master it. By “master it,” I am referring to the workflow-driven process steps people go through to achieve clean, consistent, accurate and harmonized master data, and having the relevant technical capabilities to make this process work smoothly and efficiently. And by “people,” I mean everyone involved. Read more

Much Ado About Loading

Recent chatter in the data warehousing industry has again raised the topic of data loading performance. With each new version of a database used for warehousing, the vendor trumpets their performance, trying to one-up their database competitor. There can be no doubt that physical movement of data from file to database is a critical component of the load, but is it really where the bulk of the time is spent on the nightly refresh? This raises the question: what does it mean to load the warehouse? Read more