-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
Here is an article that was published a couple of weeks back, discussing the troves of new data that are now available online. The article discusses the opportunity and challenges posed by the availability of this […]
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
Here is a useful reference for you about the design of star schemas. This is a white paper that explains some of the background on data warehousing, data cubes, and how one goes about designing a star schema.
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
Here is the link.
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
Here is the link.
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
Here’s the study guide. Make sure you’ve read this before next week’s review session so you can bring your questions.
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
Hello all,
Our TA, Magen, will again be holding office hours on Tuesday, from 2:30pm to 4:00pm in Alter Hall 603. Please drop by if you need any help with the second SQL assignment.
Gord
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
Hello everyone,
I noticed some confusion around the use of max(), min(), etc. I wanted to provide some clarification around how these two functions work when you use them along with other field values in a […]
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
We’ll take a break from the weekly question and pick it up again next week!
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
Here is the link.
-
Gord Burtch commented on the post, Week 4 Question: Due September 28, on the site MIS2502 – Data Analytics 12 years ago
Kira, please see my responses to Austin and Kelley, above. There is a nuanced distinction between table rows and columns. Rows (values) are regular data, whereas columns (fields/attributes) are meta data. To add […]
-
Gord Burtch commented on the post, Week 4 Question: Due September 28, on the site MIS2502 – Data Analytics 12 years ago
Great answer, John! This is a clear cut scenario where meta data would need to be modified.
-
Gord Burtch commented on the post, Week 4 Question: Due September 28, on the site MIS2502 – Data Analytics 12 years ago
Kelley, you’re close! However, see my response above to Austin’s comment. The same point applies here. Regular data refers to field values, whereas meta data refers to table structure. So, a new product would […]
-
Gord Burtch commented on the post, Week 4 Question: Due September 28, on the site MIS2502 – Data Analytics 12 years ago
Austin, just to follow up on your point, it is important to remember that meta data is slightly different than table data (such as a new customer record). In general, the rows or records in tables constitute plain […]
-
Gord Burtch commented on the post, Week 4 Question: Due September 28, on the site MIS2502 – Data Analytics 12 years ago
Yep, that’s a very good example Tom. I guess you would need a brand new table to handle that (capturing the “factory” entity).
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
Hello all,
I wanted to remind you all (or let you know) about the IT career fair that is being organized by our MIS department, which is taking place on October 10th. There will be 18 employers coming (you can […]
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
Hello everyone,
I wanted to remind you that you can refer to this website if you are having trouble figuring out any SQL Syntax. It’s a useful resource!
http://www.w3schools.com/sql/sql_syntax.asp
Gord
-
Gord Burtch wrote a new post on the site MIS2502 – Data Analytics 12 years ago
Here is the link. Unfortunately, the capture stopped recording after I finished discussing the SQL-Out in-class exercise (i.e., the SQL-In lecture was not recorded). That being said, I will be providing a review […]
- Load More