James P. Davanzo

One example of a data driven decision is where Wawa should open a new store. A lot of factors go into making a decision like this, such as population, geographic location, and past sales. Wawa also has to […]

I found this guest lecture to be very useful. I actually worked at a grocery store back in high school, so a lot of the data driven decisions he talked about in class were things that I’ve seen been made […]

I’m an MIS major so just about all of my future job functions will revolve around data driven decisions. Data can be used throughout many of the models we practiced in class including SQL, SAS, ERD, and various […]

The SSE is calculated by measuring the distances of each point to the center of the cluster. If the points are within the SSE, there is cohesion. If the points are between the SSE, there is distinctiveness.

What I liked most about this class was getting hands on experience with applications like MySQL and SAS, and I liked the fact that I was able to learn a lot more excel commands. A lot of IT internships often use […]

Cluster cohesion and separation are both used to determine whether or not certain data points belong in the same cluster. Cohesion measures how similar data points are to each other and minimizes their […]

In week 13, we learned a lot about association rules and how to calculate the relationship two or more variables have with each other. We did both an in class exercise and an assignment, where we calculated where […]

In week 12, we talked a lot about clustering and segmentation. Clustering is used by marketing and insurance groups. It involves splitting data into different groups based on their similarities to make comparisons […]

A business question that could be answered with a decision tree would be whether or not a company should build a big or small plant for production of a new product. The probabilities would be based on whether […]

True

A data warehouse is a repository for raw data. A data mart is made up of raw data that has been queried to be suitable for analytics. A data cube organizes the data into a multidimensional matrix. The way these […]

In week 10, we spent a lot of time discussing the concept of decision trees and how they can be used to help firms make decisions dealing with investments. A lot of it kind of reminded me of the ERD assignments […]

Week 7 taught me how to extract and transform data using ETL. We did an in class exercise which involved combining data from two different sources into one full set. The data was inconsistent and we learned […]

My username is james.davanzo

In week 6, we started talking about dimensional modeling and how using analytical data is often a lot more efficient than transactional data. We learned how to set up a data cube, and how it can be a useful way to […]

1) SELECT COUNT(Faculty.FacultyID) FROM HRData.Faculty,HRData.Department WHERE Department.DepartmentName = ‘Management Information Systems’ AND Faculty.DepartmentID = Department.DepartmentID

2) SELECT […]

Week 5 taught me a lot more about how to use SQL and a couple of other queries you can enter as well. Many of these queries had to do with adding rows, deleting rows, and altering data. I think after doing all of […]

Last week we spent a lot of time learning about SQL and how to access data using certain search queries. We used the program My SQL Workbench, and spent a lot of time sorting data from a movie database to obtain […]