Chapter 5 study guide

Working on data analytics teams to extract data from large data sets, creating reports that outline key findings, monitoring key performance indicators (KPIs) to identify success or failure, and analyzing data to identify trends are just a few of the responsibilities of a data __________.

Analyst

Curiosity, understanding context, having a technical mindset, data design, and data strategy are the 5 essential aspects of __ thinking and skills

Analytical

The process of investigating raw data of various types to uncover trends and correlations, and to answer specifically crafted questions is the role of data ___________.

Analytics

Protecting private or sensitive information by eliminating or encrypting information is the goal of data

Anonymization

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

Creating your visuals

In the statement: SELECT * FROM Customers, the asterisk (*) indicates that the user wants to extract all the columns of data FROM the __________ table.

Customers

Some of the responsibilities of a data analyst include which 3 of the following?

Data structuring Data visualization Data reporting

Collections of related fields in a database are referred to as ___.

Records

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

Redistributed

Common SQL terms include which 3 of the following?

SELECT FROM WHERE

Someone who possesses the knowledge of processing software, business strategy, and analytical skill to deliver data and reports that guide management and executives as they create well-informed decision making is known as a data ___.

Analyst

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

Bachelor's degree is correct answer for the assignment. "Ph.D. are the preferred degree due to research"

Because many business executives desire to create a data-driven decision making culture, which 3 of the following are competencies organizations invest in to support DDDM?

Building a data-driven community Data proficiency Agility in analytics and data analysis

Characteristics of databases include which 3 of the following?

Characters Records Fields

The process of taking components from data sources and analytics platforms to create a more user-friendly experience that makes finding critical insights easier is called ___________ data and analytics.

Composable

Trends in data analytics include which 3 of the following?

Composable data Data analytics as a core business function Scalable AI

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 3 of the following?

Data strategy Understanding context Curiosity

A SQL statement is used to ask a question or communicate a request of the ___________ management system.

Database

SQL is quite useful when working with large data sets and is widely used in today's business environment. It allows the user to query the data contained in a __________.

Database

DDDM refers to Data Driven __________ Making.

Decision

In a database, data is organized in complex and meaningful collections specified by the database administrator. These collections are referred to as __________.

Fields

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

Format

Characteristics of spreadsheets include which 2 of the following?

Information is organized into cells Data is structured in rows and columns

Data that offers free access, distribution, and usage is known as __________ data.

Open

Key skills required of data analysts include which 3 of the following?

Oral communication skills Technical writing skills Experience with SQL and computer code

When discussing personally identifiable information (PII), which 3 of the following are usually anonymized?

Phone numbers Names Social security numbers

The 6-step process analysts use to create data-driven decision making includes which 3 of the following?

Prepare Analysis Ask

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

Share

Which program is typically limited to one user at a time?

Spreadsheet

Which 3 of the following are major varieties of data formats?

Structured data Unstructured data Discrete data

In computer programming, a set of rules and guidelines that define a specific computer language is referred to as the language's ___.

Syntax

Providing the ability to explore and analyze data in seconds using a drag and drop interface as well as natural language processing which allows for the presentation of questions are major attributes of __________, which offers licenses for Creators, Explorers, and Viewers.

Tableau

When working in Tableau, users can assume which 3 roles?

Viewers Creators Explorers

The graphical and structured representation of data is known as data

Visualization , visualization, or visualizations

Improving decision making, customer service, production and operations processes are just a few of the trends in data ___________.

analytics

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

descriptive analytics

Entry-level data analysts frequently start with no prior __________, but go through extensive on-the-job training that teaches them how to apply information learned in college as well as training on organizational policies and procedures.

experience

The process of converting the format of data from one form to another is called data __________.

Transformation

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

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

Uses of data analytics include which 3 of the following?

Improved patient experiences and internal procedures in healthcare Improved decision making Improved customer service

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

Query

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.

Scalable

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.

Third-party

Measurable and counted data that can have almost any numeric value is called __________data.

continuous