| Python | SQL | Machine Learning | PySpark | Excel | Data Visualization | Power Bi/ Tableau | Version Control Git | ETL/Data pipeline | Communication | Project Management | Cloud Computing | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Name | ||||||||||||
| Binderiya | 4 | 4 | 2 | 3 | 4 | 5 | 4 | 4 | 3 | 4 | 5 | 4 |
| Pranjul | 4 | 4 | 3 | 3 | 5 | 5 | 5 | 4 | 2 | 4 | 5 | 4 |
| Pratham | 5 | 5 | 2 | 3 | 5 | 3 | 3 | 3 | 1 | 5 | 5 | 2 |
| Panyang | 3 | 4 | 2 | 3 | 4 | 3 | 4 | 3 | 2 | 3 | 3 | 2 |
Skill Gap Analysis
Here, we compare the technical skills required by the job market with the skills present in our team. This analysis highlights key gaps and helps identify areas where upskilling is most needed to align with industry expectations.
Group 11 Skill
Interactive Radar Chart
From this radar chart visualization we can see that our team has a lot of room for improvement for skills like PySpark and Machine Learning. Also we can see that not a lot of our team mates are confident in their skills in Cloud Computing and ETL.
The Top Skills required in the Industry
DATA_ANALYST_JOB
False 38212
True 33042
Name: count, dtype: int64Team skills: ['python', 'sql', 'machine learning', 'pyspark', 'excel', 'data visualization', 'power bi/ tableau', 'version control git', 'etl/data pipeline', 'communication', 'project management', 'cloud computing']
['data analysis', 'sql (programming language)', 'communication', 'management', 'python (programming language)', 'tableau (business intelligence software)', 'dashboard', 'computer science', 'problem solving', 'power bi']
'sql' found in: 'sql (programming language)'
'communication' found in: 'communication'
'python' found in: 'python (programming language)'| Team Average Skill | Job Demand (Normalized) | Skill Gap | |
|---|---|---|---|
| communication | 4.00 | 5.000000 | 1.000000 |
| sql | 4.25 | 4.959112 | 0.709112 |
| machine learning | 2.25 | 0.869894 | -1.380106 |
| python | 4.00 | 2.283191 | -1.716809 |
| data visualization | 4.00 | 1.520015 | -2.479985 |
| excel | 4.50 | 1.959357 | -2.540643 |
| cloud computing | 3.00 | 0.266590 | -2.733410 |
| pyspark | 3.00 | 0.104878 | -2.895122 |
| project management | 4.50 | 1.530850 | -2.969150 |
Our skill gap analysis compares the team’s average skill levels with normalized job market expectations. The “Skill Gap” metric is calculated based on the frequency of each skill’s appearance in job postings, rather than a direct assessment of skill proficiency required by employers. As such, while skills like SQL and Python appear to have smaller gaps, this may partly reflect the fact that they are mentioned slightly less often in the postings relative to emerging areas like cloud computing or machine learning. Nevertheless, SQL and Python remain critical foundational skills that the job market consistently expects from candidates.
The results indicate that the team meets or slightly exceeds market expectations in communication and SQL. However, there are notable gaps in technical domains such as machine learning, cloud computing, PySpark, data visualization, and project management. These areas should be prioritized for upskilling to align better with market demand.
Word Cloud of Skills
The word cloud highlights the most frequently mentioned skills in job postings related to data science, business analytics, and machine learning roles. Larger words like “programming language,” “problem solving,” “business intelligence,” “SQL programming,” and “data analysis” indicate skills that are highly sought after by employers. Other prominent terms such as “project management,” “Python programming,” and “Microsoft Excel” further emphasize the blend of technical, analytical, and project-oriented skills expected in the industry. This visualization captures how employers prioritize a balance between technical proficiency and business acumen.