abbyle269/insight-data-science-salaries

Power BI

Insight-Data-Science-Salaries

1) Import excel file to PowerBI and cleansing data

Remove irrelavant information from Others Options, by separate one column into two columns. We will apply this process to columns:

• Q1 - Which Title Best Fits your Current Role?.1
• Q5 - Favorite Programming Language
• Q8 - If you were to look for a new job today, what would be the most important thing to you?

Remove columns lack of information

Separate salary column to minimum and maximum columns

Relace letter k and character - to empty

Make another column by calculating the average of minimum and maximum columns

2) Visualization