Datawarehouse Design (1)

The first stage of designing a data warehouse is to define what information is needed by management . In order for this requirement can be defined precisely, then an understanding of the role and management tasks that require such information absolutely must be done first. If it has been understood, then we just stayed “answer” to the following questions:

  • Who needs information from the data warehouse?
  • What information is needed it?
  • What kind of layout and content of that information?
  • When will this information be used?
  • For what purposes?
  • What is the source for that information?

For example, suppose that would be made a sales data warehouse (or data mart sales exact) for a trading company.

  • Who needs information from the data warehouse?
    Marketing Manager
  • What information is required Marketing Manager?
    What items most sold in certain locations throughout the year
    What goods where most revenue during the year
  • What kind of layout and content of that information?
    Goods of the most widely sold in certain locations throughout the year

Goods where most revenue during the year

  • For what purpose such information?
    Basis for determining the strategy of selling goods
  • When will this information be used?
    Initial sales period
  • When will this information be used?
    Initial sales period
  • The database is what is the source for that information?
    Sales data base with the following scheme:
    1. Goods (# code, name, groups, units, price)
    2. Category (# group, sub_kategori, category)
    3. Customer (# cust_code, name_cust, address, city, zip_code, phone)
    4. Location (# zip_code, village, district)
    5. Sales (# no_faktur, # goods_code, qty)
    6. Payments (# no_faktur, date, total, discount, # cust_code)

To be continued …

Tagged: ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: