Right now I do my analysis work in SQL, currently MSSQL previous was MySQL. Always struggle to apply any functions to the data. I then do some sampling and analysis then in R.