Here is the link to my video on how to use navigation widgets.

Support- The frequency of a group occurring in the data set.
Confidence- It is the strength of the association. It can also measure the frequency of certain items in any given transaction, which will reveal a […]

2. SpotCrime.com is an example of OLAP analysis. This is because the information is classified by the time, address, and type of dimensions. The data is then presented on an easy to use map. The site also provides […]

1.Compare and contrast classification and clustering.
Clustering involves grouping similar data to form some sort of relationship between the elements within that data. This process reduces the size of large data […]

2. Regarding Decision Trees and Classification, why does one need the Chi-squared test and Gini test?
-A Chi-squared test is needed to make sure that the groups are different to provide higher and more effective […]

What data would be valuable to electoral candidates?
->Any type of social media- on blogs, facebook, events, twitter etc.
->Current trends in society and past election trends
-> U.S Census
-> Online surveys – […]

Describe the objective and activity of Kimball’s Four Step Process for Data Cube Design:
a)Choosing the business process- Asking questions about the data cube and finding the best solution to the […]

The DELETE command is used to remove rows from a table. For example, DELETE FROM ‘employee’ WHERE job = ‘CLERK’. The DROP command removes a table from the database. For example, DROP TABLE ‘employee’

DDL commands are used to define the database structure/ schema. For example, CREATE- to create objects in the database. DML commands are used for managing data within schema objects. For example, SELECT- to […]

To retrieve unique values in SQL you use the SQL Select Command. More specifically this command uses the “Distinct” method providing a database system with the unique values. For example, you select ‘column name […]

The key to resolve many-to-many relationships is to make the model as simple and easy to understand as possible. This is done by creating a new entity table and having the primary keys becoming the foreign keys. […]

A primary key is a column that uniquely identifies an entity in a table, and a foreign key is the relationship that connects two or more columns together (usually in a different table). Both different types of […]

Transactional data is real-time data. It provides organizations with the ability to perform business transactions in daily operational systems. Analytical data involves the analysis of accumulated data from past […]