Business Intelligence Tutorial

Table of Contents

About the tutorial
Tutorial business problem
Before you begin
Conventions that are used in this tutorial
Related information

---

Data Warehousing

Lesson 1. About data warehousing
What is data warehousing?
Lesson overview

Lesson 2. Creating a warehouse database
Creating a database
Registering a database with ODBC
Connecting to the target database
What you just did

Lesson 3. Browsing the source data
Viewing table data
Viewing file data
What you just did

Lesson 4. Defining warehouse security
Reinitializing the warehouse control database
Starting the Data Warehouse Center
Defining a warehouse user
Defining the warehouse group
What you just did

Lesson 5. Defining a subject area
Defining the TBC Tutorial subject area
What you just did

Lesson 6. Defining warehouse sources
Defining a relational warehouse source
Defining a file source
What you just did

Lesson 7. Defining warehouse targets
Defining a warehouse target
What you just did

Lesson 8. Defining data transformation and movement
Defining a process
Opening the process
Adding tables to a process
Adding steps to the process
What you just did
Defining the rest of the star schema (optional)
What you just did

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

Lesson 10. Scheduling warehouse processes
Specifying that the steps are to run in sequence
Scheduling the first step
Promoting the steps to production mode
What you just did

Lesson 11. Defining keys on target tables
Defining a primary key
Defining a foreign key
What you just did

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

Lesson 13. Authorizing users to the warehouse database
Granting privileges
What you just did

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

Lesson 15. Working with business metadata
Opening the information catalog
Browsing subjects
Searching the information catalog
Creating a collection of objects
Starting a program
What you just did

Lesson 16. 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

Lesson 18. About multidimensional analysis
What is multidimensional analysis?
Lesson overview

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

Lesson 20. Selecting the fact table and creating dimensions
Selecting the fact table
Creating the time dimension
Creating the standard dimensions
What you just did

Lesson 21. Joining and editing dimension tables
Editing dimension tables
What you just did

Lesson 22. Defining hierarchies
Creating hierarchies
Previewing hierarchies
What you just did

Lesson 23. Previewing and saving the OLAP Model
What you just did

Lesson 24. Starting the OLAP metaoutline
Starting the Metaoutline Assistant
Connecting to the source database
What you just did

Lesson 25. Selecting dimensions and members
What you just did

Lesson 26. Setting properties
Setting dimension properties
Setting member properties
Examining account properties
What you just did

Lesson 27. Setting filters
Reviewing filters
What you just did

Lesson 28. Creating the OLAP application
What you just did

Lesson 29. 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