Dashboard and Supporting Tool Demonstrations
This content was presented to Nelson\Nygaard Staff at a Lunch and Learn webinar on Thursday, January 6th, 2022, and is available as a recording here and embedded below.
Michael will show the R scripts used to create the TARTA Route Profile Dashboard (Toldeo, OH). This project is based off the work done by Paul Leitman for the StarMetro route profiles (Tallahassee, FL). The structure of this project consists of multiple data processing scripts that feed into shiny scripts, enabling for greater adaptability with future projects. The idea is that the shiny scripts will remain relatively consistent across projects, while the processing scripts be edited based on specific project data. The processing scripts mainly work through preparing schedule data (based on GTFS) and ridership data (client provided) to present in various maps, tables, and charts per route.
Yonghyeon (Hannah) will demonstrate data pipelines using Django to load data from Expedia data sources into database periodically. Instead of using a script, Django allow users to handle communication with database easier such as editing, dropping, or creating tables and columns without writing SQL.
Esther will demonstrate our new Project & Treatment Module that allows users to program speed and reliability treatments for buses. If this is implemented as part of a larger BDAT speed and reliability project, we are able to use these projects to generate projected costs and benefits. I will show off our “Demo” application which can be shared as a marketing tool, as well as how we have implemented this for Denver. We probably will not have time to walk through all of the code under the hood, I’m happy to show off anything that people are particularly interested in.
Bryan will discuss key R/Shiny concepts supporting the development of the Module – namely using Shiny Modules and {golem}. He is just getting familiar with these in the past few months and will plan to offer one or more webinars on the topics at some point this year.
{golem}