Cole Derhammer

The most important takeaway for me from this course was learning how to use and interpret MySQL and RStudio. Another important skill that I learned was how to analyze data through the use of pivot tables created in Excel. I learned a little bit about pivot tables in the Introduction to Microsoft Excel course, but I feel that I was able to…[Read more]

A business question that you could answer using a decision tree would be what type of car someone might buy. Car dealers would be able to analyze a person’s age, gender, marital status, and income level to make this prediction through the use of a decision tree. For example, a married man, who has three children, would probably more interested in…[Read more]

Uber has become an extremely popular transportation service over the last few years. In doing my research of R, I found out that Uber uses it for statistical analysis. An example of how it uses R would be tracking how much DUI rates decrease in areas that offer their service.
http://blog.revolutionanalytics.com/2014/06/more-companies-using-r.html

Your Brain On Beer vs Coffee

I thought that this infographic was interesting because it showed how your brain reacts to drinking beer vs coffee. The graphics and color schemes did a good job of showing distinction between the two drinks. The beer graphic was an orange tone and the coffee graphic was a…[Read more]

An example of joining tables together to retrieve more information in an entity relationship diagram is when we created a schema for the housing authority. In order to find out which unit a certain household lived in, we had to combine the the unit and household entities into a separate entity which we named unit-household. Then we were able to…[Read more]

I think that the trickiest part of creating an Entity Relationship diagram is selecting the right entities and figuring out the cardinality between each entity. I will read the narrative multiple times and then underline what I think could be entities and circle the attributes. To determine the unique identifier, I just put either “number” or “ID”…[Read more]