Hang Nu Song Nguyen

For me, the idea of “garbage in, garbage out” is very important for data analysis. It is the big issue that the people who design data systems are not the users. Moreover, the users do not understand IT enough and can not predict uncertain business conditions and how these conditions affect the way to store and extract data. The ineffective…[Read more]

During the Thanksgiving season, many supper-markets with or without deli food departments offer turkey, chicken, sea food (such as shrimp, crab, lobster, etc.) duck, beef, and pork to make traditional and non-traditional Thanksgiving dinners. A Thanksgiving question involving clustering would be which local/regions in America like which kinds of…[Read more]

The business question to be answered is whether a person will pay for public speaking online course based on any of the following combination of variables such as Age, Gender, Educational level, Income, Job title, and Taking course (willing to pay=1 , not willing to pay =0). A decision tree will provide a simple illustration of branching and…[Read more]

A data cube that we didn’t discuss in class is described:

The business question to be answered: how age and gender impact time to involve e-sport
The dimensions: catalogs of age, types of gender (Male/Female), duration
The measured fact(s). the engagement of demographic viewers.

One example of how data could be stored in a different way is Phone number. In the U.S, there is no difference between mobile and desk-phone number such as (xxx) xxx-xxxx. However, in the Vietnam, there was difference between them. For example; Vietnamese mobile numbers have aaa-xxxxxx (aaa; 3 digit numbers of specific phone provider; after that,…[Read more]

Link to Infographic: http://coolinfographics.com/blog/2018/9/17/animated-history-of-home-siding-materials.html
I choose this infographic that is a good example because I can understand the story that the infographic to tell me immediately. I see 6 types of home siding materials with different colors and the colors are similar to the colors of…[Read more]

I would like to learn more about relationship, cardinality, and schemas

The most importance takeaway from Maurice Whetstone’s talk is that the way people treats you by the way you allow them. QVC is a cable, satellite broadcast television network, and flagship shopping channel specializing in televised home shopping. They collect data in real-time with multiple channels. Collecting data in real-time can motivate…[Read more]

If I have one table “Inventory” and other table ” Warehouse”, I need to join those table to figure out how many specific inventory item was in a company’s warehouses.

The trickiest thing about making an ERD from a problem description is figuring out the cardinality. There is an unclear answer in a complex scenario. The best way to handle this is draw a basic relationship between entities, go back and forth with each option, and add the option on ERD by finding logical and weighting it.

I work as an intern at a small accounting firm. I enter transactions from clients’ bank accounts to Quickbook called batch. After completing 12 month bank statements, we conduct Annual Profit and Loss reports that use like information to start to do tax returns for clients.