Star Schema Mining

A star schema is the simplest style of data warehouse schema. A star schema consists of one or more fact tables referencing any number of dimension tables. A fact table holds the main data; a dimension table contains attributes that describe data in the fact table.

In this cue card set we use a very simple star schema consisting of one fact table SH.SALES and one dimension table SH.CUSTOMERS.

These cue cards show how you can use Data Miner to prepare data stored in a star schema so that the data can be mined.

This cue card set shows how to:

The workflow builds classification models to predict customer gender based on sales history.

cue cards icon Launch the cue cards to learn how to aggregate data in a table and join tables.