Laurel Miller

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

Consider a database (HRData) with the following tables:

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

Department(DeptartmentID, […]

Click here for class captures by date:

September 24, 2011

September 26, 2011

September 28, 2011

To access password protected posts, please check the blackboard for the password.

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

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.

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.