This is a project I made after watching some tutorial series on PowerBi. This is a full project that uses real data from this dataset.

I start by transfering the data from .xlsx file. I notice that the data will require some cleaning.

I start by transforming the data in Power Query and follow these steps:

• Delete the unused columns

• Some job positions fields are not well categorized

  • Excel could format this data in a more detailed way

  • For this exercise, I’ll split the “Other” and delimit the field using Split Column and a Custome Delimiter

    

  

  

• The result is the following columns:

• I do the same for the Favorite Programming Language column:

• I delete the Favorite Programming Language 2 column since it mosly contains null values

• I clean the Current Yearly Salary column by doing the following:

  • I duplicate the column to avoid corruping the data
  • I split the column by digit to non digit

  

• From there, I can delete the column with the “k” values, and I can replace the “k” and the ‘-” in the second column

• There’s an exception with the “+” value.
  • The original field mentioned 255+
  • If I delete it, there will be no field to make an average after. I need to solve this issue by replacing the”+” with 225
  • Then the average will be 225 by dividing the range between the 2 columns (might need a better elaboration)
• Then, I create a new custom column with the Average Salary after converting the new columns to the whole number format