Business Intelligence Tutorial

Tutorial business problem

You are a database administrator for a company that is called TBC: The Beverage Company. The company manufactures beverages for sale to other businesses. The financial department wants to track, analyze, and forecast the sales revenue across geographies on a periodic basis for all products sold. You have already set up standard queries of the sales data. However, these queries add to the load on your operational database. Also, users sometimes ask for additional ad-hoc queries of the data, based on the results of the standard queries.

Your company has decided to create a data warehouse for the sales data. A data warehouse is a database that contains data that has been cleansed and transformed into an informational format. Your task is to create this data warehouse.

You plan to use a star schema design for your warehouse. A star schema is a specialized design that consists of multiple dimension tables, and one fact table. Dimension tables describe aspects of a business. The fact table contains the facts or measurement about the business. In this tutorial, the star schema includes the following dimensions:

The facts in the fact table include orders of the products over a period of time.

The Data warehousing part of this tutorial shows you how to define this star schema.

Your next task is to create an OLAP application to analyze your data. You first create an OLAP model and metaoutline, and then use them to create the application. The Multidimensional Analysis part of this tutorial shows you how to create an OLAP application.


[ Top of Page | Previous Page | Next Page | Table of Contents ]