Capstone Project 2 - GX

Download as pdf or txt
Download as pdf or txt
You are on page 1of 24

Technology Trends and

Emerging IT Skills
Xian GUAN
November 2020
OUTLINE

• Executive Summary
• Introduction
• Methodology
• Results
• Visualization – Charts
• Dashboard
• Discussion
• Findings & Implications
• Conclusion
• Appendix
EXECUTIVE SUMMARY
• Technology trends
• In a changing tech era, web development
and SQL remains in demand
• Python is fast growing
• NoSQL databases are rising and becoming
more popular in the near future

• Demographic survey
• IT technical skill gap exists among
countries
• Gender gap exists in IT technology
employment
• Education attainment is associated with
IT technical skill development
INTRODUCTION
• Major project purpose
It reflects and analyzes technology trends
and indicates emerging IT skills in demand.

• Key questions
• What are recent top programming languages in
demand?
• What are recent top databases in demand?
• Which IT skills are and will be in great demand
for future based on recent trends?
• What is the current status of IT skilled
developer group
• Target audience: Managers and HR leads in
IT technology companies
METHODOLOGY
• Data sources
 The 2019 Stack Overflow Developer Survey
 GitHub Jobs Postings
 Programming Languages Annual Salary

• Plans for data collection and analysis


 Data exploration
 Data wrangling
 Data exploratory analysis
 Data visualization
 Data presentation
RESULTS CHARTS AND GRAPHS
• Programming language trends (this
year vs next year)
• Database trends (this year vs next
year)
• Current technology usage
• Future technology trend
• Demographics
PROGRAMMING LANGUAGE TRENDS
Top 5 programming languages Top 5 programming languages
(Current Year) (Next Year)
PROGRAMMING LANGUAGE TRENDS - FINDINGS &
IMPLICATIONS

Findings Implications

• JavaScript is steadily the • Web development is


most popular programming
language this year and next consistently in great
year. demand.
• JavaScript, HTML/CSS,
Python, SQL remain in top 5 • Python is becoming the
programming languages this fastest-growing major
year and next year. programming language.
• TypeScript, in place of
Bash/Shell/PowerShell, • SQL is steadily in demand in
becomes an emerging popular the era of big data.
programming language next
year.
DATABASE TRENDS
Top 5 databases (Current Year) Top 5 databases (Next Year)
DATABASE TRENDS - FINDINGS & IMPLICATIONS

Findings Implications

• MySQL, PostgreSQL, MongoDB, • NoSQL databases are rising


remain in top 5 databases and becoming more popular in
this year and next year, yet the near future.
with ranks changed.

• Microsoft SQL Server and • Open-source databases are


SQLite are edged out of top consistently popular.
5 databases next year.
• For SQL databases, MySQL and
• Redis and Elasticsearch PostgreSQL remains their
become two emerging popular dominant positions these two
databases next year. years.
DASHBOARD

https://dataplatform.cloud.ibm.com/dashb
oards/8f010935-d6d8-4948-b705-
052ced0155b8/view/793bd1761ebd089252feee
e4079d24057f312209b2bb855687817b495d6076
97a86941c3c82a1909de175665f0ec400ccd

Data source: The 2019 Stack Overflow Developer Survey


DASHBOARD CURRENT TECHNOLOGY USAGE
DASHBOARD FUTURE TECHNOLOGY TREND
DASHBOARD DEMOGRAPHICS
DISCUSSION
• Technology trends
• What is consistently
popular?
• What is rising and what is
declining?
• Which skills will be in
great demand in the near
future?
• Demographics
• IT Technical skill gap among
countries
• Gender gap in IT technology
employment
• Education level for IT
technical employment
OVERALL FINDINGS & IMPLICATIONS
Findings Implications

• Companies need to be flexible and


• Though technology is changing proactive in IT technology
employment to address rapid
fast, some technologies and technological changes
skills are steadily in demand • Companies need to keep experienced
• IT technical skill gap exists employees for IT skills in
consistent demand
among countries
• It is necessary to encourage and
• Gender gap exists in IT include more females into IT
technology employment
technology employment
• It is important to promote quality
• Better education is relevant to education to enhance IT skill
development
IT technical skill development
• Country gap in IT technology needs
to be overcome in the future
CONCLUSION
Technology trends
• In a changing tech era, web development
and SQL remains in demand
• Python is fast growing
• NoSQL databases are rising and becoming
more popular in the near future

Therefore,
 Companies need to be flexible and
proactive in IT technology employment to
address rapid technological changes

 Companies need to keep experienced


employees for IT skills in consistent
demand
CONCLUSION
Demographic survey
• IT technical skill gap exists among
countries
• Gender gap exists in IT technology
employment
• Education attainment is associated with
IT technical skill development

Therefore,
 More measures need to be taken to encourage
and include more females into IT technology
employment
 It is important to promote quality education
to enhance IT skill development
 Country gap in IT technology needs to be
overcome in the future
APPENDIX TOP 5 PLATFORMS (THIS YEAR)
APPENDIX TOP 5 PLATFORMS (NEXT YEAR)
APPENDIX TOP 5 WEBFRAMES (THIS YEAR)
APPENDIX TOP 5 WEBFRAMES (NEXT YEAR)
GITHUB JOB POSTINGS
POPULAR LANGUAGES

You might also like