This article describes what the dimension manager and fact provider do, and how to configure business intelligence tools to use the integrated EDW.  Read more...

This article provides guidance to what an integrated EDW is and what design elements are needed to achieve integration.  Read more...

Part two of the interview looks at some design decisions in building a warehouse as well as some of the tools available.  Read more...

An interview with a data warehousing expert Chuck Kelley with some views about the careers in data warehousing.  Read more...

With data volumes exploding, conventional enterprise data warehouses are fast running out of headroom. Data warehouse appliances are starting to fill the gap, but the emerging category of column-oriented databases may offer a better option. The key to success is matching your application to the right product.   Read more...

Are you frustrated by the inefficiency, rigidity and latency of a first-generation, hub-and-spoke-architecture data warehouse? Here's a six-step guide to evolving to a streamlined, robust Kimball Dimensional Bus Architecture that will reduce time to reporting, lower data latency, and deliver more detailed, analytically useful information.  Read more...

Read more...

Read more...

Read more...

Building a data warehouse usually isn't a small project, but somehow management sometimes sees it as something that can quickly eb done with a tool or two. Longtime DBA Janet Wong brings us a look at some of the problems you might face when getting ready to embark on this type of project.   Read more...

Information governance is defined by Larry English as the act or process of leading, directing, controlling and assuring that information is managed effectively as an enterprise resource. (PDF download)  Read more...

Usually a data warehouse is used for some sort of Business Intelligence system. Data warehousing experts Vincent Rainardi and Amar Gaddam bring us another great article on warehousing with a look at how a warehouse might be used for a CRM system.   Read more...

When loading a data warehouse, handling the ETL process of working with files can be problematic. Longtime DBA Janet Wong brings us an interesting solution that is flexible and efficient for quickly loading a number of files into a warehouse using DTS.   Read more...

How do you cope with an executive's request to "bring back a time series of activity for all subscribers who were in platinum status as of X date," or "show me a time series of orders by sales region according to the sales organization as of Y"? Here's how data warehouse pros can cope with the common requirement to look back in time.  Read more...

This article provides an architecture and process framework for implementing common reference data in a data-warehousing environment.  Read more...

ETL processing, generally involves copying/moving, transforming, cleaning the records/transactions from one or multiple sources. Most of the batch processing or warehousing projects involve such data processing in millions on daily/weekly basis. Typically, there is a Staging area and production area. Records are cleaned, transformed, filtered and verified from staging to production area. This demands SQL Set theory based queries, parallel processing with multiple processors/CPU. The article focuses on need of SQL Set theory approach and parallel processing while processing large volume of ETL records using programming approach.   Read more...

These 34 subsystems cover the crucial extract, transform and load architecture components required in almost every dimensional data warehouse environment. Understanding the breadth of requirements is the first step to putting an effective architecture in place.  Read more...

My online series of articles has been focused on the need for businesses to "get serious" about their approach to developing an enterprise business intelligence (BI) and data warehousing (DW) capability. When pursuing this capability it is important to adopt a holistic view, followed by disciplined investment and execution.  Read more...

Part 3 of this survey looks at large data volumes.  Read more...

Part 2 of this survey looks at single views of the business.  Read more...

Part 3 of Vincent Rainardi's data warehousing series looks at some of the situations and challenges of loading a fact table in a data warehouse.   Read more...

Are you frustrated by the inefficiency, rigidity and latency of a first-generation, hub-and-spoke-architecture data warehouse? Here's a six-step guide to evolving to a streamlined, robust Kimball Dimensional Bus Architecture that will reduce time to reporting, lower data latency, and deliver more detailed, analytically useful information.  Read more...

Check out our Top 10 tips on Analysis Services 2005 that will help you navigate through the features and functionality of this priceless Business Intelligence tool.  Read more...