Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


2016 Salary Survey in PowerBI


2016 Salary Survey in PowerBI

Author
Message
Christopher Huntley
Christopher Huntley
SSC Journeyman
SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)

Group: General Forum Members
Points: 94 Visits: 47
Comments posted to this topic are about the item 2016 Salary Survey in PowerBI
baiju04
baiju04
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 128
hi,

thanks for the post. Can you add the underlying data-set you have used in this tutorial? it would be helpful to do a hands-on

thanks
jorge_vicente
jorge_vicente
SSC-Enthusiastic
SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)

Group: General Forum Members
Points: 116 Visits: 149
ifthenelsenullif - Sunday, March 12, 2017 10:30 PM
Comments posted to this topic are about the item 2016 Salary Survey in PowerBI

Hi,

It is a very amazing post.
Thank you for this. I am from Spain and It's good for me to know which is the average salary and the average education.

Is there any field with the real age of the people (not experience years)?

Thank you again for so good post

Regards

jorge_vicente
jorge_vicente
SSC-Enthusiastic
SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)

Group: General Forum Members
Points: 116 Visits: 149
Other thing that I have seen surprisingly is about the certifications
There is a very small difference between people with and without.


It could be a good idea to make a difference of this chart in every country. I am sure that in several countries will can be bigger the difference.

Regards
Christopher Huntley
Christopher Huntley
SSC Journeyman
SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)

Group: General Forum Members
Points: 94 Visits: 47
baiju04 - Monday, March 13, 2017 6:35 AM
hi,

thanks for the post. Can you add the underlying data-set you have used in this tutorial? it would be helpful to do a hands-on

thanks

Here's a git repo link Thanks for the reply! The raw inital data can be obtained from this site
jorge_vicente - Monday, March 13, 2017 7:50 AM
Other thing that I have seen surprisingly is about the certifications
There is a very small difference between people with and without.


It could be a good idea to make a difference of this chart in every country. I am sure that in several countries will can be bigger the difference.

Regards


It's actually pretty close


However it can be outliers in a lot of places there's just not enough people to make a good estimate.

Eric M Russell
Eric M Russell
SSCrazy Eights
SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)

Group: General Forum Members
Points: 9749 Visits: 10359
So, our Russian and Irish brothers are at the top of the chart in terms of median salary, even after standardizing to USD equivalent?
Next time you guys are buying the drinks. Rolleyes


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
Eric M Russell
Eric M Russell
SSCrazy Eights
SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)

Group: General Forum Members
Points: 9749 Visits: 10359
One suggestion that would greatly improve the usefulness of the data, so as to accommodate for the relative sparsity of the data, is to limit industry to a selection of 20 or so categories, rather than allowing participants to enter it free-form. For example, I'm seeing 'Telecommunications', 'Telecom', 'IT & Telecommunications' split out separately. Also, 'Healthcare' and 'Healtcare'. There are also several variations of Technology.


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
tipums123
tipums123
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 92
Nice article!
Where did you get source data?

Thanks!
jorge_vicente
jorge_vicente
SSC-Enthusiastic
SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)

Group: General Forum Members
Points: 116 Visits: 149
[quo
ifthenelsenullif - Monday, March 13, 2017 8:29 AM
It's actually pretty close


However it can be outliers in a lot of places there's just not enough people to make a good estimate.
[/quote]

Yes, not enough people to make a good estimations Sad
But, it is a very helpfuly data. Nice work again!

Regards

PD: I cannot fix the "[quo" in the post Doze

Dan Guzman - Not the MVP
Dan Guzman - Not the MVP
SSC Eights!
SSC Eights! (846 reputation)SSC Eights! (846 reputation)SSC Eights! (846 reputation)SSC Eights! (846 reputation)SSC Eights! (846 reputation)SSC Eights! (846 reputation)SSC Eights! (846 reputation)SSC Eights! (846 reputation)

Group: General Forum Members
Points: 846 Visits: 740
I would like to see you put years experience against salary. Does time really equal money? Is there age discrimination? I agree with the category limitation mentioned. Free form is just too many typo's
Christopher Huntley
Christopher Huntley
SSC Journeyman
SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)

Group: General Forum Members
Points: 94 Visits: 47
Dan Guzman - Not the MVP - Monday, March 13, 2017 12:12 PM
I would like to see you put years experience against salary. Does time really equal money? Is there age discrimination? I agree with the category limitation mentioned. Free form is just too many typo's

Somewhat but again with the limited data and outliers it's hard to say.


Christopher Huntley
Christopher Huntley
SSC Journeyman
SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)

Group: General Forum Members
Points: 94 Visits: 47
tipums123 - Monday, March 13, 2017 9:00 AM
Nice article!
Where did you get source data?

Thanks!

The source data is here

jorge_vicente
jorge_vicente
SSC-Enthusiastic
SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)

Group: General Forum Members
Points: 116 Visits: 149
Dan Guzman - Not the MVP - Monday, March 13, 2017 12:12 PM
I would like to see you put years experience against salary. Does time really equal money? Is there age discrimination? I agree with the category limitation mentioned. Free form is just too many typo's


Yes!! It is a very good point. I am sure that could be an age discrimination in the salaries!
Eric M Russell
Eric M Russell
SSCrazy Eights
SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)

Group: General Forum Members
Points: 9749 Visits: 10359
Dan Guzman - Not the MVP - Monday, March 13, 2017 12:12 PM
I would like to see you put years experience against salary. Does time really equal money? Is there age discrimination? I agree with the category limitation mentioned. Free form is just too many typo's

I don't know if this could be measured, but my belief is that, broadly speaking, employers don't pay for experience quantitatively in terms of years in the industry but rather tend to pay for more qualitative metrics like past positions held, roles, and skill-sets. It's easy to say "I've been a DBA for 12 years.", but the problem is that most respondents could not accurately evaluate themselves on the more qualitative metrics. Even a question like what specific technologies the respondent has experience with is subjective. I guess the best way to frame the question would be "Do you use XYZ in your professional career, and do the people you report to at work regard you as experienced with XYZ? Yes / No", rather than simply "Do you know XYZ? Yes / No". It's more about people's impression of your knowledge and experience that determines your salary, not your own personal opinion. It is still possible for talented and experienced people to be under-rated or under-utilized, thus resulting in a lower salary, however, your own personal opinion is still important for other reasons, like giving your the confidence to move on or move up to another position that better leverages your talent.



"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
Christopher Huntley
Christopher Huntley
SSC Journeyman
SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)

Group: General Forum Members
Points: 94 Visits: 47
Eric M Russell - Tuesday, March 14, 2017 7:29 AM
Dan Guzman - Not the MVP - Monday, March 13, 2017 12:12 PM
I would like to see you put years experience against salary. Does time really equal money? Is there age discrimination? I agree with the category limitation mentioned. Free form is just too many typo's

I don't know if this could be measured, but my belief is that, broadly speaking, employers don't pay for experience quantitatively in terms of years in the industry but rather tend to pay for more qualitative metrics like past positions held, roles, and skill-sets. It's easy to say "I've been a DBA for 12 years.", but the problem is that most respondents could not accurately evaluate themselves on the more qualitative metrics. Even a question like what specific technologies the respondent has experience with is subjective. I guess the best way to frame the question would be "Do you use XYZ in your professional career, and do the people you report to at work regard you as experienced with XYZ? Yes / No", rather than simply "Do you know XYZ? Yes / No". It's more about people's impression of your knowledge and experience that determines your salary, not your own personal opinion. It is still possible for talented and experienced people to be under-rated or under-utilized, thus resulting in a lower salary, however, your own personal opinion is still important for other reasons, like giving your the confidence to move on or move up to another position that better leverages your talent.

O'Reilly did a really amazing Salary Survey which I found after I wrote this. It's here, and it's awesome. It's not database specific as it's data science but they had significant volumes and did the statistics on it so you can see it does matter.
Age, Experience, and Industry

Experience and age are two important variables that influence salary. The coefficient for experience (+3.8) translates to an increase of $2K–$2.5K on average, per year of experience. As for age, the biggest jump is between people in their early and late 20s, but the difference between those aged 31–65 and those over 65 is also significant.

Experience and age are two important variables that influence salary. The coefficient for experience (+3.8) translates to an increase of $2K–$2.5K on average, per year of experience. As for age, the biggest jump is between people in their early and late 20s, but the difference between those aged 31–65 and those over 65 is also significant.


You have to register but it's free after you do. It was basically what I really wanted here, it's that good. It's what we should aspire to every year.
archie flockhart
archie flockhart
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1290 Visits: 1153
Interesting analysis, but with the data all being self-reported, I'm not sure how much I'd rely on it. I always liked this quotation when looking at stats based on questionnaires:
  • The individual source of the statistics may easily be the weakest link. Harold Cox tells a story of his life as a young man in India. He quoted some statistics to a Judge, an Englishman, and a very good fellow. His friend said, Cox, when you are a bit older, you will not quote Indian statistics with that assurance. The Government are very keen on amassing statistics—they collect them, add them, raise them to the nth power, take the cube root and prepare wonderful diagrams. But what you must never forget is that every one of those figures comes in the first instance from the chowty dar [chowkidar] (village watchman), who just puts down what he damn pleases.

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search