-
Gord Burtch commented on the post, Week 3 Question: Due September 21, on the site MIS2502 – Data Analytics 12 years, 1 month ago
Right, great response! This goes back to the response I just posted on Jessica’s comment. Are the customers really the same, or are they fundamentally different in their behaviours. This is a very important issue […]
-
Gord Burtch commented on the post, Week 3 Question: Due September 21, on the site MIS2502 – Data Analytics 12 years, 1 month ago
Jessica, you raise a very interesting issue that I have to deal with on a daily basis in my research. Whether it makes sense to “pool” datasets together. This comes up all the time in empirical research, and the […]
-
Gord Burtch commented on the post, Week 3 Question: Due September 21, on the site MIS2502 – Data Analytics 12 years, 1 month ago
That’s a great point Kelley. I guess you could view a data-sharing agreement between MGM and Trump as a joint venture of sorts. If the two organizations do not view one another as primary competition, then the […]
-
Gord Burtch commented on the post, Week 3 Question: Due September 21, on the site MIS2502 – Data Analytics 12 years, 1 month ago
That’s a good answer Daniel. One small caveat though. Sometimes relationships ALSO become tables in the schema. This happens whenever you have a many-to-many relationship in your ER diagram. You need an […]
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years, 1 month ago
We will be working with SAS Enterprise Miner tool for the Data Analytics part (the last third of the class). To take part in this, you must create an account with SAS. The instructions are provided here: (click […]
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years, 1 month ago
use moviedb;
select * from actor;
select * from actor where actor.first_name=’Ed’;
select * from film;
select count(*) from film where rating=’PG-13′;
select length from film where […]
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years, 1 month ago
Here is the link. It seems the first 7-8 minutes were not recorded for some reason, however, during that time, I was just reviewing what was covered in the prior class, so I don’t think that should pose a problem.
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years, 1 month ago
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years, 1 month ago
This article on the HBR blog a day or two back is worth a read. It’s entitled “Data is Useless Without the Skills to Analyze It“. This should be a good motivation for doing well in this course. The article […]
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years, 1 month ago
Here is the assignment. I have provided hints along with each question, identifying which operators you will need to use to construct the query. Good luck!
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years, 1 month ago
Here is the link.
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years, 1 month ago
In the next lecture (week of the 24th) we will talk about how you insert data into a database, using MySQL. Here are the slides.
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years, 1 month ago
Here is our next in-class exercise, looking at running queries to get data out of a MySQL database. We will be working on this in class on Friday.
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years, 1 month ago
Here is the link.
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years, 1 month ago
Here is a link to a recent article on TechCrunch talking about a GitHub outage. GitHub is a web-based service for hosting open source software projects. The article demonstrates a point I made in class on Friday: […]
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years, 1 month ago
Answer one of the following questions as a comment on this post.
Submit your contribution by 3:00 PM on Friday, September 21. It should be insightful (don’t just repeat back facts from the class), but it […]
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years, 1 month ago
Here is scenario two from the in-class assignment with text highlights. This identifies entities (red), attributes (green) and relationships (blue).
I also wanted to note that you should be able to connect to […]
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years, 1 month ago
Here are the slides for lecture 5, which we will be covering next week on Monday and Wednesday. We’ll cover a variety of SQL commands that you can use to retrieve data from a database. Try to take a quick look at […]
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years, 1 month ago
Here is the ER Diagram solution for the second scenario of the in-class assignment. I have also included the Database Schema drawing for this scenario/ERD, so you can refer to this example as well if you are […]
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years, 1 month ago
- Load More