3 ms·
So glad to see this. As someone who learned both Excel and SQL on the first job (it's called being an analyst at a trading firm), I always felt that SQL was a "
by ktamura 10y ago
So glad to see this. As someone who learned both Excel and SQL on the first job (it's called being an analyst at a trading firm), I always felt that SQL was a "more powerful but clunkier cousin" of Excel and wished there was a tutorial for SQL aimed at Excel ninjas.
Well, fast forward half a decade and nobody wrote it, so I did so awhile back. Of all the things I wrote for work, it continues to be the most popular:
https://blog.treasuredata.com/blog/2014/12/05/learn-sql-by-calculating-customer-lifetime-value-part-1/ https://blog.treasuredata.com/blog/2014/12/05/learn-sql-by-c...
- dgudkov 10y agoCheck out my EasyMorph (http://easymorph.com http://easymorph.com) -- you can get the best of both worlds with it -- SQL-like logic applied to tabular datasets in an Excel-like fashion: visual, reactive, and with built-in visualizations.