Visualisation Best Practices (Part 1)

 

Power BI Visualisation Best Practices

It is said that your data is only as good as your ability to communicate it, which is why choosing the right visualisation and presenting it well is so imperative.

Today we'll look at several common visualisations available in Power BI and their recommended design practices.

* All samples on this blog are created using standard visualisation elements in Power BI Desktop (May 2016 release) *

Visualisations in A Nut Shell

Before creating any visualisation, it is useful to understand the types of data that are visualised and their relationships to each other. Here are some of the most commonly used ones from Power BI :

* Courtesy of Data Visualization 101 published by Hubspot

Capture.jpg

Capture2.jpg

Bar & Column Charts

Bar charts are very versatile. They are best used to show change over time, compare different categories, or compare parts of a whole

 

Do's & Don'ts

Capture3.jpg

Capture4.jpg

 

Pie & Donut Charts

Pie chart is arguably one of the most popular (and controversial) charts of all time. They are recommended for making part-to-whole comparisons with discrete data.  The visualistion works most effectively when there are only a few discrete values.

 

Do's & Don'ts

 

Capture5.jpg

Capture6.jpg

 

To Be Continued (Part 2)

In the next session I will talk about design practices for the following visualisations:

  • Line Chart
  • Area Chart
  • Scattered Plot

In Part 3, I will also go over the following visualisations:

  • Bubble chart and visualisation using map
  • General advice for a better visualisation design

Stay tuned !


Get in touch with us to find out more!

Topics: Blog, Best Practice, Power BI, visualisation

Jixin Jia

Jixin 'Gin' Jia (MBA, MCSE, MCP, ASA) is a certified Azure Solutions Architect. He is a MCSE in Business Intelligence and Data Management & Analytics. With a Mathematics, MBA and IT background, Jixin combines advanced analytics and modern BI technologies in building data-driven intelligence. He is a regular speaker about machine learning, quantitative analysis and Microsoft BI in many public forums. He is now an active Data Science program candidate at Harvard University.