Deal Explorer

103 deals · All three stores · September 2025

Granite Auto Group is fictional. Operating figures are synthetic.· data and methodology

Every warehouse record in this project is synthetic. Granite Auto Group and its three stores are fictional. No real dealership, customer, employee or lending data exists anywhere in the project.

Dataset v17 · developmentAs of 31 December 2025Real-engine validation pending

Real-engine validation pending. Neither accepted ADR-0008 path has recorded a result, so nothing on this page may be read as evidence that the Power BI semantic model has been validated. This console renders exported SQL figures; rendering a number in HTML proves nothing about a DAX measure.

The evidence behind both statements

How this is built, governed and validated

Filters

Period: 2025-09Remove this filter

Reset filters

Filters and controls1 applied

Period

Store

Condition

Selects deals by the vehicle's condition.

Lead source

Selects deals with a linked lead from that source. Walk-in deals are excluded when a source is chosen.

This filter selects

September 2025

Deals counts every matched transaction; the money figures are over the retail rows only, because a wholesale disposal belongs in the table below and not in a retail gross total. A deal that closed at a front-end loss is counted rather than suppressed.

Deals: 103; Matching the current filters
Retail units: 88; 15 matched transactions are not retail
Total gross: $356,938; Retail rows only

Front gross: $248,374
Back gross: $108,564
Closed at a front loss: 22

The transactions behind the aggregate

Sales & Gross for this scope

A wholesale disposal or dealer trade is shown and labelled as not retail: it is a real transaction, and judging it by retail measures would be the error, not showing it.

Finalized transactions matching the current filters, one row per deal.
Deal	Sale date	Store	Vehicle	Sale type	Sale price	Front gross	Back gross	Total gross	Days
SLE-00000255	1 September 2025	Granite Pre-Owned	2020 Jeep Wrangler SportUsed	Used Retail	$13,108	$1,809	$1,815	$3,623	107
SLE-00000256	1 September 2025	Granite Chevrolet	2020 Chevrolet Blazer 3LTCertified	Certified Retail	$13,412	$1,824	$1,841	$3,665	25
SLE-00000257	1 September 2025	Granite Chevrolet	2017 Toyota RAV4 XLEUsed	Used Retail	$5,874	$629	$304	$933	55

SLE-000002551 September 2025
2020 Jeep Wrangler Sport
Granite Pre-OwnedVEH-0000417UsedUsed Retail
Sale price
$13,108
Front
$1,809
Back
$1,815
Total
$3,623
Source: Direct Mail ResponseSalesperson: EMP-00029107 days in stock
SLE-000002561 September 2025
2020 Chevrolet Blazer 3LT
Granite ChevroletVEH-0000448CertifiedCertified Retail
Sale price
$13,412
Front
$1,824
Back
$1,841
Total
$3,665
Source: Television Spot ResponseSalesperson: EMP-0001225 days in stock
SLE-000002571 September 2025
2017 Toyota RAV4 XLE
Granite ChevroletVEH-0000587UsedUsed Retail
Sale price
$5,874
Front
$629
Back
$304
Total
$933
Walk-in or unattributedSalesperson: EMP-0001055 days in stock

Unit, lead source and attribution for these deals

Unit identifier, lead source and staff attribution for the deals listed above, in the same order. Synthetic employee codes; no name exists anywhere in ARPI.
Deal	Unit	Lead source	Salesperson	Desk	Finance
SLE-00000255	VEH-0000417	Direct Mail Response	EMP-00029	EMP-00030	EMP-00028
SLE-00000256	VEH-0000448	Television Spot Response	EMP-00012	EMP-00002	EMP-00005
SLE-00000257	VEH-0000587	Walk-in or unattributed	EMP-00010	EMP-00002	EMP-00005

Each deal id opens its Deal Jacket: the transaction explained to the cent, with the cost components behind its front gross, its trade context, staff attribution, lead timeline, integrity checks and lineage.