MIS2502 Featured Items

The Points/Extra Credit Assignment

Here are the instructions for the optional assignment. It is worth "portfolio points" for MIS Majors and extra credit for everyone. The due date is May 1, 2012 at 11:59 PM. Since this is extra credit and optional, no late assignments will be accepted under any circumstances!

Read More

Weekly Question

Week 15 Question: Due May 3

Leave your response as a comment on this post by midnight on May 3, 2012. Remember, it only needs to be a few sentences.

Answer the following question:

What was the most important takeaway (from your perspective) from this course. If you had to explain to a future MIS2502 scholar what this course was about, what would you say?

Week 13 Question: Due April 19

Answer one of the following questions as a comment on this post.

Submit your contribution by 11:00 AM on Thursday, April 19. It should be insightful (don’t just repeat back facts from the class), but it doesn’t need to be more than a few sentences. Most of all, I want to know what you think!

  1. Name and describe a business question that you could answer using clustering. What data would you collect to perform the analysis? Don’t use an example we’ve covered in class.
  2. Let’s say you performed a cluster analysis and came up with a series of market segments, describing the demographics of three different sets of customers for your business (big spenders, average spenders, small spenders). Your manager is reluctant to trust your analysis because she has a lot of experience and this contradicts what she believes is true about her customers. How would you convince her that your analysis is correct?

Week 12 Question: Due April 12

Answer one of the following questions as a comment on this post.

Submit your contribution by 11:00 AM on Thursday, April 12. It should be insightful (don’t just repeat back facts from the class), but it doesn’t need to be more than a few sentences. Most of all, I want to know what you think!

  1. Name and describe a business question that you could answer using a decision tree. What data would you collect to perform the analysis? Don’t use an example we’ve covered in class.
  2. What advice would you give someone regarding how to select the right predictor variables for a decision tree analysis?

Week 11 Question

Due to the exam, the weekly question is taking another break.

Week 10 Question: Due March 29

Answer one of the following questions as a comment on this post.

Submit your contribution by 11:00 AM on Thursday, March 29. It should be insightful (don’t just repeat back facts from the class), but it doesn’t need to be more than a few sentences. Most of all, I want to know what you think!

  1. Give an example of a problem where data mining would be useful. Then explain whether it would be an example of predictive or descriptive analytics (refer to the slides for the definitions if you don’t remember the difference).
  2. Take a look at the SpotCrime website. Type in a few zip codes to see crime statistics in different areas. Would you consider this more an example of data analytics as we’ve discussed it this week, or more like the OLAP analysis we have been doing over the last week or so? Explain your reasoning.

Week 9 Question: Due March 22

Answer one of the following questions as a comment on this post.

Submit your contribution by 11:00 AM on Thursday, March 22. It should be insightful (don’t just repeat back facts from the class), but it doesn’t need to be more than a few sentences. Most of all, I want to know what you think!

  1. Based on our discussion in class, how would you convince a reluctant manager that they should adopt a company’s existing data standards when developing a new database system?
  2. Give an example, other than those we discussed in class, of how the same piece of data could be represented multiple ways, requiring them to be reconciled before they were placed into a data mart.

Week 7 Question: Due March 15

Yes, I know I forgot the question last week!

Answer one of the following questions as a comment on this post.

Submit your contribution by 11:00 AM on Thursday, March 15. It should be insightful (don’t just repeat back facts from the class), but it doesn’t need to be more than a few sentences. Most of all, I want to know what you think!

  • Let’s say you were asked to help design a data mart for Target that captures sales data. For the fact, you can choose a granularity of hourly, daily, weekly, or monthly. What questions (and who) would you ask in order to gather the information required to make this decision?
  • Ralph Kimball (one of the founders of the notion of data warehousing) once claimed that the star schema is a superior way of delivering data to end users. He said this because the data is organized around a business event. Do you agree? Is the arrangement of the data even an important issue?

Week 5 Question: The Weekly Question is off this week!

The weekly question has taken a break for the upcoming exam. It will return in full force next week.

Week 4 Question: Due February 16

Answer one of the following questions as a comment on this post.

Submit your contribution by 11:00 AM on Thursday, February 16. It should be insightful (don’t just repeat back facts from the class), but it doesn’t need to be more than a few sentences. Most of all, I want to know what you think!

  1. Describe a situation where you’d need to use a join to retrieve information from a set of tables. For example, if you have orders in one table and customers in another table, you’d need to join those tables to figure out which orders were placed by the customers who lived in Pennsylvania.
  2. Describe a business scenario that would require a change to an existing table’s metadata.

Week 3 Question: Due February 9

Answer one of the following questions as a comment on this post.

Submit your contribution by 11:00 AM on Thursday, February 9. It should be insightful (don’t just repeat back facts from the class), but it doesn’t need to be more than a few sentences. Most of all, I want to know what you think!

  1. Trump Entertainment Resorts has a similar customer loyalty program as MGM. Imagine that the two casinos have discussed sharing customer data with each other. Executives at MGM are excited about gaining access to Trump’s extensive customer data, but they are unsure that it’s a good idea. What do you think? Why?
  2. Name one key difference (there are more than one) between an ERD and a schema. For your reference, either look at the posted solution to the in-class exercise or the Relational Modeling slides.