Yan Chen

For Amazon, there will be users/order/product/address rows. And columns as following:

Users: user_id, age, address_id, order_id
Order: order_id, user_id, product_id
Product: prodcut_id, description
Address: address_id, state, city, zip_code

The biggest challenge of assignment 4 is to select the useful data. I screened out the bad data and selected the data that could be useful to the problem we tried to solve. And turned the data that I chose to information, and analyzed the information we got. Then we set a threshold to narrow the range of information that should be analyzed.

A KPI I use every day is “weather” app on my phone. I check the weather to get dress and it also tells me if I need to bring an umbrella. The “weather” app helps a lot with checking the temperature and provides me conveniences.

There is a time that I clicked “yes” before full consideration. This is a really bad habit that do not think comprehensively before make that decision. And that time I did not save my document for my editing. So I lost some processes of my homework and I had to redo the homework from a very first draft.

“Simplify” is the most important principle to me. The main point of data visualization is to make data more understandable to the majority who know less about data analysis. Providing data that is easy to understand, helps the providers to be more persuasive. Plus, the outcome of data visualization will be more clear with the results and…[Read more]

The presentation impressed me by how the information and data improve the development of the company. With the technology developing rapidly, the skills to process data become more and more important. Mr. Celebi really uses his professional knowledge to present the actual situations to us and let me understand how useful these techniques could be.

https://fivethirtyeight.com/features/students-at-most-colleges-dont-pick-useless-majors/
This article with the data mentioned in it points out an interesting phenomenon that students regard the higher level education as an investment to their life, rather than learning something they are interested in. With this data, we can know what majors are…[Read more]

In the large corporations, the workers with working visa are more likely to have a higher educational background than local workers. In any country, the policies usually beneficial to the local workers. Therefore, two workers with the same level of educational background, the local job seeker can find a job easier. We can test that by collecting…[Read more]

http://www.theguardian.com/fashion/shortcuts/2016/mar/29/rise-blackout-tattoo-trend-internet
This article is about covering tattoos. And I am interested in this because I have a tattoo, but I really hope I don’t. I want to know how people deal with tattoos that they don’t like any more. To be honest, “blackout tattoo” sounds terrible to me. I…[Read more]

According to the article “Stephen Few on Data Visualization: 8 Core Principles”, I think the most important point is to simplify. Today we need to face more and more data, and if we cannot make the data brief and clear, the pattern can be difficult to find. And simplify will become more difficult in future, not just because there will be more…[Read more]

Maurice Whetstone’s presentation let me saw the strength of data. People are influenced a lot by data, so the most important thing is to make sure you are not fooled by the data or give other the wrong messages. You should have your own opinions about the data you get, and think it critically. But never doubt everything, because the data is c…[Read more]

Maurice Whetstone’s presentation let me saw the strength of data. People are influenced a lot by data, so the most important thing is to make sure you are not fooled by the data or give other the wrong messages. You should have your own opinions about the data you get, and think it critically. But never doubt everything, because the data is c…[Read more]

http://fivethirtyeight.com/features/billion-dollar-powerball-lottery/
The lottery bonus is a hot topic recently. The huge number of bonus made more people expected to get the money. And the tickets had been sold even more than three times of the population of the United States. These data of lottery exposed people’s desire of unearned money,…[Read more]

Some people said that students get better grades if they spend more time on study than others. I think there should have some relations between with the hours of working and the grades, but this won’t be correct every times. I can collect the average studied hours for each day and the final grade of some students in a specific semester. And…[Read more]