Article Index

  1. The 34 Subsystems of ETL (Ralph Kimball, Intelligent Enterprise, Dec 4, 2004)

A

  1. Accumulating Snapshots for Complex Workflows (Margy Ross, Design Tip #130, Dec 1, 2010)
  2. Accurate Counting with a Dimensional Supplement (Warren Thornthwaite, Design Tip #12, Aug 27, 2000)
  3. Add Uncertainty to Your Fact Table (Ralph Kimball, Design Tip #116, Sep 2, 2009)
  4. Adding a Mini-Dimension to a Bridge Table (Ralph Kimball, Design Tip #136, Jun 28, 2011)
  5. Adding an Audit Dimension to Track Lineage and Confidence (Ralph Kimball, Design Tip #26, Aug 1, 2001)
  6. Adjust Your Thinking for SANs (Ralph Kimball, Intelligent Enterprise, Mar 8, 2001)
  7. Aggregate Navigation with (Almost) No Metadata (Ralph Kimball, DBMS, Aug 1996)
  8. The Aggregate Navigator (Ralph Kimball, DBMS, Nov 1995)
  9. Alan Alda’s Interviewing Tips for Uncovering Business Requirements (Margy Ross, Intelligent Enterprise, May 1, 2005)
  10. Alternate Hierarchies (Warren Thornthwaite, Design Tip #62, Dec 7, 2004)
  11. Alternatives for Multi-Valued Dimensions (Joy Mundy, Design Tip #124, Jun 2, 2010)
  12. Another Look at Degenerate Dimensions (Bob Becker, Design Tip #46, Jun 4, 2003)
  13. The Anti-Architect (Intelligent Enterprise, Jan 14, 2002)
  14. An Architecture for Data Quality (Ralph Kimball, DM Review, Oct 2007)
  15. Are IT Procedures Beneficial to DW/BI Projects (Joy Mundy, Design Tip #129, Nov 3, 2010)
  16. Avoid Isolating DW and BI Teams (Margy Ross, Design Tip #64, Feb 8, 2005)
  17. Avoiding Alternate Organization Hierarchies (Joy Mundy, Design Tip #114, Jul 8, 2009)

B

  1. Backward in Time (Ralph Kimball, Intelligent Enterprise, Sep 29, 2000)
  2. Balancing Requirements and Realities (Margy Ross, Design Tip #125, Jun 30, 2010)
  3. Behavior: The Next Marquee Application (Ralph Kimball, Intelligent Enterprise, Apr 16, 2002)
  4. Being Offline as Little as Possible (Ralph Kimball, Design Tip #27, Apr 1, 2001)
  5. Better Business Skills for BI and Data Warehouse Professionals (Warren Thornthwaite, Intelligent Enterprise, May 11, 2008)
  6. Beware the Objection Removers (Ralph Kimball, Intelligent Enterprise, Sep 1, 2005)
  7. Beyond Paving the Cow Paths (Bill Schmarzo, Intelligent Enterprise, Nov 18, 2003)
  8. BI Components for Business Value (Warren Thornthwaite, Design Tip #151, Jan 8, 2013)
  9. The BI Portal (Warren Thornthwaite, Design Tip #58, Aug 26, 2004)
  10. Big Shifts Happening in BI (Ralph Kimball, Design Tip #60, Oct 8, 2004)
  11. Boosting Business Acceptance (Bob Becker, Intelligent Enterprise, Aug 7, 2004)
  12. The Bottom-Up Misnomer (Margy Ross, Intelligent Enterprise, Sep 17, 2003)
  13. Brace for Incoming (Warren Thornthwaite, Intelligent Enterprise, Aug 31, 2001)
  14. Brave New Requirements for Data Warehousing (Ralph Kimball, Intelligent Enterprise, Oct 1998)
  15. Bringing Up Supermarts (Ralph Kimball, DBMS, Jan 1998)
  16. The Budgeting Chain (Ralph Kimball, Intelligent Enterprise, Jun 1, 1999)
  17. Build a Ready-to-Go Resource for Enterprise Dimensions (Ralph Kimball, Design Tip #163, Feb 5, 2014)
  18. Building a Change Data Capture System (Ralph Kimball, Design Tip #63, Jan 11, 2005)
  19. Building a Foundation for Smart Applications (Joy Mundy, Intelligent Enterprise, Dec 1, 2006)
  20. Building and Delivering BI Reports (Warren Thornthwaite, Intelligent Enterprise, Apr 1, 2006)
  21. Building Bridges (Warren Thornthwaite, Design Tip #142, Feb 1, 2012)
  22. Building Custom Tools for the DW/BI System (Joy Mundy, Design Tip #94, Sep 4, 2007)
  23. Business Process Decoder Ring (Bob Becker, Design Tip #72, Oct 7, 2005)

C

  1. Call to Action for ETL Tool Providers (Warren Thornthwaite, Design Tip #122, Apr 7, 2010)
  2. Can the Data Warehouse Benefit from SOA? (Ralph Kimball, Design Tip #106, Oct 10, 2008)
  3. Catastrophic Failure (Ralph Kimball, Intelligent Enterprise, Nov 12, 2001)
  4. Causal (Not Casual) Dimensions (Ralph Kimball, DBMS, Nov 1996)
  5. Clicking with Your Customer (Ralph Kimball, Intelligent Enterprise, Jan 5, 1999)
  6. Columnar Databases: Game Changers for DW/BI Deployment (Ralph Kimball, Design Tip #121, Mar 3, 2010)
  7. Combining Periodic and Accumulating Snapshots (Ralph Kimball, Design Tip #42, Jan 7, 2003)
  8. Complementary Fact Table Types (Bob Becker, Design Tip #167, Jun 17, 2014)
  9. Complementing 3NF EDWs with Dimensional Presentation Areas (Bob Becker, Design Tip #148, Aug 1, 2012)
  10. Compliance-Enabled Data Warehouses (Ralph Kimball, Design Tip #74, Dec 16, 2005)
  11. Conformed Dimensions as the Foundation for Agile Data Warehousing (Margy Ross, Design Tip #135, Jun 1, 2011)
  12. Contain DW/BI Scope Creep and Avoid Scope Theft (Bob Becker, Design Tip #154, Apr 1, 2013)
  13. Coping with Growing Pains (Joy Mundy, Intelligent Enterprise, May 1, 2004)
  14. Coping with the Brave New Requirements (Ralph Kimball, Intelligent Enterprise, Nov 1998)
  15. Creating, Using, and Maintaining Junk Dimensions (Warren Thornthwaite, Design Tip #113, Jun 3, 2009)
  16. Creating a Reference Dimension for Infrequently Accessed Degenerates (Bob Becker, Design Tip #86, Dec 15, 2006)
  17. Creating and Managing Mini-Dimensions (Warren Thornthwaite, Design Tip #127, Sep 1, 2010)
  18. Creating and Managing Shrunken Dimensions (Warren Thornthwaite, Design Tip #137, Aug 2, 2011)
  19. Creating Historical Dimension Rows (Warren Thornthwaite, Design Tip #112, May 5, 2009)
  20. Creating the Advantages of a 64-Bit Server (Joy Mundy, Design Tip #76, Feb 9, 2006)
  21. Creating the Metadata Strategy (Warren Thornthwaite, Design Tip #75, Jan 13, 2006)

D

  1. Dangerous Preconceptions (Ralph Kimball, DBMS, Aug 1996)
  2. Dashboards Done Right (Margy Ross, Design Tip #88, Feb 21, 2007)
  3. Data Stewardship 101: The First Step to Quality and Consistency (Bob Becker, Intelligent Enterprise, Jun 2006)
  4. Data Warehouse Checkups (Margy Ross, Intelligent Enterprise, Jun 12, 2004)
  5. Data Warehouse Dining Experience (Margy Ross, Intelligent Enterprise, Jan 1, 2004)
  6. Data Warehouse Role Models (Ralph Kimball, DBMS, Aug 1997)
  7. Data Warehouse Testing Recommendations (Joy Mundy, Design Tip #134, May 4, 2011)
  8. A Data Warehousing Fitness Program for Lean Times (Bob Becker and Joy Mundy, Intelligent Enterprise, Mar 16, 2009)
  9. Data Wrangling (Ralph Kimball, DM Review, Jan 2008)
  10. The Database Market Splits (Ralph Kimball, DBMS, Sept 1995)
  11. Dealing with Data Quality: Don't Just Sit There, Do Something! (Warren Thornthwaite, Design Tip #117, Sep 30, 2009)
  12. Dealing with Dirty Data (Ralph Kimball, DBMS, Sep 1996)
  13. Dealing with Nulls in a Dimensional Model (Warren Thornthwaite, Design Tip #43, Feb 6, 2003)
  14. Declaring the Grain (Ralph Kimball, Intelligent Enterprise, Mar 1, 2003)
  15. De-Clutter with Junk Dimensions (Bob Becker, Design Tip #48, Aug 7, 2003)
  16. Design Constraints and Unavoidable Realities (Ralph Kimball, Intelligent Enterprise, Sep 3, 2002)
  17. Design Review Dos and Don’ts (Margy Ross, Design Tip #120, Feb 2, 2010)
  18. Designing the User Interface (Ralph Kimball, Intelligent Enterprise, Sep 14, 1999)
  19. Differences of Opinion (Margy Ross, Intelligent Enterprise, Mar 6, 2004)
  20. Digging into Data Mining (Ralph Kimball, DBMS, Oct 1997)
  21. Digital Preservation (Ralph Kimball, Intelligent Enterprise, Mar 1, 2000)
  22. Dimension Embellishments (Bob Becker, Design Tip #53, Mar 24, 2004)
  23. Dimension Row Change Reason Attributes (Warren Thornthwaite, Design Tip #80, Jun 1, 2006)
  24. A Dimensional Modeling Manifesto (Ralph Kimball, DBMS, Aug 1997)
  25. Dimensional Relational versus OLAP: The Final Deployment Conundrum (Ralph Kimball, Intelligent Enterprise, Apr 27, 2007)
  26. Disruptive ETL Changes (Ralph Kimball, Design Tip #126, Aug 3, 2010)
  27. Divide and Conquer (Ralph Kimball, Intelligent Enterprise, Oct 30, 2002)
  28. Dividing the World (Ralph Kimball, DM Review, Mar 2008)
  29. Document the ETL System (Joy Mundy, Design Tip #65, Mar 8, 2005)
  30. Does Your Organization Need an Analytic Sandbox? (Bob Becker, Design Tip #174, May 6, 2015)
  31. Doing the Work at Extract Time (Ralph Kimball, Intelligent Enterprise, Feb 21, 2002)
  32. Don't be Overly Reliant on Your Data Access Tool's Metadata (Bob Becker, Design Tip #44, Mar 14, 2003)
  33. Don't Forget the Owner's Manual (Joy Mundy, Intelligent Enterprise, Jul 1, 2005)
  34. Don't Support Business Intelligence with a Normalized EDW (Design Tip #34, Feb 28, 2002)
  35. Drill Down into a Detailed Bus Matrix (Margy Ross, Design Tip #41, Nov 6, 2002)
  36. Drill Down to Ask Why (Ralph Kimball, DM Review, July 2008 and Aug 2008)
  37. Drilling Down, Up, and Across (Ralph Kimball, DBMS, Mar 1996)
  38. Durable “Super-Natural” Keys (Warren Thornthwaite, Design Tip #147, Jul 10, 2012)

E

  1. Early-Arriving Facts (Ralph Kimball, Design Tip #57, Aug 2, 2004)
  2. Easier Approaches for Harder Problems (Ralph Kimball, Design Tip #131, Feb 3, 2011)
  3. Educate Management to Sustain DW/BI Success (Warren Thornthwaite, Intelligent Enterprise, Aug 27, 2007)
  4. Eight Guidelines for Low Risk Enterprise Data Warehousing (Ralph Kimball, Intelligent Enterprise, Apr 26, 2009)
  5. Eight Recommendations for International Data Quality (Ralph Kimball, Intelligent Enterprise, Aug 1, 2008)
  6. Enabling Market Basket Analysis (Ralph Kimball, Intelligent Enterprise, Apr 20, 1999)
  7. An Engineer's View (Ralph Kimball, Intelligent Enterprise, Jul 26, 2002)
  8. Enjoy the Sunset (Bob Becker, Design Tip #143, Mar 1, 2012)
  9. ERP Vendors: Bring Down Those Walls (Ralph Kimball, Intelligent Enterprise, Jun 26, 2000)
  10. Essential Steps for the Integrated Enterprise Data Warehouse (Ralph Kimball, DM Review, Apr 2008 and May 2008)
  11. The Evolving Role of the Enterprise Data Warehouse in the Era of Big Data Analytics (Ralph Kimball, White Paper Excerpt, Apr 29, 2011)
  12. An Excel Macro for Drilling Across (Ralph Kimball, Design Tip #156, Jun 2, 2013)
  13. Expanding Boundaries of the Data Warehouse (Ralph Kimball, Design Tip #141, Dec 6, 2011)
  14. Exploit Your Fact Tables (Ralph Kimball, DM Review, Jan/Feb 2009)
  15. Extreme Status Tracking for Real-Time Customer Analysis (Ralph Kimball, Intelligent Enterprise, Jun 21, 2010)

F

  1. Fables and Facts (Margy Ross, Intelligent Enterprise, Oct 16, 2004)
  2. Facing the Re-Keying Crisis (Joy Mundy, Design Tip #149, Oct 2, 2012)
  3. Fact Table Surrogate Keys (Bob Becker, Design Tip #81, Jul 6, 2006)
  4. Fact Tables (Ralph Kimball, DM Review, Dec 1, 2008)
  5. Fact Tables and Dimension Tables (Ralph Kimball, Intelligent Enterprise, Jan 1, 2003)
  6. Fact Tables for Text Document Searching (Ralph Kimball, Intelligent Enterprise, Nov 10, 2000)
  7. Factless Fact Tables (Ralph Kimball, DBMS, Sep 1996)
  8. Factless Fact Tables for Simplification (Bob Becker, Design Tip #133, Apr 5, 2011)
  9. Factless Fact Tables? Sounds Like Jumbo Shrimp? (Bob Becker and Bill Schmarzo, Design Tip #50, Oct 16, 2003)
  10. Features for Query Tools (Ralph Kimball, DBMS, Feb 1997)
  11. Final Word of the Day: Collaboration (Margy Ross, Design Tip #177, Sep 1, 2015)
  12. Fistful of Flaws (Margy Ross, Intelligent Enterprise, Oct 10, 2003)
  13. Five Alternatives for Better Employee Dimensional Modeling (Joy Mundy, Intelligent Enterprise, Aug 17, 2009)
  14. Focus on Business Processes, Not Business Departments! (Margy Ross, Design Tip #3, Jan 30, 2000)
  15. Four Fixes for Legacy Data Warehouses (Margy Ross, Intelligent Enterprise, Oct 1, 2006)
  16. Fundamental Grains (Ralph Kimball, Intelligent Enterprise, Mar 30, 1999)
  17. The Future is Bright (Ralph Kimball, Design Tip #180, Dec 1, 2015)

G

  1. Get Started with Data Mining Now (Warren Thornthwaite, Intelligent Enterprise, Oct 1, 2005)
  2. Getting Your Data Warehouse Back on Track (Margy Ross and Bob Becker, Design Tip #7, Apr 30, 2000)
  3. Going Agile? Start with Bus Matrix (Margy Ross, Design Tip #155, May 1, 2013)
  4. Graceful Modifications to Existing Fact and Dimension Tables (Ralph Kimball, Design Tip #29, Oct 15, 2001)

H

  1. Habits of Effective Sponsors (Margy Ross, Intelligent Enterprise, Sep 1, 2003)
  2. Handling All the Dates (Bob Becker, Design Tip #61, Oct 28, 2004)
  3. Have You Built Your Audit Dimensions Yet? (Ralph Kimball, Design Tip #164, Mar 3, 2014)
  4. Help for Dimensional Modeling (Ralph Kimball, DBMS, Aug 1998)
  5. Help for Hierarchies (Ralph Kimball, DBMS, Sep 1998)
  6. History Lesson on Ralph Kimball and Xerox PARC (Margy Ross, Design Tip #144, Apr 3, 2012)
  7. Hot-Swappable Dimensions (Ralph Kimball, Design Tip #16, Dec 8, 2000)
  8. Human Resources Dimensional Models (Ralph Kimball, DBMS, Feb 1998)
  9. The Hyper-Granular Active Archive (Ralph Kimball, Design Tip #165, Apr 2, 2014)

I

  1. Identify Dimension Changes Using Cyclic Redundancy Checksums (Ralph Kimball, Design Tip #4, Feb 21, 2000)
  2. Identifying Business Processes (Margy Ross, Design Tip #69, Jul 5, 2005)
  3. Implementation Analysis Paralysis (Bob Becker, Design Tip #66, Apr 11, 2005)
  4. Indicators of Quality: The Audit Dimension (Ralph Kimball, Intelligent Enterprise, Apr 10, 2000)
  5. Industry Standard Data Models Fall Short, (Margy Ross, Intelligent Enterprise, Sep 13, 2010)
  6. An Insurance Data Warehouse Case Study (Ralph Kimball, DBMS, Dec 1995)
  7. Integration for Real People (Ralph Kimball, Intelligent Enterprise, Aug 1, 2006)
  8. Involve Business Representatives in Dimension Modeling (Bob Becker, Design Tip #157, Jun 28, 2013)
  9. Is Agile Enterprise Data Warehousing an Oxymoron? (Ralph Kimball, Design Tip #111, Apr 1, 2009)
  10. Is Big Data Compatible with the Date Warehouse? (Ralph Kimball, Design Tip #146, Jun 5, 2012)
  11. Is Data Staging Relational? (Ralph Kimball, DBMS, Apr 1998)
  12. Is ER Modeling Hazardous to DSS? (Ralph Kimball, DBMS, Oct 1995)
  13. Is it a Dimension, a Fact, or Both? (Joy Mundy, Design Tip #140, Nov 1, 2011)
  14. Is Your Data Correct? (Ralph Kimball, Intelligent Enterprise, Dec 5, 2000)
  15. It's Time for Time (Ralph Kimball, DBMS, Jul 1997)

J

  1. Judge Your BI Tool through Your Dimensions (Ralph Kimball, DBMS, Nov 1, 2008)

K

  1. Keep to the Grain in Dimensional Modeling (Ralph Kimball, Intelligent Enterprise, Jul 30, 2007)
  2. Keep Your Keys Simple (Ralph Kimball, Design Tip #100, Apr 3, 2008)
  3. Keeping Text Out of the Fact Table (Bob Becker, Design Tip #55, Jun 9, 2004)
  4. Key Tenets of the Kimball Method (Joy Mundy, Design Tip #179, Nov 3, 2015)
  5. The Keyword Dimension (Ralph Kimball, Intelligent Enterprise, Oct 20, 2000)
  6. Kimball Lifecycle in a Nutshell (Margy Ross, Design Tip #115, Aug 4, 2009)
  7. Kimball's Ten Essential Rules of Dimensional Modeling (Margy Ross, Intelligent Enterprise, May 29, 2009)

L

  1. Latest Thinking on Time Dimension Tables (Ralph Kimball, Design Tip #51, Feb 1, 2004)
  2. Let's Improve Our Operating Procedures (Joy Mundy, Design Tip #52, Mar 4, 2004)
  3. Letting the Users Sleep (Ralph Kimball, DBMS, Dec 1996 and Jan 1997)
  4. Leverage Data Visualization Tools, But Avoid Anarchy (Joy Mundy, Design Tip #162, Jan 7, 2014)
  5. Leverage Process Metadata for Self-Monitoring DW Operations (Bob Becker, Design Tip #170, Nov 5, 2014)
  6. Leverage Your Dimensional Model for Predictive Analytics (Ralph Kimball, Design Tip #172, Feb 2, 2015)

M

  1. Maintaining Back Pointers to Operational Sources (Ralph Kimball, Design Tip #67, May 4, 2005)
  2. Maintaining Dimension Hierarchies (Joy Mundy, Intelligent Enterprise, Oct 27, 2008)
  3. Making Sense of the Semantic Layer (Joy Mundy, Design Tip #158, Aug 5, 2013)
  4. Managing Backlogs Dimensionally (Bob Becker, Design Tip #118, Nov 4, 2009)
  5. Managing Bridge Tables (Ralph Kimball, Intelligent Enterprise, Aug 10, 2001)
  6. Managing Large Dimensional Design Teams (Bob Becker, Design Tip #161, Nov 5, 2013)
  7. Managing Your Parents (Ralph Kimball, Intelligent Enterprise, Sep 18, 2001)
  8. Many Alternate Realities (Ralph Kimball, Intelligent Enterprise, Feb 9, 2000)
  9. Marketing the DW/BI System (Warren Thornthwaite, Design Tip #91, May 30, 2007)
  10. The Matrix (Ralph Kimball, Intelligent Enterprise, Dec 7, 1999)
  11. The Matrix: Revisited (Margy Ross, Intelligent Enterprise, Dec 1, 2005)
  12. Measure Twice, Cut Once (Warren Thornthwaite, Intelligent Enterprise, Dec 10, 2003)
  13. Meta Meta Data Data (Ralph Kimball, DBMS, Mar 1998)
  14. Microsoft SQL Server Comes of Age for Data Warehousing (Warren Thornthwaite, Intelligent Enterprise, Jun 23, 2008)
  15. Modeling a Pipeline with an Accumulating Snapshot (Ralph Kimball, Design Tip #37, Jun 13, 2002)
  16. Modeling Data as Both a Fact and Dimension Attribute (Ralph Kimball, Design Tip #97, Dec 11, 2007)
  17. Modeling Time Spans (Ralph Kimball, Design Tip #35, Mar 27, 2002)
  18. Monster Dimensions (Ralph Kimball, DBMS, May 1996)
  19. More Business Requirements Gathering Dos and Don'ts (Margy Ross, Design Tip #110, May 4, 2009)
  20. Much Ado about Nothing (Margy Ross, Design Tip #139, Oct 5, 2011)
  21. Multinational Dimensional Data Warehouse Considerations (Ralph Kimball, Design Tip #24, Jun 1, 2001)
  22. Mystery Dimensions (Ralph Kimball, Intelligent Enterprise, Mar 20, 2000)
  23. Myth Busters (Ralph Kimball, DM Review, Feb 2008)

N

  1. The Naming Game (Warren Thornthwaite, Design Tip #71, Sep 2, 2005)
  2. New Directions for ETL (Ralph Kimball, Design Tip #169, Sep 8, 2014)
  3. Newly Emerging Best Practices for Big Data (Ralph Kimball, White Paper, Sep 30, 2012)
  4. No Detail Too Small (Margy Ross, Intelligent Enterprise, Oct 30, 2003)
  5. Not So Fast (Ralph Kimball, Intelligent Enterprise, Oct 26, 1999)

O

  1. Off the Bench (Margy Ross, Design Tip #49, Sep 15, 2003)
  2. Overcoming Obstacles When Gathering Business Requirements (Margy Ross, Intelligent Enterprise, Jun 2007)

P

  1. Patterns to Avoid When Modeling Header/Line Item Transactions (Margy Ross, Design Tip #95, Oct 2, 2007)
  2. The Perfect Handoff (Ralph Kimball, Intelligent Enterprise, Dec 21, 1999)
  3. Perfectly Partitioning History with Type 2 SCD (Ralph Kimball, Design Tip #8, May 21, 2000)
  4. Picking the Right Approach to MDM (Warren Thornthwaite, Intelligent Enterprise, Feb 7, 2007)
  5. Pipelining Your Surrogates (Ralph Kimball, DBMS, Jun 1998)
  6. Pivoting the Fact Table with a Fact Dimension (Joy Mundy, Design Tip #82, Aug 2, 2006)
  7. Potential Bridge (Table) Detours (Margy Ross, Design Tip #166, May 14, 2014)
  8. Practical Steps for Designing a Dimensional Model (Margy Ross, Intelligent Enterprise, Sep 29, 2008)
  9. Preparing for Data Mining (Ralph Kimball, DBMS, Nov 1997)
  10. The Problem with Comparisons (Ralph Kimball, DBMS, Jan 1996)
  11. Professional Boundaries (Ralph Kimball, DBMS, Jul 1998)
  12. The Promise of Decision Support (Bill Schmarzo, Intelligent Enterprise, Dec 5, 2002)
  13. Put Your Fact Tables on a Diet (Ralph Kimball, Design Tip #30, Nov 3, 2001)

R

  1. Rating Your Dimensional Data Warehouse (Ralph Kimball, Intelligent Enterprise, Apr 28, 2000 and May 15, 2000)
  2. Reader Suggestions on Fact Table Surrogate Keys (Ralph Kimball and Bob Becker, Design Tip #84, Oct 3, 2006)
  3. Real-Time Partitions (Ralph Kimball, Intelligent Enterprise, Feb 1, 2002)
  4. The Real-Time Triage (Ralph Kimball, Design Tip #89, Mar 20, 2007)
  5. Relating to Agile Methodologies (Margy Ross, Design Tip #73, Nov 17, 2005)
  6. Relating to OLAP (Joy Mundy, Intelligent Enterprise, Oct 8, 2002)
  7. Relationship between Strategic Business Initiatives and Business Processes (Bill Schmarzo, Design Tip #47, Jul 10, 2003)
  8. Replicating Dimensions Correctly (Ralph Kimball, Design Tip #19, Feb 5, 2001)
  9. Resist Abstract Generic Dimensions (Margy Ross, Design Tip #83, Sep 8, 2006)
  10. Resist the Urge to Start Coding (Ralph Kimball, DM Review, Nov 2007)
  11. RFID Tags and Smart Dust (Ralph Kimball, Intelligent Enterprise, Jul 18, 2003)
  12. Risky Project Resources Are Risky Business (Margy Ross, Design Tip #173, Mar 9, 2015)
  13. A Rolling Prediction of the Future, Now and in the Past (Ralph Kimball, Design Tip #23, May 2, 2001)

S

  1. The Second Revolution of User Interfaces (Ralph Kimball, Intelligent Enterprise, Aug 24, 1999)
  2. Selecting Default Values for Nulls (Bob Becker, Design Tip #128, Oct 6, 2010)
  3. Server Configuration Considerations (Warren Thornthwaite, Design Tip #102, Jun 3, 2008)
  4. Set Your Boundaries (Ralph Kimball, DM Review, Dec 2007)
  5. Should You Use an ETL Tool? (Joy Mundy, Intelligent Enterprise, Apr 6, 2008)
  6. Showing the Correlation between Dimensions (Ralph Kimball, Design Tip #6, Apr 10, 2000)
  7. Simple Drill Across in SQL (Warren Thornthwaite, Design Tip #68, Jun 3, 2005)
  8. Six Key Decisions of ETL Architectures (Bob Becker, Intelligent Enterprise, Oct 9, 2009)
  9. Slowly Changing Dimensions (Ralph Kimball, DM Review, Sep 1, 2008 and Oct 1, 2008)
  10. Slowly Changing Dimensions Are Not Always as Easy as 1, 2, and 3 (Margy Ross, Intelligent Enterprise, Mar 1, 2005)
  11. Slowly Changing Dimension Types 0, 4, 5, 6 and 7 (Margy Ross, Design Tip #152, Feb 5, 2013)
  12. Slowly Changing Entities (Ralph Kimball, Design Tip #90, Apr 30, 2007)
  13. Smart Date Keys to Partition Fact Tables (Warren Thornthwaite, Design Tip #85, Nov 1, 2006)
  14. Smarter Data Warehouses (Joy Mundy, Intelligent Enterprise, Feb 16, 2001)
  15. Snowflakes, Outriggers, and Bridges (Margy Ross, Design Tip #105, Sep 3, 2008)
  16. The Soul of the Data Warehouse, Part One: Drilling Down (Ralph Kimball, Intelligent Enterprise, Mar 20, 2003)
  17. The Soul of the Data Warehouse, Part Two: Drilling Across (Ralph Kimball, Intelligent Enterprise, Apr 5, 2003)
  18. The Soul of the Data Warehouse, Part Three: Handling Time (Ralph Kimball, Intelligent Enterprise, Apr 22, 2003)
  19. Sparse Facts and Facts with Short Lifetimes (Ralph Kimball, Design Tip #20, Feb 27, 2001)
  20. Spatially Enabling Your Data Warehouse (Ralph Kimball, Intelligent Enterprise, Jan 1, 2001 and Jan 30, 2001)
  21. The Special Dimensions of the Clickstream (Ralph Kimball, Intelligent Enterprise, Jan 20, 2000)
  22. SQL Roadblocks and Pitfalls (Ralph Kimball, DBMS, Feb 1996)
  23. Staffing the Dimensional Modeling Team (Bob Becker, Design Tip #103, Jul 1, 2008)
  24. Staging Areas and ETL Tools (Joy Mundy, Design Tip #99, Mar 4, 2008)
  25. Standard Reports: Basics for Business Users (Joy Mundy and Warren Thornthwaite, Intelligent Enterprise, Feb 1, 2006)
  26. Stirring Things Up (Ralph Kimball, Intelligent Enterprise, Jun 22, 1999)
  27. Surprising Value of Data Profiling (Ralph Kimball, Design Tip #59, Sep 14, 2004)
  28. Surrogate Keys (Ralph Kimball, DBMS, May 1998)
  29. Surrogate Keys for the Time Dimension (Ralph Kimball, Design Tip #5, Mar 19, 2000)
  30. Surrounding the ETL Requirements (Ralph Kimball, Intelligent Enterprise, Nov 13, 2004)

T

  1. TCO Starts with the End User (Intelligent Enterprise, May 13, 2003)
  2. There Are No Guarantees (Ralph Kimball, Intelligent Enterprise, Aug 2000)
  3. There Is No Database Magic (Joy Mundy, Design Tip #175, Jun 8, 2015)
  4. Think Critically When Applying Best Practices (Bob Becker and Ralph Kimball, Intelligent Enterprise, Mar 26, 2007)
  5. Think Dimensionally (Beyond Data Modeling) (Margy Ross, Design Tip #160, Oct 3, 2013)
  6. Think Globally, Act Locally (Ralph Kimball, Intelligent Enterprise, Dec 1998)
  7. Think Like a Software Development Manager (Warren Thornthwaite, Design Tip #96, Oct 31, 2007)
  8. Three Critical Components for Successful Self-Service BI (Joy Mundy, Design Tip #153, Mar 4, 2013)
  9. Three ETL Compromises to Avoid (Bob Becker, Intelligent Enterprise, Mar 1, 2010)
  10. Three Ways to Capture Customer Satisfaction (Ralph Kimball, Intelligent Enterprise, Feb 4, 2008)
  11. Timespan Accumulating Snapshot Fact Tables (Joy Mundy, Design Tip #145, May 1, 2012)
  12. To Be or Not To Be Centralized (Margy Ross, Intelligent Enterprise, Feb 1, 2003)
  13. Traveling through Databases (Ralph Kimball, DBMS, May 1997)
  14. Tried and True Concepts for DW/BI Success (Bob Becker, Design Tip #178, Oct 1, 2015)
  15. A Trio of Interesting Snowflakes (Ralph Kimball, Intelligent Enterprise, Jun 29, 2001)
  16. Turbocharge Your Query Tools (Ralph Kimball, DBMS, Sep 1997)
  17. Two Powerful Ideas (Ralph Kimball, Intelligent Enterprise, Sep 17, 2002)

U

  1. Unclogging the Fact Table Surrogate Key Pipeline (Joy Mundy, Design Tip #171, Jan 5, 2015)
  2. Updating the Date Dimension (Joy Mundy, Design Tip #119, Dec 2, 2009)
  3. Upgrading Your BI Architecture (Joy Mundy, Design Tip #104, Aug 7, 2008)
  4. Use a Design Charter to Keep Business Modeling Activities on Track (Bob Becker, Design Tip #138, Sep 7, 2011)
  5. Using Regular Expressions for Data Cleaning (Warren Thornthwaite, Intelligent Enterprise, Jan 19, 2009)
  6. Using the Dimensional Model to Validate Business Requirements (Bob Becker, Design Tip #123, May 5, 2010)
  7. Using the SQL MERGE Statement for Slowly Changing Dimensions (Warren Thornthwaite, Design Tip #107, Nov 6, 2008)

W

  1. Warehousing without Borders (Ralph Kimball, Intelligent Enterprise, Mar 30, 1999)
  2. Warning: Summary Data May Be Hazardous to Your Health (Margy Ross, Design Tip #77, Mar 9, 2006)
  3. Watching the Watchers (Ralph Kimball, Intelligent Enterprise, Jul 17, 2000)
  4. Welcoming the Packaged App (Ralph Kimball, Intelligent Enterprise, Jun 5, 2000)
  5. What Didn't Happen (Ralph Kimball, Intelligent Enterprise, Feb 1999)
  6. What Does the Central Team Do? (Ralph Kimball, DBMS, Jun 1997)
  7. What Not to Do (Ralph Kimball, Intelligent Enterprise, Oct 24, 2001)
  8. What's in a Name (Joy Mundy, Design Tip #168, Jul 21, 2014)
  9. When a Fact Table Can Be Used as Dimension Table (Ralph Kimball, Design Tip #13, Sep 15, 2000)
  10. When a Slowly Changing Dimension Speeds Up (Ralph Kimball, Intelligent Enterprise, Aug 3, 1999)
  11. When Do Dimensions Become Dangerous? (Ralph Kimball, Design Tip #79, May 10, 2006)
  12. When Is the Dimensional Design Done? (Bob Becker, Design Tip #108, Dec 3, 2008)
  13. Working in Web Time (Ralph Kimball, Intelligent Enterprise, Nov 16, 1999)
  14. Wrangling Behavior Tags (Ralph Kimball, Intelligent Enterprise, May 9, 2002)
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset