Tutorial - CRM - Cars
DataSet Descriptive Card
DataSet ID | S0102 |
|---|---|
DataSet Name | cars |
DataSet Description | Decriptive details about the cars sold by the company |
DataSet Granularity | Car |
DataSet Source Object | crm_extract.[car] |
DataSet Relative Context |
DataSet Attributes
Functional Name | Data Type | Format | Technical Name | Example | Candidate to Sourcing | Comments |
|---|---|---|---|---|---|---|
Vin | string | id | 2HK35NBPGB8317081 | TRUE | BK | |
Manufacturer | string | brand | Porsche | TRUE | add to satellite ‘cars' | |
Model | Date | model | Carrera 911 | TRUE | add to satellite ‘cars' | |
Displ | Number | Displ | 3,2 | TRUE | add to satellite ‘cars' | |
Cylinder | string | Cyl | (6 cyl) | TRUE | add to satellite ‘cars' | |
Transmission | string | Transmission | Auto-S5 | TRUE | add to satellite ‘cars' | |
Driving wheels | string | XWD | Drive | 2WD | TRUE | add to satellite ‘cars' |
Fuel | string | Fuel | Gasoline | TRUE | add to satellite ‘cars' | |
SalesArea | string | SalesArea | CA | TRUE | add to satellite ‘cars' | |
Stnd | string | Stnd | U2 | TRUE | add to satellite ‘cars' | |
UnderhoodID | string | UnderhoodID | 7HNXV03.5NKR | TRUE | add to satellite ‘cars' | |
VehiculeClass | string | VehiculeClass | midsize car | TRUE | add to satellite ‘cars' | |
AirPollutionScore | number | AirPollutionScore | 7 | TRUE | add to satellite ‘cars' | |
CityMPG | number | CityMPG | 18 | TRUE | add to satellite ‘cars' | |
HwyMPG | number | HwyMPG | 26 | TRUE | add to satellite ‘cars' | |
CmbMPG | number | CmbMPG | 21 | TRUE | add to satellite ‘cars' | |
GreenhouseGasScore | number | GreenhouseGasScore | 6 | TRUE | add to satellite ‘cars' | |
SmartWay | bool | SmartWay | yes | TRUE | add to satellite ‘cars' | |
ReleaseDate | Date | dd/mm/yyyy | ReleaseDate | 05/09/2021 | TRUE | add to satellite ‘cars' |
UnitPrice | number | UnitPrice | 42599.0 | TRUE | add to satellite ‘cars' |