How to establish relationship between Stack Overflow developer survey results and schema datasets?

Power BI Data Model
1

I want to practice and build Power BI data analysis reports on Stack Overflow developer survey. Basically, there are two CSV files named Survey Results and Schema. How can I establish relationship between these two files? Or am I thinking wrong?

Download Dataset

2

Hi @AnilKumarPoda ,

It need to be little bit transformed to get Responce ID, Questions and Answers side by side in the table.

Basic concept you can find in pbix:

Survey.pbix (9.7 MB)

Hope it helps.

3

Thanks for the response.

1 Like