Quiz #8: Data Analytics
The six-step process analysts use to create data-driven decision making includes which three of the following?
1. Ask 2. Analysis 3. Prepare
The three-step data visualization process is comprised of which of the following?
1. Explore data sets for patterns. 2. Create your visuals. 3. Planning for visuals.
When discussing personally identifiable information (PII), which three of the following are usually anonymized?
1. names 2. phone numbers 3. Social Security numbers
A simple formula that can be used to define success is:
Data must remain the driving force for all decisions recommended by the data analyst.
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.
Data visualization is the graphical and structured representation of data.
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.
During the process step, data cleansing and checking should occur to ensure high-quality data is ready for analysis.
Which of the following is a popular Microsoft data analytics program that offers business intelligence as well as data visualization?
Power BI
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 SQL statement is used to ask a question or communicate a request of the ______ management system.
SQL database queries are executed using precise syntax of SQL statements.
Data-driven decision making (DDDM) can be facilitated through a six-step processes of Ask, Prepare, Process, Analysis, Share, and Act. Which of these steps refers to creating visualizations and presentations for key stakeholders?
Share
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.
Tableau is analytics software that offers business intelligence and data visualization across many areas as well as for organizational processes.
The graphical and structured representation of data is known as data _____.
Visualization makes it easier to see the results and conclusions ascertained from data analysis.
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.
While data analysts typically being their careers with no prior experience, they are likely to have a Bachelor's degree with emphasis in areas such as management information systems (MIS), computer science, mathematics, statistics, economics, or finance.
Data analysts must blend facts and data with knowledge about the
business or organization.
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
Characteristics of databases include which three of the following?
1. fields 2. records 3. characters
Trends in data analytics include which three of the following?
1. scalable AI 2. composable data 3. data analytics as a core business function
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
Some of the responsibilities of a data analyst include which three of the following?
1. data visualization 2. data structuring 3. data reporting
In computer programming, a set of rules and guidelines that define a specific computer language is referred to as the language's
syntax
