Here is my work for the IBM Data Analyst Certification. The purpose was to identify future skill requirements for IT industry and answer some questions like :
- What are the top programming languages in demand?
- What are the top database skills in demand?
- What are the popular IDEs?
Programming languages are Python and SQL, and I use IBM Cognos Analytics for Data Viz, which is a very similar tool to Power BI and Tableau (with drag and drop functionalities allowing you to make nice charts easily from .csv or .sql data file). Dashboards are available in Tableau as well.
#Python #SQL #Scrapping #APIs #Amazon S3 #Tableau #IBM Cognos
The notebook roughly follows this track:
Data Collection (APIs & scrapping with bs4)
Data Wrangling
Some EDA
Dashboards are included in a global presentation on PDF format (DA_survey.pdf)
Most of them come with scrapping or APIs or simply downloaded from an S3 repository, links and methods are explained in the notebook. However, the GitHub Jobs API we used in this project is deprecated, so I provide the file countries.xls which represents some data I got from this former API.
I made some dataviz inside the notebook with Matplotlib and Seaborn, but I used Tableau & IBM Cognos for the dashboards of my PPT presentation. You can go directly to the them either in Tableau or IBM Cognos Analytics