-
Jiying Li commented on the post, Weekly Question #10: Complete by December 6, 2018, on the site Data Analytics – Fall 2018 2 months, 2 weeks ago
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.
-
Jiying Li commented on the post, Weekly Question #9: Complete by November 29, 2018, on the site Data Analytics – Fall 2018 2 months, 3 weeks ago
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.
-
Jiying Li commented on the post, Weekly Question #8: Complete by November 15, 2018, on the site Data Analytics – Fall 2018 3 months, 1 week ago
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]
-
Jiying Li commented on the post, Weekly Question #7: Complete by October 25, 2018, on the site Data Analytics – Fall 2018 4 months ago
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.
-
Jiying Li commented on the post, Weekly Question #7: Complete by October 25, 2018, on the site Data Analytics – Fall 2018 4 months ago
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.
-
Jiying Li commented on the post, Weekly Question #5: Complete by October 11, 2018, on the site Data Analytics – Fall 2018 4 months, 2 weeks ago
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] -
Jiying Li commented on the post, Weekly Question #4: Complete by September 27, 2018, on the site Data Analytics – Fall 2018 4 months, 4 weeks ago
Schema and Cardinalities
-
Jiying Li commented on the post, Weekly Question #3: Complete by September 20, 2018, on the site Data Analytics – Fall 2018 5 months, 1 week ago
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]
CONNECT