Deal Explorer
136 deals · All three stores · August 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.
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.
Filters and controls1 applied
This filter selects
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
- 136
- Matching the current filters
- Retail units
- 116
- 20 matched transactions are not retail
- Total gross
- $353,812
- Retail rows only
- Front gross
- $226,505
- Back gross
- $127,307
- Closed at a front loss
- 36
The transactions behind the aggregate
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.
| Deal | Sale date | Store | Vehicle | Sale type | Sale price | Front gross | Back gross | Total gross | Days |
|---|---|---|---|---|---|---|---|---|---|
| SLE-00000123 | 2 August 2025 | Granite Subaru | 2024 Subaru Outback WildernessNew | New Retail | $27,506 | -$42loss | $733 | $691 | 27 |
| SLE-00000124 | 2 August 2025 | Granite Chevrolet | 2023 Chevrolet Trailblazer LSUsed | Used Retail | $18,054 | $3,348 | $243 | $3,591 | 25 |
| SLE-00000125 | 2 August 2025 | Granite Subaru | 2024 Subaru Impreza RSNew | New Retail | $22,051 | -$1,387loss | $1,284 | -$103 | 129 |
| SLE-00000126 | 2 August 2025 | Granite Subaru | 2026 Subaru Outback Onyx Edition XTNew | Lease | $30,837 | $528 | $1,410 | $1,938 | 87 |
| SLE-00000127 | 2 August 2025 | Granite Chevrolet | 2025 Chevrolet Tahoe LSNew | Lease | $37,157 | $994 | $448 | $1,442 | 72 |
| SLE-00000128 | 2 August 2025 | Granite Subaru | 2018 Subaru Crosstrek BaseUsed | Used Retail | $3,674 | -$31loss | $1,384 | $1,353 | 38 |
| SLE-00000129 | 2 August 2025 | Granite Chevrolet | 2024 Chevrolet Silverado EV RSTCertified | Certified Retail | $41,863 | $10,759 | $2,468 | $13,227 | 33 |
| SLE-00000117 | 1 August 2025 | Granite Subaru | 2025 Subaru Forester BaseNew | Lease | $39,861 | $1,610 | $641 | $2,251 | 35 |
| SLE-00000118 | 1 August 2025 | Granite Chevrolet | 2026 Chevrolet Silverado EV RSTNew | New Retail | $47,079 | $1,432 | $1,515 | $2,947 | 35 |
| SLE-00000119 | 1 August 2025 | Granite Chevrolet | 2025 Chevrolet Tahoe LSUsed | Used Retail | $35,929 | $5,776 | $1,058 | $6,834 | 22 |
| SLE-00000120 | 1 August 2025 | Granite Pre-Owned | 2023 Audi Q5 PremiumUsed | Dealer Tradenot retail | $26,720 | $1,420 | $0 | $1,420 | 86 |
- SLE-000001232 August 20252024 Subaru Outback WildernessGranite SubaruVEH-0000353NewNew RetailTrade
- Sale price
- $27,506
- Front
- -$42loss
- Back
- $733
- Total
- $691
Walk-in or unattributedSalesperson: EMP-0001827 days in stock - SLE-000001242 August 20252023 Chevrolet Trailblazer LSGranite ChevroletVEH-0000425UsedUsed Retail
- Sale price
- $18,054
- Front
- $3,348
- Back
- $243
- Total
- $3,591
Source: Radio Spot ResponseSalesperson: EMP-0000425 days in stock - SLE-000001252 August 20252024 Subaru Impreza RSGranite SubaruVEH-0000452NewNew RetailTrade
- Sale price
- $22,051
- Front
- -$1,387loss
- Back
- $1,284
- Total
- -$103
Walk-in or unattributedSalesperson: EMP-00022129 days in stock - SLE-000001262 August 20252026 Subaru Outback Onyx Edition XTGranite SubaruVEH-0000468NewLease
- Sale price
- $30,837
- Front
- $528
- Back
- $1,410
- Total
- $1,938
Walk-in or unattributedSalesperson: EMP-0002287 days in stock - SLE-000001272 August 20252025 Chevrolet Tahoe LSGranite ChevroletVEH-0000469NewLeaseTrade
- Sale price
- $37,157
- Front
- $994
- Back
- $448
- Total
- $1,442
Source: Customer ReferralSalesperson: EMP-0000372 days in stock - SLE-000001282 August 20252018 Subaru Crosstrek BaseGranite SubaruVEH-0000765UsedUsed Retail
- Sale price
- $3,674
- Front
- -$31loss
- Back
- $1,384
- Total
- $1,353
Source: Organic Search LandingSalesperson: EMP-0002238 days in stock - SLE-000001292 August 20252024 Chevrolet Silverado EV RSTGranite ChevroletVEH-0000842CertifiedCertified Retail
- Sale price
- $41,863
- Front
- $10,759
- Back
- $2,468
- Total
- $13,227
Source: Showroom Walk-inSalesperson: EMP-0000333 days in stock - SLE-000001171 August 20252025 Subaru Forester BaseGranite SubaruVEH-0000178NewLease
- Sale price
- $39,861
- Front
- $1,610
- Back
- $641
- Total
- $2,251
Walk-in or unattributedSalesperson: EMP-0001835 days in stock - SLE-000001181 August 20252026 Chevrolet Silverado EV RSTGranite ChevroletVEH-0000611NewNew Retail
- Sale price
- $47,079
- Front
- $1,432
- Back
- $1,515
- Total
- $2,947
Walk-in or unattributedSalesperson: EMP-0000635 days in stock - SLE-000001191 August 20252025 Chevrolet Tahoe LSGranite ChevroletVEH-0000756UsedUsed RetailTrade
- Sale price
- $35,929
- Front
- $5,776
- Back
- $1,058
- Total
- $6,834
Source: Dealer Website FormSalesperson: EMP-0001022 days in stock - SLE-000001201 August 20252023 Audi Q5 PremiumGranite Pre-OwnedVEH-0000837UsedDealer Trade
- Sale price
- $26,720
- Front
- $1,420
- Back
- $0
- Total
- $1,420
Walk-in or unattributedSalesperson: EMP-0002986 days in stock
Unit, lead source and attribution for these deals
| Deal | Unit | Lead source | Salesperson | Desk | Finance |
|---|---|---|---|---|---|
| SLE-00000123 | VEH-0000353 | Walk-in or unattributed | EMP-00018 | EMP-00013 | EMP-00017 |
| SLE-00000124 | VEH-0000425 | Radio Spot Response | EMP-00004 | EMP-00001 | EMP-00005 |
| SLE-00000125 | VEH-0000452 | Walk-in or unattributed | EMP-00022 | EMP-00023 | EMP-00017 |
| SLE-00000126 | VEH-0000468 | Walk-in or unattributed | EMP-00022 | EMP-00023 | EMP-00017 |
| SLE-00000127 | VEH-0000469 | Customer Referral | EMP-00003 | EMP-00008 | Unattributed |
| SLE-00000128 | VEH-0000765 | Organic Search Landing | EMP-00022 | EMP-00014 | EMP-00017 |
| SLE-00000129 | VEH-0000842 | Showroom Walk-in | EMP-00003 | EMP-00002 | EMP-00005 |
| SLE-00000117 | VEH-0000178 | Walk-in or unattributed | EMP-00018 | EMP-00014 | EMP-00017 |
| SLE-00000118 | VEH-0000611 | Walk-in or unattributed | EMP-00006 | EMP-00008 | EMP-00005 |
| SLE-00000119 | VEH-0000756 | Dealer Website Form | EMP-00010 | EMP-00008 | EMP-00005 |
| SLE-00000120 | VEH-0000837 | Walk-in or unattributed | EMP-00029 | EMP-00024 | Unattributed |
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.