capstone Project Santosh for temp project

s

1. Capstone_Project KAMBALA SANTOSH KUMAR 17-03-2023

2. OUTLINE Executive Summary Introduction Methodology Results Visualization – Charts Dashboard Discussion Findings & Implications Conclusion Appendix

3. EXECUTIVE SUMMARY Data Collection Collecting Data Using APIs Collecting Data Using Webscraping Exploring Data Data Wrangling Finding Missing Values Determine Missing Values Finding Duplicates Removing Duplicates Normalizing Data Exploratory Data Analysis Distribution Outliers Correlation Data Visualization Visualizing Distribution of Data Relationship Composition Comparison Dashboard Creation

4. INTRODUCTION In order to keep pace with changing technologies and remain competitive, analyze data to help identify future skill requirements. Data collection from Job postings Training portals Surveys Performing analysis to find What are the top programming languages in demand? What are the top database skills in demand? What are the popular IDEs?

5. METHODOLOGY Data is collected through GitHub Jobs API Stack Overflow survey

6. RESULTS

7. GitHub Job Postings

8. Programming Language vs Postings

9. PROGRAMMING LANGUAGE TRENDS Current Year Next Year

10. PROGRAMMING LANGUAGE TRENDS - FINDINGS & IMPLICATIONS Findings Java Script language is preferred by majority of employees Shell, Python and java are used by almost same number of employees C++ seems to be obsolete Implications Acc. Trend Java Script is going to be most preferable language in next year Python and SQL will be rank higher next year Trend shows C++ will be much more preferred next year as compared to current year.

11. DATABASE TRENDS Current Year Next Year

12. DATABASE TRENDS - FINDINGS & IMPLICATIONS Findings MySQL is highly preferred and leading with significant margin PostgreSQL and Microsoft SQL Server are at similar preference MongoDB is at the 5 th position Implications Acc. Trend PostgreSQL will be preferred most MySQL and Redis will be similar in preference Elasticsearch will be at 5 th position

13. DASHBOARD <https://dataplatform.cloud.ibm.com/dashboards/71f05cf2-51d4-4005-8bdb-67f4279f16b0/view/4364b81f39e9239610f5dce407992a0e2b622c5fb6bbd20380d47b490e357297a86045c2c82b1d08dc435637f4ba410ccf>

14. DASHBOARD TAB 1

15. DASHBOARD TAB 2

16. DASHBOARD TAB 3

17. DISCUSSION Majority of the responders were from age group 24-28 Majority of responders were males with Bachelor's degree 91.8% responders were Males and only 8.2% were female Most preferred framework is jQuery.

18. OVERALL FINDINGS & IMPLICATIONS Findings 8.2% responders were female as compared to 91.2% male Java script is the preferred language MySQL is most preferred Database. Implications In current data female participation is very low Java script is going to maintain its’s lead PostgreSQL is going to be most preferred database acc. Trend.

19. CONCLUSION Female participation is very low in the survey Java script is the best language to learn for aspiring candidates PostgreSQL is likely to be in demand so skill in this will be good Majority of the responders were from US so we can say that this data is perfect fit for citizens of USA

20. JOB POSTINGS

21. POPULAR LANGUAGES