Creating graphs in R

Once a dataframe has been set up with the necessary column, we can begin to graph the data and explore visualization options.

Creating simple charts with plot() in R

The most basic graph can be generated with the plot() function using the following script:

plot(SQL_Query_1, main = 'Discount Code by Week') 

The output of the script can be seen here:

Creating simple charts with plot() in R

While the plot displays the discount by week, it is difficult to identify the relationship week-to-week without being able to connect the dots.

The following script will connect the dots between each sequential point:

plot(SQL_Query_1, main = 'Discount Code by Week', type="o") 

The output ...

Get Practical Business Intelligence now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.