Đại học Kinh tế Quốc dân – National Economics UniversityMICRO4ASIA
🏆 Arena
Sign inSign up
MICRO4ASIAThe six micro-credentials

Courses are delivered on the Limio learning platform. Limio

← Prompt Engineering

You are viewing a public preview

Sign in to save your progress, do assignments, join discussions and get feedback.

Sign in
Module 3 — Execute: Apply, Compare and Automate

Period 7 · Task Execution — Data Visualisation Case

Print / Save as PDF
Lecture video — Period 7: Task Execution — Data Visualisation Case

A full five-step cycle for a regional net-sales chart: defining the deliverables, designing the request, checking measure, values, encoding and meaning, then refining the chart.

Flashcards · Period 7

10 words
WordMeaningExample
  • Aggregation

    Combining records into one value per group, such as the total net sales of each region.

    SUM(Net_Sales_Amount) grouped by Store_Region gives four numbers from 200 rows.

  • SUM versus average

    For "how much in total?" use SUM. An average of individual sales answers a different question (typical size of one sale).

    East has the lowest total but the highest average per transaction.

  • Zero baseline

    A value axis that starts at zero. Bars encode value by length, so a truncated axis exaggerates differences.

  • Chart encoding

    How a chart maps data to visual features such as bar length and position. Check that the encoded measure is the one you asked for.

  • Net sales is not profit

    Net_Sales_Amount records sales after discount. It contains no costs, so it cannot support claims about profit, margin or efficiency.

  • Evaluate checklist

    Measure, values, scale, labels and units, claims. A correct ranking never explains why regions differ.

  • Chart specification

    A written description of a chart (data, type, axes, labels) that you can build in another tool. Use it when the chatbot cannot draw.

  • Spreadsheet fallback

    A pivot table or SUMIF formula that reproduces the grouped totals independently. State honestly which output came from the spreadsheet.

  • Chart refinement

    Improving readability (order, clutter, emphasis, labels) while keeping values, measure and baseline unchanged, then rechecking.

  • Verification record

    Brief, prompts, input version, verified table, charts, checks and revision notes saved together so a peer can reproduce the totals.