Part 3 - Data Analytics

A data _____ uses the knowledge of processing software, business strategy, and analytical skills to deliver data and reports that guide management and executives.

Analyst

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

Ask Analysis Prepare

Select all that apply 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?

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

DDDM refers to Data Driven _____ Making.

Decision

Select all that apply The 3-step data visualization process is comprised of which of the following?

Explore data sets for patterns Planning for visuals Create your visuals

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

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

Select all that apply Uses of data analytics include which 3 of the following?

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

Select all that apply Characteristics of spreadsheets include which 2 of the following?

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

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

Names Social security numbers Phone numbers

Select all that apply Key skills required of data analysts include which 3 of the following?

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

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

Query

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

Select all that apply Which 3 of the following are major varieties of data formats?

Structured data Discrete data Unstructured data

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

Select all that apply Which 3 of the following are examples of data transformation?

The deletion of database fields or records to ensure data integrity Copying or replicating data Standardizing names and variables across data sets

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

Select all that apply When working in Tableau, users can assume which 3 roles?

Viewers Explorers Creators

Select all that apply Common SQL terms include which 3 of the following?

WHERE FROM SELECT

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

analytical

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

anonymization

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

bachelor's degree

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

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

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

Data that has been collected internally by the organization is known as _______-party data.

first

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

format

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

open

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

ordinal

Fill in the blank question. In the six-step process analysts use to create data-driven decisions, the step during which data cleansing occurs to ensure that high-quality data is ready for processing is the _________ step.

process

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

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

syntax

Most databases are composed of multiple _________, which are groups of assigned records and fields organized in rows and columns.

tables