Plenty of business intelligence (BI) or data warehouse projects have been blindsided by complications related to data quality. Sometimes these issues aren’t apparent until business users […]
You don’t often hear “metadata management” and “business initiatives” in the same sentence. It’s time for that to change. Metadata management is the secret ingredient that […]
As we discussed in my previous column, big data warehouses are back in style. In a 2004 TDWI study, 60 percent of respondents indicated that they were adopting […]
Just like boot-cut jeans and fuel-efficient cars, big data warehouses are coming back in style. Take a trip down memory lane, when IBM introduced the corporate […]
Our high-tech culture suffers from a not-invented-here syndrome. If we weren’t the masterminds behind a project, we think it can’t possibly be a good one. When […]
While data warehousing technologies and methodologies have evolved over the years, ideologies, in many cases, have not. Taking a narrow-minded approach to your data warehousing strategy […]
It’s been 20 years since the term “data warehousing” was first coined. Since then, it has evolved into a mainstream activity for Fortune 1000 companies, with […]
In part 1 of this article we discussed the ugly duckling called an operational data store (ODS). Rather than discussing the conventional wisdom and, quite frankly, the […]
Have you ever wondered why companies buy software licenses from BI vendors for hundreds or even thousands of “seats” and only use a small fraction of […]
Religious wars. We have them in IT all the time. Everyone debates architecture. The “high priests” of our trade guard it. The approaches espoused by Ralph […]
Much of the IT literature that you read focuses on tools and technology. That’s understandable, since product vendors churn out these materials to sell and market […]
The current king of business intelligence (BI) tools is Microsoft Excel. Microsoft states that there are over 150 million Excel users, with many of them using […]
The thought of meta data management doesn’t exactly inspire whoops of joy from the average IT manager. However, like flossing, it’s one of those things you’ve […]
If you’re trying to architect or build a cost-effective, productive business intelligence (BI) program, it’s important that you thoroughly understand the data franchising component of the […]
Data preparation is the core set of processes for data integration. These processes gather data from diverse source systems, transform it according to business and technical […]
You’re involved in a business intelligence project, making great progress creating reports and cubes for analysis for your business users. They’re excited about what they see […]
Key components of the data integration framework (DIF) are the software tools used to create, deploy and maintain it. This month, we discuss tools used for […]
Data standards ensure the consistency, accuracy, integrity and validity that are critical to your success. Data is not usually clean and consistent, especially when gathered […]
In my earlier column “Do You Need a Data Integration Center of Expertise?,” I discussed these key points: You need to integrate data, not just create another version of […]
This month, we explore the impact of several business intelligence (BI) trends on data integration. These trends include: business (or corporate) performance management (BPM or CPM), […]
Reining in the proliferation of expensive, redundant data silos requires a methodical approach that includes establishing a data integration center of expertise. In their quest for […]
In a previous article, I discussed the importance of adhering to product and technology standards to increase both the ROI of your IT investments and the value […]
Too many companies have implemented the “software du jour” – frequently switching to different hardware; operating systems; databases; applications; programming languages; extract, transform and load (ETL) […]
Remember the Betamax? How about eight-track tapes? If you remember either of these tape formats, you understand the importance of standards. Adhere to the wrong ones […]
The business users are restless. They’re looking to you for a solution that’s long overdue. It’s tempting to rush and buy technology to solve your problems, […]
In an earlier column, I provided an overview of the five data integration framework (DIF) components. This month, I will examine the first component –information […]
Last month, I introduced you to the concept of a data integration framework (DIF) – a combination of processes, standards, people and tools that ultimately helps […]
Published in Darwin Magazine (CXO Media) Maybe applications integration isn’t really what you need. Maybe you need to find a way to integrate your data. If […]
Reining in the proliferation of expensive, redundant data silos requires a methodical approach that includes establishing a data integration center of expertise. In their quest for […]
There has been a great deal of industry buzz about analytic applications over the last year, much of it from the trade press, industry analysts and […]
Originally published by DMBS Magazine (Intelligent Enterprise/Information Week) A tremendous amount of resources are being used in enterprises to build data warehouses and data marts. This […]