Deal Explorer

26 deals · Granite Pre-Owned · December 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

Store: GSA-003Remove 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

December 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: 26; Matching the current filters
Retail units: 22; 4 matched transactions are not retail
Total gross: $90,651; Retail rows only

Front gross: $66,719
Back gross: $23,932
Closed at a front loss: 4

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-00000551	2 December 2025	Granite Pre-Owned	2020 Jeep Wrangler SportUsed	Used Retail	$14,300	$3,372	$2,175	$5,547	20

SLE-000005512 December 2025
2020 Jeep Wrangler Sport
Granite Pre-OwnedVEH-0000874UsedUsed RetailTrade
Sale price
$14,300
Front
$3,372
Back
$2,175
Total
$5,547
Walk-in or unattributedSalesperson: EMP-0002520 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-00000551	VEH-0000874	Walk-in or unattributed	EMP-00025	EMP-00024	EMP-00028

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.