4 ms·

I want to find a way to incorporate this into a dashboard for suits. Seems like it would let them solve a lot of their own requests - in theory. In a lot of com

by eloff 7y ago

I want to find a way to incorporate this into a dashboard for suits. Seems like it would let them solve a lot of their own requests - in theory. In a lot of companies they'd probably still make requests to create the graphs and sql queries for them. Give a suit a fish and he's happy for a day. Teach a suit to fish and he'll still be back tomorrow for his fish. Who wants to fish when you can get a code monkey to do it for you.

mythrwy 7y ago
I have experience with this. Give a powerful SQL editor to a suit and find your data integrity borked beyond repair.
- striking 7y ago
  Read only?
- tracker1 7y ago
  For this, could probably dump/replicate to SQLite for archive/backup/point in time... Or one-way replicate for reports.
  - eloff 7y ago
    I've used this strategy with a read only replica. It also protects the database from long running and inefficient queries. Highly recommend doing this if you have the budget for it.
  - amylene 7y ago
    This is how PowerBI, from Microsoft, works. It copies the data into local RAM (or on a cloud machine that also runs the dataviz)
- deleted 7y ago
  [deleted]
deleted 7y ago
[deleted]
samplatt 7y ago
This is literally what SSRI and PowerBI was invented for. Still requires codemonkies to prepare the data, but at least it cuts down on the rate of requests by allowing them to massage filters by themselves.
jpau 7y ago
Success here is possible. I didn't believe it until I saw it :) I was in a regional strategy-esque team for Uber Eats. Eats have a nicely curated data warehouse of core operational data. They also have excellent, free, self-paced SQL training built around that same data (a tailored version of https://academy.vertabelo.com/ https://academy.vertabelo.com/). So you learn both how SQL works and how your data is structured at the same time. You'd be surprised how many junior-mid level suits are eager to pick this up. The result is very useful. Some non-technical folk picked this up on the side in just a few weeks. They understood the limitations and caveats needed to use the data well. They needed very limited assistance here-and-there. It was purely magical how they picked up both the data and the system.
throwaway_pdp09 7y ago
> Give a suit a fish and he's happy for a day. Teach a suit to fish and he'll still be back tomorrow for his fish. With the exception of a very few competent suits I have known... this is so spot on! Love it! Beautifully put!

by eloff 7y ago

mythrwy 7y ago

I have experience with this. Give a powerful SQL editor to a suit and find your data integrity borked beyond repair.

striking 7y ago
Read only?
tracker1 7y ago
For this, could probably dump/replicate to SQLite for archive/backup/point in time... Or one-way replicate for reports.
- eloff 7y ago
  I've used this strategy with a read only replica. It also protects the database from long running and inefficient queries. Highly recommend doing this if you have the budget for it.
- amylene 7y ago
  This is how PowerBI, from Microsoft, works. It copies the data into local RAM (or on a cloud machine that also runs the dataviz)
deleted 7y ago
[deleted]

deleted 7y ago

[deleted]

samplatt 7y ago

This is literally what SSRI and PowerBI was invented for. Still requires codemonkies to prepare the data, but at least it cuts down on the rate of requests by allowing them to massage filters by themselves.

jpau 7y ago

Success here is possible. I didn't believe it until I saw it :) I was in a regional strategy-esque team for Uber Eats. Eats have a nicely curated data warehouse of core operational data. They also have excellent, free, self-paced SQL training built around that same data (a tailored version of https://academy.vertabelo.com/ https://academy.vertabelo.com/). So you learn both how SQL works and how your data is structured at the same time. You'd be surprised how many junior-mid level suits are eager to pick this up. The result is very useful. Some non-technical folk picked this up on the side in just a few weeks. They understood the limitations and caveats needed to use the data well. They needed very limited assistance here-and-there. It was purely magical how they picked up both the data and the system.

throwaway_pdp09 7y ago

> Give a suit a fish and he's happy for a day. Teach a suit to fish and he'll still be back tomorrow for his fish. With the exception of a very few competent suits I have known... this is so spot on! Love it! Beautifully put!