Sunil Wattal

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.

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.

Click here for class captures by date:

October 8, 2012

October 10, 2012

October 12, 2012

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 […]

Click here for a study guide for test 1.

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 […]

Click here for instructions on the in-class exercise. The Excel data file can be accessed here.

Here are the sample questions for test 1  (click here).

Click here for class captures by date:

October 1, 2012

October 3, 2012

October 5, 2012

Think for about 100 seconds what you learnt in class during week 6 (dimensional modeling) and summarize your thought here.

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 […]

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 […]

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/

Pls note the TA will have office hours in Alter Hall 603 (Laptop Lab) tomorrow (10/2) from 2:30 – 3:30pm.

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

Click here for instructions on the inclass exercise.

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 […]

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 […]

Consider a database (HRData) with the following tables:

Faculty(ID, FirstName, LastName, Title, DepartmentID, BuildingID, Phone, Email)

Department(DeptartmentID, DepartmentName)

Building(BuildingID, […]