Group 3: Early Women Graduates using Tableau Public

[CathGalway]

I'm not getting very much out of this at all. One of the things that is slowing me down is the fact that in one instance 1905 seems to have been entered as 1095. Do we think it's OK to correct this?

[ElisaCas]

Me neither. I think the csv file contains data not sorted correctly. For example dates, names + school, NUL, unmatched dates. What can we do with these data and file? Can we modify them in order to achieve the most appropriate and relevant visualization? Thanks

[EBenbow1]

Dear all,

Very much the same for me, I also found the 1095 instance, I tried to do a graph of entry by year but it ended up looking a bit weird because a couple of the odd datasets.

https://public.tableau.com/profile/eliot.benbow#!/vizhome/RHULEarlyGraduates/Sheet5

Best wishes,

Eliot

[CathGalway]

I think we're going to have to modify this data if we want it to display meaningfully.

[ElisaCas]

So do you think that data like NULL and random conjunctions like "and" are not useful and can be eliminate? I think so, but we are also modifying the original dataset. Probably this exercise was made with this purpose, to verify what happens in case the cvs file is not "perfect". Thank you. Regards, Elisa

[CathGalway]

Yes, I think we can do that, although you are right that it modifies the dataset. I'm interested in what we do with the "staff" category, which is entered in many columns, standing for date, school, subject etc. Also, see the eigencentrality column? Presumably it's used because the dataset is conceived as a social network, but we don't see the connections on which those numbers are based. What is giving me some concern though, is that often those numbers are attached to graduates coded as "staff" so by removing those people would we be taking out people who are significant in other ways to the dataset?

[ElisaCas]

Yes, probably we will lose some data about people. But the category Student is repeated and somehow redundant: full name+degrees etc. and then again names, surnames. About the eigencentrality, I can't understand its meaning, it looks like a math variable. I hope we can come up with something interesting by tomorrow!

[CathGalway]

Agreed. I'm going to spend half an hour today cleaning up this data - adding location to the schools and so forth. I'll post the results here. It'll be in around 90 minutes, because I'm teaching before then....

[EBenbow1]

This has been very interesting to think about, I've also been looking at the varied ways the "Degree" column for subjects and (sometimes) classification are displayed. There must be about 5 or 6 different combinations of data organisation and input going on there. Some give more information than others - specific subject, classification etc. I'll try and put something together for that this afternoon :)

[CathGalway]

I think I'm going to take out all the staff. On the grounds that it is unclear that they did a degree. I think the original data has been all the women in the college at the time. I'll keep them on one sheet, so you can add them back if you want.

[MarkQUB]

I have done the same and excluded 'staff'. I have done one looking at degrees by year so thought it unnecessary to include staff: https://public.tableau.com/profile/mark.o.rawe#!/vizhome/DegreesbyYear2/Sheet1?publish=yes

[MarkQUB]

I have done the same and excluded 'staff'. I have done one looking at degrees by year so thought it unnecessary to include staff: https://public.tableau.com/profile/mark.o.rawe#!/vizhome/DegreesbyYear2/Sheet1?publish=yes

Apologies that is the wrong link! Here is the correct one: https://public.tableau.com/profile/mark.o.rawe#!/vizhome/DegreesbyYear3/Sheet1?publish=yes

[CathGalway]

This is taking longer than half an hour. Apologies.

[CathGalway]

Here's a screenshot of what I've been able to do with it. I'm hoping I can go back and play about with filters.

[ElisaCas]

Dear All,

I am attaching the screenshots I have made in Tableau. I hope they work. I used the CVS file provided for the course, just slightly altered. The first one still contains data not really relevant, the others can be more interesting, because I didn't take into account data as NULL, "and". Some of them just show the same data by different visualizations: I think bar charts/bubbles/etc. and different colours can influence our perception of data and be more or less effective for our purposes. I also experimented, like in Tableau 5, where I considered Eingencentrality (but I don't know its importance or use) and name+subjects without changing the original file.

Regards, Elisa

[CathGalway]

So this is as far as I think I can take this before the workshop tomorrow, because of my schedule. I can't get it to save on the Tableau Public site so that it is viewable on one screen, but they are actually linked, which means you can examine the spikes and trends.

[CathGalway]

I don't know whether this works https://public.tableau.com/profile/catherine.emerson#!/vizhome/TestonGraduates/Dashboard1?publish=yes

[ElisaCas]

Thank you Catherine. It works, it's interactive (from my smartphone, at least). I think is very clear.

[MarkQUB]

https://public.tableau.com/profile/mark.o.rawe#!/vizhome/GraduatesxArrivedxSubjectAreaxDegree/Sheet2?publish=yes

I was interested in looking at subject areas by the degrees held by graduates. This is all still very new to me so I apologise for the very rudimentary charts!