Data Source

and related info. File format is a .csv file. The dataset was obtained here: https://github.com/AlexTheAnalyst/Power-BI/blob/main/Power%20BI%20-%20Final%20Project.xlsx

Data cleaning

I decided to perform all of the data cleaning steps within PowerBI (i.e. not prior to in the original .csv file).
While it can be easier to perform much if not all of initial data cleaning steps outside of PowerBI, I wanted to use the
included toolset for this project.

Sample list of some of the data cleaning steps:

a) AVG SALARY
Separated salary values from ranges to average values. Salaries were given by the paricipants as ranges (e.g. 60K- 100K USD).
The averages for theses data points were then calculated so that I could represent average salary values from the survey.
b) Removed unecessary columns
c) Removed uneeded abbreviations (e.g.: 'k' for thousands of USD)

Created the Dashboard