Skip to main content
Don’t miss what’s next at Microsoft Ignite
Don’t miss what’s next at Microsoft IgniteGet direct access to the people, products, and expertise behind Microsoft technology, with opportunities to ask questions, build skills, and learn alongside the community.
Register now
Microsoft
separator
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-research-59d81640-cfaf-4c1d-9316-e97d7b8a7328/image0_icon300.png

Survey Analysis by SmartVisuals

by SmartVisuals.io

Free Trial
Download SampleInstructions

Survey results like a research agency: Likert, crosstabs with sig letters, NPS - one visual.

Report survey results in Power BI like a research agency - weighted, tested, defensible. Likert batteries, crosstabs with significance letters and NPS, over one survey table, in one visual. No export to a statistics package or a survey platform, no DAX monastery: map Question, Answer and a Value, and switch views.

Three views, one data shape

  • Likert battery: diverging stacked bars with the neutral split on the axis, N/A answers detached, a collapsed disagree / neutral / agree view for executives, tracker mode; nets, means, dimensions and benchmark deltas.
  • Crosstab: banner tables with sticky headers, column %, values or an index vs Total, heat shading, transpose, search - virtualized, so a 30,000-row banner scrolls like a native table.
  • NPS: headline score as a number, badge or face with its margin of error, the 0-10 distribution, promoter / passive / detractor split and the trend over waves.

Says the finding, prints the footnote

  • Smart caption: every view writes one sentence with the finding - highest and lowest statement, strongest dimension, the biggest gap between segments, the NPS change and whether it is significant, how many cells differ - offline, in your language, and read out by screen readers.
  • Agency footnote: base, weighted and effective n, wave and source in one line, with a template of your own; a footer that explains the letters and marks.
  • Quick Styles: Agency deck, Executive summary or Compact tracker set a whole look in one click; every setting stays editable afterwards.

Free forever - and never blocked

  • All three views with unweighted counts and percentages: the diverging battery with N/A handling and bases, the crosstab with Index vs Total, search and transpose, the NPS score with its margin of error, histogram, trend and remappable cut-offs; the smart caption, the footnote, quick styles, every cosmetic option (themes, fonts, colours, bar shapes, the NPS score as a number, badge or face, a configurable legend, conditional formatting on answer colours, sorting), cross-filtering, 20 languages.
  • Format on the canvas (on-object formatting): click a bar, label or legend to style it in place.
  • No lock-out, ever. Unlicensed viewers always see the full free tier - no watermark, no broken visual.

Premium: the survey reading and the statistics (per-user license)

  • Survey reading: top and bottom box, net score, means, dimensions with pooled score bars, benchmark and wave deltas and a target line in the battery; the NPS rolling average; crosstab tracker deltas with a Trend column and CSV export.
  • Weighted results: map Sum of Weight and Sum of Weight2 and every percentage, base and test uses Kish effective bases - the convention behind agency column tests.
  • Significance letters (A/B/C): column proportion z-tests between segments in every view, 90 / 95 / 99 % confidence, optional Bonferroni correction, low bases flagged and excluded - the letters agencies put in their tab decks, inside Power BI.
  • Nets and means with tests: top / bottom box net rows and mean rows with Welch-test letters in the crosstab; the vs-total and vs-benchmark tests of each statement in the battery; a test on every tracker delta in the battery and the crosstab; cells marked above / below the rest of the sample.
  • NPS inference: a z-test on every wave-over-wave change and on every segment's movement, how big a wave a non-significant change would need, lettered segment comparison, a target line with the gap to it.

Try before you buy: every premium feature previews free in Power BI Desktop and in edit mode. Licenses are per user, purchased on AppSource and assigned in the Microsoft 365 admin center - no license keys, no vendor portal.

Built properly

  • Every statistic is computed offline inside the visual - no external services, no telemetry, nothing leaves your report. The methodology is published (formulas, conventions, degenerate cases).
  • Validated: the statistics engine is diffed against R (survey package) and scipy on full synthetic studies before every release.
  • Accessible: one keyboard tab stop with arrow navigation, Windows high contrast; number formats follow your measures' format strings, dynamic ones included.

New in 1.1.0.0: format on the canvas, conditional formatting (fx) on answer colours, a configurable legend, dynamic format strings and 20 languages, all free; a net score and a target line in Premium. For visuals added from 1.1.0.0 on, the rest of the survey reading above is Premium too; reports created before 1.1.0.0 keep it as it was.

Questions or feature requests: hello@smartvisuals.io - we read every message.

Visual capabilities

This visual is certified by Power BI

At a glance

https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-research-59d81640-cfaf-4c1d-9316-e97d7b8a7328/image1_shot1hero.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-research-59d81640-cfaf-4c1d-9316-e97d7b8a7328/image2_shot2views.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-research-59d81640-cfaf-4c1d-9316-e97d7b8a7328/image5_shot3crosstab.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-research-59d81640-cfaf-4c1d-9316-e97d7b8a7328/image4_shot4nps.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-research-59d81640-cfaf-4c1d-9316-e97d7b8a7328/image3_shot5themes.png
English (United States)
Your Privacy Choices Opt-Out Icon Your Privacy Choices
Consumer Health Privacy Sitemap Contact Us Privacy & Cookies Terms of Use About our ads Manage cookies