White Papers

Efficient "One-Row-Per-Subject" Data Mart Construction for Data Mining

Overview Creating a "One-row-per-subject" data mart is a fundamental task when preparing data for data mining. To answer the underlying business question, the analyst or data-mart programmer is challenged to distill the relevant information from various data sources. Creating a data mart involves more than reading columns from a source table to the data mart. It also includes the aggregation or transposition of observations from "Multiple-row-per-subject" tables like transactional tables and time histories. This paper shows the details of input data structures for a "One-row-per-subject" data mart. It also discusses the "One-row-per-subject" paradigm from a technical and a business point of view, and shows how data, some of which include hierarchical dependencies, is aggregated into a "Single-row-per-subject.".

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher: SAS Institute
File Format: PDF
Date Published: Dec 22, 2006
Format: White Papers
Topics: Business Intelligence - Data Warehousing, Data Mining - Analysis

Similiar White Papers

Information Architecture Essentials, Part 5: Business Intelligence in Your Information Architecture

This series explores a variety of elements that create a successful information architecture design. As one manages and

Publisher: IBM | Tags: business intelligence, data, data mining

American Airlines uses Sybase IQ to conduct fast ad hoc queries to uncover fraudulent ticketing.

American Airlines is the world?s largest carrier, serving more than 250 cities in 41 countries with 1,100 airplanes and

Publisher: Sybase | Tags: data

A Brief Tutorial on Database Queries, Data Mining, and OLAP

Modern, commercially available relational database systems now routinely include a cadre of data retrieval and analysis

Publisher: University of Rhode Island | Tags: data, data mining, database

Download Crystal Reports 2008

Try out a fully functional copy of the industry-leading software, Crystal Reports 2008, for 30 days! O

Publisher: SAP | Tags: productivity, software

What's New in SAS OLAP Cube Studio 4.2

With the release of SAS 9.2, new functionality and enhancements have been added to SAS OLAP Cube Studio 4.2. New feature

Publisher: SAS Institute | Tags: data

SAS Institute White Papers

A Clever Demonstration of the SAS SUBSTR Function

The SAS SUBSTR function differs from the substring function in other programming languages as it can be used on either s

Publisher: SAS Institute

Understanding Your Customer: Segmentation Techniques for Gaining Customer Insight and Predicting Risk in the Telecom Industry

The explosion of customer data in the last twenty years has increased the need for data mining aimed at Customer Relatio

Publisher: SAS Institute | Tags: crm, customer service, data, data mining

Featured white papers

The Value of Location Intelligence in the Communications Industry

Pitney Bowes

Public Services are under pressure, the challenge is to do more with less. How do you improve citizen satisfaction, increase cost efficiencies and improve service delivery? The power of location intelligence is helping many local authorities...

Download now »
Best Practices for Translating Customer Satisfaction into Revenue

Citrix Online

Today's support organisations are focused on two top-level metrics: financial results and customer satisfaction. For most, it's easy to track financial performance, but customer satisfaction is akin to speaking a foreign language...

Download now »
HP print solutions and 3M

Hewlett-Packard (HP)

The objective for 3M was to optimize office printing infrastructure at 3M locations worldwide, reduce total cost and environmental footprint. Some of the business benefits acheived by switching to HP print solutions...

Download now »