3 ms·
Non-techies wielding SQL is a big advantage for sure, but a moderately complex dataset sends SQL aggregations complexity through the roof. While modern data war
by kulikalov 4y ago
Non-techies wielding SQL is a big advantage for sure, but a moderately complex dataset sends SQL aggregations complexity through the roof. While modern data warehouses can handle such queries, I can hardly imagine non-technical person being able to write it.
That's where dashboards come in handy.
- urthor 4y agoDenormalized views? Every dashboard is an exercise in denormalization anyway. Certainly I would never expect people to be experts. SQL Group By is nontrivial.
- kulikalov 4y agoStill limited to 2-dimensional data. Data warehouses support structs and arrays, but it's not easy for a human to read.