3 ms·
This could be more of a symptom of Excel (and spreadsheets) being too darn hard to get right. I've switched to Sqlite and Jupyter from what was a useful but ha
by softgrow 3y ago
This could be more of a symptom of Excel (and spreadsheets) being too darn hard to get right.
I've switched to Sqlite and Jupyter from what was a useful but hard to debug spreadsheet with really long repeated formulas that were just database joins. The amount of code to view has probably dropped by 90%. Of course now its easier there is ten times the functionality, but at least its a lot easier to understand some SQL vs Excel formulas.
- cykros 3y agoPowerQuery and the built in data model do a lot to make Excel better at handling joins in a sane fashion, but are relatively recent features that some are still realizing are there in the first place, particularly for the Office365/Mac crowd. Nice way to keep your basic tables basic and still maintain the full depth of your relationships all inside of Excel. Throw in some calculated columns and measures using DAX and it's a pretty darn powerful tool. That said, in the data science world, there's a LOT of crossover when it comes to functionality, between tools like Excel, Tableau, and *SQL in particular. And the crossover seems to be growing by the day, especially with Python functionality being built into Excel in the near future.