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?

Business Intelligence

New DATE Format in SQL Server 2008

I'm currently using SSIS to import data into Replicon, editions of timesheet software that track time and expenses for attendance, payroll, project costing and client billing. As expected, there are always some opportunities to pick up experience along the way.For some columns, Replicon expects the imported date format to be in a strict date format,… Continue reading New DATE Format in SQL Server 2008

Business Analytics

Analysis Services 2008: Issue and Resolution #2

Here is another Analysis Services error message which I've seen crop up from time to time:Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_mytablename', Column: 'ColumnName', Value: 'UNK'. The attribute is 'ColumnName'.There are a number of ways to get rid of this. I'm in favour of sorting… Continue reading Analysis Services 2008: Issue and Resolution #2

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