Banner Image

All Services

Programming & Development Programming & Software

R(Shiny)based data visualization service

$35/hr Starting at $1K

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.

About

$35/hr Ongoing

Download Resume

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.

Skills & Expertise

APIData AnalysisDatabase DevelopmentProgrammingRR StudioReportsShinyVisualization

2 Reviews