Matt Scholar Solutions

Skills · Data analysis

Data visualisation for research with Tableau and Power BI

A good chart makes your finding obvious at a glance; a poor one hides it or misleads. Learn to choose the right chart for each finding, build clear dashboards in Tableau or Power BI, and present your results honestly in your dissertation.

Introduction

A good chart makes your finding obvious at a glance; a poor one hides it or misleads. Learn to choose the right chart for each finding, build clear dashboards in Tableau or Power BI, and present your results honestly in your dissertation.

When you need this skill

  • Your dissertation is a data analytics or business intelligence project.
  • You need clear figures for your results chapter.
  • Your supervisor has said your charts are cluttered or hard to read.
  • You're building a dashboard as part of your project.

Common student questions

Which chart should I use?

Choose by what you want the reader to see. The table below covers most dissertation findings. Whatever you choose, give each chart one clear message, and state that message in its title or caption.

Scroll horizontally to read the chart recommendations.

Chart recommendations by the finding you want to show
What you want to showChart to use
Compare values across categoriesBar chart
Change over timeLine chart
The distribution of one variableHistogram or box plot
A relationship between two variablesScatterplot
Parts of a wholeStacked bar chart; a pie chart only with two or three parts
Differences between placesMap

Should I use Tableau or Power BI?

Both build interactive dashboards. Power BI Desktop is free to download but runs only on Windows. Tableau's free option for learners, Tableau Desktop: Public Edition, publishes only to Tableau Public, where work is publicly visible, so never use it with confidential or participant data. Use the tool your programme expects, or the one employers in your target field use.

Can I include an interactive dashboard in my dissertation?

Most dissertations are submitted as Word or PDF files, so include static, high-resolution images of the key views, each with a figure number, caption and explanation in the text. Add a link to the interactive version only if your programme allows it and the data isn't confidential. Describe how the dashboard was built in your methodology.

What makes a chart clear and honest?

Start bar chart axes at zero, label axes with units, and avoid 3D effects and decoration that distort or distract. Label lines and bars directly instead of relying on a legend where you can. Use consistent colours for the same categories across charts, and choose colour-blind-friendly palettes. Show the data that answers your question, not every variable you have.

What you'll learn

  • Choose the right chart for each finding
  • Prepare and shape data for visualisation
  • Build charts and dashboards in Tableau and Power BI
  • Create calculated fields and basic measures
  • Design dashboards around the reader's question
  • Apply principles of clear, honest and accessible charts
  • Export high-resolution figures and write figure captions
  • Explain your visual design choices in your dissertation

Tools required

Data visualisation tools and their uses
ToolUsed for
Power BI DesktopData preparation with Power Query, measures and dashboards (Windows)
TableauInteractive charts and dashboards
ExcelQuick charts and preparing data

Charts in Python and R are covered on the quantitative analysis and machine learning skill pages.

How sessions work

Live online sessions, scheduled around your time zone. We build a sample dashboard together from a public dataset, then you design figures and dashboards for your own data between sessions. Recordings are available to revisit. This skill links to the Statistics for Dissertations.

Worked example

Sample project: Which product categories and regions drive sales growth for a retailer, using a public sales dataset?

  1. 1. Question first

    List the three questions the dashboard must answer.

  2. 2. Prepare

    Clean and shape the data in Power Query, and check dates, categories and missing values.

  3. 3. Measures

    Create total sales, growth compared with the previous year and average order value.

  4. 4. Build

    A line chart of sales over time, a bar chart by category, a map by region and filters for year and category.

  5. 5. Review

    Check every chart against the clarity principles, and simplify anything that doesn't answer one of the three questions.

  6. 6. Write up

    Export each key view as a high-resolution figure with a caption stating its finding.

Practical guidance

FAQs

Do I need to learn DAX for Power BI?
Basic measures cover most dissertation needs. We teach the measures your project requires, not the whole language.
I use a Mac. Can I use Power BI?
Power BI Desktop runs only on Windows, so on a Mac you'd need a Windows environment. Tableau runs on both, but remember its free edition publishes publicly.
How many figures should my dissertation include?
As many as your findings need and no more. Every figure should be referred to and explained in the text.
Can I use AI tools to generate charts?
Check your university's rules, and never upload confidential or participant data to an online tool without permission.
Free 20-minute consultation · No obligation

Learn to present your findings clearly with a mentor

We will understand your course, stage, and specific roadblocks, and recommend a structured skills programme—or tell you honestly if we are not the right fit.

Discuss topic & timeline
Honest feasibility check
Pricing discussed transparently

Pricing is discussed in your free consultation.

Written by the Matt Scholar research team · Last reviewed 15 November 2026

References

  • Tufte, E.R. (2001) The Visual Display of Quantitative Information. 2nd edn. Cheshire, CT: Graphics Press.