New and old Tableau users alike struggle with grasping Tableau's concept of Layout Containers. I put together this exercise last week for a recent training course to help explain what is going on behind the scenes. Layout Containers in Tableau 8 force spatial relationships between dashboard...
In this mini-series I'm going to show you some cookbook style examples for using PowerShell to explore your Tableau workbooks. Follow along, this is going to be fun! Tableau workbooks (TWB files) are just XML files. Packaged workbooks (TWBX files) are just ZIP files that contain...
I saw an interesting post and data set this morning from ProCon.org. The information was in tabular form, so I copied it and extracted the data into Tableau. 20 minutes later, I had a fully-interactive dashboard that presented the information relevant to me in a...
Some fun Table Calculation questions came in this week. With four hours in the air heading home to New York from Portland, OR, I thought I’d quickly add these to the learning library. Here’s the first – I’ll put up another post with the second,...
Tableau Server is officially online. Users can now take advantage of their data from virtually anywhere with Tableau Online, a hosted (SaaS) version of Tableau Server. The benefits of a comprehensive, cloud-based business intelligence platform in Tableau Online are massive: Greater Access to Tableau Server With Tableau Online,...
Is your Tableau extract done? Don’t wait to find out! Send yourself (or a group) an email. If you haven’t already, make sure you’ve done this and this. Oh, and make sure you’ve got PowerShell v3 installed. Done? Perfect. Let’s get to the fun stuff. We’ll be...
A question I was recently asked by an in training Tableau User was ‘Why would I apply a table calculation by cell?’. To answer this I have produced a simple example of a by cell Table Calculation. Before I get to it I would like...
Tableau has the ability to recreate any colour by using the RGB colour model. By using this you can customise your charts and dashboards to match your corporate branding guidelines. The chart below shows the top 5 BBC Television Channels by expenditure in 2012. It is...
Tableau, DataSift and Google BigQuery are intent on taking social media analytics to the next level. The three recently forged a partnership that will enable users to seamlessly integrate their data within these platforms, allowing near endless possibilities for social media data analysis. Users will...
This Marimekko chart was fun to get right. There are some great examples of complex table calculations built in to it. The use case is similar to that of a series of stacked bars. It has graphical similarities to a treemap but it lacks the...
Scenario Our sales team collects information and forecasts possible sales using a data-table called ‘Opportunities’. If a sales opportunity converts to an actual sales lead, the customer and his information is moved to the ‘Leads’ table. Opportunities that do not convert remain on the original table. Additionally,...
Your ‘To-Do’ list: We’ll use Oracle for this example. In future posts, I’ll discuss other databases (including SQL Server). Download and install the ODAC (Oracle Data Access Components) from here. Make sure you have PowerShell v3 installed. Step 1: Set up the link between PowerShell and Oracle Copy the attached...
The Tableau Customer Conference 2013 turned out to be a truly inspiring event. Hans Rosling captured the hearts and minds of the packed event room as did Andy Kriebel (Facebook), JP Rangaswami (Salesforce), Tableau’s own Christian Chabot and many customer speakers such as Cisco’s Rob...
Question: Of all the workbooks on Tableau Server, which (1) use a Tableau Server data source and (2) what workbook(s) use them? Answer: Since there’s no simple and straightforward way to extract this information from the default views on Tableau Server (_datasources, etc.), we’ll...
Is data visualized more insightful than data stockpiled? It certainly depends on who you ask but, in some very specific cases, data visualized can shed light on some tightly guarded tribal knowledge. To that end, the team for the Civic Data Challenge has provided numerous...
One of the easiest-to-use diagnostic and troubleshooting tools we use here at InterWorks when working with Vertica clusters is Tableau. Vertica tracks a vast amount of information about cluster and database status. Diving into that data and quickly building visualizations and dashboards from these system...
What you will cover: Aggregating extracts to different levels (Year / Month) Data blending Calculations Parameters Step 1: Model your Data (read: What are you trying to analyze?) For our specific case, we’ll have a total of 5 TDE files and our dashboard will move seamlessly through each of them using...
Whenever I get the chance to introduce someone to the world of Tableau, one of the first things people tend to fall in love with are the tooltips and the ability to quickly view the underlying data of a mark. The default tooltips in Tableau...
Let’s be honest, the new version of Tableau is pretty slick. Despite how one feels about various additions/omissions to the software, the most recent update is a step in the right direction. While never perfect for every person, the software will certainly encourage more people...
“Data for data’s sake is a path to disaster” As is so often the case, various colleagues, friends and random members of the data culture offer up ideas regarding the use of Tableau, data and design. Sure, some of these “Huh, I wonder if I can...
Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson
Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301
Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072