• The Information Services Division (ISD) of the National Health Service (NHS) Scotland has a long history of producing official and national statistics.
• We produce around 200 publications each year.
• Traditional publication format is a static pdf document with accompanying excel tables.
• Production uses proprietary software and is time-consuming, involving extensive manual formatting and checking.

• Focus groups and interviews with over 10 different user groups.
• Determined user experiences of existing product and how the new product design could meet their needs.
• Created user stories which influenced the features of the minimum viable product.

• Acute Hospital Activity and Beds publication released in December 2017.

Acute Activity data explorer

R Shiny code

• To determine how the explorer works in practice, and to identify potential faults or usability issues.
• In general, feedback indicates that the core functionality of the explorer is highly usable.
• Features to improve usability include:
  • Features that distract or confuse users removed from the plotly toolbar
  • plotly toolbar displays by default
  • Default graph automatically displays

• R knowledge within ISD:
  • R training at an organisation level
  • R Style Guide
  • Blank R Project and R Shiny templates
  • Resources
• Consistency of Shiny dashboards:
  • Share R Shiny code for the original data explorer
  • Future: design manual
• IT
  • shiny.io server and iframes
  • R and RStudio versions
  • package management

• Psychiatric Hospital Activity publication to be released 25 September 2018.
• Continued refinement of the current Data explorer.
• Accessibility review of the Data explorer.
• Automate production process (Reproducible Analytical Pipeline).