Some habits are hard to break
Nice to hear people still using Excel and SQL for analytics, when a general purpose programming language and dataframe support makes it so much easier.
I worked years creating fraud reports in perl from large sql-databases, where the output had to be an excel spreadsheet. My major concerns were the 64K row limit and the crappy positioning. I alsways spent more than 60% of the time on Excel presentation.
Now I do python with dataframes using pandas and store it in a nosql elasticsearch database. I then import them into R for final analysis and presentation. In a nosql database you can store dataframes directly, it is like a multidimensional sql database. no more issues with positioning within the spreadsheet and presentation follows using the R cran modules.
Biting the hand that feeds IT
