Charting and dashboards - agileChilli
We’re pleased to announce the addition of a new chart type to our lineup (bar charts, scatter diagrams, time series, pie charts, maps etc.)
Heatmaps have recently been launched, powered by our charting technology Highcharts.
Heatmaps are two-dimensional and show correlations between two variables.
Adding a heatmap is really simple. Create a new chart as normal, (in brief: open a tile and click the chart button at the bottom left of the screen) but instead of just adding one grouping, add two. Add your calculation (e.g. count or records) as normal too.
Update: agileBase now supports global mapping based on any address that Google will recognise. Postcodes are still the quickest way to map UK data.
Word clouds for text analysis
The ‘word cloud’ has become very popular, used increasingly by national newspapers and described as ‘the gateway drug to textual analysis‘ by the Chronicle of Higher Education. Word clouds are now available in agileBase.
Analysing numerical data is fairly well understood. There are all sorts of charts and statistics you can use, many of which have been available in agileBase for some time. However, what do you do when you have databases of unstructured text? For example
- learner records
- book reviews
- customer feedback
How do you discern patterns and pick out trends in this mass of text?
Let’s jump straight in with an example.
This is a summary of the learning database that we use in our organisation – books, online articles, videos, PDFs etc. The text includes our reviews and where relevant summaries from amazon.com. You can quickly get an idea of the sorts of things we’re interested in.
What’s more, the word cloud is interactive – you can click on a word to filter by it. This will show a list of results – books etc. – that you can drill down into and also a new word cloud summarising that set of results. In this way, you can iteratively explore an area and find interesting resources – this is a method we’re pioneering.
Here’s the cloud that you get when you click on ‘systems’:
As you can see, it’s cleverly picked up a number of different forms of the word ‘systems’. This is made possible by the use of research from Lancaster University in natural language processing.
In fact, if you hover over a word, you can see the different forms. For example, science includes also sciencific (a spelling mistake), scientific, scientifically, scientism, scientist and scientists. In this way, you don’t have to know the exact word you’re searching for.
To see a word cloud of your own data, just go to the charts tab in agileBase and select a field to use as a source of text – it’s as simple as that!
We predict this will become a useful resource in many different areas. Let us know what you think, especially if you have an idea that you’d like to try it out on.