Business Intelligence, Data Visualisation, PowerBI, Tableau

Using Excel as a data source for Tableau – Shaping your Data

The purpose of this blog is to help you to see the difference that the underlying data structure has in determining the visual resulting visual output. For me, the underlying data is all-important; if it isn't clean or well-structured, then this needs to be resolved first. After that, even the neat pivoted and un-pivoted data… Continue reading Using Excel as a data source for Tableau – Shaping your Data

Data Visualisation, Tableau

Nobel Peace Prize Winners visualisation using Tableau

It's possible to interact directly with Tableau workbooks using Tableau Public, which is probably best described as a 'Youtube' for data.  This means that viewers are no longer passive consumers of data visualisations. Instead, data consumers are turned into active, interactive data consumers who can visually navigate their way, slicing intuitively through their data sets in… Continue reading Nobel Peace Prize Winners visualisation using Tableau

Business Intelligence, Data Visualisation, Tableau

Visualisation of Nobel Peace Prize Winners

Every year since 1901, the Nobel Prize is an international award dedicated to outstanding achievements to humanity. There are prizes in physics, chemistry, physiology or medicine, literature. It is administered by the Nobel Foundation in Stockholm, Sweden.The most commonly recognised award is the award for peace, and this year, the Nobel Peace Prize winner has been announced as Chinese dissident Liu… Continue reading Visualisation of Nobel Peace Prize Winners

Data Visualisation, Tableau

Some Fun – a Film Critics Dashboard!

It’s the time of year again, where the film critics and pundits try to guess who will be awarded an Academy Award©, otherwise known as an Oscar, at this year’s event.  In order to explore the numbers behind the Oscar© guesswork, I’ve tried to create a ‘Film Critic dashboard’ which based on Guardian Datastore data… Continue reading Some Fun – a Film Critics Dashboard!

Data Visualisation, Tableau

Data Visualisation: Beauty and Clarity?

This blog post focuses on an analysis of the donations made, by country, to assist the healing of Haiti after the devastating series of earthquakes in January 2010.  The process of tagging donations as specifically coming from organization, governments and countries is complex, and not as quick as one might expect. For example, the European… Continue reading Data Visualisation: Beauty and Clarity?

Data Visualisation, Tableau

Data Visualisation of Worldwide Chocolate Sales – Kraft and Cadbury

Despite the current economic difficulties, chocolate sales are continuing to rise throughout the world (Mintel, 2010). For example, British chocolate lovers have increased sales by nearly 6% from 2007, and in China, chocolate sales rose by 18%. Currently, chocolate sales remain in the headlines with the potential takeover of Cadbury by Kraft Foods Inc. In… Continue reading Data Visualisation of Worldwide Chocolate Sales – Kraft and Cadbury

Tableau

Tableau Training in UK at your offices! | Tableau Software

If you are interested in Tableau training at your office, or at a training venue in London which I can arrange, please do not hesitate to get in touch by emailing me at jen.stirrup@datarelish.com I'm open to the contents of the training sessions, and the content would be driven by your needs. Please let me… Continue reading Tableau Training in UK at your offices! | Tableau Software

Business Intelligence, Data Visualisation, Tableau

Dates in Tableau Calculations

ate formatting is a crucial aspect of many reports. Recently I found a useful trick in Tableau for formatting dates when using calculated fields. Using the DateTrunc formula, it is possible to aggregate the raw values up to a particular date in a time period. The DateTrunc calculation will take the values in the specified… Continue reading Dates in Tableau Calculations

Business Intelligence, PowerBI, Tableau

Preserving Tablixes on Export from SSRS 2008 to Excel

In Reporting Services 2008, it is possible to export to Excel using the Visual Studio interface and the Reporting Services browser. However, what about the case where you have a complex report with numerous tablixes, matrices and so on, and want to preserve these in the target Excel Workbook? Here is a nifty trick for… Continue reading Preserving Tablixes on Export from SSRS 2008 to Excel