Occasionally, you will find the need to compare filtered data against the total data source. As Tableau's filters remove the data from the data partition, this can sometimes be a tricky problem. You might be tempted to try the "Total" function in a formula like the...
Neutrality has always been a key concern in data analysis. As analysts, it is critical that we not introduce our own bias into the interpretation of data. Anyone who has had a statistics class is familiar with the importance of random samples and neutral questions....
With Tableau 8, users gained the ability to color marks by multiple dimensions on a single axis with some automatic combined field magic. What happens though, when you want color by a dimension and a measure? In the past, I have separated out members of...
If I were to ask you to name the three most significant factors that predict the murder rate within a geographic area, then I would expect you would name some measure of median income. To test this hypothesis, we could do a simple linear regression...
In the interest of full disclosure, I should let you know that I am a SAS user with a math background. I want to share my experience of exploring Tableau as a new user doing analysis in a relatively unfamiliar environment. For this first piece, we...
I know many of you cringed when you saw the words Global Filter, but I’ve had many questions come up recently regarding this while clients upgrade from Tableau 7 to Tableau 8. So, I thought I’d put something together. Quick Filters in Tableau 7 In Tableau 7,...
I’m three months in to my career at InterWorks and think it’s high time for my first blog post. In this post, we’ll cover the basics of using PowerShell and Tabcmd to distribute PDF files of your Tableau views via email. I have to give...
So, Here's the "Why" In Tableau, we are easily able to slice and dice the data according to our dimensions thanks to the default manner in which Tableau aggregates the data on our behalf. Therefore, I can simply add any measure and trust the view is...
The Problem As consultants, we often run into instances where we need to connect to a Microsoft SQL database as a user from another domain. Using SQL Server Management Studio fails the login because we can't specify which domain credentials to use, just that we want to...
This is part 2 of my mini-series on exploring Tableau workbooks with PowerShell. If you missed it, you should read Part 1: Opening Workbooks, before continuing. Welcome back! Last time I showed you how to open a Tableau workbook (TWB or TWBX) in PowerShell so you...
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...
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,...
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 Quick Way to Reengineer Worksheets & Workbooks for New Data - Imagine you are receiving updated versions of the same or similar set of data. Possibly, you are sent an excel file each week with the current market data, or perhaps a colleague that works...
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...
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...
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...
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