1 of 18

Developers’ Trends Analysis

Priyansh Agrawal

26-7-2022

2 of 18

OUTLINE

  • Executive Summary
  • Introduction
  • Methodology
  • Visualization – Charts
  • Dashboard
  • Findings & Implications
  • Appendix

3 of 18

EXECUTIVE SUMMARY

  • This report aims at analyzing various trends among developers on basis of demography and preferred language/DB
  • We have performed various tasks for this analysis such as
    • Extract, Transform, Load, clean and analyze data with professional standards
    • Visualize data via. Different graphs and charts to gain insights into the aforementioned task and create relevant and interactive dashboard
  • While languages show more or less no major shift in trends except the rise of python, DB trends are showing some major shifts
  • The developer industry has a significant majority of young undergraduate males

4 of 18

INTRODUCTION

  • The IT sector is one of the largest industries today with some of the biggest companies in the world being IT companies like google ,FB and with time it is proving to be ever changing very frequently
  • Every now and then some new technology arrives that promises to completely change very basic functioning of IT industry itself
  • In an effort to keep track of changing trends in technologies we have prepared a report to analyze short term trends of IT industry

5 of 18

METHODOLOGY

  • Collected Data from sources like Stack Overflow using Pandas , APIs and Webscraping
  • Improving Data quality by standardizing and normalizing data and dealing with missing values
  • Analyzing Data using statistical methods like correlation and dealing with outliers
  • Visualizing the data
    • Gaining insights into the data using line , bar, pie charts
    • Creating a dashboard with interactive visualizations using cognos analytics

6 of 18

RESULTS

In our analysis we have found some interesting insights regarding trends of languages ,DB and demography that we have shared below

7 of 18

PROGRAMMING LANGUAGE TRENDS

Current Year

Next Year

8 of 18

PROGRAMMING LANGUAGE TRENDS - FINDINGS & IMPLICATIONS

Findings

​

  • JavaScript and HTML/CSS are most common and in-demand languages
  • SQL’s popularity remains relatively unaffected
  • Python is the only language that more people are willing to learn than the people already using it

Implications

​

  • Web development is quite popular as a career choice
  • SQL is and probably will be 1st choice for developers to work with databases
  • Python’s popularity is skyrocketing compared to any other language

9 of 18

DATABASE TRENDS

Current Year

Next Year

10 of 18

DATABASE TRENDS - FINDINGS & IMPLICATIONS

Findings

​

  • DB like PostgreSQL and MongoDB are gaining popularity whereas MySQL and MS SQL server are slowly declining

​

Implications

​

  • DB market is experiencing a major shift as more and more people are showing interest in cloud based Databases like PostgreSQL and NoSQL Databases like MongoDB instead of conventional Databases

​

11 of 18

DASHBOARD

https://jp-tok.dataplatform.cloud.ibm.com/dashboards/8d8e6e50-d066-41ec-a57c-3786641de247/view/7814a0061fb56eee40afc0e407992e037a312608e4bbd756d4d37b490b677697a86c42c4c82b425b8f470237fabf46519a

12 of 18

DASHBOARD TAB 1

​

​

13 of 18

DASHBOARD TAB 2

14 of 18

DASHBOARD TAB 3

​

​

Screenshot of dashboard tab 3 goes here

15 of 18

OVERALL FINDINGS & IMPLICATIONS

Findings

​

  • JS,HTML/CSS currently tops the popularity and will continue for a while but python is catching up
  • Conventional Databases are loosing popularity and new cloud based ones are gaining upper hand

​

Implications

​

  • Web development is currently a popular career choice but AI, ML, Data Science are gaining popularity day by day
  • We should be expecting a significant change in the working of IT industry in upcoming years regarding managing Databases

​

16 of 18

APPENDIX

Skill

No of jobs

C

43000

C#

424

C++

365

Java

3465

JavaScript

392

Python

1366

Scala

42

Oracle

982

SQL Server

286

MySQL Server

0

PostgreSQL

10

MongoDB

174

CITY

No. of jobs

Washington DC

5316

Seattle

3375

New York

3226

Los Angeles

640

San Francisco

435

Austin,Detroit

0

17 of 18

JOB POSTINGS

18 of 18

POPULAR LANGUAGES