Forum Discussion
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 | Sales Experience Index Level 1 National Average Target | Sales Experience Index 12MR | OVERALL SALES Experience QUALIFIER | SERVICE Experience Index Level 1 National Average Target | SERVICE Experience Index 12MR | OVERALL SERVICE Experience QUALIFIER | Parts Sales Target | Dealer Peer Comparator Parts Sales | OVERALL PARTS SALES QUALIFIER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Q1 2025 | Q4 2024 | Q1 2025 | Qualifier 2 previous quarters | 12MR | Qualifier 12MR | Q4 2024 | Q1 2025 | Qualifier 2 previous quarters | 12MR | Qualifier 12MR | Q4 2024 | Q1 2025 | Qualifier 2 previous quarters | National 12MR Avg | Qualifier 12MR National Avg | PEER GROUP 12 MR AVG | Qualifier 12MR Regional Avg | Q4 2024 | Q1 2025 | Qualifier 2 previous quarters | National 12MR Avg | Qualifier 12MR National Avg | PEER GROUP 12 MR AVG | Qualifier 12MR Regional Avg | Q4 2024 | Q1 2025 | Qualifier 2 previous quarters | 12MR | Qualifier 12MR | Q4 2024 | Q1 2025 | Qualifier 2 previous quarters | 12MR | Qualifier 12MR | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | Dealer | Location | Presidents Award Groups | ZM | PMA | Actual | Target | % of Target | Actual | Target | % of Target | Actual | Target | % of Target | Peer Comparator Target | % of Peer Comparator | Peer Comparator Target | % of Peer Comparator | Peer Comparator Target | % of Peer Comparator | Survey Returns | Dealer NPS | Target Sales NPS | % | Survey Returns | Dealer NPS | Target Sales NPS | % | Survey Returns | Dealer NPS | National Avg | % of National Avg | PEER AVG | % of Regional Avg | Survey Returns | Dealer NPS | Target SERVICE NPS | % | Survey Returns | Dealer NPS | Target SERVICE NPS | % | Survey Returns | Dealer NPS | National Avg | % of National Avg | PEER AVG | % of Regional Avg | Actual | Target | % of Target | Actual | Target | % of Target | Actual | Target | % of Target | Peer Comparator Target | % of Peer Comparator | Peer Comparator Target | % of Peer Comparator | Peer Comparator Target | % of Peer Comparator | |||||||||||||||||||||
| 12345 | QWERT | Hamilton | GROUP 1 | pending - recruiting | ABCDE | 330 | 354 | 94% | 288 | 209 | 138% | No | 1,279 | 1,313 | 98% | No | 96.08% | 98% | 196.13% | 71% | No | 110.73% | 89% | No | No | 23 | 91.30 | 77.30 | 119% | 12 | 75.00 | 77.30 | 98% | No | 82 | 84.15 | 78.16 | 107.7% | No | 77.93 | 108% | No | No | 60 | 43.33 | 54.50 | 80% | 120 | 53.33 | 54.50 | 98% | Yes | 347 | 52.16 | 78.16 | 66.7% | Yes | 47.31 | 111% | No | No | 17,99,671 | 19,84,508 | 91% | 20,06,745 | 10,32,617 | 195% | No | 73,02,629 | 65,74,004 | 112% | No | 1 | ######## | 2 | ######## | No | 1 | ######## | No | No | |||
| 56789 | YUIOP | Auckland | GROUP 1 | Natalie | FGHIJ | 333 | 360 | 93% | 343 | 184 | 187% | No | 1,281 | 1,160 | 111% | No | 96.08% | 97% | 196.13% | 96% | No | 110.73% | 101% | No | No | 20 | 75.00 | 77.30 | 98% | 15 | 86.67 | 77.30 | 113% | No | 98 | 78.57 | 78.16 | 100.5% | No | 77.93 | 101% | No | No | 69 | 52.17 | 54.50 | 96% | 83 | 40.96 | 54.50 | 76% | Yes | 261 | 45.59 | 78.16 | 58.3% | Yes | 47.31 | 97% | Yes | Yes | 19,56,651 | 18,92,909 | 104% | 21,73,661 | 12,83,834 | 170% | No | 79,32,121 | 71,52,661 | 111% | No | 1 | ######## | 2 | ######## | No | 1 | ######## | No | No |
@ibendlin rajendraongole1 @Dinesh_Y
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!!
8 Replies
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 Hi Singh_Yoshi ,
Thank you for reaching out to Microsoft Fabric Community.
Could you please provide more details about your question so we can assist you more effectively?
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks & Regards,
Rekha,
CustomerSupportTeam.
I have a source file that contains data of dealers and its actuals and targets for Q4 and Q1. I want to bring that data into dashboard. I have also a format of how the dashboard look like. But I'm not able to attached excel file as I dont see that option in my interface fabric community. So I used table option to paste my data(both source file as well as dashboard format)
If you refer my previous texts you will have a data and if you can copy and paste it in excel, you may get some idea.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!!
Hi Singh_Yoshi ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
If the issue remains unresolved, kindly share sample data and clearly outline the expected results.
Thank you!!
Hi Singh_Yoshi ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
