Request for Proposal Trainer on Data Analysis with R

Request for Proposal

Trainer on Data Analysis with R

RFP BEY/2022/01

FOR

DANISH REFUGEE COUNCIL (LEBANON)

The Danish Refugee Council assists refugees and internally displaced persons across the globe: we provide emergency aid, fight for their rights, and strengthen their opportunity for a brighter future. We work in conflict-affected areas, along the displacement routes, and in the countries where refugees settle. In cooperation with local communities, we strive for responsible and sustainable solutions. We work toward successful integration and whenever possible – for the fulfilment of the wish to return home.  

The Danish Refugee Council founded in Denmark in 1956, and has since grown to become an international humanitarian organization with more than 7,000 staff and 8,000 volunteers. Our vision is a dignified life for all displaced. All of our efforts based on our value compass: humanity, respect, independence and neutrality, participation, and honesty and transparency.

Operating since 2004 in Lebanon, DRC has addressed the needs and rights of vulnerable populations, working initially with Palestinian refugees (since 2004), Iraqi refugees (2007-2010), Lebanese IDPs (during the 2006 conflict), migrant domestic workers (since 2009) and, since 2011, responding to the Syrian refugee crisis.

DRC Lebanon is currently delivering programming in protection, basic assistance, livelihoods, and community development interventions. This myriad programming seeks to address the immediate needs of displaced populations and concurrently support vulnerable host populations. DRC has three offices spread throughout Lebanon in, Beirut, the Beqaa and North (Halba).  For further information about DRC, please refer to our website: https://drc.ngo/

Objectives:

Some of the Danish Refugee Council’s interventions are designed to improve protection and effectiveness of the humanitarian response in Lebanon by enhanced coordination through joint analysis, planning and response. DRC Lebanon has developed a beneficiary centric integrated system for three main sectors Protection, Economic Recovery, and MEAL along with humanitarian common platform to manage referrals between partners in Lebanon. The Referral Information Management System”RIMS” has the capacity to generate two categories of valuable data that can be used to improve humanitarian response: 1) information on the effectiveness and timeliness of referral processes and 2) gaps in service provision across sectors. To that end, DRC will analyze aggregated information from RIMS partners to produce analysis on relevant trends and gaps. In relation to trends, for example, RIMS can support the identification of bottlenecks at each step of the referral process and DRC can present this data at inter-agency meetings to discuss potential ways to address them. Additionally, RIMS can support analysis of gaps, for example, by cross-referencing needed services against those actually received, and incorporating gender, age, nationality; time and sector variables into the analysis, DRC will have the capacity to capture relevant trends and gaps in service provision. In addition, RIMS has the capacity to link to other online platforms through API.

DRC is seeking to appoint a Trainer on Data Analysis with R for the following:

The R Data Analysis Trainer will train DRC technical team on analysing data, linking R to QGIS, linking R to postgreSQL database, linking R to PoweBi, also to train the team on Shiny R.

DRC Lebanon has variety of tools and systems, which are:

• ALPHA and RIMS are developed using ASP.NET core web application hosted on Azure Ubuntu server, and linked to PostgreSQL database.
• DRC has an internal ODK Aggregate server installed on Azure Ubuntu server to collect data offline and linked to a PostgreSQL database. Staff uses ENKETO links or ODK Collect mobile application to collect data.
• Additionally, DRC Lebanon programme teams use online (stored on share point and google drive) and offline excel files to store information.

Specifically, DRC technical team have to be trained during the training on the below:

• The different data structures, such as atomic vectors, lists, data frames, and tibbles. How to create and use them.
• How to import different types of files into R
• How to execute chunks of code following an if-else logic
• How to summarize data
• How to create powerful easy to read pipelines using dplyr and other packages
• Introduction to R plots using ggplot2 and plotly
• Introduction to interactive mapping using Leaflet
• Building interactive dashboards using R-Markdown
• Shiny R
• Linking R to QGIS, PostgreSQL, and PowerBi

Responsibilities:

• Introduction to data analysis using R and RStudio
• Data Quality Management
• Introduction to Data Analysis using Programming Languages
• R Fundamentals (Introduction to R, RStudio overview, Interface Description, Basic R concepts, Vocabularies, Variable Types in R, Operators in R)
• Walkthrough datasets
• Importing and Exporting Data
• Introducing concept of libraries and R essential Libraries (dplyr, ggplot2, and others...)
• Data manipulation in R (Explore, Subset, Restructure, and Combine)
• Executing basic statistical and data analysis commands
• Descriptive Statistics
• Correlation Analysis (Pearson, Pvalues...)
• Plotting in R (Element of graphics, ggplot2, and plotly)
• Introducing to interactive mapping (Leaflet)
• Creating products (R-Markdown, HTML Widgets, and Flex Dashboards)
• Project - Interactive Dashboard using Markdown and Flex
• Other duties as agreed with the Information Management Manger in line with objectives above and weekly work plans.

Deliverables:

The consultancy work is expected to start in March 2022 for duration 6 days and not to exceed 10 days

 (8 working hours per day approximately) between 2^nd March 2022 – 31^st March 2022.

It is expected to start the consultancy by reviewing DRC’s information and data SOPs, and them to assess on regular basis the information management systems that DRC has. Additionally, advise on measers that should be taken to overcome identified security issues.