1)Give an example of a problem where data mining would be useful. Then explain whether it would be an example of predictive or descriptive analytics.

The data mining is more of a predictive rather than a […]

Ji Mun’s here

Compare and contrast classification and clustering

When contrasting classification and clustering methods, it is important to realize that they both use algorithms to solve coding issues that minimize the […]

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

The gini test is required for classification and decision trees since this test allows the leaf nodes with […]

2.What data would be valuable to electoral candidates?

There are many various data that would be valuable to electoral candidates. Nowadays, people have their own interests and preferences and hobbies that they […]

The key objectives is getting data from a transactional database to an analytical database that goes from relational to dimensional. If is important to identify where the data come from to fill the data mart.
1) […]

1. Choosing the Business Process- The first step of Kimball’s Four Step Process of Data Cube is a process to determine what the cube will be covering and what method will it be using. This is to ensure that the […]

The ALTER command is used to add, delete, or modify columns in an existing table. The INSERT command is used to insert a new row in a table.Alter is part of a DDL statement that modifies and changes the […]

Based on our learning, ERD and SQL have relationship that interrelate each other. When ERD (Entity Relationship Diagram) is used to modify code for SQL (Structured Query language) its called reverse engineering. […]

Based on our learning, ERD and SQL have relationship that interrelate each other. When ERD (Entity Relationship Diagram) is used to modify code for SQL (Structured Query language) its called reverse engineering. […]

How do you resolve the M:N (many to many) relationship?

In order to resolve the N:N relationship, you first have to figure out that this is the logical view and it is acceptable only in the logical view. In […]

There are ways to distinguish the differences between the primary key and foreign key. Primary key is a column or a combination of columns that demonstrates the uniqueness of each row in a table of a relational […]

Ji Mun, Kaitlin Carr, Olsian Goxhaj, Mike Garner, DeVaun Brown

Gender= clothes, school supplies
Age= make ads in the music industry
Geography= winter coats, location
College Student= school supplies, […]

Analytical informations helps a company or organization to analyze the data they have. Analytical information would eventually end up generating a transaction decision but the focus point of the analytical […]