NYC-Jobs

Thi is HR Dashboard displaying current job postings form the City of New York.

Data are extracted directly from online source - public API updated weekly, from this url:

https://data.cityofnewyork.us/api/views/kpav-sd4t/rows.csv

The New York official website with current public job postings is available here:

https://www1.nyc.gov/jobs/explore-careers.page

Started this project in Nov 2019, using at the begining Excel, VBA and power query tools to create interactive excel dasboard. Currently are ongoing additional Python analysis shown below.

Python:

Recent jobs update: 2021-11-27

Dataset - NA values visualisation:

Summary of Tidy Data (overview):

() Mini Dashboard:

Funnel Chart - Job postings by Categories:

Job Categories:

Natural language processing with wordcloud (Preferred skills):

Python shell output:

Dataset overview:

Excel dashboard url:

https://1drv.ms/x/s!Agrn_bdzKydQg2Qs72TWo2XntPry