Analysis of Data Scientist Salaries

Hello, in this blog post, we will try to analyze the data scientist salaries by various factors. We will first upload our data to MySQL, we will do data manipulation there. After that we will upload it into the google data studio for creating an interactive dashboard. Data set link.

Lets start by removing the rows that we are not going to use

ALTER TABLE mytable
DROP COLUMN FIELD1,
DROP COLUMN work_year,
DROP COLUMN salary,
DROP COLUMN salary_currency,
DROP COLUMN employee_residence,
DROP COLUMN company_location;

and renaming the columns that we need to change

ALTER TABLE mytable
RENAME COLUMN salary_in_usd TO salary;

Now we need to change data types in order to make changes in our data set

ALTER TABLE mytable
MODIFY COLUMN experience_level VARCHAR(15),
MODIFY COLUMN employment_type VARCHAR(15),
MODIFY COLUMN company_size VARCHAR(10);

Now we can update the values in our data set. Lets start by updating the experience_level column

UPDATE mytable
SET experience_level = "Junior"
WHERE experience_level = "EN";

UPDATE mytable
SET experience_level = "Mid"
WHERE experience_level = "MI";

UPDATE mytable
SET experience_level = "Senior"
WHERE experience_level = "SE";

UPDATE mytable
SET experience_level = "Expert"
WHERE experience_level = "EX";

Employment type column

UPDATE mytable
SET employment_type = "Part_time"
WHERE employment_type = "PT";

UPDATE mytable
SET employment_type = "Full_time"
WHERE employment_type = "FT";

UPDATE mytable
SET employment_type = "Contract"
WHERE employment_type = "CT";

UPDATE mytable
SET employment_type = "Freelance"
WHERE employment_type = "FL";

Company size column

UPDATE mytable
SET company_size = "Small"
WHERE company_size = "S";

UPDATE mytable
SET company_size = "Medium"
WHERE company_size = "M";

UPDATE mytable
SET company_size = "Large"
WHERE company_size = "L";

and we can view it by SELECT * FROM mytable; and export it in order to uploading our updated data into the google data studio. We can finally create our dashboard. And here is our interactive dashboard :