About this document
Simplifying Data Exploration for Non-Techies by anushabala is a document available to read on EtoBox.
The document discusses the limitations of using a normalized OLTP data model for data exploration by non-technical business users. A marketing executive at Walmart asks about toothpaste sales in small towns over the past month. Answering this question requires a complex 6-way SQL join across large tables, which may take a long time to execute and impact system performance. The normalized data model, while efficient for transactions, is not suitable for easy ad-hoc exploration by business users.
- Author
- anushabala
- Language
- EN