Skip to content

As a Data Analyst, I have been tasked with collecting data from various sources and identifying trends for this year's report on emerging skills. My first task is to collect the top programming skills that are most in demand from various sources including: Job postings Training portals Surveys Once we have collected enough data, you will begin a…

License

Notifications You must be signed in to change notification settings

GaurabKundu1/Technology-Trends-and-Analysis

Repository files navigation

Technology Trends & Analysis

Author : GAURAB KUNDU

This Project is the Data Analyst Capstone Project of the IBM Data Analyst Professional Certificate

Project Description

As a Data Analyst, I have been tasked with collecting data from various sources and identifying trends for this year's report on emerging skills.

My first task is to collect the top programming skills that are most in demand from various sources including:

Job postings

Training portals

Surveys

Once I have collected enough data, I will begin analyzing the data and identify insights and trends that may include the following:

What are the top programming languages in demand?

What are the top database skills in demand?

What are the popular IDEs?

Outline

SL. NO Outline
1 Executive Summary
2 Introduction
3 Objective
4 Hardware and Software Requirments
5 Methodology
6 Results
7 Discussion
8 Conclusion
9 Appendix

Executive Summary

This Project will give you an overview of :

  1. Trends in programming languages and databases

  2. Demographics survey

  3. Technological gap in countries

  4. Gender gap in jobs

Introduction

As a Data Analyst, I have been tasked with collecting data from various sources and identifying trends for this year's report on emerging skills. My first task is to collect the top programming skills that are most in demand from various sources including: Job postings,Training portals,Surveys.

Once I have collected enough data, I will begin analyzing the data and identify insights and trends.

Objective

Background

Analyzing the trends in software development.

Purpose

Identify skill requirements for future.

Question for Analysis

What are the top programming languages in demand?

What are the top database skills in demand?

What are the popular IDEs?

Audience

Human Resource and IT Head.

Hardware and Software Requirments

Hardware

In this Project We are going to use IBM Cloud Pack for Data and its various Web services, so a decent Internet Connection is required only. All the hardware requirments will be covered by IBM Cloud Pack for Data.

Software

We are going to use IBM Watson Studio for this project.

In case of local machine We are going to use the following softwares in this project :

Programming Language : Python

IDE : Jupyter Notebook

Packages : Pandas, Numpy, Scipy, Scikit-learn, Matplotlib, BeautifulSoop.

Methodology

Data Collection

The Data was collected from:

Stack Overflow Developer 2019 Survey

GitHub Job Postings

Programming Languages Annual Salary

The used Data Sets are:

DataSet1 which contains information about the IT professionals.

DataSet2 which contains information about trending technologies and programming languages.
To see the code and step by step process of Data Collection click here

Data Exploration

To see the code and step by step process of Data Exploration click here

Data Wrangling

To see the code and step by step process of Data Wrangling click here

Exploratory Data Analysis

To see the code and step by step process of Exploratory Data Analysis click here

Data Visualization

To see the code and step by step process of Exploratory Data Visualization click here

Results

Results are based on this table

Screenshot (230)

Programming Language Trends

Screenshot (231)

Programming Language Trends - Findings & Implications

Findings

  1. JavaScript, HTML/CSS, SQL are top 3 this year.

  2. Python and Typescript becoming popular next year.

  3. PowerShell edged out in next year.

Implications

  1. Web development are still in high demand.

  2. Big Data technology in companies still requires SQL.

  3. With AI and ML in rising demand, Python is best choice.

Database Trends

Screenshot (233)

Database Trends - Findings & Implications

Findings

  1. MySQL is most popular.

  2. Behind is Microsoft SQL.

  3. MongoDB and Redis are upcoming favorites.

  4. New kid on the block: Elasticsearch.

Implications

  1. Open-source databases are still preferable in companies.

  2. NoSQL databases will make an impact for storing non-relational data.

  3. Redis supports abstract data types.

  4. Pre-tuned search to website, app, or ecommerce store.

IBM Cognos Dashboard Link

Dashboard

Current Technology usage Dasboard

Screenshot (234)

Future Technology trend Dasboard

Screenshot (235)

Demographics Dashboard

Screenshot (236)

Discussion

Technology Trends now and future

Training and Reskilling workers

Females participation in Technology field

Bridge divide of technology gaps in developing countries

Eliminate age and education discrimination in employment

Ovearall Findings and Implications

Findings

  1. Fast changing technology every year.

  2. Concentration on several countries like USA and India.

  3. Gender gap in technology jobs.

  4. Platforms like Docker and AWS are growing.

Implications

  1. Companies need to be flexible and adjust to rapid changes.

  2. Need to spread technology out to lagging countries.

  3. Impact on job hiring’s.

  4. Shift to faster app deployments and cloud services in future.

Conclusion

From this project we have known the Technology Trends for current and next year, Programming Languages, Database and Platform overview. We have got an overview of Demographics. What are the actions to be taken. And we came to know that In future, we can use incorporate Machine Learning to predict trends and salaries

Appendix

Screenshot (237)

GitHub Job postings

Screenshot (238)

Popular Languages by salary

Screenshot (239)

About

As a Data Analyst, I have been tasked with collecting data from various sources and identifying trends for this year's report on emerging skills. My first task is to collect the top programming skills that are most in demand from various sources including: Job postings Training portals Surveys Once we have collected enough data, you will begin a…

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published