Data Analysis - CIS Quiz

Table

A common SQL term used in queries is FROM. FROM allows the user to choose the _____ of the database in which the query is located.

Scalable.

A major trend in data analytics is the use of artificial intelligence to focus on small data which is more precise, using small datasets that are capable of impacting decisions in the present. This is known as ______ AI.

Curiosity, understanding context, and data strategy.

Analytical skills necessary for a data analyst include the characteristics and capabilities that allow for the observation, research, and interpretation of a problem or change in a desired state. According to Google, there are five essential aspects of analytical skills including which three of the following?

Records.

Collections of related fields in a database are referred to as

Bachelor's degree.

Data analysts are likely to have achieved what education level when beginning their career?

Business/Organization.

Data analysts must blend facts and data with knowledge about the

Format.

Data transformation is the process of converting the _____ of data.

Share.

Data-driven decision making (DDDM) can be facilitated through a six-step processes of Ask, Prepare, Process, Analysis, Share, and Act. Which of these steps refers to creating visualizations and presentations for key stakeholders?

Redistributed.

In order to be considered open data, databases must provide access rights so that they can be

two dashes: "- -."

In order to make understanding and interpretation of SQL queries easier, users have the ability to add comments. The symbol(s) that will tell SQL that an entry is a comment and should not be used in the query is(are)

Ordinal

Qualitative data that is not categorized is called nominal data. Qualitative data that is categorized (ranked, for example) is considered _____ data.

Structured.

SQL allows users to isolate specific information contained in a database, as well as to aid in the selection, creation, addition, and extraction of data from a database. SQL stands for ______ query language.

Query.

SQL, usually pronounced "sequel," is quite useful when working with large data sets. The Q in SQL stands for

How will the data be collected? What types of data do you need to solve a specific problem? How much data should be collected?

Select three critical factors to consider when determining the right data to select?

Creating your visuals.

The 3-step data visualization process consists of exploring the data sets for pattern, then planning for visuals, and finally

Spreadsheets, databases and query languages, and data visualization tools

The main tools used by data analysts include which three of the following?

Descriptive analytics.

Trying to answer questions such as "what happened?" or "what is occurring?" or "what was the ROI?" is the role of

Improved decision making, improved patient experiences and internal procedures in health care, and improved customer service

Uses of data analytics include which three of the following?

Personally.

When data is anonymized, the PII is eliminated or encrypted. PII includes names, Social Security numbers, addresses, and more and stands for ______ identifiable information.

Third-party.

When selecting the right data, it is important to be aware of the source of the data. For example, data that is sold by an entity that didn't actually collect the data is considered ______ data.