This week we have started to look into some data sets. I have picked the "Medical_School_Enrollment_TOTAL_by_School" and started to do some experiments.
I used two tools total to see which one I like better, R and Tableau.
First, I opened the xlsx file and found out it needs some clean up.
For example, on the second row, the first two grids should be "State" and "Medical School" instead of "Total Enrollment" and null. Also, in the fist column, the there are a lot of empty space for state information. So I have deleted the first column and renamed the two grids.
.
After that, I decided to visualize the enrollment of all the schools in the UC system.
Finally, I used ggplot to draw the diagram.
After that, I also got a chance to look at Tableau using the same data set.
I have to say that I prefer Tableau more because it is very neat and fast. It is also easier for people like me who is not a professional coder. I can focus more on what is the best way of presenting data rather than trying to figure out how to make it work.
This is the first diagram I drew. I was trying to show the same thing: the distribution of different ethnicities.
The next diagram I did was focusing on demographic information. The state filled with deeper colors means they have more students enrolled.
The third diagram was about comparing the number of total enrollment of all ethnicities with the total enrollment of white students.
After looking into the two tools, I would choose to work with Tableau more.
Comments