Retail Executive Analytics

Analysis-ready model

Clean_Data

A structured Excel-table equivalent with valid date types, normalized dimensions, numerical measures, derived revenue and profit, and a traceable Source_Row reference.

Row integrity

47 accepted rows

2 rows were excluded only after invalid-date and duplicate-ID validation.

Dimensional consistency

6 fields standardized

Whitespace, case, payment labels, locations, and blank customer segments are normalized.

Measure readiness

Revenue + Profit

Quantity, unit cost, and unit price are numeric and produce robust analytical measures.

Transformation rules

  1. 01Validate ISO dates; reject rows that cannot become an exact Excel date.
  2. 02Remove repeated Transaction_ID values while retaining the original source layer.
  3. 03Trim and standardize category, city, payment, and status dimensions.
  4. 04Coerce numeric strings, calculate Revenue and Profit, and protect margin from divide-by-zero.

Structured analytical table

Every clean record retains a Source_Row link for reconciliation.

SourceTransactionDateSegmentRegionCategoryProductRevenueProfitMarginRating
2TX-10012025-01-03ConsumerSouthElectronicsAtlas Laptop Pro$2,598$82831.9%3
3TX-10022025-01-08BusinessWestHome & OfficeSummit Standing Desk$2,760$1,04037.7%3
4TX-10032025-01-13BusinessSouthHome & OfficeTerra Cookware Set$246$11848%3
5TX-10042025-01-18BusinessMidwestElectronicsVertex Monitor 27$1,260$44435.2%3
7TX-10062025-02-04ConsumerMidwestElectronicsAtlas Laptop Pro$2,598$82831.9%3
8TX-10072025-02-09BusinessWestHome & OfficeSummit Standing Desk$2,760$1,04037.7%3
9TX-10082025-02-14BusinessWestHome & OfficeTerra Cookware Set$246$11848%3
6TX-10052025-02-23BusinessNortheastElectronicsTrail Hydration Pack$460$24052.2%3
12TX-10112025-03-05ConsumerSouthElectronicsAtlas Laptop Pro$2,598$82831.9%3
13TX-10122025-03-10BusinessWestHome & OfficeSummit Standing Desk$2,760$1,04037.7%3
10TX-10092025-03-19BusinessNortheastHome & OfficeSora Office Chair$954$42644.7%3
11TX-10102025-03-24ConsumerNortheastSportsTrail Hydration Pack$460$24052.2%3
17TX-10162025-04-06UnspecifiedMidwestElectronicsAtlas Laptop Pro$2,598$82831.9%3
14TX-10132025-04-15BusinessSouthElectronicsNova Wireless Earbuds$188$8645.7%3
15TX-10142025-04-20BusinessMidwestHome & OfficeSora Office Chair$954$42644.7%3
16TX-10152025-04-25BusinessNortheastSportsTrail Hydration Pack$460$24052.2%3
18TX-10172025-05-11BusinessWestSportsPulse Running Shoe$616$28446.1%3
19TX-10182025-05-16BusinessWestElectronicsNova Wireless Earbuds$188$8645.7%3
20TX-10192025-05-21BusinessNortheastHome & OfficeSora Office Chair$954$42644.7%3
21TX-10202025-05-26ConsumerNortheastSportsTrail Hydration Pack$460$24052.2%3
22TX-10212025-06-07ConsumerSouthElectronicsVertex Monitor 27$840$29635.2%3
23TX-10222025-06-12BusinessWestSportsPulse Running Shoe$616$28446.1%3
24TX-10232025-06-17BusinessSouthElectronicsNova Wireless Earbuds$188$8645.7%3
25TX-10242025-06-22BusinessMidwestHome & OfficeSora Office Chair$954$42644.7%3
26TX-10252025-07-03BusinessNortheastHome & OfficeTerra Cookware Set$1,105$46542.1%3
27TX-10262025-07-08ConsumerMidwestElectronicsVertex Monitor 27$756$21228%3
28TX-10272025-07-13BusinessWestSportsPulse Running Shoe$556$22440.3%3
29TX-10282025-07-18BusinessWestElectronicsNova Wireless Earbuds$169$6739.6%3
31TX-10302025-08-04ConsumerNortheastHome & OfficeTerra Cookware Set$1,230$59048%3
32TX-10312025-08-09ConsumerSouthElectronicsVertex Monitor 27$840$29635.2%3
33TX-10322025-08-14BusinessWestSportsPulse Running Shoe$616$28446.1%3
30TX-10292025-08-23BusinessNortheastHome & OfficeSummit Standing Desk$3,897$2,60766.9%3
36TX-10352025-09-05BusinessNortheastHome & OfficeTerra Cookware Set$1,230$59048%3
37TX-10362025-09-10ConsumerMidwestElectronicsVertex Monitor 27$840$29635.2%—
34TX-10332025-09-19BusinessSouthElectronicsAtlas Laptop Pro$1,299$41431.9%3
35TX-10342025-09-24BusinessMidwestHome & OfficeSummit Standing Desk$2,070$78037.7%3
41TX-10402025-10-06ConsumerNortheastHome & OfficeTerra Cookware Set$1,230$59048%3
38TX-10372025-10-15BusinessWestSportsTrail Hydration Pack$368$19252.2%3
39TX-10382025-10-20BusinessWestElectronicsAtlas Laptop Pro$1,299$41431.9%3
40TX-10392025-10-25BusinessNortheastHome & OfficeSummit Standing Desk$2,070$78037.7%3
42TX-10412025-11-11ConsumerSouthHome & OfficeSora Office Chair$726$37451.5%3
43TX-10422025-11-16BusinessWestSportsTrail Hydration Pack$420$24458.1%3
44TX-10432025-11-21BusinessSouthElectronicsAtlas Laptop Pro$1,481$59640.2%3
45TX-10442025-11-26BusinessMidwestHome & OfficeSummit Standing Desk$2,361$1,07145.4%3
47TX-10462025-12-12ConsumerMidwestHome & OfficeSora Office Chair$726$37451.5%3
48TX-10472025-12-17BusinessWestSportsTrail Hydration Pack$420$24458.1%3
49TX-10482025-12-22BusinessWestElectronicsAtlas Laptop Pro$1,481$59640.2%3
Retail Executive Analytics Workbook · Source data preserved, transformations documented, insights automated.
⚡Built with GenMB
⚡Built with GenMB