Tag: Tableau
20 June, 2017
How to Insert R data frame into SQL
I’ve run into this issue a couple of times during my time at PMG. I’ve used R to perform some kind of analysis, forecasting, clustering, etc., and I need to get the result into our database so anyone on our analytics team could use the output in a SQL query or connect to it in […]
27 September, 2016
Average Calculation in Tableau
There is a bit of misconception about how Tableau calculates average numbers. I have seen analysts struggle with this seemingly easy calculation. Let’s use Tableau Superstore data and calculate Average Sales by Weekday. The common way would be to drop the date into rows field and then use AVG Sales calculation, like below. The problem […]
