-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 12 years, 1 month ago
Click here for a copy of the presentation slides. We’ll cover this in week 4.
In this lecture, we’ll discuss the use of Structured Query Language (SQL) to extract information from a database using the SELECT statement.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 12 years, 1 month ago
Think for about 100 seconds what you learnt in class during week 3 and summarize your thought here.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 12 years, 1 month ago
Summarize the differences between the three customer segments at MGM in terms of: a. Customer Interaction Model, b. Role of Information Systems
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 12 years, 1 month ago
Comment on the following with respect to the MGM case: “you cannot become a whale just by eating at the buffet.” Also, explain whether this makes business sense for the firms. (Hint: See Q5b from the MGM case […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 12 years, 1 month ago
Click here for a copy of the presentation slides. We will cover this in week 3.
In this lecture, we’ll provide an overview of MySQL and discuss the use of MySQL Workbench to write queries.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 12 years, 1 month ago
Prepare an Entity Relationship Diagram (ERD) for the following business scenario:
The Monster Car Company produces specialty vehicles by contract, all with the “Monster” theme. The company operates several […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 12 years, 1 month ago
Prepare an Entity Relationship Diagram (ERD) for the following business scenario:
The Big City public housing agency has assigned you the task of keeping track of who is living in the agency’s developments over […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 12 years, 1 month ago
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 12 years, 1 month ago
Click here for class captures by date:
August 27, 2011 – not available due to technical issues
pls note that class captures may not be available for all dates due to […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 12 years, 1 month ago
Think for about 100 seconds what you learnt in class during week 2 and summarize your thought here.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 12 years, 1 month ago
Here is a very good reference for Entity Relationship Diagrams (ERD) (click here).
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 12 years, 1 month ago
Assignment 1: Case Study in Business Intelligence
Slots, Tables, and All That Jazz: Managing Customer Profitability at the MGM Grand Hotel (HBS 9-106-029)To access the case, follow the directions on the […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 12 years, 1 month ago
What is a ‘multi-valued attribute? Give examples. Why is it not preferable to have multi-valued attributes in a table?
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 12 years, 1 month ago
Look up ‘referential integrity’ on the internet. How does a foreign key in a table help maintain referential integrity?
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 12 years, 1 month ago
Think for about 100 seconds what you learnt in class during week 1 and summarize your thought here.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 12 years, 1 month ago
Does a team need to assemble the best players to win a championship? Or can it ‘mathematically’ pick a set of average players to increase your probability of winning the game? Watch Moneyball to find the answer (<a […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 12 years, 1 month ago
Refer to the in-class exercise from 9/1/2011 (click here for a copy). Here is a question to consider:
Is there any information which we’d like to have that we can’t get from Facebook alone? If so, how would we […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 12 years, 1 month ago
This is election season, and quite a few of us are following the campaigns. Political campaigns are increasing using data analytics to make decisions on how reach out to voters, raise money, and mobilizing people […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 12 years, 1 month ago
Refer to the in-class exercise for week 1 (click here for a copy).
Here is a question to think about: what is the value of data to online companies such as Facebook or LinkedIn?
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 12 years, 1 month ago
List examples of how companies are using data to achieve a competitive advantage (give examples of specific companies and mention how they use data).
- Load More