• Quarterly management reports for Dementia Post Diagnostic Support (PDS) data

• SPSS used for data preparation and calculating performance measures

• Excel used to present data

• New data recording guidance prompted review of methodology and presentation of management reports

• Process can be automated using R and R Markdown

• Output can include interactive elements

• Output as a stand alone html file

  • Universal file format
  • No requirement for password protected shiny server
  • Can continue to be distributed via email to restrict access

• Looks swish!

Define output as flexdashboard in YAML header of R Markdown document:

---
title: "Dementia PDS Quarterly Management Report"
output: 
  flexdashboard::flex_dashboard:
    navbar:
      - title: "Data as at 31 December 2019"
    logo: isdscotland.png
    orientation: rows
    vertical_layout: scroll
---

Add a new row…

Row
-------------------------------------------------

Add multiple pages…

Home
=================================================

Create a tabset to switch between sections…

Row {.tabset}
-------------------------------------------------

flexdashboard::valueBox(paste0(80, "%"), 
                        icon = "fa-percent",
                        caption = paste("of people estimated to be newly",
                                        " diagnosed with dementia were referred",
                                        " for post-diagnostic support.")
)

• Used to create multiple pages with the same layout for each financial year and health board, thus avoiding duplication of code

• Write separate R Markdown document called a “child” template

• Use knitr::knit_child() in the main markdown document to knit the “child” template for each combination of parameters

• Tutorial to use R Markdown Childs with flexdashboard

• Automate date in navbar so dashboard is fully automated

• Improve comments/documentation of code

• Develop further data analysis

• Develop as shiny dashboard when infrastructure available

Alice Byers - Health & Social Care Team

• Email - alice.byers@nhs.net

• GitHub - alice-hannah

Useful Links

• flexdashboard

• Tutorial to use R Markdown Childs with flexdashboard