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
Man Booker Prize Winners since 1969
As you may have seen, the Man Booker prize has been won by Howard Jacobson with The Finkler Question. If you're a bookworm like me, and like to read all of the short-listed entries and previous Man Booker Prize winners, then you may be interested to have a look at my 'Man Booker Prize' dashboard, which is hosted … Continue reading Man Booker Prize Winners since 1969
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
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
Obtaining Sample Data Sources
One of my readers, Misbah, wrote recently to ask a query about obtaining sample data sets. I've done some research on this - Misbah, this blog is dedicated to you and I wish you all the best in your studies. I've discussed some of the problems in obtaining datasets, along with some resolutions. There are … Continue reading Obtaining Sample Data Sources
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: 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?
Bullet Graphs for Performance Monitoring and More | Tableau Software
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
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 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
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
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