As part of our contract with PG, we receive weekly XML files with survey results. We have used that to create a data source that we publish to the Tableau Server. We have an Inpatient dashboard for 11 of our hospitals, and an ED dashboard for 15 of our EDs. Then we have service line analysts who have created additional views. The data comes in with one row per question/per survey.
Let me know if you have any other questions.
Thank you for your response. That was the direction I thought was best however when contacting Press Ganey they informed me that the XML data would be an additional cost. It made me wonder if my request was unusual.
I was also told its an additional fee.