@kevin-yili-hong
Active 11 years, 1 month ago-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 13 years, 1 month ago
Please spend 100 seconds to reflect on what you have learned in ER Diagram, and Database Schemas.
What is the most important thing you learned in the first week?
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 13 years, 1 month ago
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 13 years, 1 month ago
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 13 years, 1 month ago
Hi All,
Here are two useful MySQL reference books that you might find handy, especially when you forget the syntax!
MySQL Cookbook: this one can only be opened in windows environment
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 13 years, 1 month ago
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 13 years, 1 month ago
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 13 years, 1 month ago
•1. Come up with a Problem Statement!
•2. Gathering Info/Requirements from the descriptions: what are the entities, what are the attributes of entities. And draw rectangles for entities, and some circles around […] -
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 13 years, 1 month ago
Here are the questions for the case “Slots, Tables, and All that Jazz: Managing Customer Profitability at the MGM Grand Hotel.”
Make notes on these for the class discussion May 24!. Remember there will be a […]
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 13 years, 1 month ago
Hello everyone,
Tomorrow we will be having a 30 minutes in class exercise on ER modeling. It will get you more familiar with the ER diagrams, especially the complex cases!
You can find the exercise document <a […]
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 13 years, 1 month ago
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 13 years, 1 month ago
Hi all,
Since majority of you want to condense the course instead of having a make-up class, we will integrate the in-class exercise (Thursday) to Tomorrow, it will be about ER diagram. And we will be talking […]
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 13 years, 1 month ago
Hi all,
Please think of the following:
Scenario:
You are consulting for Facebook as they decide to improve their efforts to generate ad-based revenue for their site. You know that ads are most successful […]
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 13 years, 1 month ago
Hi All,
I am attaching a general systems analysis report, it was an academic essay I wrote last year in about two hours. In this report, I start with the “documentation” from academic literature, and the […]
-
Kevin Yili Hong commented on the post, ICE 5.1 Telling a Story through Visualization, on the site Course Blog on Data Analytics 13 years, 1 month ago
I can see that you are already a good data analyst! Good example.
-
Kevin Yili Hong commented on the post, ICE 5.1 Telling a Story through Visualization, on the site Course Blog on Data Analytics 13 years, 1 month ago
John, definitely, I was once an MIS major 7, 8 years ago and this is the class that I still remembers. The knowledge from this similar class (we had database management at that time) is been used on a daily basis. […]
-
Kevin Yili Hong commented on the post, ICE 5.1 Telling a Story through Visualization, on the site Course Blog on Data Analytics 13 years, 1 month ago
Jasmine you are absolutely correct. The thing you will learn in this course will hopefully help you become such an effective “interpreter”..
-
Kevin Yili Hong commented on the post, ICE 5.1 Telling a Story through Visualization, on the site Course Blog on Data Analytics 13 years, 1 month ago
Good summary on data! A similar example of airline reservation system relational diagram intrigued me about 7 years ago when I was in a MySQL course. We never thought before how these systems really work, but now […]
-
Kevin Yili Hong commented on the post, NIST 800 60 V1R1 Guide for Mapping Types of Information and Information Systems to Security Categories, on the site Course Blog on Data Analytics 13 years, 1 month ago
Yes Justin, we do observe that firm data collection from users (consumers) are becoming more implicit than before. Almost each and every move of you is recorded. Also please try to keep in mind the difference […]
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 13 years, 1 month ago
Hello everyone,
Besides the regular lecture on Relational Database Modeling, we will be having 30 minutes -45 minutes of the class on an in-class exercise about gathering requirements. It will challenge you on […]
-
Kevin Yili Hong commented on the post, ICE 5.1 Telling a Story through Visualization, on the site Course Blog on Data Analytics 13 years, 1 month ago
Dustin, good summary. Yes we are really getting into what firms’ IT (database guys) do in terms of their firm database. Personally I’ve worked with a company which has more than 200 tables in its MySQL database, […]
- Load More
