DW Basics Channel

Channel Sponsored by

Data warehousing is a foundational practice that supports enterprise reporting, business intelligence and decision support. Data warehouses and data marts are created across levels of sophistication and different philosophical approaches, but typically involve extracting and transforming data from operational/transactional databases and loading it to a repository for shared use and analysis. The DW Basics channel has been created to capture and aggregate stories related to fundamental approaches and practices for creating, managing, utilizing and maintaining a data warehouse.

Data Warehousing and Business Intelligence Strategies for Small and Medium Businesses

This article discusses some key strategies that SMBs could take advantage of to institute a simple business intelligence and data warehousing program

A Generalized Approach to the Creation of Bridge Records

Applied to data warehousing, a bridge table relates a fact record to one or more dimension records. Where a fact has a one-to-many relationship with a dimension, or many-to-many, you may choose to handle that with a bridge table

Real Time Data Warehousing, Part 3

This third and final article of the series addresses the questions “What causes the biggest headaches?” and “What can do you do about it?”

10 Mistakes to Avoid in a Business Intelligence Delivery

Every data warehousing and business intelligence project teaches us something. It is generally on failures, however, that we base our new success. You can learn from other’s failures, 10 of which are discussed in this article.

Real-Time Data Warehousing, Part 2

This article addresses the question “How is real time achieved?”

• More Articles

Back to the Basics of Data Warehousing

Approaches, methods and techniques from the early days of data warehousing are still applicable today

Getting Started on Your Enterprise Business Intelligence and Data Warehousing Journey

Here are a few more things to consider before getting started or going too far down the path of developing an enterprise business intelligence and data warehouse capability.

Drill Down to Ask Why, Part 2

In this month’s column, I’ll continue with this example and explore how to implement analytic capabilities to explore “why” in a real data warehouse/business intelligence system.

Analytical Database Options

Relational databases are ill-suited for analytical processing. Until recently, database developers were able to overcome the problem.

Building a Leadership Foundation

I’ll suggest areas where information management leaders can look to build a leadership foundation.

• More Columns

Forrester Report: Best Practices for Scaling the Next-Generation Enterprise Data Warehouse

Advances in Data Warehouse Performance

Data Warehousing Buyer's Guide

Data Warehouses: What are they and how will they benefit your organization?

By Guident Technologies, Inc.

Spend Data Warehouse on Steroids

By Zycus

• More White Papers

Implementing Enterprise Data Warehousing

By Alan Schlukbier

The Power of IT: Survival Guide for the CIO

By Jan De Sutter

Implementing a Data Warehouse: A Methodology that Worked

By Bruce R. Ullrey

• More Books

• Find DW Basics products & services on Information Management Marketplace

Articles from this Site

• Clarabridge Partners with Teradata Corporation
• Teradata Launches Data Warehouse Packages
• Navy Exchange Service Command Selects Netezza
• Back to the Basics of Data Warehousing
• Netezza Enters Location Intelligence Market
• More Articles from this Site

---

White Papers

• Forrester Report: Best Practices for Scaling the Next-Generation Enterprise Data Warehouse
• Data Warehousing Buyer's Guide
• Advances in Data Warehouse Performance
• Data Warehouses: What are they and how will they benefit your organization?
• Spend Data Warehouse on Steroids
• More White Papers

---

Web Seminars

• Measuring Data Warehouse Performance: WinterCorp's Analysis of the HP Oracle Exadata Storage Server
• More Web Seminars

---

Books

• Implementing Enterprise Data Warehousing
• The Power of IT: Survival Guide for the CIO
• Implementing a Data Warehouse: A Methodology that Worked
• Professional SQL Server 2005 Programming (Programmer to Programmer)
• Joe Celko's Analytics and OLAP in SQL (The Morgan Kaufmann Series in Data Manage
• More Books