Likert Scale Survey: Power BI Dashboard Example

Companies administer surveys to obtain feedback on important topics. One of the most common survey styles is a Likert scale survey, which uses a five-point scale to gauge how strongly an individual agrees or disagrees with a question/statement. Based on the questions asked in the survey, the end-user can gain meaningful insights into what is going well and what needs improvement within the organization. That is the purpose of this Power BI dashboard example – it displays the results of a Likert scale survey at a high level with the ability to drill down to a more granular view.

Who is the Ideal User of This Dashboard?

This Likert scale survey dashboard example is designed for leadership to gather insights into the feelings and morale within the organization based on Likert scale survey results.

What Can You Accomplish with This Dashboard?

Survey Results Overview

This page displays the survey results broken down by question category. The end-user can filter the data based on the participants’ country, department, job level, and gender.

Average Score by Question Category

This provides the average answer (on a scale of 1 to 5 with 1 = strongly disagree and 5 = strongly agree) of employees for each question category. The average for each question category will be colored based on where it falls on the 1 to 5 scale. 

The closer the average is to 1, the darker the red it’ll be (signaling a potential problem and, thereby, an opportunity for improvement). The closer the average is to 5, the darker the blue it’ll be (signaling that the organization is doing exceptionally well in that category).

Percentage of Participants by Question Category and Answer

This provides a breakdown of how the survey participants answered questions from each question category. Hovering over each color displays the number of participants (in addition to the percentage shown in the visual).

 The end-user can select the information button next to the title of this visual to jump to the Survey Results Details page to see the underlying data.

Survey Results Analysis

This page provides a more granular view of the survey results broken down by country, gender, department, and job level. This enables the end-user to see if there are any substantial differences or similarities across these four groups. 

The slicers at the top of the page can be used to show a specific question category and/or question. The end-user can select the information button next to the title of this visual to jump to the Survey Results Details page to see the underlying data.

Survey Results Details

This page provides the lowest level of granularity in the data. This enables the end-user to see the range of responses to each question from strongly disagree to strongly agree. Like the Survey Results Overview page, the data on this page can be filtered by country, department, job level, and gender of the participants.

Conclusion

We hope you have found this Power BI Likert Scale dashboard example useful in gaining insights from Likert scale survey results.

If you have any questions, need help, or are interested in having a team of Power BI experts design dashboards for you, feel free to reach out!

Data Coach is our premium analytics training program with one-on-one coaching from renowned experts.

Accelerate and automate your data projects with the phData Toolkit