Chi Ho Max Tong

  • Chi Ho Max Tong‘s profile was updated 3 months, 2 weeks ago

  • Chi Ho Max Tong posted a new activity comment 6 months, 2 weeks ago

    The best benefit from this class is the languages learned for developing database and data analysis. Really amazed by what R-Studio can do and it provide a huge advantage for me and better prepared me for the future career. I would definitely let the potential companies know what I had learned from the class and how I can demonstrate my skills to…[Read more]

  • Chi Ho Max Tong posted a new activity comment 6 months, 3 weeks ago

    Clustering can solve customer group for Black Friday, relevant variables could be something like demographics, when did they start shopping, how far away did they go, the amount of money spent and duration in the mall. this could help firms to know where they are how much do they spend, and how long did they stay in the mall. so next time they…[Read more]

  • Chi Ho Max Tong posted a new activity comment 7 months, 1 week ago

    A good example would be using decision tree for the insurance industry, it helps calculated the expected loss by analyzing which factors have the higher frequency or severity, it also helps contribute when considering which factor is useful for decision making, such as tobacco use, gender, age, geographic area, health status, etc. it also helps us…[Read more]

  • Chi Ho Max Tong posted a new activity comment 7 months, 3 weeks ago

    I think the information that the website provided is more like OLAP/Pivot table, it’s only showing what crimes happened in the area over the past. And it is up to the user how they want to use the data presented on the website. as an example, by using those past history data, a user can easily identify which area have the most crime history, and…[Read more]

  • Chi Ho Max Tong posted a new activity comment 8 months, 1 week ago

    A good example of how data can be stored in different formats are Y/N, 1/0. it can be used in the different database or same database, which might create confusion for the system to connect the data together, a good way to reconcile the problem is to set the back logic of the system to accept either one of the formats, and will reject any other…[Read more]

  • Chi Ho Max Tong posted a new activity comment 8 months, 2 weeks ago

    Your Brain On Beer vs Coffee


    this is an interesting infographic, introducing how should we get the energy to focus or being creative, This infographic is good because the audience can compare the good or bad of consuming either product and it’s suggesting an idea that not much students would do it at…[Read more]

  • Chi Ho Max Tong posted a new activity comment 9 months ago

    still thinking it would be great to go over some ERD examples specially related to the carnality, and mainly focusing on SQL, how to identify the true meaning of the questions, how to identify what to use, (distinct and such), does the sequences matter as they go left to right (film.film_id= inventory.film_id) (inventory.film_id = film.film_id)

  • Chi Ho Max Tong posted a new activity comment 9 months ago

    I was working at fossil, company used a customer database to track all customer behavior, at each transactions, they would collect customers names, emails, address, and phone number then they would use the system to record what product did customers bought. By connecting product type and customer emails, they joint both tables together and with…[Read more]

  • Chi Ho Max Tong posted a new activity comment 9 months, 2 weeks ago

    the most trickiest thing for creating an ERD, is determining the attribution for entities or relationship. when doing the in-class exercise I always confuse where to put the attribution, should it connect with relationship or connect with entities. Solution for that is when looking through the paragraph, make sure write down all the entities…[Read more]

  • Chi Ho Max Tong posted a new activity comment 9 months, 3 weeks ago

    I was working in the retail, we would have a system similar to transactional database. At the closing time, manager would take out all the sales record and start analysis, when is the most busiest period, how many items does customers buy in a single purchase, did we reach the goal of the day, what should we do the next day, and we analysis…[Read more]

  • Chi Ho Max Tong‘s profile was updated 9 months, 4 weeks ago

  • Chi Ho Max Tong‘s profile was updated 1 year, 5 months ago

  • Chi Ho Max Tong changed their profile picture 1 year, 5 months ago

Skip to toolbar