| Welcome to Kimball Design Tips Thanks for subscribing to our Design Tips! Here’s the complete Design Tip library, including the current year which is only available to subscribers. Happy reading! |
| Design Tips 2012 | |
| Design Tip #147 | Durable Super-Natural Keys |
| Design Tip #146 | Is Big Data Compatible with the Data Warehouse? |
| Design Tip #145 | Time Stamping Accumulating Snapshot Fact Tables |
| Design Tip #144 | History Lesson on Ralph Kimball and Xerox PARC |
| Design Tip #143 | Enjoy the Sunset |
| Design Tip #142 | Building Bridges |
| | |
| Design Tips 2011 | |
| Design Tip #141 | Expanding Boundaries of the Data Warehouse |
| Design Tip #140 | Is it a Dimension, a Fact, or Both? |
| Design Tip #139 | Much Ado About Nothing |
| Design Tip #138 | Use a Design Charter to Keep Dimensional Design Activities on Track |
| Design Tip #137 | Creating and Managing Shrunken Dimensions |
| Design Tip #136 | Adding a Mini-Dimension to a Bridge Table |
| Design Tip #135 | Conformed Dimensions as the Foundation for Agile Data Warehousing |
| Design Tip #134 | Data Warehouse Testing Recommendations |
| Design Tip #133 | Factless Fact Tables for Simplification |
| Design Tip #132 | Kimball Forum Update |
| Design Tip #131 | Easier Approaches For Harder Problems |
| | |
| Design Tips 2010 | |
| Design Tip #130 | Accumulating Snapshots for Complex Workflows |
| Design Tip #129 | Are IT Procedures Beneficial to DW/BI Projects? |
| Design Tip #128 | Selecting Default Values for Nulls |
| Design Tip #127 | Creating and Managing Mini-Dimensions |
| Design Tip #126 | Disruptive ETL Changes |
| Design Tip #125 | Balancing Requirements and Realities |
| Design Tip #124 | Alternatives for Multi-valued Dimensions |
| Design Tip #123 | Using the Dimensional Model to Validate Business Requirements |
| Design Tip #122 | Call to Action for ETL Tool Providers |
| Design Tip #121 | Columnar Databases: Game Changers for DW/BI Deployment? |
| Design Tip #120 | Design Review Dos and Don’ts |
| | |
| Design Tips 2009 (PDF format—2009 design tips zipped) | |
| Design Tip #119 | Updating the Date Dimension |
| Design Tip #118 | Managing Backlogs Dimensionally |
| Design Tip #117 | Dealing with Data Quality: Don’t Just Sit There, Do Something! |
| Design Tip #116 | Add Uncertainty to Your Fact Table |
| Design Tip #115 | Kimball Lifecycle in a Nutshell |
| Design Tip #114 | Avoiding Alternate Organization Hierarchies |
| Design Tip #113 | Creating, Using, and Maintaining Junk Dimensions |
| Design Tip #112 | Creating Historical Dimension Rows |
| Design Tip #111 | Is Agile Enterprise Data Warehousing an Oxymoron? |
| Design Tip #110 | Business Requirements Gathering Dos and Don’ts |
| Design Tip #109 | Dos and Don’ts on the Kimball Forum |
| | |
| Design Tips 2008 (PDF format—2008 design tips zipped) | |
| Design Tip #108 | Design Tip #108 When is the Dimensional Model Design Done? |
| Design Tip #107 | Using the SQL MERGE Statement for Slowly Changing Dimension Processing |
| Design Tip #106 | Can the Data Warehouse Benefit from SOA? |
| Design Tip #105 | Snowflakes, Outriggers, and Bridges |
| Design Tip #104 | Upgrading your BI Architecture |
| Design Tip #103 | Staffing the Dimensional Modeling Team |
| Design Tip #102 | Server Configuration Considerations |
| Design Tip #101 | Slowly Changing Vocabulary |
| Design Tip #100 | Keep Your Keys Simple |
| Design Tip #99 | Staging Areas and ETL Tools |
| Design Tip #98 | Focus on Data Stewardship |
| | |
| Design Tips 2007 (PDF format—2007 design tips zipped) | |
| Design Tip #97 | Modeling Data as Both a Fact and Dimension Attribute |
| Design Tip #96 | Think Like A Software Development Manager |
| Design Tip #95 | Patterns to Avoid when Modeling Header/Line Item Transactions |
| Design Tip #94 | Building Custom Tools for the DW/BI System |
| Design Tip #93 | Transactions Create Time Spans |
| Design Tip #92 | Dimension Manager and Fact Provider |
| Design Tip #91 | Marketing the DW/BI System |
| Design Tip #90 | Slowly Changing Entities |
| Design Tip #89 | The Real Time Triage |
| Design Tip #88 | Dashboards Done Right |
| Design Tip #87 | Combining SCD Techniques Having It Both Ways |
| Design Tips 2006 (PDF format—2006 design tips zipped) | ||
| Design Tip #86 | Reference Dimensions for Infrequently-Accessed Degenerates | |
| Design Tip #85 | Smart Date Keys to Partition Fact Tables | |
| Design Tip #84 | Readers’ Suggestions on Fact Table Surrogate Keys | |
| Design Tip #83 | Resist Abstract Generic Dimensions | |
| Design Tip #82 | Pivoting the Fact Table with a Fact Dimension | |
| Design Tip #81 | Fact Table Surrogate Keys | |
| Design Tip #80 | Dimension Row Change Reason Attributes | |
| Design Tip #79 | Dangerously Large Dimension Tables | |
| Design Tip #78 | Late Arriving Dimension Rows | |
| Design Tip #77 | Warning: Summary Data may be Hazardous | |
| Design Tip #76 | Advantages of a 64-bit Server | |
| Design Tip #75 | Creating the Metadata Strategy | |
| Design Tips 2005 (PDF format—2005 design tips zipped) | ||
| Design Tip #74 | Compliance-Enabled Data Warehouses | |
| Design Tip #73 | Relating to Agile Methodologies | |
| Design Tip #72 | Business Process Decoder Ring | |
| Design Tip #71 | Naming Conventions | |
| Design Tip #70 | Architecting Data for MS SQL Server 2005 | |
| Design Tip #69 | Identifying Business Processes | |
| Design Tip #68 | Simple Drill-Across in SQL | |
| Design Tip #67 | Maintaining Back Pointers to Operational Sources | |
| Design Tip #66 | Implementation Analysis Paralysis | |
| Design Tip #65 | Document the ETL System | |
| Design Tip #64 | Avoid Isolating the DW and BI Teams | |
| Design Tip #63 | Building a Change Data Capture System | |
| | ||
| Design Tips 2004 (PDF format—2004 design tips zipped) | ||
| Design Tip #62 | Alternate Hierarchies | |
| Design Tip #61 | Handling all the Dates | |
| Design Tip #60 | Big Shifts in Business Intelligence | |
| Design Tip #59 | Surprising Value of Data Profiling | |
| Design Tip #58 | BI Portal | |
| Design Tip #57 | Early Arriving Facts | |
| Design Tip #56 | Dimensional Modeling for Microsoft Analysis Services | |
| Design Tip #55 | Exploring Text Facts | |
| Design Tip #54 | Delivering Historical and Current Perspectives | |
| Design Tip #53 | Dimension Embellishments | |
| Design Tip #52 | Improving Operating Procedures | |
| Design Tip #51 | Latest Thinking on Time Dimension Tables | |
| | ||
| |||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Design Tips 2000 (PDF format—2000 design tips zipped) | ||
| Design Tip #16 | Hot Swappable Dimensions | |
| Design Tip #15 | Combining SCD Techniques | |
| Design Tip #14 | Arbitrary Balance Reporting with Transaction Facts | |
| Design Tip #13 | When Fact Tables can be used as Dimensions | |
| Design Tip #12 | Accurate Counting with a Dimensional Supplement | |
| Design Tip #11 | Accurate Counts within a Dimension | |
| Design Tip #10 | Is your Data Correct | |
| Design Tip #9 | Processing Slowly Changing Dimensions during Initial Load | |
| Design Tip #8 | Perfectly Partioning History with Type 2 SCD | |
| Design Tip #7 | Getting your Data Warehouse back on Track | |
| Design Tip #6 | Showing the Correlation between Dimensions | |
| Design Tip #5 | Surrogate Keys for the Time Dimension | |
| Design Tip #4 | Fast Changing Complex Customer Dimensions | |
| Design Tip #3 | Focus on Business Process, not Business Departments | |
| Design Tip #2 | Multiple Time Stamps | |
| Design Tip #1 | Guidelines for an Expressive Clickstream Data Mart | |