This project combines R, SQLite and RShiny and examines the labour market across the Organization for Economic and Cooperation Development (OECD) countries. It highlights labour market trends, the analysis of average job tenure, unemployment trends and countries with highest labour force, in a post-Covid19 ecovery period.
Data source: OECD
- Labour Force Status data
- Job Tenure data
Tools used: R, SQL (SQLite), RShiny)
Steps:
- Loading libraries
- Loading dataset
- Selecting relevant columns for analysis
- Examining the dataset
- Building a relational database
- Analysing the data (Employment trend, Unemployment trend, Top countries with highest labour force, Average Job Tenure)
- Creating the RShiny app
- Running the RShiny application and displaying the visuals through an HTML page (preview provided in PDF format).