- 226,904raw orders,
as exported - 40,985completed ones
after cleaning - 9,992products,
deduplicated - 27categories
they fall into
Case D—01. The reduction is the work — the answer only comes after it.
-
Salesforce
Tableau Desktop Specialist
Certified 08 / 2026
-
Python Institute
PCEP — Certified Entry-Level Python Programmer
Certified 2026
Given away in discount — because 92.8 % of orderlines were discounted at all.
226,904 raw orders · SQL · Python · TableauOne case worked through end to end
Five cases where a number was supposed to settle an argument. One is worked through end to end — from raw export to four pricing rules, each argued from the data.
Are discounts actually good for business?
Marketing said discounts drive growth. The board saw orders rising while revenue fell. We rebuilt the true discount signal from 226,904 raw orders — cleaned to 40,985 completed ones — and classified 9,992 products into 27 categories.
The finding: discounting was not a strategy, it was the permanent default. Depth sat at ~20 % all year and barely moved for Black Friday — 23 %, while the Spanish market went to 47 %. Eniac still had its best week of the year on less than half the market's discount. The deepest cuts sat on the cheapest products, which earn the least.
The decision: stop blanket discounting, concentrate it on four events — Black Friday, Christmas, New Year, Valentine's — and cap it by price tier: low ≤ 10 %, medium ≤ 15 %, high ≤ 10 %, premium ≤ 5 %.
