Combining Data from Two Different Surveys | XM Community
Skip to main content
Question

Combining Data from Two Different Surveys

  • September 22, 2023
  • 5 replies
  • 1112 views

Forum|alt.badge.img+1

Hi Community,

I am interested in learning how to combine data from five different surveys so all the data can be analyzed at once.

The survey is a class evaluation administered to about 750 students across 17 sections of the one course. The survey gathers information about student experience regarding experiential learning exercises they completed. One of the exercises is faculty preference. Faculty have selected five different exercises. Here is the breakdown for the faculty preference exercise (FPE) and the number of sections completing the exercise:

FPE1 = 3 sections

FPE2 = 3 sections

FPE3 = 5 sections

FPE4 = 5 sections

FPE5 = 1 section

I branched out the exercises by faculty last semester and the data did not correlate well in SPSS. 

The data is also not accurate when I list all the exercises in the survey and have the students select the choice because students inadvertently select the wrong exercise for their class session.

This semester I thought I would try  administering five different surveys. The first eleven questions are the same for the five surveys. The last question differs based upon the faculty preference exercise.

I look forward to receiving recommendations.

With gratitude,

Doc

5 replies

Nam Nguyen
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+29
  • QPN Level 8 ●●●●●●●●
  • September 23, 2023

@Doctalks You can use data mapping to combine your data from different sources to common reporting field that use for dashboard (those 11 common question). In the dashboard you can still break it out by filter.

More about datamapping here: https://www.qualtrics.com/support/vocalize/dashboard-settings-cx/dashboard-data/dashboard-data-overview/#OrganizingSources
Hope this helps


Forum|alt.badge.img+1
  • Author
  • September 23, 2023

Nam,

Thank you for the help and information. I will look into the data mapping process.


Forum|alt.badge.img+14
  • Level 5 ●●●●●
  • September 25, 2023

You could also export your survey data and upload into other dashboard platforms like Tableau or Power BI if you have more experience with those programs. 


Forum|alt.badge.img+1
  • Author
  • September 25, 2023

Thank you, Ash123. I appreciate the suggestion. While I am not familiar with Tableau or Power Bl, you are the second person to recommend exporting the data from the different surveys, creating a new document or survey, and importing them into a combined new document.


Nam Nguyen
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+29
  • QPN Level 8 ●●●●●●●●
  • September 26, 2023

Thank you, Ash123. I appreciate the suggestion. While I am not familiar with Tableau or Power Bl, you are the second person to recommend exporting the data from the different surveys, creating a new document or survey, and importing them into a combined new document.

Combine data from multiple sources is a feature, why do you have to do it manually?