Lessons 1 - 4

Question 1

________ can be represented in different forms of types

Answer 1

Data

Question 2

What type of data:

Standardized

Answer 2

Structured

Question 3

What type of data:

Clearly defined

Answer 3

Structured

Question 4

What type of data:

Searchable

Answer 4

Structured

Question 5

What type of data:

Comply with a predefine format

Answer 5

Structured

Question 6

What type of data:

Do not have a predefined data model

Answer 6

Unstructured

Question 7

What type of data:

Stored in its native format or in unstructured raw formats

Answer 7

Unstructured

Question 8

What type of data:

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

Answer 8

Unstructured

Question 9

What type of data:

Data based on location and geographical coordinates

Answer 9

Geospatial

Question 10

What type of data:

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

Answer 10

Geospatial

Question 11

Data vs Information

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

Answer 11

Data

Question 12

Data vs Information

Can be structured, unstructured, or geospatial

Answer 12

Data

Question 13

Data vs Information

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

Answer 13

Data

Question 14

Data vs Information

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

Answer 14

Information

Question 15

Data vs Information

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

Answer 15

Information

Question 16

Provides context for data and enables decision making

Answer 16

Information

Question 17

What kind of Logical Assertion of Information:

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

Answer 17

Fact

Question 18

What kind of Logical Assertion of Information:

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

Answer 18

Opinion

Question 19

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

Answer 19

Preference

Question 20

What kind of Logical Assertion of Information:

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

Answer 20

Convention

Question 21

What of Type of Analytics:

Examines historical data to understand what happened

Answer 21

Descriptive Analytics

Question 22

What of Type of Analytics:

Most common type of analytics

Answer 22

Descriptive Analytics

Question 23

What of Type of Analytics:

Delivered Through reports and dashboards

Answer 23

Descriptive Analytics

Question 24

What of Type of Analytics:

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

Answer 24

Diagnostic Analytics

Question 25

# What of Type of Analytics: Identifies patterns, relationships and correlations to diagnose the root cause of an issue

Answer 25

Diagnostic Analytics

Question 26

# What of Type of Analytics: Answers what could happen?

Answer 26

Predictive Analytics

Question 27

# What of Type of Analytics: Uses statistical models and machine learning to forecast what might happen in the future

Answer 27

Predictive Analytics

Question 28

# What of Type of Analytics: Predicts outcomes, such as customer churn or product sales

Answer 28

Predictive Analytics

Question 29

# What of Type of Analytics: Analytics that provides recommendations to achieve a desired outcome

Answer 29

Prescriptive Analytics

Question 30

# What of Type of Analytics: Answers what should we do?

Answer 30

Prescriptive Analytics

Question 31

A single repository or organizational database

Answer 31

Data warehouse

Question 32

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

Answer 32

Data Warehouse

Question 33

Involves a large data store and keeps historical data

Answer 33

Data Warehouse

Question 34

Supports analysis and decision-making

Answer 34

Data Warehouse

Question 35

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

Answer 35

* DW - Data Warehouse * DWH - Data Warehouse * EDW - Enterprise Data Warehouse

Question 36

What does OTP mean?

Answer 36

Online Transaction Processing

Question 37

What does OTP do?

Answer 37

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

Question 38

What does OLAP mean?

Answer 38

Online Analytical Processing

Question 39

What does OLAP do?

Answer 39

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

Question 40

# ADDITIONAL NOTES: OLTP - EAD | skip ra ay

Answer 40

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

Question 41

# ADDTIONAL NOTES OLAP - DW

Answer 41

* SQL Server - Data Analyst * Tableau - Report Developer