Migration of a VBA tool to Shiny on Docker

Context summary

The company has a load curve analysis tool historically coded in VBA in Excel. It generates many business and diagnostic graphs that are useful to analyze the power consumption of companies.  ThinkR is mandated to develop and deploy this tool in a more modern language and to deploy it online.

Our intervention

• Code audit and optimization – package design
• Implementation of a code versioning and collaborative work tool
• Dockerization for application deployment via shinyproxy
• Installation of the application on a dedicated server accessible only with authentication

Result & added value

• Delivery of a documented R package with an installation procedure
• The application is secured,  powerful and maintainable