top | item 46161296

(no title)

quacked | 2 months ago

For small-to-medium size data sets, you can use Power Query/BI to essentially run a relational database and metrics/dashboards on it inside an Excel spreadsheet plus a web page, minus all the features that a real DB has in terms of version control and backups.

I can't leave Excel for that. I can set up a "data integration" in 3 hours that has a highly customizable and (relatively) bug-free front-end, and maintain it myself. The amount of work and knowledge it takes to get the same thing spun up in a proper language with a proper server is 1-3 orders of magnitude more.

discuss

order

No comments yet.