Data Warehousing

Article

Recently, I was at a conference, and I heard the following discussion about what a data warehouse was. One person suggested that a data warehouse was really all the old legacy systems connected by software that could access the data. By calling such a contraption a data warehouse, the organization could avoid having to do the hard and complex work of integration. There are so many problems with this federated approach to a data warehouse that they are almost not worth repeating here. But (once again!) here goes.

2009-11-09

6,637 reads

Kimball University: Six Key Decisions for ETL Architectures

by Additional Articles

Intelligent Enterprise

Data Warehousing

Article

Best-practice advice on software vs. coding, where to integrate, how to capture changed data, when to stage data, where to correct data and what latency levels to shoot for.

2009-10-20

4,926 reads

Energy Intelligence

by Additional Articles

DMReview

Data Warehousing

Article

Given that companies spend on average between 7 and 12 percent of their annual budgets on energy – a focus on reducing energy consumption can have significant bottom-line impact

2009-09-30

3,575 reads

How to Calculate Data Warehouse Reliability

by Additional Articles

DMReview

Data Warehousing

Article

This article outlines a more objective and analytical approach to the ETL and data flow architecture selection based on a set of variables with an objective to enhance the reliability of the overall data warehousing solution.

2009-09-29

4,823 reads

Ten Pitfalls In Establishing An Enterprise Architecture

by Additional Articles

Intelligent Enterprise

Data Warehousing

Article

Avoiding getting snared in these traps avoids having to spend a lot of money later to fix problems, Gartner says. In addition, EA benefits can be realized faster and the risk of program failure is reduced.

2009-09-23

4,327 reads

Implementing a SQL Server Fast Track Data Warehouse

by Additional Articles

Microsoft MSDN

Data Warehousing

Article

This paper defines a reference configuration model (known as SQL Server Fast Track Data Warehouse) and a CPU core-balanced approach to implementing a symmetric multiprocessor (SMP)-based SQL Server data warehouse with proven performance and scalability expectations for sequential I/O data workloads.

2009-09-04

4,268 reads

Kimball University: Five Alternatives for Better Employee Dimension Modeling

by Additional Articles

SQLServerCentral.com

Data Warehousing

Article

The employee dimension presents one of the trickier challenges in data warehouse modeling. These five approaches ease the complication of designing and maintaining a 'Reports To' hierarchy for ever-changing reporting relationships and organizational structures.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-08-26

3,651 reads

Introduction to Fast Track Data Warehouse Architectures

by Additional Articles

TechNet Blogs

Data Warehousing

Article

This paper provides an overview and guide to SQL Server® Fast Track Data Warehouse, a new set of reference architectures created for scale-up (SMP) SQL Server based data warehouse solutions. It includes a summary of the resources available in the reference configuration, the distinguishing features of the approach, and the steps necessary to take full advantage of the new architectures.

2009-06-26

4,002 reads

Kimball University: A Data Warehousing Fitness Program for Lean Times

by Additional Articles

Intelligent Enterprise

Data Warehousing

Article

How can you do more with less? Follow this data warehousing/BI strengthening regimen to cut cost, avoid expenditures and bulk up the bottom line.

2009-03-24

2,851 reads

The Flaws of the Classic Data Warehouse Architecture, Part 1

by Additional Articles

B-Eye

Data Warehousing

Article

Visit ten randomly picked customers that own a data warehouse architecture, and you will see that at least eight have developed a classic data warehouse architecture (CDWA). What do I mean by a CDWA? In a CDWA, data is copied periodically from production systems to the central data warehouse.

2009-03-20

6,058 reads

Data Warehousing

What a Data Warehouse is Not

Kimball University: Six Key Decisions for ETL Architectures

Energy Intelligence

How to Calculate Data Warehouse Reliability

Ten Pitfalls In Establishing An Enterprise Architecture

Implementing a SQL Server Fast Track Data Warehouse

Kimball University: Five Alternatives for Better Employee Dimension Modeling

Introduction to Fast Track Data Warehouse Architectures

Kimball University: A Data Warehousing Fitness Program for Lean Times

The Flaws of the Classic Data Warehouse Architecture, Part 1

Blogs

The Data API Builder Start and Add Extensions in VS Code

Using OneLake for Excel Files in Microsoft Fabric

Another AI Faux Pax

Forums

AD, powershell and ssis

File date from Extended Event .xel files

SSMS gets very messy

Question of the Day

Sparse Column Defaults