Unit 3

Question 1

Primary Key

Answer 1

field that uniquely identifies a record. ex: student id or employee id

Question 2

Foreign Key

Answer 2

Field that is in a relational table, that relates to a primary key of another table

Question 3

Schema

Answer 3

Blueprint on how the database is constructed.

Question 4

Big Data

Answer 4

Data come from everywhere—including smartphone metadata, internet usage records, social media activity, computer usage records, and countless other data sources—to be sifted for patterns and trends.

Question 5

Four Vs of Big Data

Answer 5

Volume (amount), Variety (Various forms), Veracity (quality and trustworthiness), Velocity (speed).

Question 6

Data mining/Data discovery

Answer 6

examination of huge sets of data to find patterns, connections, outliers and hidden relationships. It is a BI tool used for decision making.

Question 7

Structed data

Answer 7

resides in fixed formats, well labeled, easily queried and searched.

Question 8

unstructured data

Answer 8

is unorganized data(social media/big data) cannot be easily read or or processed by a computer. not stored in rows and columns

Question 9

semi structured data

Answer 9

in between structured and unstructured data, can be read but takes work. example is email.

Question 10

Big data tools

Answer 10

ETL and Hadoop

Question 11

Extract

Answer 11

Once you have determined where your data is coming from and where you want it to reside, you can start extracting. usually comes from CRM or ERP

Question 12

Transform

Answer 12

Once you have extracted data, they need to be transformed to fit into the database table. This may involve removing decimals and dollar signs from financial transactions so it will fit into the structured data table.

Question 13

Load

Answer 13

Once data are transformed, they are ready to finally be transferred into the data warehouse and data mart. The more often this is done, the more up-to-date analytic reports can be.

Question 14

Hadoop

Answer 14

an infrastructure for storing and processing large sets of data across multiple servers. Instead of centralized files in one place like a data warehouse or data mart, Hadoop uses a distributed file system that allows files to be stored on multiple servers

Question 15

Which restriction applies to the data in the primary field of a database?

Answer 15

The primary key has to be unique

Question 16

The data are full of missing, misplaced, or duplicate data, which the data analyst needs to remove.
Which process can this data analyst use to remove such data?

Answer 16

Normalization

Question 17

A data analyst wants to use software to look for useful patterns and hidden relationships in this large set of social media data. Which process can be used to look for these patterns and relationships?

Answer 17

Data Mining

Question 18

A business analyst wants to use the social media data to create and present business intelligence. She will create visualizations that will be used by the executive team. Which tool is appropriate for creating and presenting this business intelligence?

Answer 18

Tableau

Question 19

scrubbing the data

Answer 19

the process of transforming data into an accurate, clean, and error-free form

Question 20

Master Data Management (MDM)

Answer 20

is a methodology or process used to define, organize, and manage all the data of an organization that provides a reference for decision-making. Master data management tools can be used to support master data management by removing duplicates, standardizing data, and incorporating rules to prevent incorrect data from entering the system, thus creating an accurate source of master data

Question 21

Data Governance

Answer 21

is managing the availability, integrity, and security of the data to ensure that the data remain high quality and valid for data analytics. Policies and procedures are established that define the data governance program, such as who has access, who has update capabilities, when and how backups are made and stored, and who administers the policies to ensure that they are followed

Question 22

Data Management Process

Answer 22

can be defined as acquiring data, making sure the data is valid, and then storing and processing the data into useable information for a business

Question 23

data management return on investment

(ROI)

Answer 23

value of having the data available to process to make key decisions. ROI is negatively impacted by improper data management

Question 24

Benefits of data management

Answer 24

predictive analytics, BI, and data analysis

Question 25

data analytics

Answer 25

patterns, correlations, and hidden data relationships.

Question 26

Online analytical processing (OLAP)

Answer 26

end users can submit queries against the database to gain insight into data relations such as trend analysis and also to create data models that guide future decisions. A common use of OLAP is the creation of what-if scenarios for budgeting and forecasting.

Question 27

Business intelligence (BI)

Answer 27

is a set of software and services that turn data into information that helps leaders in an organization make wise decisions.

Question 28

Topic analytics

Answer 28

enables you to sift through large sets of data and identify the most common and most important topics in an easy, fast, and scalable way. For example, if a customer said, “the barista was friendly,” that would be categorized under the topic “Employee Friendliness.”

Question 29

Text analytics

Answer 29

sometimes called text mining, is the process of extracting information from written sources such as websites, e-books, and emails and inserting the data into a database to evaluate and interpret relevance or to understand customers’ feedback on products and services.

Question 30

Business analytics

Answer 30

attempts to make connections between data so organizations can try to predict future trends that may give them a competitive advantage. Business analytics can also uncover computer system inadequacies within an organization

Question 31

A data analyst wants to search through unstructured data from social media posts to look for useful customer behavior patterns and sentiments. Which type of analytics is appropriate for this task?

Answer 31

Text analytics

Question 32

descriptive analytics

Answer 32

is the baseline that other types of analytics are built on.

Question 33

predictive analytics

Answer 33

attempts to reveal future patterns in a marketplace, essentially trying to predict the future by looking for data correlations between one thing and any other things that pertain to it.

Question 34

=SUM(number1,[number2],…)

Answer 34

Adds all the values selected in the argument.

Question 35

=AVERAGE(number1,[number2],…)

Answer 35

Calculates the average of all the values selected in the argument.

Question 36

=MAX (number1,[number2],…)

Answer 36

Finds the maximum value of all the values selected in the argument.

Question 37

=MIN (number1,[number2],…)

Answer 37

Finds the minimum value of all the values selected in the argument.

Question 38

=COUNT(value1,[value2],…)

Answer 38

Counts the number of values selected in the argument that contain numbers

Question 39

arguments

number1,[number2],…

Answer 39

The argument number1 is required and is the first number, cell reference, or range for which you want to calculate what the functions return. The argument [number2] and the rest are optional (use of square brackets indicates these additional arguments are optional), including any additional numbers, cell references, or ranges that you want to calculate what the functions return.

Question 40

value1,[value2],…

Answer 40

The argument value1 is required and is an item, cell reference, or range. The argument [value2] and the rest are optional (use of square brackets indicates these additional arguments are optional), including any additional numbers, cell references, or ranges.

Question 41

Boolean logic

Answer 41

is based on only two values, 0 and 1. In spreadsheets, the values 0 and 1 are represented by the values FALSE and TRUE, respectively. Boolean logic and Boolean functions deal with expressions that result in either the value TRUE or the value FALSE. No other outcome is allowed in Boolean formulas or functions.

Question 42

IF function =IF(logical_test,[value_if_true],[value_if_false])

Answer 42

logical_test~ A test or logical comparison of value that is either TRUE or FALSE.
[value_if_true] ~Used to specify the result of the IF function if the Boolean expression result is TRUE.
[value_if_false] ~Used to specify the result of the IF function if the Boolean expression is FALSE.