The University of Melbourne · FACULTY OF STATISTICS

CMCE10002 Chap.12 Predictive Analytics, Stored Data and APIs

- one subject, every graph, every model, every mark
5 Chapters5-page Bible
Our own words - no uploaded lecturer files
Updated for this semester
Chapter 12 of 13 · CMCE10002

Predictive Analytics, Stored Data and APIs

Three topics, one shared job

The last three teaching weeks name using data to form and evaluate forecasts, storing and using existing data, and collecting structured and unstructured data from the interfaces services publish. The matching workshops apply them to workforce planning, auction records and economic series.

Together they cover the cases where the data is not already in front of you.

A forecast is judged on rows it has never seen

A descriptive summary is judged by whether it computes what it claims. A forecast is judged by whether it is right about something unseen, so the evaluation cannot reuse the rows the rule was built from.

Hold part of the data back, fit on the rest, score on the part held back, and where the data runs in time hold back the later rows rather than a random selection.

Live data is dated data

The same request issued next month returns different rows, so an analysis built on a live service is reproducible only if the request and its date are recorded and the response is saved beside the code.

A score means nothing on its own

Whether an average error is good depends entirely on what the alternative would have produced, and the cheapest alternative is always available: predict each period to equal the one before it.

Reporting the two side by side turns an unreadable number into a decision about whether the rule is worth maintaining. A rule that fails to beat that alternative is a finding rather than a failed exercise, and reporting it plainly is stronger than re-fitting until a better number appears.

In this chapter

What this chapter covers

  • 01

    Forming a rule and evaluating it as two separate jobs

  • 02

    Holding back later rows when the data runs in time

  • 03

    Comparing every forecast against a trivial alternative

  • 04

    Describing the slice taken from a shared store precisely

  • 05

    Recording the request and saving the response so live data stays reproducible

Worked example · free

Evaluating a staffing forecast honestly

Q [4 marks]. AskSia assigns four practice points to this independent exercise; they are not a University marking scheme. A planner builds a rule predicting next month's headcount from the last twelve months of demand and reports that it matches the historical figures almost exactly. Assess the claim.
  • 1Ask which rows the rule was scored on, and say what the answer implies.
  • 1Give the correct evaluation and the reason for the split direction.
  • 1Name the comparison that makes the score meaningful.
  • 1State the three figures the report must carry.
If the rule was scored on the same twelve months it was built from, the reported accuracy says only that the rule is flexible enough to trace the past, which is not the property anyone needs. Build it on the first nine months and score it on the last three, and because demand runs in time the held-back rows must be the later ones rather than a random selection. Score the trivial alternative on the same three months, predicting each month to equal the one before, because a sophisticated rule that does not beat it is not earning its cost. Report the score on the held-back months, the score of the trivial alternative, and the period both were measured over.
Sia tip — A rule that fits every wobble in the rows it was built from has usually memorised accidents, and accidents do not repeat. Worse performance on held-back data than a simpler rule is the standard symptom.
Glossary

Key terms

Held-back data
Rows deliberately excluded while a rule is built, kept aside to score it honestly.
Baseline comparison
A deliberately trivial alternative used to judge whether a more elaborate rule is worth its cost.
Overfitting
Matching the accidental detail of the rows a rule was built from, which does not repeat on new data.
Structured data
Data that already arrives in a rectangular shape of rows and columns.
Unstructured data
Data that arrives nested or text-heavy and needs reshaping before it becomes a table.
FAQ

Predictive Analytics, Stored Data and APIs FAQ

Why can a forecast not be scored on the data it was built from?

Because any sufficiently flexible rule can be made to trace rows it has already seen. Scoring on those rows measures how closely it reproduces the past, not whether it will be right about a period nobody has observed yet.

How should data be split when it runs in time?

Hold back the later periods rather than a random selection. In production the rule will be predicting forwards, so a random split lets it learn from periods that come after the ones it is being asked to predict.

What makes an analysis built on a live data service reproducible?

Recording the request as code, noting the date it was issued, and saving the response as a file beside the analysis. The code shows how the data was obtained and the saved file fixes what was actually reported.

Study strategy

Exam move

These weeks carry no assessment of their own and still appear in the final paper. Give them one deliberate pass in revision, focused on the three-part forecast report and the reproducibility of a live data request.

Working through Predictive Analytics, Stored Data and APIs in CMCE10002? Sia is AskSia’s AI Statistics tutor — ask any CMCE10002 Predictive Analytics, Stored Data and APIs question and get a clear, step-by-step explanation grounded in how CMCE10002 is taught and assessed. Read this chapter free, then take your hardest questions to Sia.

A+Everything unlocked
Unlocks this Bible + all 74 of your The University of Melbourne subjects - and 1,000+ Bibles across every Australian university.
Sia - your CMCE10002 tutor, unlimited, worked the way the exam marks it
The full 5-page Bible + practice bank with worked solutions
Chrome extension - sync your LMS so Sia knows your deadlines
Bilingual EN / Chinese on every Bible and every Sia answer
$0.99 Trial
30-day money-back · cancel in one tap · how it works
Unlock the full CMCE10002 Bible + 74 The University of Melbourne subjects
$0.99 Trial