Jillian Perrone

The most valuable part of the course for me was exposure to SQL and R studio. I believe that understanding the basics of SQL and R studio will be quite beneficial to my marketing degree and will set me apart from other marketing candidates who may not have exposure to these fields. I would explain to an employer that I have a great understanding,…[Read more]

A Thanksgiving-themed question that can be answered using clustering is “Based on US geographic regions, who is more likely to cook their own Thanksgiving meal rather than going out for the holiday?” The data collected includes the geographic regions in the US, where people spend Thanksgiving, age, relationship status, number of children, and…[Read more]

A business question that can be answered with the use of a decision tree is whether someone qualifies for a car rental. The data that can be collected is age, gender, credit score, income, occupation, and criminal history. The advice I would give someone regarding how to select the right predictor variables for a decision tree analysis is to make…[Read more]

A business question that could be answered with a data cube is “Which webpage had the most views in 2018?”. The dimensions would be webpage, year, and action. The measured fact is the total number of page views.

An example of how data can be stored in different formats is with currency. An American based company that does business internationally may have to change the currency format from other countries to the American dollar format, and vice versa. This problem can be solved using the Currency function in Excel to format all data into the same currency.

https://www.greenandvibrant.com/sites/default/files/inline-images/hydroponic-gardening-infographic.png

I chose this graphic because it thoroughly explained to me what Hydroponics is. The graphic was separated into organized sections with headings that explained how Hydroponics works, the types of systems, and what plants are best grown with the…[Read more]

A topic I would like to discuss during the review session is identifying when an attribute is attached to a relationship in an ERD. Also, going over cardinality would be helpful.

For a ride-sharing company, a join can be used to combine the Driver table and Rating table. You can join these tables to figure out the first and last name of drivers who have received an average rating above 4 stars on a 1-5 scale. This information could help to determine which drivers are satisfying customers.

I believe that the trickiest thing about creating an ERD is figuring out the cardinality. I find myself unsure of whether I am drawing the correct cardinality to describe the relationship, as well as if I am putting the relationship into words correctly. My advice when figuring out cardinality is to go over the practice problems and re-watch the…[Read more]

The fitness app Nike Training Club uses the data from my workouts to create personalized fitness plans that fit my routine. The app tracks the type, frequency, and duration of my workouts and uses this data to recommend what my next fitness plan should include. This information is useful to me because it helps me to track my performance and…[Read more]