| MUET / Departments / Computer Systems & Software Engineering / Course of SW /DWH |  |
DATA WARE HOUSE Theory (100) Practical (50) INTRODUCTION TO BASICS OF DATA WAREHOUSE Decision support systems, operational and analytical Processing, Data warehouse, data mart, Environment for Data Access, Architecture, Technical Infrastructure, Source and Target Data, Levels of Users, Classes of Tools, DSS Applications Data Conversion tools, Meta Data, Star Schema, Hierarchies, Granularity, Database gateway, Decision Support Development Cycle. ARCHITECTURE AND INFRASTRUCTURE Data Warehouse Architecture and its characteristics, Expanding the Generic Data Warehouse architecture, Relationship fo Architecture and Infrastructure. CRITICAL SUCCESS FACTORS Data warehouse incorporates, Operational and historical data, Periodic updates, Service levels, Interactive exploration of information by end-user, database structures, Total organization view DSS support, Fraud detection, target marketing, Profitability analysis, customer retention, inventory management, credit risk analysis, long term value assessment, pricing, key critical success factors. DECISION SUPPORT LIFE CYCLE Life cycle for systems development, DSLC in architected environment, The phases of DSLC. DATA WAREHOUSE DEVELOPMENT Pilot project proof, choosing a area for data warehouse development, Successful data warehouse. GATHERING DATA REQUIREMENT Proper mindset, User interviews, Facilitation via alignment, Developing data model dimensional business model, logical data model. DATA INTEGTRATION Introduction, Metamorphosis of information to data, Data integration, Data architecture, Meta Data, Data integration process, Data sourcing, Data consolidation and its processes, Data analysis for data consolidation, Data conversion, Data Pollution. DESIGNING DATA BASE FOR DATA WAREHOUSE Decision Support Databases, Star Schema database design, Varieties of Star schema, A Salad dressing Aggregation, Demoralization, Data warehouse design examples. DATA ACCESS Data access, Types of Data access, User levels, Data access characteristics, Classes of Tools, Tool Selection NOTE: PRACTICAL WILL BE BASED ON THEORY RECOMMENDED BOOKS
[1] Building Data Warehouse for Decision Support, 2nd Edition, By: Vidette Poe, patricia Klauer, Stephen Brobst. [2] Planning and Designing The Data warehouse, by: Romon Barquin, Herb Edelstein. [3] Understanding and Implementing Successful Data Mart, by: Douglas Hackney.
|
