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.
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.