data 1 Flashcards

1
Q

IMPACT Cycle

A

Identify the Questions: Define the specific questions or problems to be addressed.
Master the Data: Understand the data available and ensure its quality and relevance.
Perform the Analysis: Apply appropriate analytical techniques to the data.
Communicate Insights: Present the findings in a clear and actionable manner.
Track Outcomes: Monitor the results to assess the effectiveness of the analysis and make adjustments if necessary.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Data Analytics

A

is the process of evaluating data with the purpose of
drawing conclusions to address business questions. Effective Data
Analytics provides a way to search through large structured and unstructured data to identify unknown patterns or relationships.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Big Data

A

refers to datasets which
are too large and complex to be analyzed traditionally. Remember the 3V ’s:
Volume refers to size
Velocity refers to frequency
Variety refers to different types

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

types of attributes

A

Primary keys are unique identifiers.
Foreign keys are attributes that point to a primary key in another table.
Composite keys are a combination of two foreign keys used for line items.
Descriptive attributes include everything else.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Intersection tables

A

a special type of database table, is used to remove many-to-many relationships.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

four main categories of
data analytics

A

Descriptive analytics are
procedures that summarize existing data to determine what has happened in the past.

Diagnostic analytics are
procedures that explore the current data to determine why something has happened the way it has, typically comparing the data to a benchmark.

Predictive analytics are
procedures used to generate a model that can be used to determine what is likely to happen in the future.

Prescriptive analytics are
procedures that model data to enable recommendations for what
should be done in the future.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

SELECT, WHERE, ORDER BY, JOIN ON

A

SELECT column FROM table, WHERE price>500, ORDER BY ASC DESC, JOIN inventory ON Sales.IventoryID = Inventory.InventoryID

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly