Payroll-Control Panel LA
The database that I looked into was the Payroll information for all Los Angeles city departments since 2011. There were jobs such as a zoo veterinarian, zoo research directors, zoo registrar, zoo curator of reptiles and zoo curator of education. And the data was broken down into employment type, projected annual payroll, hourly or events, and then the different payments monthly. My datasets ontology consisted of breaking down the different payrolls that occurred in the different years. This was consisted of a lot of different numbers including the breakdown of projections of what one would be paid and also the actual earnings which made it interesting to see the comparison and margin of those numbers. I think many people could use and find this database helpful. Such people could include young people that are beginning to start their careers or at least starting to plan out their future and looking at these numbers can give them an idea of what to expect if they are in this field. If younger people are interested in becoming lets say a zoo vet, and they had to decide between this and another job, a deciding factor can very well be the money and with access to this database, this could very well help them out in deciding or making long term plans. This database can also be found helpful from people involved at the zoo. If someone who is in charge of the zoo or helps runs it, has a good idea of how much workers are making, then it is easier to keep a balance of the work to pay ratio. It would be helpful with maintaining the economic price range of the whole zoo and make it easier to have a good lay out and understanding of how successful the zoo is doing. From this database, I can tell that zoo vets make a good amount of money for their job. I can also examine that other jobs such as firefighters, city employees and city planning people are paid differently when it comes to hourly, monthly, and even yearly. This is all about a balance and making sure the city is getting what it needs, along with making sure workers are getting what they deserve as well. Something that is left out that I noticed was if any of this includes raises or other benefits. If I were to start over with a new database, I would described the different jobs in a specific field so people trying to decide between two close jobs would have a more specific and clear idea of the numbers.
https://controllerdata.lacity.org/Payroll/Payroll/qjfm-3srk/data
This is awesome! I loved how you broke down how the payroll data was separated and now I am especially fascinated in how these niche jobs are paid over periods of time and the actual and predicted earnings. It definitely is useful for those looking for a job like a zoo vet. Keep up the great work!
I appreciate how you spent the time discussing multiple groups of people that could benefit from payroll data like this; it helps form a larger picture of how this data plays a role in everyday decisions. The topic itself was interesting, and you did well in describing how the dataset is broken up. I think it would be helpful for you to break up your blog entries in to separate paragraphs, just so it is a bit easier to read and doesn’t look as chunked together. I also would have liked it if you talked a bit more about how the dataset would be different if a different ontology was utilized. All in all, good job!