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

Content with tag Design and Theory Rss

<< Newer    Items 61 to 80 of 144    Older >>
 

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,816 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,223 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,393 reads

What is a zettabyte?

By Steve Jones 2007/03/14 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 1,640 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,088 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,425 reads

What's an allocation unit?

By Steve Jones 2007/02/02 | Category: design and theory
Rating: (not yet rated) |  Discuss |   Briefcase | 1,466 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,889 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 | 25,245 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,844 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,284 reads

Data Warehouse Loading

Data warehousing is becoming more and more popular, especially as companies seek to leverage the information stored in various systems to improve their business processes. Warehousing expert Vincent Rainardi brings us the next installment of his series on data warehousing, examining the issues of loading data.   Read more...
By Vincent Rainardi 2006/10/24 | Source: SQLServerCentral.com | Category: design and theory
Rating: |  Discuss |   Briefcase | 13,761 reads

Analysis: Where Rules Management and BPM Meet

Is your company trying to accelerate cycle times, lower costs, improve responsiveness, ensure compliance with policies and best practices, and increase customer satisfaction? Well, of course! That's why you need a comprehensive approach to managing your organization's business rules  Read more...
Rating:  Rate this |   Briefcase | 2,112 reads

Business Intelligence in SQL Server 2005, Part 1

This article takes a look at SQL Server 2005 Reporting Solutions as applied to Business Intelligence systems.  Read more...
By Additional Articles 2006/09/20 | Source: Red-Gate | Category: design and theory
Rating:  Rate this |   Briefcase | 2,652 reads

Data Quality

What is data quality? How do you measure it and how does it affect your data warehouse? SQL Server warehousing expert Janet Wong brings us a look at what data quality is and what it means to you.   Read more...
By Janet Wong 2006/09/18 | Source: SQLServerCentral.com | Category: design and theory
Rating: |  Discuss |   Briefcase | 8,345 reads
<< Newer    Items 61 to 80 of 144    Older >>
 
Tags
data warehousing (58)    
analysis services (ssas) (7)    
t-sql (4)    
olap server (3)    
business intelligence (2)    
career (2)    
editorial (2)    
sql server 2005 (2)    
table information (2)    
basics (1)    
database design (1)    
development (1)    
dts (1)    
editorial - ipod (1)    
editorial - wmv (1)    
integration services (ssis) (1)    
mdx (1)    
miscellaneous (1)    
normalisation (1)    
numa (1)    
product reviews (1)    
reporting services (ssrs) (1)    
reviews (1)    
sql server 7 (1)    
transaction logs (1)