Data Analytics

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

Analytical

The 3-step data visualization process is comprised of which of the following?

Create your visuals Explore data sets for patterns Planning for visuals

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

Spreadsheet

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

format

Collections of related fields in a database are referred to as

records

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.

table

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

transformation

The graphical and structured representation of data is known as data

visualization

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 must blend facts and data with knowledge about the ___.

Business or organization

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

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 Curiosity Understanding context

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

Data structuring Data reporting Data visualization

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

Data visualization tools Databases and query languages Spreadsheets

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

Names Phone numbers Social security numbers

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

Ordinal

Microsoft's analytics software that allows for the processing, manipulation, and visualization of data is called Microsoft ______ BI.

Power

When working in Microsoft Power BI, which 3 tiers are available?

Power BI Pro Power BI Premium Power BI Desktop

The steps in the data project life cycle, according to Harvard University's Data Science Ready Project include which 3 of the following?

Sensing Wrangling Collection

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

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?

curiosity, understanding context, data strategy

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

Bachelor's degree

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

Continuous

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

Format

Select three 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?

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?

Share

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.

Structured

DDDM refers to Data Driven _____ Making.

decision

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

descriptive analytics

Data analysts must blend facts and data with knowledge about the

business or organization

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

creating your visuals

The information technology (IT) architecture and infrastructure, software applications, programming languages, and storage technologies used for the collection, storage, analysis, and interpretation of meaningful data is referred to as the ________ ecosystem.

data

Uses of data analytics include which three of the following?

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

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 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

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

personally

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

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

redistributed

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 data is anonymized, the PII is eliminated or encrypted. PII includes names, social security numbers, addresses, and more and stands for ___ identifiable information.

Personally

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

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

Explorers Viewers Creators

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

Query

Questions that data analysts often ask include which 3 of the following?

What overall outcomes and results that are needed? Who will receive the information and analysis? What are the time constraints for the project?

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

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

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

analytics

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

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

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)

two dashes "--"

Characteristics of spreadsheets include which 2 of the following?

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

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

spreadsheets, databases and query languages, data visualization tools

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.

structured

For data to be considered open data, it must have what 3 characteristics?

Datasets must have access rights that allow them to be reused and redistributed. Datasets must be universally available so that anyone can use the data. The public must have access and datasets must be available for use.

The process of data analytics includes which of the following?

Descriptive analytics Prescriptive analytics Predictive analytics

Uses of data analytics include which 3 of the following?

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

Which of the following is a popular data analytics program that offers business intelligence as well as data visualization?

Tableau