Visualising Your Data Differently With Power BI

Visualising Your Data Differently With Power BI

James Crossland

Digital Marketing Manager|Kerv digital

Published 06/07/22 under:

Have a question about something here?

Get in touch

Data Visualisations In Microsoft Power BI

 

Analytics teams using Microsoft Power BI can choose a variety of data visualisation techniques… Are some better than others though?

 

Microsoft Power BI offers users a wide variety of different data visualisation options to help look for meaning in their data.

Given the large amounts of data Power BI often deals with however, accurately, and more importantly usefully, portraying it has been a large driver for Microsoft over the last few years.

If a user can’t tell at a glance what their data’s saying then are they, in fact, any better off than looking at it in its raw form?

 

Accurate and efficient data visualisations have become core to modern analytic and business intelligence processes, with many organisations experimenting with the swathe of new options that an improved CRM data structure and Power BI have made possible.

Of course, the guiding principles behind data visualisation haven’t really changed in decades, but as technology has offered more and more visualisation options to developers and analysts the tendency has been to try and cram in as much information as possible, with the end result that data graphics have become more and more complex and inscrutable over time.

 

Microsoft Power BI cuts through that, allowing data analysts to create their own, custom, data visualisations to help display their data in reports that are a lot more intuitive to grasp.

The problem is that with the range of options available, your data can sometimes get displayed in a way that’s either not the best format or worse, actually misleading to someone reading it.

That’s why we’re discussing some of the best techniques to display different data sets, alongside their associated pros and cons as we know a lot of people really struggle with selecting the right data visualisation technique for the right task.

KPI Visualisations

 

Most people using Power BI for reporting won’t be looking for a ‘deep dive’ into their data, but rather a high-level understanding of a key metric in as succinct way as possible.

That’s what the KPI visualisation is there for.

It will let you highlight a single key datapoint and show it rising and falling over time.

Line Charts

 

Starting with the easiest then, line charts are one of the most instantly recognisable ways to display data, allowing users to identify trends with just a glance.

They can display data measured over two axes, with different categories of data being displayed by differently coloured lines.

Line charts are most effective when used to display data over time, for example, rising and falling profits, plotted monthly over the course of a year. In fact, Microsoft Power BI will actually allow you to create time series charts from your data, allowing you to drill down by flipping one axis between yearly, monthly, weekly or even daily instances.

They simplify data into an easily understood graph that can be understood at a glance… however that simplification can sometimes be their weakness as complicated, underlying trends can sometimes get missed.

Pie Charts

Need to show something as a percentage breakdown? The humble pie chart is your friend!

Pie charts look great and are helpful in displaying ‘top line’ information but… many data visualisation experts agree that people can struggle to take away detailed information from them, often struggling to process close differences in the different sizes of the ‘slices’.

For high level information at a glance, they’re excellent but if you need more detail, particularly with large data sets, you might want to consider a different data visualisation technique.

Bar Charts

 

Perhaps even more so than line charts, bar charts are one of the easiest ways to display simple data sets. Sans all the different colours, curves, gradients, angles or shapes of other display methods, a simple bar chart is unparalleled for showing off relative sizes of categorical data at a glance (e.g. sales by district).

The bonus to a bar chart is that they can be understood by virtually anyone without any specialist understanding of your data or the need for a key at the side of the graph explaining what everything means. On top of that, Power BI allows you to implement variations on the bar chart for stacked and grouped options, allowing you to visualise the makeup of subcategories whilst still maintain the detail of the overall categories.

Scatter Plots

 

Scatter plots, also known as scatterplots, scatter graphs or scattergrams, are used to display the general density of data in a two-dimensional format or the relationship between two values (i.e., outdoor temperatures and ice cream sales).

That means they’re great for displaying relative densities of data as well as overall trends (that you might not have been aware of before) and outliers in an easy-to-read manner.

For instance, along one axis you could plot a sample groups IQ, along the other you could measure the time taken to solve a complex problem. The general density of ‘scatter plots’ would then let you infer trends based on that information.

Bubble Charts

 

Bubble charts are used when someone needs to accurately display three different dimensions of data by plotting them along an X/Y axis with varying sizes of bubbles, for instance, using the example above, outdoor temperature vs ice cream sales vs ice cream truck size.

A bubble chart can, with a minimal of explaining, provide quite complex information in a condensed and visual manner.

Some ‘advanced tips’ for bubble charts include labelling the separate bubbles for clarity and adjusting the layout/sizes so bubbles aren’t overlapping each other.

Network Diagrams

 

Although not native to Power BI, network diagrams are often used in conjunction with other data visualisation techniques to show how the different data sets being represented elsewhere are connected to each other in reality.

They’re particularly good at letting users grasp the inter-connectivity of data that might have been difficult to imagine without visualisation.

Most data visualisation experts agree however that if not put together carefully, most network diagrams quickly become indecipherable. The trick is to show a high level of detail and then, if needed, let the user drill down on successive network diagrams for greater, expanded information.

Sankey Diagram

 

Sankey diagrams can be used to plot out process flows via lines and arrows that can vary in width to show relative sizes of the data in individual flows.

Depending on the amount of data present, some Sankey diagrams can, initially, be quite overwhelming at a casual glance but there really aren’t any better data visualisation techniques for the representation of process flows, however, Power BI offers some extra functionality with Sankeys that make them a lot more interactive than normal, allowing users to explore truly complex process flows.

When using one it’s often worth including an annotation to explain to anyone viewing it how the diagram is set up and what it’s demonstrating.

Treemaps

Treemaps are used to display data in a hierarchical fashion in which nested blocks are used to represent different data sets.

Those nested blocks are particularly good at identifying trends but if they’re not sixed correctly or ordered in a non-intuitive way then they can be difficult to read.

Circle Packing Charts

 

Finally, the circle packing chart is a variation on the treemap, using, as the name suggests, circles rather than blocks to represent the relationships in your data.

By plotting different sized circles and placing them within other circles, you can easily display data ‘three levels deep’.

t-SNE

 

Getting a little (a lot) more technical now, t-SNE or, to give it it’s full name, t-Distributed Neighbour Embedding, actually uses machine learning to model dimensional data sets as two or three dimensional data points for display in a scatter plot, using colours, shapes or other visual elements to represent the third dimension.

Data visualisation analysts developed it to combat some limitations of the more traditional scatter plot.

 

Stacked Area Chart

 

Much like a line chart, stacked area charts show the breakdown of a trend into subcategories.

A line chart tells you if something’s going up or down but an area chart can tell you what’s responsible for that trend (is it one district having a great month, or are all districts growing equally?).

Maps & Filled Maps

 

If you’ve geographic data, Power BI has a range of ways to plot this out.

Without any technical set up you can throw some geographical data at Power BI and it’ll recognise the columns corresponding to areas (could be latitude/longitude, could be postcodes, could be zip codes… not to worry, Power BI will work it out) and plot it on a great looking, interactive map, which also handles grouping things up automatically.

Custom Visualisations

Finally, there’s a vast library of pre-built custom visualisations available online, covering a myriad of uses but if you’re still not satisfied Power BI will let you can build your own, allowing you to display your own data in any way you find easiest!

 

As we finish up it’s also worth mentioning the interactivity available in Microsoft Power BI.

All Power BI visualisations allow you to drill down into your data at the touch of a button.

For instance, say your dashboard has a map of sales by county, and a line chart of total sales. You might notice on the map that Yorkshire is way below the rest, so you click through, and hey presto, your line chart will automatically show the sales in just that area.

Related Articles

You might also be interested in

From our world to yours

Compliance monitoring under the spotlight

From our world to yours

The rise of business messaging apps and the need to stay on...

From our world to yours

Compliance: important ownership changes while adapting for flexible remote workforces

From our world to yours

Data silos and legacy compliance monitoring systems – barriers to effective surveillance...

From our world to yours

What it takes to top the Gartner CCaaS Magic Quadrant

From our world to yours

Why gamification is topping the bill for contact centre agent workforce management...

From our world to yours

8 contact centre trends to future proof your business

From our world to yours

Spotlight on Local Government – Where is CX heading for citizens?

From our world to yours

Think bigger with Microsoft Teams.

From our world to yours

Microsoft Teams is here to stay, what’s the next step?

From our world to yours

At Kerv we want to make customer-first really mean something…

From our world to yours

Different by design

From our world to yours

How Engagement Technology is Transforming the Membership Sector

From our world to yours

A modern CRM system needs a modern data platform

From our world to yours

What is… Microsoft Cloud for NonProfit?

From our world to yours

6 Back-office technologies modern supply chains should already be using

From our world to yours

Re-imagining CX in a golden age of integrations – combining Genesys and...

From our world to yours

Maximising CX value through AI-driven digital engagement

From our world to yours

Experience as a Service: What it is, why it’s important and where...

From our world to yours

Achieving empathy across digital channels

From our world to yours

Redesigning CX from the ground up

From our world to yours

Genesys EMEA Cloud Partner of the Year 2020

From our world to yours

Life at Kerv Digital As A Functional Consultant

From our world to yours

Life @ Kerv Digital as an Apprentice Power Platform Consultant

From our world to yours

How To Increase Efficiency With Dynamics 365 Supply Chain Management

From our world to yours

Supply Chain Control Towers – The Tech That’s Changing Logistics Forever

From our world to yours

Supply Chain Digital Twins – The What, The Who & The Why...

From our world to yours

On-Demand Logistics & The Tech That Makes It Possible

From our world to yours

What Is… Insurtech?

From our world to yours

What Is… Microsoft Cloud For NonProfit?

From our world to yours

16 Times You’ve Been Using Artificial Intelligence Without Realising

From our world to yours

Jack’s Worried – His Website Is Losing Him Dues Paying Members

From our world to yours

From Paper Based To Cutting Edge… With Zero Downtime

From our world to yours

Life at Kerv Digital as a UX Designer

From our world to yours

Sarah is Sad – Her Staff Aren’t Finding New Members Or Engaging...

From our world to yours

How To Squeeze Hidden Value From The Hidden Data You Didn’t Know...

From our world to yours

Reducing Member Churn & Delivering Member Insights With Data Science

From our world to yours

Life @ Kerv Digital As A Dynamics Functional Consultant

From our world to yours

The Effect Fintech Is Having On Our Everyday Lives

From our world to yours

Dealing With Ethical Walls In Tech… Ethically

From our world to yours

Life @ Kerv Digital As A DevSecOps Engineer

From our world to yours

IOT: Dragging The Future Of Healthcare Into Today

From our world to yours

How Will Tech Revolutionise Health Care Over The Next Half Century?

From our world to yours

Empowering Public Transport With Big Data

From our world to yours

Putting Patients First Vs. Cost Concerns

From our world to yours

Life @ Kerv Digital As A Power Platform Solution Architect

From our world to yours

What’s The Best CRM For The Membership Sector?

From our world to yours

How Remote Patient Monitoring Data Can Drive Health Efficiencies

From our world to yours

Is A Career In NonProfit Digital Transformation Rewarding?

From our world to yours

Six Back-Office Functions NonProfits Should Be Using Robotic Process Automation For

From our world to yours

How Data Storage Management Will Change In 2022

From our world to yours

Business Central Vs Sage – Which Does Your Organisation Need?

From our world to yours

How To Debug Something With A Rubber Duck

From our world to yours

Using Design Thinking To Empower Digital Transformations

From our world to yours

How Business Central Can Keep You GDPR Compliant

From our world to yours

What Can Business Central Actually Do?

From our world to yours

Why Data Classification Is Vital To Your Organisation (And How To Easily...

From our world to yours

How To Inspect Items When Using The Execute Pipeline Activity In ADF/Synapse...

From our world to yours

How To Create UI Flow’s In Power Automate

From our world to yours

D365 BC Vs D365 FO: Let’s Settle This Once And For All!

From our world to yours

How To Drive Donor Engagement With Kerv Digital’s Free Powerups

From our world to yours

9 Awesome Benefits To The Microsoft Dataverse

From our world to yours

Canvas Apps Vs Model-Driven Apps

From our world to yours

How To Set Up Field Monitoring In Business Central

From our world to yours

Check Out The Benefits Of The Microsoft Catalyst IDEA Framework…

From our world to yours

Component Led Development, Or… How To Make Your Organisation Instantly More Resilient

From our world to yours

How To Achieve A Single Customer View In 5 Easy Steps

From our world to yours

Best Practice For Creating Cloud Flows With Microsoft Power Automate

From our world to yours

Legacy Estate Reduction… Or When To Get Rid Of Old Tech

From our world to yours

What Is Fintech?

From our world to yours

How To Get Better At: Online Continuous Personal Development (CPD)

From our world to yours

Virtual Exam Proctoring (Or How To Stop People Googling The Answers At...

From our world to yours

How Hyperautomation’s Benefiting PAO’s (Professional Accountancy Organisations)

From our world to yours

Cyber Security For Remote Working… How Everyone Can (And Has To) Pitch...

From our world to yours

What Is An Advanced Persistent Threat (APT’S) Attack?

From our world to yours

Database Marketing – What Is It & How Can You Benefit From...

From our world to yours

Microsoft Dynamics Cloud Licensing Options – What’s Available?

From our world to yours

Privacy By Design – What You Need To Know

From our world to yours

How To Connect To A Named Sandbox Environment

From our world to yours

What Are The Different Types Of Cloud Licensing Agreements?

From our world to yours

How To Export To Text Files From Microsoft’s Business Central SAAS

From our world to yours

Technical Debt – The What, Why, When & How Do I Get...

From our world to yours

Ensuring Business Continuity With The Microsoft Stack

From our world to yours

What’s The Best CRM For The NonProfit Sector?

From our world to yours

Rage Donations – How To Engage Past The ‘Now’

From our world to yours

What Is It & How To Avoid: Vendor Lock-In

From our world to yours

The Bad Guys Don’t Care You’re The Good Guys

From our world to yours

Build The Future Of The NonProfit Sector… Today

From our world to yours

Data Protection & Artificial Intelligence: Best Practice

From our world to yours

Shadow IT – 9 Things To Look Out For & 1 Unexpected...

From our world to yours

Organisational Debt & Why It Makes Digital Transformation Hard

From our world to yours

Discussing All Things RPA… Robotic Process Automation

From our world to yours

Creating A Low Code App Using PowerApps & The Power Platform

From our world to yours

Now’s The Time To Get Excited About Cognitive Search

From our world to yours

If You Don’t Have An Automated Deployment Process… You’re Already Obsolete

From our world to yours

Tips & Tricks To Creating Successful Volunteer Management Systems

From our world to yours

The Five Types Of Cyber Criminals

From our world to yours

Security-By-Design: Or… Better Safe Than Sorry!

From our world to yours

Leading With Technology In The Membership Sector

From our world to yours

What Does IAAS, PAAS & SAAS Stand For?

From our world to yours

What Is Business Architecture?

From our world to yours

What Is Data Gravity? (And How Your Organisation Can Benefit From It)

From our world to yours

How To Fix DateTime Stamps In Microsoft Dynamics 365

From our world to yours

6 Easy Steps For Promoting A Culture Of Cyber Security

From our world to yours

15 Cyber Security ‘Things’ To Safeguard Your Business

From our world to yours

Microsoft Dynamics 365: Settings In solutions

From our world to yours

13 Ways To Save Money When Using Microsoft Azure

From our world to yours

The Problems With Addresses In Microsoft Dynamics 365

From our world to yours

Understanding The Benefits Of Predictive Science In The NonProfit Sector

From our world to yours

Top 6 Digital Impacts On Membership Organisations

From our world to yours

The 7 Stages Of A Successful AI Project

From our world to yours

What’s The Difference Between UI And UX?

From our world to yours

8 Ways Your Business Can Increase Turnover With Big Data

From our world to yours

Dynamics 365 In NonProfits

From our world to yours

Kerv acquires TDS Global Communications Compliance Practice

From our world to yours

What is Microsoft’s Power Automate?

From our world to yours

What is InvestTech?

From our world to yours

Derek Is Stressed – His Purchasing Team Aren’t Coping With Long Winded...

From our world to yours

Life @ Kerv Digital As A Jnr DevSecOps Engineer…

From our world to yours

Life @ Kerv Digital As A Principal Architect

From our world to yours

Life @ Kerv Digital As An Azure DevSecOps Engineer…

From our world to yours

Life @ Kerv Digital As Head Of Client Services, Public Sector

From our world to yours

Life @ Kerv Digital As A Junior DevSecOps Engineer

From our world to yours

Life @ Kerv Digital As A Graphic Designer

From our world to yours

Microsoft Inspire 2022 – Here’s All The Big Announcements!

From our world to yours

The Need for WhatsApp Compliance Recording

From our world to yours

Life @ Kerv Digital As A UX Researcher

From our world to yours

Life @Kerv Digital As A Senior Delivery Manager

From our world to yours

Life @ Kerv Digital As A Senior Delivery Manager

From our world to yours

Data Silos and Legacy Compliance Monitoring Systems – Barriers to Effective Surveillance...

Have a question?

Leave your details and a member of the team will be in touch to help.
Type your first name here
Type your last name here
Type your phone number here
Type the company you represent here
By pressing send, you agree to our Terms and Conditions and Privacy Policy.
This field is for validation purposes and should be left unchanged.