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!
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?
Tableau are sponsoring a live webinar with Stephen Few on 23rd February; register quick! This will be well worth a listen. I've included the link below for you: Bullet Graphs for Performance Monitoring and More | Tableau SoftwarePosted using ShareThis
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
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
Here’s a quick note on how to take a backup of an existing database, and restore it to a brand new database where you don’t have a copy of the schema. A few preliminaries:If you try to do this without using REPLACE, then you might get the following error message: Error 3154: The backup set… Continue reading Creating a new database from a backup
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
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 firstname.lastname@example.org 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