I mostly use sql for data management stuff through c# .NET. But there is a lot of Excel and power bi towards the numbers people.
Comment on I try to spice it up with some VB Macros but it's still ultimately just a spreadsheet.
EditsHisComments@lemmy.world 1 day agoHopefully you utilize Python instead of Excel for data management. Unless you have non-engineers or tech-illiterate people on your team or adjacent teams lol
virku@lemmy.world 1 day ago
ViatorOmnium@piefed.social 1 day ago
Why not both. I once wrote an abomination that read and wrote data into a Google Spreadsheet, interacting with formulas in the spreadsheet in the process.
prex@aussie.zone 6 hours ago
Image
iii@mander.xyz 13 hours ago
I hope there’s a place worse than hell
EditsHisComments@lemmy.world 1 day ago
Jesus Christ
virku@lemmy.world 1 day ago
Oh Lord. Before I found power bi 15 or so years ago I made interactive speeadsheets that did a lot of querying directly towards sql based on a set of input cells. Did a lot of crunching on the data merging data fetched from different database etc before presenting them in their own sheets. The worst part is that it was a huge leap from what we did earlier. Then I would write sql queries and dump the result to Excel every time management needed data.