<< 1 >>
Rating: 
Summary: Building a Data Warehouse Using SAS/ Warehouse Administrator
Review: This is the course guide that accompanies the instructor-based training course offered by the SAS Institute. The course guide serves an excellent desk reference and provides detailed step-by-step exercises that can be completed outside the course itself. The manual includes 12 sections with chapter exercises and summaries and an appendix. Section 1 Introduction to Data Warehousing has: evolution of data warehousing, modeling the warehouse and implementation tasks. Section 2 Introduction to SAS/Warehouse Administator Software has: overview of SAS/Warehouse Administrator software, logical organization, primary interfaces, and steps for implementing the warehouse. Section 3 Case Study includes: introduction, SAS rapid data warehouse methodology, assessment, requirements, and design. Section 4 Getting Started with SAS/Warehouse Administrator Software includes: implementation tasks, the SAS desktop, defining warehouse environments, shared metadata, notes and icons, and cast study. Section 5 Operational Data Defnitions has: implementation tasks, operational data definitions groups, operational data definitions, and case study. Section 6 Data Warehouse and Subjects includes: implementation tasks, defining warehouses, and defining subjects. Section 7 Detail Tables and Data Tables has: implementation tasks, defining detail logical tables, defining detail and data tables, and defining detail logical tables as views. Section 8 Understanding the Process Editor has: implementation tasks, introduction, input sources for ODDs, case study dimension tables, data mappings, data transfers, building the process flows, case study data and fact table, user exits, and record selectors. Section 9 Loading Detail Tables with the Process Editor includes: implementation tasks, load process attributes, loading detail tables, and loading detail logical tables. Section 10 Summary Groups, Summary Tables, and MDDBs has: implementation tasks, introduction, summary groups, summary tables, and summary MDDBs. Section 11 Information Marts has: implementation tasks, information marts, information mart items, and information mart files. Section 12 Exploring and Exporting Metadata includes: introduction, exploring metadata, and exporting metadata. The manual is well organized and illustrated and very user-friendly.
<< 1 >>
| 
