Quickly Reshape Survey Data with Informatica REV

Do you ever use surveys to gather information from a large group of people to then distill into sentiment and motivation through analysis? Whether it is businesses trying to better help serve their customers, colleges and universities learning more about their students, or even organizations polling to find out how they can improve employee satisfaction, surveys are a critical tool for helping capture the differing opinions of the masses. Yet, a lot of the time the most important REVelations in survey data remain hidden due to the inherent difficulties in shaping the raw response data and then performing meaningful analysis. The data needs to be prepped before even getting to visualize the results, and this process can take up to several hours. Manually reshaping thousands of rows of survey submissions can prove a big challenge and one that most data workers loathe to take on. So, what is a data worker to do?

Informatica’s REV takes the complexity out of many of the manual tasks you might do in Excel to get your survey data prepped for analysis and visualization. REV makes it especially easy to re-shape your data so that you can reclaim your day. The hours that people spend manually shuffling, transposing, combining, and prepping their survey data in order for analysis can now be reduced to minutes by using REV.

Are you curious to find out how? Keep reading … or better yet, try it out for yourself!

Show & Tell

More than likely your survey will have Likert Scale questions where the data you receive will have each question as a separate column heading. Many analysis and visualization tools prefer to work with “normalized” data where there is a separate row for each question in the survey and the answer data is repeated for each survey respondent. Trying to un-pivot all this data in Excel can take a long time, especially if you have no idea how to do it. Using REV, all you need to do is perform a few simple clicks. In your survey data project, just click on the ‘Summarize’ icon and select ‘Unpivot’.


REV’s Intelligent Data Profiling shows you what columns will and will not be un-pivoted. Click on ‘Change’ in the Unpivot Columns box to de-select which columns of data you do not want to un-pivot.


Click on the ‘X’ for the Respondent ID field to remove that column from being un-pivoted. Then, click on ‘Done’ and then ‘Unpivot’ to make your changes final and “normalize” your survey data.


Quick, easy, and simple. And all in a few seconds!

Try It Out

Do you want to try it out for yourself? Sign up for REV and set up your account. Once logged in, you will see our guided stories at the top starting with Erica.


Click on the down arrow until you see the guided story Get my data ready to analyze.


Click on ‘Try It’ to see how easy and quick it is to re-shape and prep survey data using REV.

Working with data shouldn’t be a hard thing, and it definitely should not take you hours upon hours to get your data fit and ready for analysis and visualization. Get back the hours you’re losing to Excel. Sign up for REV and go from data drudgery to analytic awesomeness!