INFO90002 Chap.10 Data Warehousing and Analytical Models

Data Warehousing and Analytical Models

Data Warehousing and Analytical Models connects three subject-supported ideas: operational versus analytical data, fact and dimension and ETL and lineage. The chapter does not treat them as interchangeable labels. It asks what each idea identifies, how the relationship operates in a bounded setting and what evidence would make the resulting judgement more or less credible.

That order is important because a memorised definition can be correct while the application built from it is wrong.

The practical objective is to design an analytical grain and preserve the transformation trail. A useful starting note has four columns: observed condition, concept, mechanism and consequence.

The observed condition comes from the question or evidence; the concept supplies a disciplined category; the mechanism explains the link; and the consequence states why a decision maker should care. If one column is empty, further description will not fix the missing reasoning.

operational versus analytical data provides the first lens. Define its object, scale and context before attaching an evaluation.

Ask what is being counted, classified or interpreted and whose position is represented. This avoids a common error in which the same word shifts meaning between the opening definition and the final recommendation. A stable definition makes later comparison possible without pretending the concept is universal.

fact and dimension supplies the connecting logic.

Rather than writing that it is important, state what changes, through which process, over what interval and for whom. That sentence generates an evidence plan: one piece of evidence should establish the starting condition, one should test the process and one should show the relevant outcome. Repeated descriptions of the starting condition do not corroborate the process.

ETL and lineage provides a test or consequence.

Use it to compare cases, expose a trade-off or identify a stakeholder whose result differs from the average. The comparison should be chosen before the conclusion, because a comparison invented after the fact tends to defend the preferred answer.

A disciplined comparison can support the claim, narrow it or show that a different mechanism is more plausible.

The chapter application is completed only when evidence changes an action. Write the recommendation with an actor, an action, a reason and a review signal.

The actor identifies responsibility; the action makes the advice operational; the reason points back to the mechanism; and the review signal specifies what future observation would trigger adjustment. This structure works for reports, cases, oral explanations and timed responses.

Accuracy also requires a boundary: a warehouse metric needs a stable definition before optimisation.

Keep that sentence visible beside notes and model answers. It prevents a subject concept, published at one level of generality, from being converted into an unsupported claim about a person, organisation, population or assessment rule.

Where a live task brief adds constraints, the live brief controls the operation while this guide continues to support the underlying reasoning.

Study this chapter through retrieval and transfer. First reconstruct the three ideas and their analytical jobs without notes. Next explain the mechanism aloud in plain language. Then apply it to a changed scenario and deliberately look for a counter-case.

Finally compare the result with the source material and record what the correction reveals. Fluency is useful only when it remains source-controlled and adaptable.

Keep a chapter-specific error log rather than a generic list of weak habits.

When a response goes wrong, classify the failure: was operational versus analytical data undefined, was the link through fact and dimension asserted instead of explained, or was ETL and lineage omitted when the conclusion needed testing? Rewrite only the defective move, then rerun the same reasoning on a different example.

Over time the log should record the trigger, the mistaken inference, the corrected mechanism and the evidence that distinguishes them. This turns feedback into a reusable diagnostic and prevents the same conceptual error from reappearing under new surface details.

What this chapter covers

• 01

  operational versus analytical data

• 02

  fact and dimension

• 03

  ETL and lineage

• 04

  Evidence and mechanism

• 05

  Boundary and transfer

AskSia practice: apply Data Warehousing and Analytical Models

Key terms

operational versus analytical data

The first analytical lens used in Data Warehousing and Analytical Models.

fact and dimension

The relationship or process that connects evidence to the explanation.

ETL and lineage

The comparison, consequence or control that tests the conclusion.

Data Warehousing and Analytical Models FAQ

Exam move

Retrieve operational versus analytical data, fact and dimension and ETL and lineage; explain their relationship; apply them to a changed scenario; then audit the result against the source and the boundary statement.

Working through Data Warehousing and Analytical Models in INFO90002? Sia is AskSia’s AI Information Technology tutor — ask any INFO90002 Data Warehousing and Analytical Models question and get a clear, step-by-step explanation grounded in how INFO90002 is taught and assessed. Read this chapter free, then take your hardest questions to Sia.