Power BI Journey: Blog #8

It is finished! The second to the last vlog talked about the different visualizations and when they are appropriate to be applied while the last vlog was about the final project which utilized all the lessons learned from Vlog 1 up to now. And, here is my final output.

In the above dashboard, we can see some demographics as indicated by the 630 total survey participants with an average age of 29.87 years old. We can also see that data scientist has the highest average salary ($94k) followed by data engineer ($65k) then data architect ($64k) among data professionals. We can also see that the favorite programming language of data professionals is Python, followed by R and other programming languages and the distribution of data professionals in each of the given programming languages. For example, for those who selected Python as their favorite programming language, 255 of those were data analyst, 54 are either a student or still looking for a job or no job at all, while 54 have other job titles. We can also observe that a significant number of data professionals found it neither easy nor difficult to transition to becoming a data professional, followed by those who found it difficult and then followed by those who found it easy. Work-life balance is at 5.74 while salary satisfaction is at 4.27. This means that, on average, data professionals have above average work-life balance and a below average salary satisfaction.

What I found interesting in the final project is that whenever I click the country of origin, all the data pertaining to that country of origin will be displayed. It shows that the dashboard varies depending on your preferences. For example,

In this case, I selected the country of origin for survey participants in India. Here, we see that there are 73 survey participants and the average age of those who participated in the survey is 27 years old. We can also see that still the highest average salary in India are data scientist ($68k) followed by data engineer ($52k) then others ($27k) among data professionals. We can also see that the favorite programming language of data professionals is Python where 31 data analyst reported utilizing the said programming language. Work-life balance is at 4.79 while salary satisfaction is at 3.51. This means that, on average, data professionals have below average work-life balance and a below average salary satisfaction. These numbers are comparably lower than the average work-life balance and salary satisfaction for all countries.

I am amazed by this platform and the possibilities it could make with data. Can't wait to apply this on a real-world data and work as a data professional. Maybe take this survey in the nearest future. Thank you Alex the Analyst.

Comments

Privacy Policy of ShinStats: descriptives calc

Privacy Policy Shin Nix built the ShinStats app as an Ad Supported app. This SERVICE is provided by Shin Nix at no cost and is intended for use as is. This page is used to inform visitors regarding my policies with the collection, use, and disclosure of Personal Information if anyone decided to use my Service. If you choose to use my Service, then you agree to the collection and use of information in relation to this policy. The Personal Information that I collect is used for providing and improving the Service. I will not use or share your information with anyone except as described in this Privacy Policy. The terms used in this Privacy Policy have the same meanings as in our Terms and Conditions, which are accessible at ShinStats unless otherwise defined in this Privacy Policy. Information Collection and Use For a better experience, while using our Service, I may require you to provide us with certain personally identifiable information. The information that I request will be retaine...

Power BI Journey: Blog #6

In this lesson, the focus is on "Conditional Formatting" which is very much similar to the conditional formatting in MS Excel which I could relate to following the making of the joint reporting system for personnel during my second job. Basically, we click the data columns that we want to be displayed in a tabular visualization. Next, we select the columns that we will be applying conditional formatting to > Right-click on that column > Select Conditional Formatting > Select from among the options which is more appropriate for your application In this particular exercise, we utilized Background conditional formatting using gradient (applied on the first column of the first table) and rules (IF ELSE which was applied on the second column of the first table), Icons conditional formatting (applied on the second column of the first table), Data bars conditional formatting (applied on the second column of the first table and the fourth column of the second table). In the...

SQL Journey: Blog #3

I have reached the end of lesson 2. The final project is entitled "Data dig" where we are given a set of interesting data sets: NASA astronauts , Superbowl results , Pokemon stats , NBA players , Top movies , Top countries by population , Solar system objects by size , Marvel characters , Furniture store sales , Earned KA badges , Winston's donut logs , Card game results , and NFL draft picks . We are to pick one of those data sets and use advanced SELECT queries to discover things about the data. What sort of questions might one have about that data, like if they were using it for an app or a business idea? Here are some ideas:What are average, max, and min values in the data? What about those numbers per category in the data (using HAVING)? What ways are there to group the data values that don’t exist yet (using CASE)? What interesting ways are there to filter the data (using AND/OR)? Basically, the above given questions will serve as a guide on what we could dig from ...

Shin Nix

Search This Blog