This is the companion GitHub repository for the June 2023 Posit Team Community demo. The goal of the demo was to extract R package download data from Posit's Public Package Manager (PPPM) using an Extract-Transform-Load (ETL) Quarto script and visualize the results using a custom-themed Quarto report. Below are the key files in workflow:
-
ETL.qmd
: The Extract-Transform-Load Quarto document. In this document, we call the PPPM API and extract package download data for three popular R package:ggplot2
,dplyr
, andshiny
. The data is then cleaned and pinned to Posit Connect using thepins
package. This script was published to Posit Connect and scheduled to run daily. -
boring-report.qmd
: A draft Quarto report visualizing the package download results from the ETL script. -
posit_theme/posit_theme.qmd
: Same as theboring-report.qmd
but with with a custom Posit-theme applied. A color palette was created usingRColorBrewer
and incorporated into a newgt
table and the existing ggplot. This document was also published to Posit Connect and set to run daily. -
quarto-job-scheduling-slides.qmd
: Slides for the live presentation.