I was recently asked to create a dashboard of charts in Excel. I wanted to create a modern-looking dashboard that looks better than the default styles in Excel, and I wanted to make it interactive so that the dashboard users could get more value from it. I can’t share the real dashboard with you due … More Interactive Excel Dashboard
In my last blog post I described how I created my first bubble scatter plot in R and this post is about how I improved it. The changes I wanted to make were: Add a key (legend) – My question on Stack Overflow – How to add a legend after updating a scatter plot with the … More Improving the bubble scatter plot in R
I wanted to have a go at creating a chart using R, based on a simple data set. I started by creating a data set using some information about 5 of the tools that feature in this article. I created a rank for each tool, for each aspect the article writer had compared for each … More Creating my 1st bubble scatter plot in R
I got frustrated at work this week when a spec I’d been given for a data extract didn’t seem to match the sample files provided. The extract produced a set of 90 fixed-width files, with a large number of fields in each file. I needed to confirm whether there was a mismatch between the spec … More Going off-piste with R
I’ve recently become fascinated with data science and have heard that R is a popular open-source tool for doing data analytics so I wanted to have a play with it to understand what it can do. I’m not a programmer (although I have done some programming at university during my Computing degree) so I was … More Learning R with DataCamp
Fox Visual Insights 