Xiaoyu Liang

I’m a psych student, and I know the data is very important part of the research study. and before this course, I had a statistic course, but there have some differences between those two courses. The most important thing I learned of this course is how to use Excel and Tableau. I will recommend this course to future students, I will say this…[Read more]

rotten tomatoes stores movie reviews. the row will be short reviews, and columns will be the name of the movies, how many stars the movie got (0-5), the year of the movie produced, names of the director and main actors, which type the movie is, and who writes the reviews.

One example of a KPI is the Data plan on my phone. So I have 5G data plan per month, and when I used 2.5GB of the 5G, I will get the text from the mobile company. They will tell me I already used 50% data of this month and when is the bill ending. That can help me not overuse data otherwise I will pay more money for the data. on the other hand, I…[Read more]

I think the most important to avoid is start working on the database without doing a full backup first. The first reason is if you don’t have a complete backup you may mess up the whole data file and don’t have a chance to rework for it. Second is the computer is not always that stable when we work in data we need to think about such emergency…[Read more]

Inequality index: where are the world’s most unequal countries?
https://www.theguardian.com/inequality/datablog/2017/apr/26/inequality-index-where-are-the-worlds-most-unequal-countries

The topic is fascinating, the article is talking about from wealth distribution to the World Happiness Report – and which countries rate best and worst u…[Read more]

I think the most important principles core is the simplify. That’s why we’d like to have great big data but not let people read academic papers or have an observation by themselves. We like data cause data is reliable and easy to understand, everyone can read it. So that’s why I think simplify is the most important core.

https://www.theguardian.com/news/datablog/2017/aug/22/how-much-do-abortions-cost-across-australia-explainer

This article is talking about the dilemma of legal abortion in Australia. Campaigns for easier access to abortion in Australis can make the law have changed, but abortion still too hard to help those women who are homeless or low income.…[Read more]

An example of “conventional wisdom” is people think they shopping on the Black Friday will save their money. in this case, they forget when people see the sale item, they may buy more products even they don’t need it at all. for the test, I will compare the family expense on black Friday to rest of days. also, I want to check the discount rate of…[Read more]