In relational database design, the main objective is to mirror the database structure as outlined in the requirements to ensure data integrity. While this approach may sometimes be challenging for users of the database, the difficulty should primarily indicate the complexity of business needs rather than flaws in the design.

Conversely, whereas BI designs must also adhere to the requirements, usability is also especially important in your designs. Small design errors can result in analytic mistakes that have huge business implications, even when the data is technically correct. In this lightning talk, I will highlight a significant mistake I made in my initial large star schema project that haunted me for years.