Business Intelligence Tutorial
DB2 Universal Database offers the Data Warehouse Center, a DB2
component that automates warehouse processing. You can use the Data
Warehouse Center to define which data to include in the warehouse.
Then, you can use the Data Warehouse Center to automatically schedule
refreshes of the data in the warehouse.
This tutorial covers the most common tasks that are required to set up a
warehouse.
In this tutorial, you will:
- Define a subject area that identifies and groups the processes
that you will create for the tutorial.
- Explore the source data (which is the operational data) and define
warehouse sources. Warehouse sources identify the source
data that you want to use in your warehouse
- Create a database to use as the warehouse and define warehouse
targets, which identify the target data to include in your
warehouse.
- Specify how to move and transform the source data into its format for the
warehouse database. You will define a process, which
contains the series of movement and transformation steps required to produce a
target table in the warehouse from one or more source tables, views, or
files. You will then divide the process into steps, each of
which defines one operation in the movement and transformation process.
Then you will test the steps that you defined and schedule them to run
automatically.
- Administer the warehouse by defining security and monitoring database
usage.
- Create an information catalog of the data in the warehouse if you have
installed the DB2 Warehouse Manager package. An information
catalog is a database that contains business metadata that helps users
identify and locate data and information that is available to them in the
organization. End users of the warehouse can search the catalog to
determine which tables to query.
- Define a star schema model for the data in the warehouse. A
star schema is a specialized design that consists of multiple
dimension tables, which describe aspects of a business, and one
fact table, which contains the facts about the business. For
example, if you manufacture soft drinks, some dimension tables are products,
markets, and time. The fact table might contain transaction information
about the products that are ordered in each region by season.
- You can join the fact table and dimension tables to combine details from
the dimension tables with the order information. For example, you might
join the product dimension with the fact table to add information about how
each product was packaged to the orders.
[ Top of Page | Previous Page | Next Page | Table of Contents ]