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