Data Visualisation QUESTIONS AND
ANSWERS
What are the three main Simplifying understanding, telling a story, highlighting
purposes of data significant results
visualisation?
How can data visualisation By showing patterns, trends, and relationships that allow
support predictive forecasting
analysis?
What does OLAP stand for, Online Analytical Processing; used to analyse and query
and what is its purpose? large datasets interactively
What is the role of Enables analysis of historical trends, correlation with
enterprise data current data, and data optimisation, also Storage of
warehousing in data large amounts of data
visualisation?
What are the three V's of Volume, Variety, Velocity
big data?
How can big data affect Expands scope of information, depth of insights, and requires
the design of a data advanced tools
visualisation?
Name one risk and one Risk → privacy/security concerns; Benefit → deeper insights and
benefit of using big data in prediction
visualisation.
Which spreadsheet Pivot tables and slicers
feature is most commonly
used to create
dashboards?
What is the function of To visually highlight data trends, thresholds, or anomalies
conditional formatting in
spreadsheets?
Give an example of a Mean, Standard Deviation
statistical function in
spreadsheets used for
analysis.
Which database tool is A schema
, used to define structure
and relationships between
tables?
ANSWERS
What are the three main Simplifying understanding, telling a story, highlighting
purposes of data significant results
visualisation?
How can data visualisation By showing patterns, trends, and relationships that allow
support predictive forecasting
analysis?
What does OLAP stand for, Online Analytical Processing; used to analyse and query
and what is its purpose? large datasets interactively
What is the role of Enables analysis of historical trends, correlation with
enterprise data current data, and data optimisation, also Storage of
warehousing in data large amounts of data
visualisation?
What are the three V's of Volume, Variety, Velocity
big data?
How can big data affect Expands scope of information, depth of insights, and requires
the design of a data advanced tools
visualisation?
Name one risk and one Risk → privacy/security concerns; Benefit → deeper insights and
benefit of using big data in prediction
visualisation.
Which spreadsheet Pivot tables and slicers
feature is most commonly
used to create
dashboards?
What is the function of To visually highlight data trends, thresholds, or anomalies
conditional formatting in
spreadsheets?
Give an example of a Mean, Standard Deviation
statistical function in
spreadsheets used for
analysis.
Which database tool is A schema
, used to define structure
and relationships between
tables?
