I am a senior R/Shiny software engineer with 5 years of direct experience.
Through the past 5 years in R/Shiny, I have developed several data visualization websites/web apps and I can provide my service with satisfied result for long term.
Here, let me introduce one of my recent R/Shiny projects.
- The goal of the project is to generate monthly, quarterly, yearly sales reports for car sales companies in German and visualize sale's trends, analyze sale's results, display all results with graphs in dashboard page.
- I used technologies like R, RPostgreSQL, RPostgres, plotly, rjson, pool, Shiny, Postgresql.
###Code snippet for Server side of RPostgresql
appserver <- function(input, output) { ##Update data in Rpostgresql table observeEvent(input$update_table_sql,{ ###Construct Update Query to send to RPostgreSQL table qry = paste0("UPDATE table SET column1 = '",paste(input$value1,"')")) dbSendQuery(conn = con, statement = qry) ###shinyModal to show to user when the table is written to the database is successful showModal( modalDialog( title=paste0("RPostgreSQL table Updated"), br(), div(tags$b(paste0("You have UPDATED your data in the RPostgresSQL database"), style = "color: green;")) )) }) })
If you give me a chance to contribute to your project, I will bring my values to your success.
Thanks,
Serhii.