Power Query Project 1

In the first Power Query example, we will look at data for one thousand staff and clean it up. The data is in an Excel file. We will load it to Power Query and perform below clean-up activities. After data is clean, we will publish the dataset to Excel for analysis. 

• Connect to Employee Data file
• Replace missing gender & department values
• Remove employees without salary
• Extract employee’s country and remove address column
• Extract year of join
• Publish data to Excel