Lessons 1 - 4 Flashcards

For First Quiz

1
Q

________ can be represented in different forms of types

A

Data

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

What type of data:

Standardized

A

Structured

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

What type of data:

Clearly defined

A

Structured

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

What type of data:

Searchable

A

Structured

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

What type of data:

Comply with a predefine format

A

Structured

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

What type of data:

Do not have a predefined data model

A

Unstructured

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

What type of data:

Stored in its native format or in unstructured raw formats

A

Unstructured

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

What type of data:

Email, social media posts, text files, audio, and video

A

Unstructured

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

What type of data:

Data based on location and geographical coordinates

A

Geospatial

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

What type of data:

Can be represented by a point, a polygon, or a 3D shape

A

Geospatial

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

Data vs Information

Discrete measurement, fact, or observation representing a real-world process

A

Data

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

Data vs Information

Can be structured, unstructured, or geospatial

A

Data

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

Data vs Information

Unprocessed facts or figures, collected through observations transactions, or measurements

A

Data

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

Data vs Information

Created when data is analyzed and usually combined with other data to extract meaning and provide context

A

Information

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

Data vs Information

Processed, organized, and presented data to be useful for making decisions, understanding complex concepts, or building knowledge

A

Information

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

Provides context for data and enables decision making

A

Information

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

What kind of Logical Assertion of Information:

Objective piece of information that is verifiable and can be proven true or false through evidence

A

Fact

18
Q

What kind of Logical Assertion of Information:

Subjective belief or judgment that reflects an individual’s thoughts, feelings, or interpretations

A

Opinion

19
Q

What kind of Logical Assertion of Information:

Choice or liking for one thing over another, influenced by personal taste and doesn’t involve a broader judgment or belief

A

Preference

20
Q

What kind of Logical Assertion of Information:

Widely accepted practice or standard that is established by common agreement or tradition

A

Convention

21
Q

What of Type of Analytics:

Examines historical data to understand what happened

A

Descriptive Analytics

22
Q

What of Type of Analytics:

Most common type of analytics

A

Descriptive Analytics

23
Q

What of Type of Analytics:

Delivered Through reports and dashboards

A

Descriptive Analytics

24
Q

What of Type of Analytics:

Examines data to understand why something happened or why did it happen

A

Diagnostic Analytics

25
Q

What of Type of Analytics:

Identifies patterns, relationships and correlations to diagnose the root cause of an issue

A

Diagnostic Analytics

26
Q

What of Type of Analytics:

Answers what could happen?

A

Predictive Analytics

27
Q

What of Type of Analytics:

Uses statistical models and machine learning to forecast what might happen in the future

A

Predictive Analytics

28
Q

What of Type of Analytics:

Predicts outcomes, such as customer churn or product sales

A

Predictive Analytics

29
Q

What of Type of Analytics:

Analytics that provides recommendations to achieve a desired outcome

A

Prescriptive Analytics

30
Q

What of Type of Analytics:

Answers what should we do?

A

Prescriptive Analytics

31
Q

A single repository or organizational database

A

Data warehouse

32
Q

Integrates data from multiple sources (internal and external) and organized it around business processes

A

Data Warehouse

33
Q

Involves a large data store and keeps historical data

A

Data Warehouse

34
Q

Supports analysis and decision-making

A

Data Warehouse

35
Q

The abbreviated forms are DW, DWH, or EDW which mean?

A
  • DW - Data Warehouse
  • DWH - Data Warehouse
  • EDW - Enterprise Data Warehouse
36
Q

What does OTP mean?

A

Online Transaction Processing

37
Q

What does OTP do?

A

Handles daily transactions in real-time, often in enterprise applications.

38
Q

What does OLAP mean?

A

Online Analytical Processing

39
Q

What does OLAP do?

A

Primarily used for data analysis and decision-making, involving complex queries on historical data stored in data warehouses.

40
Q

ADDITIONAL NOTES:

OLTP - EAD

skip ra ay

A

Enterprise Application Databases

could be:
* CRM - Customer Service Representative
* Point-of-sales - Salesperson
* Accounting - Accountant

41
Q

ADDTIONAL NOTES

OLAP - DW

A
  • SQL Server - Data Analyst
  • Tableau - Report Developer