Hopefully 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
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.
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.
Computer engineer checking in. Same here!
Hopefully 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
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.
I hope there’s a place worse than hell
Jesus Christ
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.
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.