Data Analytics - Assignment (ALA)Assignment

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

A) WHERE ✅ B) SPLIT C) FROM ✅ D) SELECT ✅

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

A) predictive analytics B) descriptive analytics ✅ C) prescriptive analytics D) tracking 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 consists of exploring the data sets for pattern, then planning for visuals, and finally ___.

Creating your visuals

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

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?

A) Agility in analytics and data analysis ✅ B) Data proficiency ✅ C) Increased investment in database servers. D) Building a data-driven community ✅

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

A) Analyst ✅ B) Financer C) Administrator D) Fabricator

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

A) Create your visuals ✅ B) Planning for visuals ✅ C) Ask the stakeholders D) Explore data sets for patterns ✅

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

A) Experience with SQL and computer code ✅ B) Technical writing skills ✅ C) Oral communication skills ✅ D) In-depth understanding of sociology

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

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

Database

DDDM refers to Data Driven ____ Making.

Decision

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

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

Ordinal

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

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

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?

A) Share ✅ B) Act C) Ask D) Analysis

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

A) Unstructured data ✅ B) Speculative data C) Structured data ✅ D) Discrete data ✅

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

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

A) Explorers ✅ B) Creators ✅ C) Builders D) Viewers ✅

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

A) Has the data been anonymized? B) How will the data be collected? ✅ C) What types of data do you need to solve a specific problem? ✅ D) How much data should be collected? ✅

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

A) Improved patient experiences and internal procedures in healthcare ✅ B) Improved decision making ✅ C) Improved data security D) Improved customer service ✅

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

A) Information is organized into cells ✅ B) Data is structured using rules and relationships defined by the DBMS C) Data entry is often automated and constrained by defined parameters D) Data is structured in rows and columns ✅

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

A) Data strategy ✅ B) Curiosity ✅ C) Sensing D) Understanding context ✅

Select all that apply For data to be considered open data, it must have what 3 characteristics?

A) The data must be primary data. B) Datasets must be universally available so that anyone can use the data. ✅ C) Datasets must have access rights that allow them to be reused and redistributed. ✅ D) The public must have access and datasets must be available for use. ✅

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

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

Query

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

anonymization

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

customers

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

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

transformation

When data is anonymized, the PII is eliminated or encrypted. PII includes names, social security numbers, addresses, and more and stands for ___ identifiable information.

A) Private B) Publicly C) Personally ✅ D) Power

Select all that apply Characteristics of databases include which 3 of the following?

A) Records ✅ B) Characters ✅ C) Fields ✅ D) Slides

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

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.

A) Scalable ✅ B) Predictive Analytics C) Data Fabric D) Composable