May 29, 2024
|
29 min
|
9.4k views
How to Automate Reporting with Quarto Dashboards and Scheduled Rendering on Posit Connect
How to stop rebuilding the same report every month: write it once as a Quarto dashboard, schedule a script on Posit Connect that fetches the new data and stores it with pins, and let Connect re-render the dashboard on a schedule. Everyone who needs it gets the current version at a URL, and nobody has to remember to update it. Built here on monthly Consumer Price Index data from the Bureau of Labor Statistics. With Isabella Velasquez.
What you will learn
Why a Quarto dashboard suits a recurring report better than a notebook The layout building blocks: pages, rows, columns, tabsets, sidebars and cards How to theme a dashboard so it matches your organisation How to create a virtual environment so the deployment matches your machine How to schedule a script on Posit Connect so new data is collected as it is published What pins does, and why the data fetch is separate from the report How to publish from VS Code to Posit Connect How to set environment variables for credentials rather than hard-coding them Chapters 0:00 What this session builds 1:17 Overview of the project 2:14 The data: monthly Consumer Price Index from the BLS 3:00 Why Quarto rather than a notebook 5:41 What a Quarto dashboard is 7:17 Navigation bars and pages 7:30 Rows 7:47 Columns 8:00 Tabsets 8:16 Sidebars and cards 9:50 Theming 10:38 The finished BLS dashboard 11:30 Deployment options 11:50 What Posit Connect does 13:02 Starting from the GitHub repo 14:15 Creating a virtual environment 15:50 Scheduling a script with pins so new data is picked up 19:17 Publishing from VS Code to Posit Connect 20:15 Environment variables on Posit Connect 25:30 The finished dashboard
Learn more Quarto dashboards: https://quarto.org/docs/dashboards/ Posit Connect: https://posit.co/products/enterprise/connect/ Publishing Quarto to Connect: https://quarto.org/docs/publishing/rstudio-connect.html pins: https://pins.rstudio.com
Quarto
rstudio
Automate Reporting
Quarto Dashboard
Scheduled Reports
Posit Connect
Rstudio Connect
Dashboards in Python
Dashboard in R
Pins R
Publish Quarto
Quarto Deployment
Recurring Report Automation
Bls Data
Posit