Data Warehouse Dimensional Modeling Design 101 — Regarding system design for a data-intensive application, it usually comes with two options: write or read optimized. There isn’t a database design that fits and optimizes both writing and reading. Like all system design perspectives, no solution is right or wrong, while only pros and cons. As data professionals who…