Automated analysis, reporting and presentations using R and LaTex

Have you wondered how to create automated reports in R? Are there certain dashboards, reports and presentations that show the same analysis for different categories or regions? Every time the data changes do you have to recalculate the numbers, recreate the charts, and design the slides? Did you wish for an automated statistical reporting system?

Look no further: in this video, you will see the power of R, rmarkdown, and LaTex to create beautiful looking dashboards, reports and presentations.

Read this accompanying blog post for the scripts and more details:

Some other little new things you may learn in this video:
- how to create a calendar heat map in R
- how to use kableExtra to make your tables look nice
- how to connect to databases in R
- how to use SQL to connect to a database
- how to make your ggplot graphs clean

To get started, you will need:
- R
- RStudio
- LaTex installation (MiKTex or MacTex)
- Northwind database
- the scripts/file shown in the video (

For further reading on this topic, visit Yihui Xie's excellent writing and books:
- RMarkdown:
- Bookdown:

I just want to warn, however, that this article is not for beginners because it does involve some trickery with LaTex, a typesetting language. To get my final dashboard, I spent hours struggling with the path variable, LaTex packages, and RStudio.

I have all the code set up, but you may face difficulties when you are trying to do this on your own. Before you get started, make sure that you test your set-up and environment. Make sure your R is up-to-date. Make sure your RStudio is up-to-date. Make sure all your libraries are up-to-date. Make sure you have LaTex typesetting packages installed: MikTex for Windows and MacTex for MacOS. You may want to test them by creating a simple, minimal example using a typesetting program like TexMaker or by creating a rmarkdown document in RStudio and adding some LaTex commands to it.

We will use the Northwind database that Microsoft provides with its Access database and
SQL Server database. Luckily for us, JP White also made an SQLite database off the same tables.

#rstats #rprogramming #automated-reporting #automated-analysis #latex #rmarkdown #sqllite

markdown,rmarkdown,latex,reporting,automated,analysis,presentations,dashboards,heatmap,r programming,database,sqllite,automated analytics reports,automated reports and dashboards,create automated reports in r,