This project focuses on using PowerQuery Editor to clean up raw data from real world.
▻ Data cleaning is done to get data in structured manner: For example: Data profession has involved large number of job role which is simplified into "other" using power query editor
▻ Similar approach is done for favrouite programming language
▻ For column yearly salary as it is given in range like 30k-40k, the approach i used is seprated 30k and 40k in different column and average is applied on both column.
▻ Different approach to clean data
▻ Right visualiztion tool (i.e for cateforical column which contain 4-5 category a pie chart or donat chart should be used)
▻ Data Scientist earn the highest salary followed by data enginner and data architecture. ▻ USA has the most highest average salary and least highest salary is of India but salary structure depend upon cost of living of particular country ▻ You dont need to do Phd to get into data industry, A Bachloer and Master's degree would be enough to crack in this industry. ▻ No doubt Python is the favrouite language and the reason is obivious :) ▻ On an average salary wise Data professional seems to be not pleased.
Power BI, Microsoft Excel