Archive for Category: Data Visualisation

Tableau

Tableau is a data visualisation and analytics package, aimed at streamlining the process behind interpreting scale data. You don’t need to be at all technically minded to track, and the drag and drop format means it’s blindingly obvious to use for connecting data channels. You can import data from...

Qlikview

Qlikview takes data from a range of different sources, and combines and analyses that data to provide business-wide analytics, insights and intelligence. It’s like Google Analytics for your entire data set – not just web traffic. Regardless of the different types of data your business holds, Qlikview provides an...

Datawrapper

Datawrapper is a free, open source project that makes creating charts, maps and other visual displays of information simply a case of uploading your data. Datawrapper takes just a couple of clicks to sift through your data and create visual presentations of your numbers, whether you’re looking for bar...

Excel

Microsoft’s pioneering spreadsheet package, Excel is a must-have application for anyone interpreting data on scale. It’s data visualisation options remain industry-leading, presenting an array of sorting, structuring and presentational options for adding meaning to your figures. At a basic level, you can chart, sort, and sum your data. For...

Regular Charts

Excel makes it easy to take data from a source and arrange it into charts, graphs, tables and other graphical representations, so you can interpret information at a glance. Charts are easy to create, edit and modify within Excel – the Chart Wizard is designed to walk you through...

Pivot Tables

Pivot tables are incredibly useful, and easy to execute within Excel. They allow for filtering and summarisation of raw, ‘flat’ data, helping make sense of a broader data set. Pivot tables are created by selecting all the relevant data fields, then choosing Insert>Pivot Table. Pivot Tables are created in...

Data Analysis Tookpak

Recommended for advanced Excel users, the Data Analysis Toolpak is a free add-on for Excel which enables the processing and interpretation of complex data, statistics and engineering calculations through a range, or ‘Toolpak’ of additional functions, including Correlation, Rank and Percentile, Random Number Generation and z-tests for variance. You...

Powerpivot

Powerpivot is a function that allows pivot tables to get one step better, making it possible to combine and summaries data from across multiple different sheets without VLOOKUPs. Essentially, it’s another free Add-In from Microsoft, with the ability to transform Excel into a much more powerful beast – think...

Wordle

A super simple tool for putting together word clouds. Word clouds are much criticised, but very useful for quickly understanding popular themes in site search terms, in title tags of competitors’ content, and much more that you can use to improve site results. Alongside that, *everyone* understands them so...

Tagul

Tagul takes word clouds and makes them pretty. In just a couple of clicks, you can create attractive word clouds that silence the critics and improve the aesthetic of your site, as well as helping users better understand and navigate your site. Tagul allows you to create word clouds...