Business Intelligence Tutorial

Contents

  • Contents

  • About the tutorial
    Tutorial business problem
    Before you begin
    Conventions that are used in this tutorial
    Related information
    Contacting IBM
    Product Information

    Data Warehousing

  • About data warehousing
    What is data warehousing?
    Lesson overview

  • Creating a warehouse database
    Creating a database
    Registering a database with ODBC
    Connecting to the target database
    What you just did

  • Browsing the source data
    Viewing table data
    Viewing file data
    What you just did

  • Defining warehouse security
    Specifying the warehouse control database
    Starting the Data Warehouse Center
    Defining a warehouse user
    Defining the warehouse group
    What you just did

  • Defining a subject area
    Defining the TBC Tutorial subject area
    What you just did

  • Defining warehouse sources
    Updating the TBC sample sources
    Defining a relational warehouse source
    Defining a file source
    What you just did

  • Defining warehouse targets
    Defining a warehouse target
    Defining a target table
    Adding columns to the target table
    What you just did

  • Defining data transformation and movement
    Defining a process
    Opening the process
    Adding tables to a process
    Adding the SAMPLETBC.GEOGRAPHIES table to the process
    Adding steps to the process
    Defining the Load Demographics Data step
    Defining the Select Geographies step
    Selecting columns from the Geographies source table
    Creating the GEOGRAPHIES_TARGET table
    Specifying properties for the GEOGRAPHIES_TARGET table
    Defining the Join Market Data step
    What you just did
    Defining the rest of the tables for the star schema (optional)
    What you just did

  • Testing warehouse steps
    Testing the Load Demographics Data step
    Promoting the rest of the steps in the star schema (optional)
    What you just did

  • Scheduling warehouse processes
    Running steps in sequence
    Scheduling the first step
    Promoting the steps to production mode
    What you just did

  • Defining keys on target tables
    Defining a primary key
    Defining a foreign key
    Defining foreign keys in the Data Warehouse Center
    What you just did

  • Maintaining the data warehouse
    Creating an index
    Collecting table statistics
    Reorganizing a table
    Monitoring a database
    What you just did

  • Authorizing users to the warehouse database
    Granting privileges
    What you just did

  • Cataloging data in the warehouse for end users
    Creating the information catalog
    Selecting metadata to publish
    Updating published metadata
    What you just did

  • Working with business metadata
    Opening the information catalog
    Browsing subjects
    Searching the information catalog
    Creating a collection of objects
    Starting a program
    Creating a Programs object
    Starting the program from a Files object
    What you just did

  • Creating a star schema from within the Data Warehouse Center
    Defining a star schema
    Opening the schema
    Adding tables to the schema
    Autojoining the tables
    Exporting the star schema
    What you just did

  • Summary

    Multidimensional data analysis

  • About multidimensional analysis
    What is multidimensional analysis?
    Lesson overview

  • Starting the OLAP model
    Starting the OLAP Integration Server desktop
    Connecting to the OLAP catalog
    Starting the Model Assistant
    What you just did

  • Selecting the fact table and creating dimensions
    Selecting the fact table
    Creating the time dimension
    Creating the standard dimensions
    What you just did

  • Joining and editing dimension tables
    Editing dimension tables
    What you just did

  • Defining hierarchies
    Creating hierarchies
    Previewing hierarchies
    What you just did

  • Previewing and saving the OLAP Model
    What you just did

  • Starting the OLAP metaoutline
    Starting the Metaoutline Assistant
    Connecting to the source database
    What you just did

  • Selecting dimensions and members
    What you just did

  • Setting properties
    Setting dimension properties
    Setting member properties
    Examining account properties
    What you just did

  • Setting filters
    Reviewing filters
    What you just did

  • Creating the OLAP application
    What you just did

  • Exploring the rest of the Starter Kit
    Exploring the OLAP Model interface
    Exploring the OLAP Metaoutline interface
    Exploring the Administration Manager
    What you just did

  • Notices
    Trademarks