Module Assessment - Data Analytics

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

Creators Explorers Viewers

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

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

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 ______Blank command is used to indicate multiple fields in conjunction with FROM and WHERE to narrow the search and get specific results.

SELECT

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

Tableau

Questions that data analysts often ask include which three 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?

Which type of chart is commonly used to create pictographs?

bar or line chart

What are potential disadvantages of data visualization?

convey biased or inaccurate information or inaccurate information display correlations that do not accurately reflect causation

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

creating your visuals

What best practices should be applied when designing data visualizations?

defining a specific purpose for the visualization designing visualizations for the target audience including all relevant data

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

discrete data structured data unstructured data

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

format

What is one of the advantages of data visualization?

illustrates patterns in 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

What is another term used to describe line charts?

line plots

What is cherry-picking data in the context of data visualization?

omitting data that contradicts a desired conclusion

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

ordinal

What type of relationships do pie charts primarily represent?

part-to-whole relationships

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

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

technical writing skills experience with SQL and computer code oral communication skills

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

What is a pictograph used for in data representation?

using pictures to represent data

In a bar, line, or scatterplot graph, which axis is typically used to represent the values being compared?

y-axis

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

Bachelor's degree

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

query.

Trends in data analytics include which three of the following?

scalable AI composable data data analytics as a core business function

What is another term used to describe scatter plots?

scatter diagrams

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

spreadsheets databases and query languages data visualization tools

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?

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

The public must have access and datasets must be available for use. 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.

Data analysts must blend facts and data with knowledge about the

business or organization.

What is a potential consequence of including cherry-picked data in a visualization?

creation of misleading and false conclusions

A simple formula that can be used to define success is:

data + organizational knowledge = problem solved or Data must remain the driving force for all decisions recommended by the data analyst.

Because many business executives desire to create a data-driven decision making culture, which three of the following are competencies organizations invest in to support DDDM?

data proficiency agility in analytics and data analysis building a data-driven community

What is an important consideration when designing data visualizations?

defining a specific purpose for the visualization

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