Ísis Santos Costa’s Reviews > The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling > Status Update

p. 450
19 • ETL Subsystems and Techniques
↳ Round Up the Requirements
... ↳ Biz Needs
... ↳ Compliance
... ↳ Data Quality
... ↳ Security
... ↳ Data Integration
... ↳ Data Latency
... ↳ Archiving and Lineage
... ↳ BI Delivery Interfaces
... ↳ Available Skills
... ↳ Legacy Systems
↳ The 34 Subsystems of ETL
... ↳ Group 1: Extracting
... ↳ Group 2: Cleaning & Conforming
... ↳ Group 3: Delivering
... ↳ Group 4: Managing

p. 439
18 • Dimensional Modeling Process and Tasks (cont.)
↳ Design the Dimensional Model
... ↳ Reach Consensus on High-Level Bubble Chart
... ↳ Develop the Detailed Dimensional Model
... ... ↳ Identify Dims & their Attributes
... ... ↳ Identify the Facts
... ... ↳ Identify Slowly Changing Dimension Techniques
... ... ↳ Document the Detailed Table Designs
... ... ↳ Track Model Issues
... ... ↳ Maintain Updated Matrix

p. 434
Dimensional Modeling Process and Tasks
↳ Modeling Process Overview
↳ Get Organized
... ↳ Identify Participants, Especially Business Representatives
... ↳ Review the Business Requirements
... ↳ Leverage a Modeling Tool
... ↳ Leverage a Data Profiling Tool
... ↳ Leverage or Establish a Naming Convention
... ↳ Coordinate Calendars and Facilities

p. 428
Kimball DW/BI Lifecycle Overview
↳ Common Pitfalls Auto Avoid
...↳ 6 Make back room performance > ease of use
...↳ 7 Invest time in normalizing instead of building dimensional models
...↳ 8 Galactic multi-year project
...↳ 9 Lack a business senior management visionary as business sponsor
...↳ 10 Love tech & data instead of business' requirements and goals

p. 428
Kimball DW/BI Lifecycle Overview
↳ Common Pitfalls Auto Avoid
...↳ 1 Neglect business acceptance
...↳ 2 Presume requirements are static
...↳ 3 Load only summarized data
...↳ 4 Standalone dim. modeling w/o Data Architecture & conformed dim.
...↳ 5 Make supposedly queryable data overly complex

p. 426
Kimball DW/BI Lifecycle Overview
↳ Lifecycle BI Applications Track
...↳ BI Application Specification
...↳ BI Application Development
↳ Lifecycle Wrap-up Activities
...↳ Deployment
...↳ Maintenance and Growth

p. 422
Kimball DW/BI Lifecycle Overview
↳ Lifecycle Data Track
...↳ Dimensional Modeling
...↳ Physical Design
......↳ Develop Naming and Database Standards
......↳ Develop Physical Database Model
......↳ Develop Initial Index Plan
......↳ Design Aggregations, Including OLAP Database
......↳ Finalize Physical Storage Details
...↳ ETL Design and Development

p. 420
Kimball DW/BI Lifecycle Overview
↳ Lifecycle Technology Track
...↳ Product Selection and Installation
......↳ Understand the Corporate Purchasing Process
......↳ Develop a Product Evaluation Matrix
......↳ Conduct Market Research
......↳ Evaluate a Short List of Options
......↳ If Necessary, Conduct a Prototype
......↳ Select Product, Install on Trial, and Negotiate

p. 418
Kimball DW/BI Lifecycle Overview
↳ Lifecycle Technology Track
...↳ Technical Architecture Design
......↳ Establish an Architectural Task Force
......↳ Collect Architecture-Related Requirements
......↳ Document Arc. Requirements
......↳ Create the Arc. Model
......↳ Determine Arc. Implementation Phases
......↳ Design & Specify Subsystems
......↳ Create the Arc. Plan
......↳ Review & Finalize the Technical Arc.

p. 414
Kimball DW/BI Lifecycle Overview (cont.)
↳ Business Requirements (cont.)
...↳ Prioritizing Requirements