Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

How to analyse the survey to understand how answer to one question impacts rest

Hi All,

I have a survey data with 5 Question

1.) Whom yu are living with : girlfriend, wife

2.) If the person healthy : yes, no, partially

3.) Is the person working : Yes, No

4.) Are you happy with the person : Yes, No, Cant Say

5.) If the person owns a house : yes, no

 

I want to analyse one answer impacts the rest of the answers.  For eg. how many of perople living with wife who has house and are happy. The requirement is to analyse these answers along each other.

The data collected is this format below. Please suggest what would be the best way to analyse the data in such fashion.

 

UserIdQuestionAnswer
1Whom yu are living withWife
1If the person healthyYes
1Is the person workingNo
1Are you happy with the personYes
1If the person owns a houseNo
2Whom yu are living withGirlfriend
2If the person healthyPartial
2Is the person workingYes
2Are you happy with the personYes
2If the person owns a houseNo
3Whom yu are living withWife
3If the person healthyYes
3Is the person workingyes
3Are you happy with the personNo
3If the person owns a houseYes

 

0 REPLIES 0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.