Explain in your own words the terms Support, Confidence and Lift used in Association rule discovery?

Suport is a fraction of how many items in the set have the variables or distinctions in which you want over […]

Data mining would be useful if you are trying to decide what products to include in a package to sell to customers.This would be an example of descriptive analytics because to do this you would have to use the […]

Classification is the process of determining what group a data element belongs to. This is done based on the data contained in the element. Whereas, Clustering is the grouping of data so that the elements will […]

Regarding Decision Trees and Classification, why does one need the Chi-squared test and Gini test?

The Chi-squared test is the proportion of the group whereas the Gini test is the diversity of the group. A high […]

Summarize what data mining is and what data mining is not.

Data mining is the exploration of large quantities of data to create an understanding of a meaningful pattern. Also, it is the extraction of previously […]

1. What are the key OBJECTIVES and ISSUES of getting the information into the data mart (ETL)?

The key objectives of getting the information into the data mart are extracting the data, transforming the data, […]

a) choosing business process: determine what the cube is going to be about and what questions you want to answer about the business

b) decide on the level of granularity: This determines how much detail you […]

Alter is if you want to change the table such as by adding a column where as insert into is if you want change the table data such as by adding a row. An example of Alter is ALTER TABLE `m1orderdb`.`Product` DROP […]

DML stands for data manipulation language and DDL stands for data definition language. DML is used for query and update commands. An example of this would be SELECT which extracts data from a database or DELETE […]

We use the SQL command SELECT DISTINCT to retrieve unique values. An example of this would be SELECT DISTINCT `CITY`, `State` FROM `OrderDB`.`Customer`

To resolve a many to many relationship you must add additional tables. An example of this would be product and order have a many to many relationship, so the Order-Product table is created to resolve this. Order […]

A primary key is a key that makes an entity uniquely identifiable. Where as a foreign key does not include information that is uniquely identifiable and is included for linking data tables together and including […]

Transactional data is data that is currently occurring and used to analyze an event. Where as, analytical data is data that has happened in the past that is used to make and support business decisions.