How Do I Quickly Tweak All Files in a Folder?

I recently got hooked on Tableau Public. It's pretty awesome! One of the downsides, however, is the need to find yourself some interesting "open" datasets to visualize. As the number of prospective students at British universities has long been of interest to me, I thought I'd check out if UCAS had any publicly available data … Continue reading How Do I Quickly Tweak All Files in a Folder?

When can a Radar Chart be useful?

If you've been using Excel for a while, you've probably had to analyse performance, using a number of variables.    While bar and line charts (or a combination of the two) can be a handy way of doing this, you might also consider the radar chart as a suitable tool to:     1. Visualize the … Continue reading When can a Radar Chart be useful?

10 Best Practices of Spreadsheet Management

Assuming Excel is your play tool and that you need to handle data worth of 30,000 rows + in order to produce your analyses, below are some tips that could help improve and optimize your spreadsheet usage: 1. Do change the default csv connection properties! • Prompt for file on refresh: achieves nothing but render … Continue reading 10 Best Practices of Spreadsheet Management