Clearly and Simply

Tag: tableau software

  • O’zapft is!

    The Development of the Beer Prices at the Oktoberfest – a Tableau Visualization and Analysis

    Oktoberfest Impressionen - Photographer: sanfamedia.com (flickr.com)At this moment Munich’s mayor Christian Ude opens the 179th Oktoberfest in Munich with the traditional shout “O’zapft is” after tapping the first barrel of beer.

    Prior to every Oktoberfest we have a reoccurring heated discussion on the beer price. And – except for the breweries and the tent hosts – we all agree that this year’s “drastic” rise of the beer price is inacceptable.

    No one really takes this discussion too seriously, but we are having it every year.

    So, today’s opening of the Oktoberfest is a good opportunity to have a closer look at the prices and the price development of beer at the Oktoberfest. This article provides an interactive Tableau visualization (beer prices since 2002), followed by an analysis of the price trend since 1952.

    (more…)

  • Web Page Objects on Tableau Dashboards

    Spice up your Tableau dashboard with a web page object showing additional web-based or other external information at your user’s fingertips

    A window too high / Photographer: ephotography (flickr.com)

    Tableau dashboards and all their built–in interactive features are a piece of art on their own.

    However, in certain circumstances (i.e. if your data and visualization is suitable), you can even top this by embedding a web page object into your dashboard and a URL action to hyperlink to additional web–based information outside of your data source, depending on your data and on the user’s selection.

    Google Map views of your geographical data, additional product information from the Internet, websites of other companies, content from your company’s Intranet or even folders and files stored on a file server.

    Today’s post is a step-by-step tutorial how to embed web pages into your Tableau dashboard and update the views depending on user inputs. Furthermore the article includes a couple of real life examples and a discussion of the pros and cons of using this technique.

    (more…)

  • Embed and Open Tableau Workbooks in PowerPoint

    A follow up post: how to embed a Tableau Packaged Workbook in PowerPoint and open it directly within the Slide Show

    Woman Aircraft Worker / Photographer: David Bransby (flickr.com)Yesterday’s post Embed Tableau Visualizations in PowerPoint described three stand-alone alternatives (i.e. without the use of an add-in) to Andy Kriebel’s great post on how to embed a Tableau dashboard in PowerPoint.

    Both Andy and I used the word “embed” in the titles of our posts. Truth be told, this is a little exaggeration. Using a web browser control object navigating to a Tableau workbook stored on a server like Tableau Public is not really embedding the workbook. The main disadvantage of those approaches is the fact that you can interact with the Tableau dashboards, but you are not able to edit the workbook. Let’s assume you are receiving a question during your presentation which cannot be answered with your existing views and dashboards: You are not able to add another sheet and do some extra data analysis and new visualizations on the fly. In other words, you are losing one of Tableau’s greatest advantages: rapid fire data analysis and Business Intelligence.

    Of course you can physically embed the Tableau workbook in your PowerPoint presentation as an object like you can do with any other file of any other application. However, there is one main pitfall: PowerPoint does not allow you to open an embedded object during the slide show. You always have to interrupt the presentation, go back to the normal view in PowerPoint and open the file from there. Honestly, this is not much better than simply opening the file from the Windows explorer and it is far from being a seamless experience for the audience of your presentation.

    So, here is today’s challenge: embed a full packaged workbook into PowerPoint and provide a way to open it directly during the slide show.

    (more…)

  • Embed Tableau Visualizations in PowerPoint

    How to embed Tableau Visualizations in PowerPoint Presentations – an alternative without using an add-in

    Men and a woman reading headlines / Photographer: Jack Delano (flickr.com)The way stories and insights are presented to the management is fundamentally changing. For a very long time management presentation were based on PowerPoint decks with embedded static images of the data visualizations.

    Nowadays, requirements have gone up. Static data visualizations are not sufficient anymore. Especially during presentations based on data analysis, it is expected that the presenter is able to answer questions on the data live during the meeting.

    Tableau Software meets exactly this requirement. The highly interactive dashboard features and the ability to build new views on the fly by dragging and dropping enables you to answer almost every possible question on the data live.

    However, in most cases your dashboard or data visualization will not cover all topics of your presentation. So what to do? Switching back and forth between PowerPoint and Tableau during the presentation? Well, this is an option, but it is inconvenient for the presenter and not a seamless experience for the audience.

    So, what we need is a way to embed the Tableau visualization directly into the PowerPoint presentation. This will not only guarantee a seamless interactive presentation but also provide the option to distribute the PowerPoint file to the audience including an interactive Tableau dashboard.

    Earlier this week my Tableau blogging colleague Andy Kriebel published a great article on his blog VizWiz how to embed a Tableau dashboard into a PowerPoint presentation using the free LiveWeb Add-In:

    Tableau Tip: Embedding a Dashboard in PowerPoint in 8 simple steps

    Today’s post is a follow-up to Andy’s article, showing an alternative how to do the same thing using some simple VBA code instead of the add-in.

    (more…)

  • Dice Portraits of the Tableau Management

    Mosaic Dice Portraits of Tableau Software’s Leadership Team

    Dice Portrait of Christian ChabotFirst things first: this is a fun post. Don’t expect to learn much from today’s article, neither about Data Visualization in general nor about special tips and tricks in Tableau.Today’s post is in line with 2 fun articles about (re-)creating art with Tableau Software:

    Tableau Replica of Curtis Steiner’s 1,000 Blocks

    and

    6 Famous Paintings in Tableau

    The article is adopting an idea of creating images using different faces of a dice: mosaic dice pictures or portraits. The post includes the beautiful article and video I stole this idea from and my Tableau workbook showing the portraits of the members of the Tableau Management Team using dice face custom shapes.

    (more…)