Li Chen

In my opinion, the most important takeaway from this course was VLOOKUP, Pivot Tables and Concatenate of Excel. Although I’m not major in MIS, but I think it will helps me a lot in my future career. Those skills helps me in organize the massive datas and helpful for data visualization. I would explain to a future employer how this excel skills,…[Read more]

A Thanksgiving question involving clustering would be：How many pies were bought based on flavor? and which one is most popular in Thanksgiving. Collecting date with how many Pies were sold in total during Thanksgiving, and what are the spice type of Pies has been sold. From this data, we can know clusters represent which flavor is the most p…[Read more]

A business question that can be answered using decision tree is which stock is more valuable for investor. For investment, there are multiple options: Stocks, MF, Bonds and etc, all the useful information are collected for analyzing what the optimistic expected value and what the worst expected value. Adding all the expected value up, and compare…[Read more]

A business question that could be answered with a date cube could be “what is our best ticket sales show?” the dimensions would be the performer for the particular performance, the date of the performance, and the time of the performance. The measured facts would be the amount sales in numbers and dollars.

Your Brain On Beer vs Coffee

I chose this graphic because it clearly explained how human brain affected by coffee and beer. The graph is combine with two part, on the left side displays the beer, and on the right side displays the coffee. At the bottom, it also lists what the pros and cons of those two…[Read more]

For the exam 1, I would like to go over the SQL, Sub-select, and cardinalities of ERD.

The using join to retrieve information from a set of tables is very common in company’s HR department. when I had a HR internship last summer, I learn a lot of how join the employee information table with their given ID, by type in the ID you will get employee’s information, like name, email, phone, department and etc. Furthermore, you can join…[Read more]

I think the trickiest part of ERD is the Cardinality, it is the last and most important step of the whole ERD process, and it determined the relationship with all the entities. So, in order to make sure you are using the right cardinality to express the relationship, you have to pick up the related attribute from every next entity, because you…[Read more]