DATA VISUALIZATION EXPLORING AND
EXPLAINING WITH DATA FINAL PAPER
TESTED QUESTIONS WITH VERIFIED
ANSWERS COMPLETE STUDY SHEET
●● What distinguishes data analysis from simple reporting?
Answer: The search for insights that might significantly affect a
business' decision-making.
●● What is data interpretation?
Answer: The process of contextualizing and understanding insights
derived from data.
●● What is the first step in the data exploration process?
Answer: Identify Questions that the analytical database should answer.
●● What does a data relationship describe?
Answer: How data elements or values relate to each other.
●● Name one of the eight foundational data relationships identified by
Stephen Few.
Answer: Nominal comparison, distribution, deviation, ranking, part-to-
whole, correlation, time series, or geospatial.
,●● What are common approaches to exploring data relationships?
Answer: Visualization and statistics.
●● What is a PivotTable?
Answer: A tool in Excel that allows users to quickly rearrange data to
answer important business questions.
●● Why are flat tables preferred over cross-tabulation tables in data
analytics?
Answer: Because flat tables do not contain data values in the column
headers that are useful for analysis purposes.
●● What are the components used for data exploration with
PivotTables?
Answer: Fields area, values area, rows and columns for sorting, and
filters for data selection.
●● What is the purpose of filters in a PivotTable?
Answer: To determine what data should be considered for analysis.
●● How can dragging and dropping fields in a PivotTable help in data
exploration?
, Answer: It allows users to answer questions about total units sold, shares
in total sales, and comparisons across different models.
●● What is a Power BI Matrix used for?
Answer: To summarize total units sold per model over a specified time
period.
●● What is the benefit of using charts over tables for analysis?
Answer: Charts are often more effective for visualizing data
relationships.
●● What is an example of a nominal comparison data relationship?
Answer: Comparing the values of a nominal variable based on the values
of a second, numeric variable.
●● What is the role of insights in the data exploration process?
Answer: Insights generate new questions, leading to further exploration
and understanding.
●● What should be included in a data dictionary for a data set?
Answer: Definitions and descriptions of the data elements within the
data set.
●● What does the term 'data reporting' refer to?
EXPLAINING WITH DATA FINAL PAPER
TESTED QUESTIONS WITH VERIFIED
ANSWERS COMPLETE STUDY SHEET
●● What distinguishes data analysis from simple reporting?
Answer: The search for insights that might significantly affect a
business' decision-making.
●● What is data interpretation?
Answer: The process of contextualizing and understanding insights
derived from data.
●● What is the first step in the data exploration process?
Answer: Identify Questions that the analytical database should answer.
●● What does a data relationship describe?
Answer: How data elements or values relate to each other.
●● Name one of the eight foundational data relationships identified by
Stephen Few.
Answer: Nominal comparison, distribution, deviation, ranking, part-to-
whole, correlation, time series, or geospatial.
,●● What are common approaches to exploring data relationships?
Answer: Visualization and statistics.
●● What is a PivotTable?
Answer: A tool in Excel that allows users to quickly rearrange data to
answer important business questions.
●● Why are flat tables preferred over cross-tabulation tables in data
analytics?
Answer: Because flat tables do not contain data values in the column
headers that are useful for analysis purposes.
●● What are the components used for data exploration with
PivotTables?
Answer: Fields area, values area, rows and columns for sorting, and
filters for data selection.
●● What is the purpose of filters in a PivotTable?
Answer: To determine what data should be considered for analysis.
●● How can dragging and dropping fields in a PivotTable help in data
exploration?
, Answer: It allows users to answer questions about total units sold, shares
in total sales, and comparisons across different models.
●● What is a Power BI Matrix used for?
Answer: To summarize total units sold per model over a specified time
period.
●● What is the benefit of using charts over tables for analysis?
Answer: Charts are often more effective for visualizing data
relationships.
●● What is an example of a nominal comparison data relationship?
Answer: Comparing the values of a nominal variable based on the values
of a second, numeric variable.
●● What is the role of insights in the data exploration process?
Answer: Insights generate new questions, leading to further exploration
and understanding.
●● What should be included in a data dictionary for a data set?
Answer: Definitions and descriptions of the data elements within the
data set.
●● What does the term 'data reporting' refer to?
