Shuyi Sun

The most important takeaway for me from the course is data visualization. I learnt how to transform lots of data into table, charts and infographics which is easier for people to understand the information. I would explain to a future employer that the technical skills I learnt from this class includes ERD, SQL and R. Those are some languages that…[Read more]

A thanksgiving themed question could be what state prefer online shopping on Black Friday rather than go to the mall. The data needed includes the shopping record differentiated by states, numbers of online orders and in-store purchases. This cluster analysis can help brands to assess marketing strategy, determine whether they should focus…[Read more]

A business decision tree example: For a auto insurance company, whether they should offer a person insurance plan. This question helps the company manage business risks. Variables in this tree includes the person’s age, gender, occupation, license’s history/length, driving score/experience, etc. The insurance company will determine whether to make…[Read more]

The business question to be answered is: What airlines did a passenger choose in the past 10 years? The dimensions are passenger ID, the year and the airline company. The measured facts could be the frequency of a passenger choose the same airline in a decade and what particular year this passenger choose the airline. We can tell which airline is…[Read more]

One example I can think of how data can be stored in different formats is that people always write a probability in three ways. We can use either a percent, a fraction, or a decimal to represent a probability. For instance, the probability of getting the head side of a coin when you flip it can be written as 50%, 1/2 or 0.5. The solution is…[Read more]

http://coolinfographics.com/blog/2018/9/17/animated-history-of-home-siding-materials.html

I really like this infographic because it tells me a story of the history of home siding materials in a simple way. Even I don’t know much about home siding materials, I can still easily understand what’s going on in this area. This data visualization…[Read more]

I would like to go over cardinalities in ERD as well as discussing more about in what cases we should use joins and subselect functions in SQL.

I was helping my friend with his psychological research and we collected raw data from social surveys which contain different targets, those groups were divided by ages, genders, careers, etc. Each question in the survey was designed as an attribute of the topic, and we took the answers transferred into the matching characteristics then use them…[Read more]

One of the companies that has a platform business model is Uber which relies on networks, network effects facilitate exchange and create distribution value among players because it allows people to interact online. People can do business or get service through an app and the whole system is running based on credits. Uber is an successful example…[Read more]

Nothing is impossible, Martin Ford’s idea is kind of scary and unbelievable when I first heard it, but later on I agree what he said that technology will take our jobs in the future, maybe not in ten years, but possibly in decades. His example of horse is funny but it’s a very true fact, and I found that some old jobs are disappearing right now, I…[Read more]