Are you underpaid? or you are getting paid in the market range? If you are looking for a job, what range of salary you should be looking for? The Salary survey and the report is helpful to answer these questions. A salary survey is a form that everyone fills, and from the result of that, a report is generated. This is merely a report of your own data. I don’t get it from a web query or anything like that. Here is how it works, and how you can use it.
Introduction
This is the time of the year for the Power BI salary survey. Last year we have over 600 participants. The survey for this year includes one new question about the salary change because of the COVID-19.
This survey uses the result from the Microsoft Form and pushes it to Power BI using Power Automate.
Enter your Salary info
No confidential information is required from you, no email, name, company name, etc. So feel free to enter the values without any doubts.
Here is a Microsoft Form I have created that you can easily answer. Answer the Survey
Or you can even enter your data here directly:
Check the report
Either you enter the data or not, you would be able to check the report here:
Things to know
- The report data is merely from the form filled by all others.
- Be honest in entering your information, do not enter information more than once.
- There is a tab in the report above, in which you can filter using slicers to find out what is the average salary for your selection criteria.
- the survey and the report are built using Microsoft Forms, Power Automate, and Power BI (I might write an article about that later).
- To get more accurate results, encourage everyone in the Power BI space to go and fill the form.
- No sensitive information (email, IP, name, company name, etc) is stored.
- Because the result is a report (not a dashboard), it won’t show you the result in real-time, but after an hour or two, you should be seeing the result added hopefully.
- If you still don’t see any data in the report, that is probably because we are still waiting for some submissions to come through.
- If there is a field, which is not in the survey, and you feel is important to add, please let me know in the comments below.
Here are some sample screenshots of the report (the sample screenshots are with my sample test data of five entries, which has been wiped out before posting this article);
Categories:
What should be my salary?
Details page (You can navigate to this page using right-click, drill through from other pages)
Salary Survey 2020
For the complied report of salary survey 2020, check out this link:
Reza is author of more than 14 books on Microsoft Business Intelligence, most of these books are published under Power BI category. Among these are books such as Power BI DAX Simplified, Pro Power BI Architecture, Power BI from Rookie to Rock Star, Power Query books series, Row-Level Security in Power BI and etc.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.
Thanks Reza for the initiative and for the work done. This is really great!
I think using combo boxes for the country and one for currency, as well as restricting salary entry to numbers only in the Ms Form would have helped ensure greater quality of the output.
In some countries, the values of the currency easily brings you to millions in the local currency. Not knowing the reported currency and not having a common base makes it impossible to compare cross-country. Furthermore, for those same countries, the deal is often negotiated in US dollars and one would better report in that currency. That’s why I would suggest to add a field for the local currency in which one reports.
Additionally we could be given the choice to input an hourly rate, daily rate and so on. Someone declaring a 30K USD of annual income could have a higher hourly rate (with less deal in the year) than someone declaring a 45K USD of annual income.
Hi David
good point about hourly/daily rates etc. Will consider it for 2022.
I am also a bit beginner in MS forms, have to learn how to do those settings.
there will be a cleaned-currency-exchanged version of the report available in a few weeks.
Cheers
Reza
wow i’d better moving to brazil…
🤣🤣
This is awesome! I’ve been wanting to see something like this, I feel that LinkedIn and Glassdoor don’t properly categorize Power BI Report Developer type of roles. Although Job Titles are all over the place in this report, I think some of the other categories could be cleaned up a bit (3 different versions of United States for country) and perhaps provide a list (dropdown) of values to choose from in the survey if appropriate. The top right bar chart could have the y axis widened to view longer job titles and maybe a tooltip popup to show individual salaries for each title you hover over. Just a couple ideas….oh yeah and maybe use the filter pane cause on the 1st page if you select a value in one viz and want to add filtering by selecting another value from a different viz you can only filter by the most recent selection….adding filters to the filters pane would solve this.
Thanks
We would provide a more detailed, clean and currency-exchanged report in a few weeks when we have enough participants 🙂
Cheers
Reza
Hi Reza. Czechia and Czech Republic is the same. It is just Short vs Long name. Perhaps, next time you should use some OptionSet, Also, for Czech Republic, there is 78k. But this seems to be monthly value. Definitively not annual in local currency.
Hi.
This is not a cleaned version of the report, check out this post for that.
Cheers
Reza