-
Sunil Wattal wrote a new post on the site MIS Distinguished Speaker Series 11 years, 11 months ago
Hilal Atasoy
Assistant Professor,
Fox School of Business, Temple Univ
October 12, 2012
Speakman Hall 200, 1000am – 1100am
Seminar Title : Firm-Level Evidence of the Effects of IT Use on […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Click here for instructions on the in-class exercise. The Excel data file can be accessed here.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Here are the sample questions for test 1 (click here).
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Think for about 100 seconds what you learnt in class during week 6 (dimensional modeling) and summarize your thought here.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Let’s say you were asked to help design a data mart for Target that captures sales data. You have to choose a level of granularity to aggregate the data: – hourly, daily, weekly, or monthly. What questions (and […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
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 […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Here is an interesting article on challenges of using Big Data in companies. Thanks to our classmate Brandon Warech for sending this.
http://gigaom.com/data/how-trifacta-wants-to-teach-humans-and-data-to-work-together/
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Pls note the TA will have office hours in Alter Hall 603 (Laptop Lab) tomorrow (10/2) from 2:30 – 3:30pm.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Here is a nice reference reading on the differences between database queries and OLAP – http://homepage.cs.uri.edu/faculty/hamel/pubs/hamel-197-manuscript-final.pdf
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Click here for instructions on the inclass exercise.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
If you get an error message that you are not permitted to alter or delete or update a table in the SQL Assignment, following the following steps:
Close your My SQL Workbench. Open it again and before you open […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Click here for a copy of the presentation slides. We’ll cover this in weeks 6-7.
In this lecture, we’ll discuss the concepts of analytical databases and data cubes, and learn how to create a data cube from […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Consider a database (HRData) with the following tables:
Faculty(ID, FirstName, LastName, Title, DepartmentID, BuildingID, Phone, Email)
Department(DeptartmentID, DepartmentName)
Building(BuildingID, […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Consider a database (HRData) with the following tables:
Faculty(ID, FirstName, LastName, Title, DepartmentID, BuildingID, Phone, Email, Awards)
Department(DeptartmentID, […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
To access password protected posts, please check the blackboard for the password.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Using the moviedb database, answer the following questions:
1. List the actors who starred in the oldest movie?
2. Which movie has been rented the maximum number of times?
2a Also, list all customers who […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Assignment: SQL #2 Putting Data Into a Database
Click here for a copy of the assignment. This is due on Wednesday – October 3, 2012. Please submit a printout of your answers at the beginning of class.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Click here for instructions on the inclass exercise. Please make sure to note your MySQL login and password from the gradebook before coming to the lab.
- Load More