Using R to create a dashboard for Dam operations

[massimo.narini]

Hi everyone,



for those of you that are interested in viewing your data in different ways that are NOT within the WISKI environment, this may be of interest to you!

I have created a "Dam Operations Dashboard", which effectively allows our dam operators to have access to their data in table format from both historical data and the new data that is being imported to WISKI through Survey 123.

The link is here: https://quinteconservationwiski.shinyapps.io/Dam_Operations_V1/

It was created using R Statistical Program, a few different packages that are associated with it and KIWIS. I am sure there are potentially easier or more efficient ways of doing this, but I am proficient in R and know that I can fix this if it does malfunction, uses open source software and is fairly customizable if others would like something similar.

Each dam has its own tab, with each table being searchable, filterable by column and the time frame can be selected. It is not the fastest to load, but it is bringing in data from 2000 to current, so that kind of makes sense. It is also pulling data from a local CSV file until we are able to grab comments from a TS using KIWIS.


If anyone is interested in this code or understanding what is possible, feel free to get in touch with me and we can see what we can do!


Massimo Narini, M.Sc | WISKI Data Management Analyst
Quinte Conservation
MNarini@quinteconservation.ca
Phone: (613) 968-3434  ext 122 

[massimo.narini]

After some modifications and tests, we are on to version 4!


https://quinteconservationwiski.shinyapps.io/DamOperationsDashboardV4/


There were issues with the slider for filtering on the far most left column ending up off the screen when displaying it on an iPhone, so you can now rearrange the column by dragging and dropping them in a new order so that you can access the slider for the column you need.

This idea could be used not only for tables, but also for graphs.

I think that many people would benefit from the creation of a dashboard to handle their DPC rather then the clunky Excel spreadsheets that seem to be common place around the Hub (personal opinion only).

Contact me if interested in learning more!



Massimo Narini, M.Sc | WISKI Data Management Analyst
Quinte Conservation
MNarini@quinteconservation.ca
Phone: (613) 968-3434  ext 122