DATA ANALYTICS EXAM SCRIPT 2026
QUESTIONS AND SOLUTIONS
◉Identify Questions. Answer: determine the answer or insight
you're looking for, make a hypothesis, identify a target value.
◉Master the Data. Answer: understand the available data, extract,
transform, load the data
◉Prepare a Model. Answer: identify a model or approach, perform
the analysis
◉Address Results. Answer: compare the results with your
hypothesis, refine your model
◉Communicate the Results. Answer: draw a conclusion, gain
understanding, summarize the results in plain language, use
appropriate visualizations
◉Track Outcomes. Answer: evaluate results, gather feedback, adjust
as needed
, ◉Financial Statement Analysis. Answer: Investors, analysts,
shareholders, partners, and managers identify trends, patterns, or
relationships between numbers reported on the financial
statements.
◉Financial Statement Analysis (examples). Answer: What is the
average selling price of an iPhone? Is the company able to service its
debt? How has working capital changed over the past three years?
◉Budget and Controlling. Answer: Managers evaluate performance
and operations to determine whether to increase sales or cut costs
and evaluate whether their decisions have the expected impact on
financial performance.
◉Budget and Controlling (examples). Answer: Which locations are
using the most energy? How much training are we providing
employees?How are we performing on balanced scorecard
benchmarks? Is our price variance within an acceptable range?
◉Auditing. Answer: Auditors evaluate financial and non-financial
data to evaluate risk, identify effectiveness of internal controls, test
management assertions, and evaluate information systems.
◉Auditing (examples). Answer: Which transactions represent the
highest risk and exposure for the client? Are there transactions that
QUESTIONS AND SOLUTIONS
◉Identify Questions. Answer: determine the answer or insight
you're looking for, make a hypothesis, identify a target value.
◉Master the Data. Answer: understand the available data, extract,
transform, load the data
◉Prepare a Model. Answer: identify a model or approach, perform
the analysis
◉Address Results. Answer: compare the results with your
hypothesis, refine your model
◉Communicate the Results. Answer: draw a conclusion, gain
understanding, summarize the results in plain language, use
appropriate visualizations
◉Track Outcomes. Answer: evaluate results, gather feedback, adjust
as needed
, ◉Financial Statement Analysis. Answer: Investors, analysts,
shareholders, partners, and managers identify trends, patterns, or
relationships between numbers reported on the financial
statements.
◉Financial Statement Analysis (examples). Answer: What is the
average selling price of an iPhone? Is the company able to service its
debt? How has working capital changed over the past three years?
◉Budget and Controlling. Answer: Managers evaluate performance
and operations to determine whether to increase sales or cut costs
and evaluate whether their decisions have the expected impact on
financial performance.
◉Budget and Controlling (examples). Answer: Which locations are
using the most energy? How much training are we providing
employees?How are we performing on balanced scorecard
benchmarks? Is our price variance within an acceptable range?
◉Auditing. Answer: Auditors evaluate financial and non-financial
data to evaluate risk, identify effectiveness of internal controls, test
management assertions, and evaluate information systems.
◉Auditing (examples). Answer: Which transactions represent the
highest risk and exposure for the client? Are there transactions that
