ch 3 info

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) ___.

2 dashes: "- -"

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?

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

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

Analysis Prepare Ask

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

Analytical

Data analysts must blend facts and data with knowledge about the ___.

Business or organization

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

Composable

Trends in data analytics include which 3 of the following?

Composable data

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

Creating your visuals

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?

Curiosity Understanding context Data strategy

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

Customers

Characteristics of spreadsheets include which 2 of the following?

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

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

Data reporting Data structuring Data visualization

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

Data visualization Data structuring Data reporting

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

Data visualization tools Spreadsheets Databases and query languages

A SQL statement is used to ask a question or communicate a request of the

Database

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. The public must have access and datasets must be available for use. Datasets must be universally available so that anyone can use the data.

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

Descriptive analytics

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

Discrete data Structured data Unstructured data

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

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

Uses of data analytics include which 3 of the following?

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

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

Names Social security numbers Phone numbers

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

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

Planning for visuals Explore data sets for patterns Create your visuals

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

Power BI Premium Power BI Pro Power BI Desktop

The process of data analytics includes which 3 of the following?

Prescriptive analytics Descriptive analytics Predictive analytics

Characteristics of databases include which 3 of the following?

Records Fields Characters

Using the correct syntax allows the user to extract data from multiple fields found in data tables. In order to extract information from multiple tables, the ___ command is used to indicate multiple fields in conjunction with FROM and WHERE to narrow the search and get specific results.

SELECT

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

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

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

Spreadsheet

One way to visualize a data ecosystem is to apply it to the data project life cycle. The Data Science Ready project outlines the 5 steps of the data project life cycle. The final stage in this life cycle is ___.

Storage

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

Syntax

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

Tableau

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

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

Viewers Explorers Creators

There are three main tools data analysts and other members of an organization use to analyze data. They are spreadsheets, databases and query languages, and data

Visualization

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?

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

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

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

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

anonyization

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

data

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

exeperience

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

open

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

power bi

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

process

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

tableau