Please enable JavaScript.

Coggle requires JavaScript to display documents.

Data Warehousing (assignment (ch2: (why data warehouse is necessary (poor…

- - - - several db > differ db is best for differ people
      - poor data quality
        
        duplicate; incompatible with each other
      - local optimisation > global
    - - Executive & manager levels
        
        • Formulate business strategy
        • Establish goals
        • Set objectives
        • Monitor results
    - - Strategic info
        
        Integrated
        A single view of the firm. An Enterprise wide view
        Data Integrity
        Accurate and conform to business rules
        Accessible
        Easily accessible, intuitive access, responsive analysis
        Credible
        Trusted values – every business value has ≡ 1 value
        Timely
        Must be available with the correct timeliness for the data
  - - - star schema diagram
        
        different data formats
        
        different db management sys
  - - - mainly standards
        
        most profitable products: unit sales, dollar sales, margin + store loc/each month [previous year]
        
        most profitbale loc
        
        most fitable time peroid
        
        key customers: age group & suburb << unit sales, dollar sales, margin + time periods
      - concerns
        
        open store on sundays
        
        locates the most profitable products in prominent places in stores
        
        two new store locs + expand the floor space in existing stores