Retail Executive Analytics

Preserved source

Raw_Data

The source layer is never edited. Its original strings, blanks, inconsistent casing, and invalid date record remain visible so the cleaning process is audit-ready.

Source rows

49

Unaltered transaction rows

Duplicate rows

1

Detected by Transaction_ID

Invalid dates

1

Blocked from Clean_Data

Standardizations

6

Applied only downstream

Source transaction table

Search is a view-only aid; the raw source remains unchanged.

SourceTransactionOrder DateCustomerRegion / CityCategoryProductQtyUnit PricePaymentStatusRating
2TX-10012025-01-03Mason FamilySouth / AustinElectronicsAtlas Laptop Pro21299Credit CardCompleted3
3TX-10022025-01-08Kite & PineWest / PortlandHome & OfficeSummit Standing Desk4690Bank TransferCompleted3
4TX-10032025-01-13Lumen FitnessSouth / AtlantaHome & OfficeTerra Cookware Set1246Digital WalletCompleted3
5TX-10042025-01-18Pioneer LabsMidwest / ChicagoElectronicsVertex Monitor 273420InvoiceCompleted3
6TX-10052025-02-23Northstar StudioNortheast / New York electronics Trail Hydration Pack592Credit CardCompleted3
7TX-10062025-02-04Rivera HouseholdMidwest / DetroitElectronicsAtlas Laptop Pro21299Bank TransferPending3
8TX-10072025-02-09Cedar CollectiveWest / San FranciscoHome & OfficeSummit Standing Desk4690Digital WalletCompleted3
9TX-10082025-02-14Harbor & Co.West / SeattleHome & OfficeTerra Cookware Set1246InvoiceCompleted3
10TX-10092025-03-19Beacon HospitalityNortheast / New YorkHome & OfficeSora Office Chair3318Credit CardCompleted3
11TX-10102025-03-24Patel HouseholdNortheast / new yorkSportsTrail Hydration Pack592Bank TransferCompleted3
12TX-10112025-03-05Mason FamilySouth / AustinElectronicsAtlas Laptop Pro21299Digital WalletCompleted3
13TX-10122025-03-10Kite & PineWest / PortlandHome & OfficeSummit Standing Desk4690InvoicePending3
14TX-10132025-04-15Lumen FitnessSouth / AtlantaElectronicsNova Wireless Earbuds1188Credit CardCompleted3
15TX-10142025-04-20Pioneer LabsMidwest / ChicagoHome & OfficeSora Office Chair3318Bank TransferCompleted3
16TX-10152025-04-25Northstar StudioNortheast / New YorkSportsTrail Hydration Pack592Digital WalletCompleted3
17TX-10162025-04-06Rivera HouseholdMidwest / DetroitElectronicsAtlas Laptop Pro21299InvoiceCompleted3
18TX-10172025-05-11Cedar CollectiveWest / San FranciscoSportsPulse Running Shoe4154Credit CardCompleted3
19TX-10182025-05-16Harbor & Co.West / SeattleElectronicsNova Wireless Earbuds1188Bank TransferPending3
20TX-10192025-05-21Beacon HospitalityNortheast / New YorkHome & OfficeSora Office Chair3318Digital WalletCompleted3
21TX-10202025-05-26Patel HouseholdNortheast / BostonSportsTrail Hydration Pack592InvoiceCompleted3
22TX-10212025-06-07Mason FamilySouth / AustinElectronicsVertex Monitor 272420Credit CardCompleted3
23TX-10222025-06-12Kite & PineWest / PortlandSportsPulse Running Shoe4154credit cardCompleted3
24TX-10232025-06-17Lumen FitnessSouth / AtlantaElectronicsNova Wireless Earbuds1188Digital WalletCompleted3
25TX-10242025-06-22Pioneer LabsMidwest / ChicagoHome & OfficeSora Office Chair3318InvoicePending3
26TX-10252025-07-03Northstar StudioNortheast / New YorkHome & OfficeTerra Cookware Set5221Credit CardCompleted3
27TX-10262025-07-08Rivera HouseholdMidwest / DetroitElectronicsVertex Monitor 272378Bank TransferCompleted3
28TX-10272025-07-13Cedar CollectiveWest / San FranciscoSportsPulse Running Shoe4139Digital WalletCompleted3
29TX-10282025-07-18Harbor & Co.West / SeattleElectronicsNova Wireless Earbuds1169InvoiceCompleted3
30TX-10292025-08-23Beacon HospitalityNortheast / New YorkHome & OfficeSummit Standing Desk31,299Credit CardCompleted3
31TX-10302025-08-04Patel HouseholdNortheast / BostonHome & OfficeTerra Cookware Set5246Bank TransferPending3
32TX-10312025-08-09Mason FamilySouth / AustinElectronicsVertex Monitor 272420Digital WalletCompleted3
33TX-10322025-08-14Kite & PineWest / PortlandSportsPulse Running Shoe4154InvoiceCompleted3
34TX-10332025-09-19Lumen FitnessSouth / AtlantaElectronicsAtlas Laptop Pro11299Credit CardCompleted3
35TX-10342025-09-24Pioneer LabsMidwest / ChicagoHome & OfficeSummit Standing Desk3690Bank TransferCompleted3
36TX-10352025-09-05Northstar StudioNortheast / New YorkHome & OfficeTerra Cookware Set5246Digital WalletCompleted3
37TX-10362025-09-10Rivera HouseholdMidwest / DetroitElectronicsVertex Monitor 272420InvoicePendingBlank
38TX-10372025-10-15Cedar CollectiveWest / San FranciscoSportsTrail Hydration Pack492Credit CardCompleted3
39TX-10382025-10-20Harbor & Co.West / SeattleElectronicsAtlas Laptop Pro11299Bank TransferCompleted3
40TX-10392025-10-25Beacon HospitalityNortheast / New YorkHome & OfficeSummit Standing Desk3690Digital WalletCompleted3
41TX-10402025-10-06Patel HouseholdNortheast / BostonHome & OfficeTerra Cookware Set5246InvoiceCompleted3
42TX-10412025-11-11Mason FamilySouth / AustinHome & OfficeSora Office Chair2363Credit CardCompleted3
43TX-10422025-11-16Kite & PineWest / PortlandSportsTrail Hydration Pack4105Bank TransferPending3
44TX-10432025-11-21Lumen FitnessSouth / AtlantaElectronicsAtlas Laptop Pro11481Digital WalletCompleted3
45TX-10442025-11-26Pioneer LabsMidwest / ChicagoHome & OfficeSummit Standing Desk3787InvoiceCompleted3
46TX-10452025-13-40Northstar StudioNortheast / New YorkElectronicsNova Wireless Earbuds5214Credit CardCompleted3
47TX-10462025-12-12Rivera HouseholdMidwest / DetroitHome & OfficeSora Office Chair2363Bank TransferCompleted3
48TX-10472025-12-17Cedar CollectiveWest / San FranciscoSportsTrail Hydration Pack4105Digital WalletCompleted3
49TX-10482025-12-22Harbor & Co.West / SeattleElectronicsAtlas Laptop Pro11481InvoicePending3
50TX-10192025-05-21Beacon HospitalityNortheast / New YorkHome & OfficeSora Office Chair3318Digital WalletCompleted3

Governance note

This page demonstrates the interview-ready control: the source is immutable, while all decisions about rejected rows and standardized values are documented in the next model layer.

Retail Executive Analytics Workbook · Source data preserved, transformations documented, insights automated.
Built with GenMB
Built with GenMB