IS 3100 - Chapter 7 - Data Analytics

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

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

Analyst

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

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

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

Business or organization

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

Collection, Sensing, Wrangling

Which 3 of the following are examples of data transformation?

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

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 simple formula that can be used to define success is:_____________+ organizational knowledge = problem solved.

Data

Trends in data analytics include which 3 of the following?

Data analytics as a core business function, Composable data, 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

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

Data structuring, Data reporting, Data visualization

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

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

Datasets must be universally available so that anyone can use the data. 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.

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

Discrete data, Unstructured data, Structured data

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

Fields

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

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

How much data should be collected? What types of data do you need to solve a specific problem? How will the data 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

Characteristics of spreadsheets include which 2 of the following?

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

According to Tableau, data-driven decision making (DDDM) is the uses which of the following to guide strategic business decisions that align with organizational goals, objectives, and initiatives.

Metrics, Data, Facts

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

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

Planning for visuals, Explore data sets for patterns, Create your visuals

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

Power

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

Power BI

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

Prepare, Ask, Analysis

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

Query

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

Records

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

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

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

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

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

Tables

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

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

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

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

Transformation

Which of the following best describes the focus of predictive analytics?

Understanding, predicting, and planning for future events and outcomes.

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

Viewers, Creators, Explorers

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

Visualization

Common SQL terms include which 3 of the following?

WHERE, FROM, SELECT

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

analytics

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

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

descriptive analytics