Well done to the data team at The Economist, having to visualise a 12-year journey of a space probe as it makes a flying visit to eight different asteroids. They’ve made a very complicated journey look quite straightforward and elegant. A probe intended to study the Trojan asteroids takes off – The EconomistLucy, as this […]Continue reading “Lucy in the sky with asteroids — Miscellaneous Details”
Tag Archives: Data Visualisation
Patient Pathway Analysis Tool – Update
Update on my Patient Pathway Analysis work for NHS England RightCare.
Quick Steps to Make Effective Data Visualisations
This is an example of the default settings for a bar chart in Excel. This is functional but could be far more effective; here are my main steps I use to create quick, effective data visualisations.
Analytics and Ethics
Upon the enlightening release of the Cambridge Analytica exposé that revealed the company’s underhanded tactics it utilises to influence and manipulate people with a combination of data analytics, espionage, and ‘honeypotting’, I think it’s incredibly important to discuss how the analytical community needs to ensure a commitment to honest and unbiased analytics, and ethically sourcedContinue reading “Analytics and Ethics”
HOW TO… Excel: Create a Dynamic Data Range for a Chart
Continuing the theme of automatically updating charts, we’re going to look at how to make a chart deal with a dynamically changing data range. This is useful for situations where you have multiple measures that each have a different number of independent variables (the variables plotted on our x-axis, which was the month of theContinue reading “HOW TO… Excel: Create a Dynamic Data Range for a Chart”
Nintendo Console Dashboard – Linked Pictures
Using Linked Pictures to update my Nintendo Console Dashboard.
Nintendo Console Dashboard
I love Nintendo. So, of all the things one can make a Dashboard about, of course I went ahead and created a Dashboard using data about Nintendo’s array of home consoles.
HOW TO… Excel: Using Index and Match to Create Dynamic Data Tables
This is a follow-up to the last tutorial. Thanks to reddit user /u/small_trunks for noticing my blunder!
HOW TO… Excel: Using SUMIFS to Create a Dynamic Data Table
This is a continuation of the previous tutorial. Due to the volatility of the INDIRECT function, it may be necessary to avoid using it when trying to create large dashboards which will be handling and outputting large amounts of data. So, we’ll need an alternative in these cases. One of the ways this can beContinue reading “HOW TO… Excel: Using SUMIFS to Create a Dynamic Data Table”
HOW TO… Excel: Create a Dynamic Data Table Using INDIRECT and Combo Boxes
Creating a full and cohesive user experience in an Excel based dashboard can be really difficult if you don’t know where to start. Often, the easiest way to approach the situation will be to utilise Pivot Tables and Pivot Charts, which come with useful tools like slicers to dynamically filter the data with a touchContinue reading “HOW TO… Excel: Create a Dynamic Data Table Using INDIRECT and Combo Boxes”