Wednesday, May 20, 2020

A little more interaction

For the last few days I've been looking at ways to incorporate some of the Covid-19 data into a more interactive format for the blog. It's not been easy. Although there are many tools out there, most of them do not work well once you move from the classic simple charts and I've yet to find a tool that can provide the type of charts I like to craft in Excel. So the quest the a decent BI tool continues. 

But by way of a start please see the widget at the top of the blog showing the country growth trajectories created using Tableau. A full page version can be found here. I've had to make a fair few compromises on the layout and I'm not 100% sold on the approach, but it's a start. 

Gains from this approach include interactivity (if somewhat slow) selecting of countries and also the ability to scroll through 5 weekly data points... hopefully the update cycle will also be much improved (tests on other data analyses have been successful so far). One downside if the inability to join the dots of a scatter chart so you have to rely on unpredictable labelling to see what is happening. 

There's also a single country over time analysis available here I would have embedded the dashboard into the blog, but the auto-code generation module in Tableau is unreliable at best (it took hours of fiddling about to get the one in the header to work correctly). So I'm cutting my losses at this time. 

Any feedback on these analyses would be most welcome.

No comments:

Post a Comment