Re:What SQL Analysts Need to Know About Python (2016)
by iagovar on Monday November 04, 2019 @06:39PM
(#21447978)
Well, because Excel is quick. I know R and SQL, and I still use Excel a lot.
If I want a quick overview of a problem, query db from Excel -> PowerQuery -> PivotTables. It's easy to use, it's very easy to find solutions in google for PowerQuery, and it just feels slick.
If I need in depth analysis then is when I switch to programming.
If I want a quick overview of a problem, query db from Excel -> PowerQuery -> PivotTables. It's easy to use, it's very easy to find solutions in google for PowerQuery, and it just feels slick.
If I need in depth analysis then is when I switch to programming.