Í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
↳ 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

p. 410
« You don't ask business representatives about the granularity or dimensionality of their critical data. You need to talk to them about what they do, why they do it, how they make decisions, and how they hope to make decisions in the future. Like organizational therapy, you're trying to detect the issues and opportunities. »