In the previous section, we found several patterns in the data, such as the behavior of the CitySize column. Now we are going to look at a better picture of the columns in the SourceData.Actions table using R. For this data exploration, we will use R Studio with additional libraries RODBC for access to SQL Server and ggplot2 for visualization of data.
When R Studio is started, let's write the following lines of code in R:
install.packages('RODBC');install.packages('ggplot2');
The install.packages() function installs both libraries. For the preceding code to succeed, we need access to the internet from the computer running R Studio. The install.packages() function downloads the package with all its prerequisites and ...
