Survey Analysis by SmartVisuals
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.