PowerBI_sample_project

Notes on the Data Professional Survey Project

(The image below is a .jpg image of the PowerBI project also incl. in this repository)

This is a sample project made in PowerBI with an outline of the steps below:

1. 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

2. 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)

3. Created the Dashboard