Ísis Santos Costa’s Reviews > The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling > Status Update
Ísis Santos Costa
is on page 473 of 608
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
— 3 hours, 17 min ago
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
Like flag
Ísis’s Previous Updates
Ísis Santos Costa
is on page 484 of 608
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
— 1 hour, 35 min ago
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
Ísis Santos Costa
is on page 476 of 608
p. 442
18 • Dimensional Modeling Process and Tasks (cont.)
↳ Design the Dimensional Model (cont.)
... ↳ Review and Validate the Model
... ... ↳ IT Reviews
... ... ↳ Core User Review
... ... ↳ Broader Business User Review
... ↳ Finalize the Design Documentation
— 3 hours, 13 min ago
18 • Dimensional Modeling Process and Tasks (cont.)
↳ Design the Dimensional Model (cont.)
... ↳ Review and Validate the Model
... ... ↳ IT Reviews
... ... ↳ Core User Review
... ... ↳ Broader Business User Review
... ↳ Finalize the Design Documentation
Ísis Santos Costa
is on page 468 of 608
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
— Dec 20, 2025 06:10PM
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
Ísis Santos Costa
is on page 462 of 608
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
— Nov 01, 2025 03:54PM
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
Ísis Santos Costa
is on page 462 of 608
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
— Nov 01, 2025 03:54PM
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
Ísis Santos Costa
is on page 460 of 608
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
— Nov 01, 2025 03:43PM
Kimball DW/BI Lifecycle Overview
↳ Lifecycle BI Applications Track
...↳ BI Application Specification
...↳ BI Application Development
↳ Lifecycle Wrap-up Activities
...↳ Deployment
...↳ Maintenance and Growth
Ísis Santos Costa
is on page 456 of 608
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
— Nov 01, 2025 03:39PM
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
Ísis Santos Costa
is on page 454 of 608
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
— Nov 01, 2025 03:35PM
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
Ísis Santos Costa
is on page 453 of 608
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.
— Nov 01, 2025 03:32PM
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.
Ísis Santos Costa
is on page 453 of 608
p. 414
Kimball DW/BI Lifecycle Overview (cont.)
↳ Business Requirements (cont.)
...↳ Prioritizing Requirements
— Nov 01, 2025 03:25PM
Kimball DW/BI Lifecycle Overview (cont.)
↳ Business Requirements (cont.)
...↳ Prioritizing Requirements
