Reverse proxy for shiny server with nginx

Open source version of shiny server does not include any authorization option so if you want to limit access based on login you have to use either Apache or nginx as “reverse proxy”. We choose nginx because it is very simple and elegant solution which not...

Bigquery cheat sheet – Standard SQL – functions

Conversions: CAST ( expr AS type )   Aggregate functions: Return single aggregate value for group of rows ANY_VALUE ( expr) [ OVER (…) ] FROM … ARRAY_AGG( DISTINCT …. IGNORE|RESPECT NULLS ORDER BY …. LIMIT …) [ OVER () ] ARRAY_CONCAT_AGG AVG BIT_AND BIT_OR...

Measures of Dispersion

Also called “measure of variability or spread” range – difference between the highest and lowest values + often both extremes are reported with it interquartile range – alternative measure, less influenced by extreme values = range of the...