Skip to content

Step-by-Step Guide to adding ASM responses in Power BI

This guide aims to give a general introduction to adding ASM data in Power BI.

Disclaimer: ASM data can be both nuanced and complex - semi-technical knowledge is advised for working with this.

Your nps.today team is always available for guidance and assistance with ASM. Contact our support team at [email protected]

Step 1: Launch Power BI Desktop

A. Open your Power BI desktop file.

B. When you have your desktop file opened, click on Transform Data to open the Power Query Editor, as highligted below.

Step1Transformdata

For information on Power BI, you can click here: Get Started with Power BI Guide

Step 2: Navigate to the Responses Table

A. Locate the Responses table in the Queries pane on the left-hand side of the Power Query Editor.

Responses is where all ASM data is located, and needs to be unpacked.

B. Click on the responses table to display its content in the data preview pane.

Step2responses

Step 3: Select Relevant Survey Data

A. In the Responses table, identify the column containing survey answers, which is named surveyanswerssimple

step3surveyanswerssimple

Step 4: Unpack the List of Questions

A. Click the small expand icon (two arrows pointing outward) in the column header.

B. You will get a list containing every question in your Advanced Survey, identified by question name. Select the question to unpack or expand.

step4unpackquestions

Step 5: Unpack Questions

Now you you have unfolded the row of questions, you will find them expanded in a line of rows, with the header matching the question name. Now you need to unpack the Name, title and values of each question.

ASM Question Fields: Name, Title, and Value

"Name"

  • Description:
    The Name field uniquely identifies a question in the survey structure. It is primarily used internally by the survey logic or when referencing a specific question
  • Content:
  • A unique identifier for the question.
  • Typically, it is short, descriptive, and follows a naming convention (e.g., question1, email, age).
  • This value is not visible to the end-user.

"Title"

  • Description:
    The Title field defines the text displayed to the survey respondents. It is the question text showed to survey recipients.

"Value"

  • Description:
    The Value field represents the answer or response provided by the respondent to this specific question.
  • Data Type:
    The data type depends on the question type (e.g., string, number, array, boolean).
  • Content:
  • The respondent's input or selection.

A. Repeat the unpacking process for the questions or similar nested fields in the dataset.

B. Expand and select the fields to extract detailed question-level data (e.g., Name, Title, or descriptive metadata).

C. Verify that the questions are appropriately matched to their responses.

Below is a screenshot of the fields to be unpacked, with a visual of where you find these fields when working in Advanced Survey Module.

Step5unpackquestionvalue

Substep 5.2: Verify Unpacking

Check that all necessary questions and fields have been unpacked.

Step 6: Apply

Click "Close & Apply"

step6apply

Step 7: Add data fields in your dashboard

The GIF below shows how you can add the data fields and values you just extracted in your dashboard.

Step7GIFadddata