Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Design and Theory, Data Warehousing Rss

   Items 1 to 20 of 61    Older >>
 

The Flaws of the Classic Data Warehouse Architecture, Part 1

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.  Read more...
By Additional Articles 2009/03/20 | Source: B-Eye | Category: data warehousing
Rating:  Rate this |   Briefcase | 5,498 reads

Problems In Building a Data Warehouse

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...
By Janet Wong 2007/03/05 | Source: SQLServerCentral.com | Category: design and theory
Rating: |  Discuss |   Briefcase | 7,079 reads

Using Data Warehouse for CRM

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...
By Vincent Rainardi 2007/02/07 | Source: SQLServerCentral.com | Category: design and theory
Rating: |  Discuss |   Briefcase | 8,410 reads

The Dynamic Process of Loading Data

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...
By Janet Wong 2007/01/23 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 9,887 reads

Building a Quality BI Framework Solution Starts with a Quality ETL Sol

Developing an effective solution requires quality within and across all components of the BI architecture.   Read more...
By Additional Articles 2007/09/20 | Source: Datawarehouse.com | Category: design and theory
Rating:  Rate this |   Briefcase | 2,444 reads

Best-Practice Analytic Architecture to Support Business Strategy

A primary objective of any analytic architecture is business enablement - the ability to provide business users with access to quality information that can be used to drive decision-making.  Read more...
By Additional Articles 2007/09/06 | Source: Datawarehouse.com | Category: design and theory
Rating:  Rate this |   Briefcase | 2,008 reads

BI Has Left the Building

Smart CFOs and CIOs should consider making mobile BI available to employees as a way to improve productivity, extend BI adoption and improve operational efficiencies.   Read more...
By Additional Articles 2007/08/31 | Source: Datawarehouse.com | Category: design and theory
Rating:  Rate this |   Briefcase | 2,440 reads

Data Warehousing: Ensuring Data Integrity with End-to-End and Statisti

This article provides an architecture and process framework to ensure data quality in a data warehousing environment.  Read more...
By Additional Articles 2007/08/02 | Source: Datawarehouse.com | Category: design and theory
Rating:  Rate this |   Briefcase | 1,498 reads

Data is at the Heart of Enterprise-Wide BI and DW

At the core of an enterprise BI/DW program is the data that is being made available to the business users who are looking to make better decisions using this information. Properly managing this information is the most critical activity of the enterprise BI team.  Read more...
Rating:  Rate this |   Briefcase | 1,815 reads

Bridging the Impedance Mismatch Between Business Intelligence and Serv

Business intelligence (BI) and service-oriented architecture (SOA) have conflicting principles and needs. This article will show you how to make peace between them.  Read more...
By Additional Articles 2007/06/11 | Source: MSDN Communities | Category: design and theory
Rating:  Rate this |   Briefcase | 5,819 reads

Introduction to Data Warehousing Part 1

In Part 1 of this extensive series, Wes Dumey starts some of the core concepts of data warehousing. In this video he covers what a data warehouse is, why companies use them and what are some of the key components.  Read more...
By Additional Articles 2007/03/21 | Source: JumpStartTV | Category: design and theory
Rating:  Rate this |   Briefcase | 3,324 reads

More Problems with Data Warehousing

In response to the first part, new author Richard Gardner brings us a few more issues that you should be aware of when planning your data warehouse.   Read more...
By Richard Gardner 2007/03/20 | Source: SQLServerCentral.com | Category: design and theory
Rating: |  Discuss |   Briefcase | 5,815 reads

Mastering Enterprise BI: Time Intelligence Pt. II

BI Architect Bill Pearson continues his introduction to enhanced features in Analysis Services 2005 for Time Intelligence support. In this session, we examine new, wizard-driven features that support the easy addition of Time Intelligence within our cube.  Read more...
By Additional Articles 2007/03/20 | Source: Database Journal | Category: design and theory
Rating:  Rate this |   Briefcase | 2,212 reads

Designing A Data Warehouse: Part 1 Dimension Types

In this first part of a multiple part series, Brian Knight shows the different types of slowly changing dimensions you'll use and the business reason for using each type.   Read more...
By Additional Articles 2007/03/19 | Source: JumpStartTV | Category: design and theory
Rating:  Rate this |   Briefcase | 4,382 reads

Problems In Building a Data Warehouse

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...
By Janet Wong 2007/03/05 | Source: SQLServerCentral.com | Category: design and theory
Rating: |  Discuss |   Briefcase | 7,079 reads

Using Data Warehouse for CRM

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...
By Vincent Rainardi 2007/02/07 | Source: SQLServerCentral.com | Category: design and theory
Rating: |  Discuss |   Briefcase | 8,410 reads

The Dynamic Process of Loading Data

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...
By Janet Wong 2007/01/23 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 9,887 reads

Populating Fact Tables

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...
By Vincent Rainardi 2007/01/02 | Source: SQLServerCentral.com | Category: design and theory
Rating: |  Discuss |   Briefcase | 24,962 reads

Avoiding the Metadata Pitfalls

By doing a bit of groundwork and effectively controlling the scope of the metadata repository continuously throughout the project, few problems should arise.  Read more...
By Additional Articles 2006/11/27 | Source: Datawarehouse.com | Category: design and theory
Rating:  Rate this |   Briefcase | 1,838 reads

Kimball University: Four Fixes Refurbish Legacy Data Warehouses

DW/BI professionals are often tasked with making evolutionary upgrades and improvements to minimize cost and upheaval in the current analytic environment. We explore four upgrades that can breathe new life into legacy data warehouses.  Read more...
Rating:  Rate this |   Briefcase | 2,272 reads
   Items 1 to 20 of 61    Older >>
 
Tags
analysis services (ssas) (5)    
olap server (3)    
basics (1)    
database design (1)    
development (1)    
dts (1)    
integration services (ssis) (1)    
miscellaneous (1)    
product reviews (1)    
reporting services (ssrs) (1)    
reviews (1)    
sql server 2005 (1)    
sql server 7 (1)