-
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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Pls note the following office hours for the SQL 1 assignment.
1. I have my office hours after class today from 3-4pm in Speakman 201 E
2. The TA will have office hours in Alter Hall 603 (Laptop Lab) tomorrow […]
-
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 5 and summarize your thought here.
-
Sunil Wattal wrote a new post on the site DATA ANALYTICS @ MIS2502 /S2 11 years, 11 months ago
Click here for class captures by date:
September 17, 2011
September 19, 2011
September 21, 2011
-
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 4 and summarize your thought here.
- Load More