Commonly Used SQL in 1 page

SQL

SQL (Structured Query Language) has been around for many years and is a very useful tool to access data in small or large scale.  If you are like me, that may not be using SQL everyday, but need to use it once in a while.  What I like to...

Easy web access log processing with R

R

I recently had a need to diagnose a problem in my web site, so I wanted to do some analysis of the raw access log file.  There are many out-of-the-box analytical utility available but none of them allows me to drill down to the access pattern in more details....

R in the web – with Shiny App

R

How do you host R application on the internet?  One of the available service is from shinyapps.io.  This is a hosting service that allows you to deploy your R application to the server, and shared them on your web pages. It was really easy to setup.  I used RStudio to develop...

Graphing with R 101

R

What is R? R is programming language and execution platform for statistical computing and graphics.  It is known to be the successor for the S language, which was developed at Bell Laboratory.  It focuses on a wide variety of statistical and graphical techniques, including linear and nonlinear modelling, time...