Forum Discussion
Solved
Need help on modelling and Visualization
Hi Below is the Source file format Dealer Performance Concern Process New Vehicle Sales Target Dealer Peer Comparator New Vehicle Sales OVERALL NEW VEHICLE SALES QUALIFIER ...
Hi Singh_Yoshi ,
If you need help uploading data you can use the below link for the process.
Other process to share the file: please save the sample and expected data in an Excel file, upload it to SharePoint, and share the link with me.
Thank you!!
Below is the requirement using the source file I already posted,
| Dealer Performance Concern Process | |||||||||
| Please refer to DCB 091.23 - REISSUE dated 10th Feb 2025 for more information. | |||||||||
| Dealer Code | #REF! | ||||||||
| Dealer Name | #N/A | ||||||||
| Location | #N/A | ||||||||
| PMA | #N/A | ||||||||
| Presidents Awards Group | #N/A | ||||||||
| New Vehicle Sales | Sales One Cx Performance | ||||||||
| Sales Target | Level 1 National Sales Experience Index Target | ||||||||
| Actual | Target | % of Target | Survey Returns | Dealer NPS | Target Sales NPS | % of Target | |||
| #REF! | #N/A | #N/A | #N/A | #REF! | #N/A | #N/A | #N/A | #N/A | |
| #REF! | #N/A | #N/A | #N/A | #REF! | #N/A | #N/A | #N/A | #N/A | |
| Qualifier 2 previous quarters | #N/A | Qualifier 2 previous quarters | #N/A | ||||||
| Actual | Target | % of Target | National Average | ||||||
| 12MR | #N/A | #N/A | #N/A | Survey Returns | Dealer NPS | Target Sales NPS | % of Target | ||
| Qualifier 12MR | #N/A | 12MR | #N/A | #N/A | #N/A | #N/A | |||
| Qualifier 12MR | #N/A | ||||||||
| Peer Comparator | |||||||||
| Actual | Target | % of Target | PEER COMPARATOR | ||||||
| #REF! | - | #N/A | #N/A | Survey Returns | Dealer NPS | PEER AVG | % of Target | ||
| #REF! | - | #N/A | #N/A | 12MR | #N/A | #N/A | #N/A | #N/A | |
| Qualifier 2 previous quarters | #N/A | Qualifier 12MR | #N/A | ||||||
| Actual | Target | % of Target | |||||||
| 12MR | - | #N/A | #N/A | ||||||
| Qualifier 12MR | #N/A | ||||||||
| Overall New Vehicle Sales Qualifier | #N/A | OVERALL SALES CVP QUALIFIER | #N/A | ||||||