News for hackers. Stuff that matters.
Re:How to create a dashboard in Python with Jupyter Notebook by kulikalov on Tuesday June 14, 2022 @07:04AM (#31737204)
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.

Re:How to create a dashboard in Python with Jupyter Notebook by urthor on Tuesday June 14, 2022 @07:07AM (#31737243)
Denormalized views? Every dashboard is an exercise in denormalization anyway.

Certainly I would never expect people to be experts. SQL Group By is nontrivial.

Re:How to create a dashboard in Python with Jupyter Notebook by kulikalov on Tuesday June 14, 2022 @07:22AM (#31737430)
Still limited to 2-dimensional data. Data warehouses support structs and arrays, but it's not easy for a human to read.