You are viewing a public preview
Sign in to save your progress, do assignments, join discussions and get feedback.
In this period, we explain what its results mean. A useful report answers a business question, gives evidence, and states what the data cannot tell us. We will use a small sales example to practise this. By the end, you should be ready to complete a one-to-two-page report and check that all submitted files agree.
By the end of this lesson you can:
Key idea: A useful report answers a business question, gives evidence, and states clearly what the data cannot tell us. Every number must be traceable to the notebook.
The lecture suggests this order (a guide, not an extra grading rule):
The report should be readable without running Python, but the reader must be able to find each supporting calculation in the notebook.
The lecture's teaching table (one row in the cleaned data = one transaction for one product category; revenue after discount):
| Region | Transactions | Revenue (million VND) | Share |
|---|---|---|---|
| North | 40 | 60 | 50% |
| Central | 30 | 30 | 25% |
| South | 30 | 30 | 25% |
| Total | 100 | 120 | 100% |
The share uses total revenue across all three regions as the denominator. Defining revenue as "after discount" means every reader uses the same measure.
A good finding: "North records the highest January revenue in this dataset, 60 million dong, or 50% of the total." It has a period (January), a measure (revenue after discount), a value (60 million, 50%) and a comparison (highest of three regions).
What we cannot say: that North has the highest profit (there are no cost data), or that North's staff are better (the data say nothing about causes). Keep observed results separate from possible explanations. A reasonable next step: compare costs and product mix before changing the budget.
Explain how cleaning changed the data:
The two groups do not overlap. Keep the excluded records and reasons so someone can review the decisions, and report the final checks. A lower row count does not automatically mean better data, and the revenue total may omit real sales whose prices still need correction.
A limitation is useful when it tells the reader how to interpret the result:
Avoid vague phrases such as "the data may have problems". Limits do not make the analysis useless; they show where its conclusion applies and what to collect next.
Scenario. Write one report paragraph from the table above.
You can confirm the numbers in a few lines, which is also how the report's numbers should be traced to the notebook:
import pandas as pd
by_region = pd.DataFrame({"transactions": [40, 30, 30],
"revenue_m": [60, 30, 30]},
index=["North", "Central", "South"])
by_region["share_pct"] = by_region["revenue_m"] / by_region["revenue_m"].sum() * 100
assert by_region["share_pct"].sum() == 100
assert 108 - 5 - 3 == by_region["transactions"].sum()
print(by_region)
Expected output: shares of 50.0, 25.0 and 25.0, and both checks pass (100 transactions, matching 108 - 5 - 3). In your own report, replace the example values with your notebook results.
Include the notebook, cleaned data, quality table and short report. Run the notebook from the beginning and compare its final values with the report; check dates and units, not only totals. State your sources, any AI assistance, and each member's contribution for group work. Keep the raw data unchanged.
Flashcards · Interpreting and Reporting Results
8 wordsA statement of what the data show, including period, measure, value and comparison.
The total used to calculate a share or rate; it must be stated so readers interpret the percentage correctly.
The period, records and definitions that a result is based on.
A specific gap in the data or method that affects how a finding should be interpreted.
A concrete action that would address a limitation or test an explanation.
Keeping what the data show separate from possible reasons that still need evidence.
Counts showing how the data changed from input rows to analysed rows, with reasons.
Every number in a report can be found and reproduced in the notebook.