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

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

p. 414
Kimball DW/BI Lifecycle Overview
↳ Business Requirements
...↳ Requirements Preplanning
......↳ Choose the Forum
......↳ Identify and Prepare the Requirements Team
......↳ Select, Schedule, and Prepare Business Representatives
...↳ Collecting Business Requirements
......↳ Launch
......↳ Interview Flow
......↳ Wrap-up
...↳ Conducting Data-Centric Interviews
...↳ Documenting Requirements