Data Analytics

table

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.

Analyst

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

Scalable

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.

data

A simple formula that can be used to define success is: ______________ + organizational knowledge = problem solved.

Data strategy Curiosity Understanding context

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 proficiency Building a data-driven community Agility in analytics and data analysis

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?

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

Characteristics of spreadsheets include which 2 of the following?

records.

Collections of related fields in a database are referred to as

Analytical

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

decision

DDDM refers to Data Driven __________ Making.

Bachelor's degree

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

business or organization

Data analysts must blend facts and data with knowledge about the

Format

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

analytics

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

Fields

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

Redistributed

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

two dashes: "- -."

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)

Continuous

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

Power

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

storage

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

tableau

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.

ordinal

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

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

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

Structured

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.

Creating your visuals

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

Planning for visuals Explore data sets for patterns Create your visuals

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

Ask Analysis Prepare

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

data

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.

Transformation

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

Social security numbers Names Phone numbers

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

analyst

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

Share

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?

experience

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.

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

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

query.

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

getting feedback.

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

Personally

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

Power BI Pro Power BI Premium Power BI Desktop

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

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.

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

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

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

Data structuring Data visualization Data reporting

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

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

composable

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.

descriptive analytics

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

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

Uses of data analytics include which 3 of the following?

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

Uses of data analytics include which three of the following?

Third-party

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.

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

Which 3 of the following are examples of data transformation?

Unstructured data Structured data Discrete data

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

Visualization

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.

Tableau

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

Spreadsheet

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