Search
Channels
Featured Web Seminars 
White Papers
Advertisement
Information Center
Product Center
Reader Services
Sign up today and access Information Management on the web!
Your FREE registration entitles you to:
FREE email newsletters
FREE access to all Information Management content
FREE access to web seminars, resource portals, our white paper library and more!
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.
Articles
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 others 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?
Columns
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 months column, Ill 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
Ill suggest areas where information management leaders can look to build a leadership foundation.
White Papers
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
Books
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
Advertisement
Channel Resources
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
Advertisement

