Jiying Li

For me, this course helped me a lot. I was not in MIS major, but after this class, I felt it is very useful in my future career. I learned how to use SQL and R studio to deal with a huge amount of data. Our lives will be full of data in the future, so these tools will help me very much.

The Thanksgiving question involves the clustering would be which states in the US like to travel to where during Thanksgiving holiday. Ranking the top 2 places that people from each state that like to go to. The data should be grouped by state and to see what is the most popular place for people come from the same state.

A business question that you could answer using a decision tree is “Should the company book flight or train ticket for a team of employees?” This question will help the company to determine what is the most efficient way and also can save more money for the company. The data should be collected are the prices of flight and train at same time…[Read more]

The business question to be answered is What is the most popular brand of chocolate in the past 3 year. The dimensions are chocolate brand, year, and units sold. The measured fact would be how many units of chocolate had been sold of this brand.

The business question to be answered is What is the most popular brand of chocolate in the past 3 year. The dimensions are chocolate brand, year, and units sold. The measured facts would be how many chocolate of a brand did the customer buy.

How To Fix Common Cooking Mistakes

I choose this because I loving cooking and these are exactly the mistakes I usually make during cooking. It has very cute pictures matching each kind of ingredients. Adding more words can make these graphics to be easier to understand. I am not good at “reading” a map or any other…[Read more]

Schema and Cardinalities

When I help my sister to count about people who ordered candies or chocolate for their festival gifts during this summer for her organization, it should join different tables together. There are several tables such as employee, gifts, and shipping method. We need to determine which gift each employee wants to order and ship to their address by…[Read more]