Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Data Modelling Best Practice for Survey

Hi,   I have a large dataset of over 1500 entries with 150 columns. It consists of personal particular questionaires, and dozen other questions composed of radio button (single input), checkboxes (...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Based on the need one of the ideas is to unpivot the columns (radio to Zbox) but they are 150 numbers. If you have a lot of rows. the number of rows will multiply.

Depending on how you need the answers in the final visual each column may to processed.

 

A better sample with some of the output you want can help.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I couldn't post as I'm getting an invalid HTML error.

    <p>As I'm new to data and power BI, I'm dont know some of the keywords to search for the solution effectively.<br />Sample of the radiobutton and textbox questionaires:</p>
    <p><span style="font-family: inherit;"><li-image width="999" height="289" alt="radio.PNG" align="inline" id="446305i93FC1F7B54C7FA93" size="large" sourceType="new"></li-image><br />Sample of the checkbox questionaires:</span></p>
    <p><li-image width="999" height="176" alt="checkbox.PNG" align="center" id="446304i355E941214BAEB87" size="large" sourceType="new"></li-image><br /><br /></p>

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

       

       

      The checkboxes (top) and radiobutton/textbox questionaires are shown as above.