Seminaride ajakava

  • 21.09 Introduction PDF
    • motivation for warehousing
    • typical business cases
    • analyses systems (human vs. warehouse)
  • 28.09 Architecture, technology, methods PDF
    • data warehouse architecture
      • warehouse vs database
    • dimensional modelling
    • ETL (Extract, transform, load)
      • scheduling
      • checks and alarms, exception handling
    • Integration
      • common Address problem
      • slowly changing dimensions
    • Business and technical metadata
      • common warehouse metamodel (CWM)
    • User Interface - analyses, visualisation & reporting tools
  • 05.10 Seminaritöö teemade tutvustamine ja valimine
  • 12.10 Külalisesinaja Hansapangast (Indrek Heinloo - PPT)
    • datawarehousing & BI Hansapangas
    • case-study: cost allocation
    • case-study: profitability calculations
    • case-study: data stewardship, data quality assurance
  • 21.10 Asko jutt lükkus edasi
  • 28.10 Elion'i kogemustest (Remo Suurkivi - PPT)
    • Customer analytics
    • Call data records
    • Fraud detection
  • 02.11 Asko kogemused õppeinfosüsteemi DW ehitamisel

Seminaritööde tulemuste tutvustamine detsembri alguses.

edit