-
Sunil Wattal wrote a new post on the site MIS Distinguished Speaker Series 11 years, 10 months ago
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 10 months ago
Click here for a copy of the presentation slides. We’ll cover this in week 8.
In this lecture, we’ll discuss the key issues involved with converting a transactional database into an analytical database.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 10 months ago
Click here for a copy of the assignment. The Excel spreadsheet can be accessed here
This is due on Wednesday – October 24, 2012. Please submit a printout with all the answers at the beginning of the class.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 10 months ago
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 10 months ago
Hi All,
A couple of announcements about test 1:
1. The first test will be held on Monday, October 15. The study guide for the same has been posted on the blog.
2. The test will be 50 mins duration and […]
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 10 months ago
Click here for a study guide for test 1.
-
Sunil Wattal wrote a new post on the site MIS Distinguished Speaker Series 11 years, 10 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, 10 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, 10 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, 10 months ago
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 10 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, 10 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, 10 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, 10 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, […]
- Load More