Category: Tableau

Feed: The Information Lab. Author: Andre De Vries. 15 October, 2018 | Andre de Vries Build your first Tableau Dashboard Extension In this blogpost I will walk you through building your first Tableau dashboard extension. It is aimed at those that have no prior experience with creating extensions. I’ll explain my setup for building them and then we will build a basic extension that allows you to auto refresh your dashboard on a timer. This could be useful for when you are publicly displaying a dashboard and it needs a regular data refresh. This process would then be automated. Intro ... Read More

Feed: What's New. Author: Hannah Blacksmith. This piece was originally published on CIO.com. Data is a critical fuel in creating better customer experiences, more efficient operations, and opening new revenue streams. The organizations who are best at analyzing data will be the most competitive and impactful. As such, organizations are turning to so-called “smart” analytics technologies—like artificial intelligence, machine learning, natural language interactions, and complex algorithms—to find an edge and further augment analytical abilities, drive organizational change, and catalyze digital transformation in their businesses. Yet few of these promising technologies have achieved widespread success. Shrouded in mystery and hype, they ... Read More

Feed: The Information Lab. Author: Alexandra Hanna. 9 October, 2018 | Alexandra Hanna Differential Pricing Using Table Calculations I’m writing this blog after visiting the Tableau community forum – a place to resolve any doubts. Here is the user’s question I helped solve. “I need to create a KPI that compares the value for competitors against ours. I am really battling with this. In essence if the number is higher than ours it must be red, if it is lower it must be green and if it is the same it must be black” This problem is perfect to showcase ... Read More

Feed: The Information Lab. Author: Pablo Saenz de Tejada. 5 October, 2018 | Pablo Sáenz de Tejada Cache data in a concrete step in Alteryx 2018.3 Probably one of the most demanded functionalities in the Alteryx community: “I want to save or cache the data at certain point of my workflow so I don’t have to run it completely again when I fix a small thing.” Especially useful when you have some concrete processes that require more run time like complicate joins, clustering, data cleansing, spatial match, etc. The good news is that you can do now this from Alteryx ... Read More

Feed: The Information Lab. Author: Carl Allchin. 4 October, 2018 | Carl Allchin Tableau Prep Development Tableau Prep launched in April 2018 to much acclaim due to an easily accessible user interface and some neat data preparation tricks under the hood. But what has happened since then? Personally, I have lost count of the various features have been added as the team have added many nice additions on their monthly release schedule. So I thought I would pull together some of favourites below Changing the Colour of the Step When teaching Tableau Prep, I have received a flow of questions ... Read More

Feed: The Information Lab. Author: Chris Love. 3 October, 2018 | Chris Love Fixing Tableau Errors: Cannot mix Aggregate and Non Aggregate Arguments If you’ve arrived at this blog it’s likely you’re experiencing this error. In short, the reason for this error is that Tableau cannot mix an aggregate argument e.g. sum(Sales), avg(Profit), Profit Ratio with non-aggregate arguments e.g. Discount, Sub-Category. In order to fix it you need to make all arguments aggregates or all arguments non-aggregates / row level variables. If you have time then we recommend this video where Zen Master Chris Love explains the terms and shows ... Read More

Feed: The Information Lab. Author: Andy Kriebel. 31 August, 2018 | Andy Kriebel Why I created the FT Visual Vocabulary in Tableau As the Head Coach of The Data School, I need to be on top of all things Tableau so that I can pass that knowledge onto our trainees. What I really hope they pick up is my method for learning and my constant to desire to get better at my craft. When they graduate from The Data School, they’re clearly some of the best Alteryx and Tableau users in the World. While that’s fantastic, unless they have an ... Read More

Feed: The Information Lab. Author: Luke Stoughton. 2 October, 2018 | Luke Stoughton Tableau – Find your closest Competitors Ever needed to find out which of your competitors are sitting just above or below you in terms of performance? Or maybe see how your competitors are performing and what their closest competitors are? There’s a relatively straightforward way of doing this in Tableau, we’ll need to create a couple of calculations and parameters first. Here’s how to do it using Superstore, we’ll use the Manufacturer field as your company: Create a Closest Competitors Parameter. This will determine the threshold above ... Read More

Feed: The Information Lab. Author: Ravi Mistry. 1 October, 2018 | Ravi Mistry Explorer? Creator? Viewer? Demystifying Tableau’s Licensing Model. It’s been just under 6 months that Tableau announced a ‘New Day for Data‘, announcing three key changes; 1. Introducing the new version of Tableau Desktop and Server, from 10.5 to 2018.1 – An amendment to the naming convention from major/minor releases to year of release/version number for that year. For example, 2018.2 was the 2nd version released in 2018. 2. Tableau Prep, previously code-named Project Maestro, was added to the Tableau suite of analytical tools, focussing on data preparation ... Read More

Feed: What's New. Author: Hannah Blacksmith. When you clean data, you often have to find inaccurate data values that represent real-world entities like country or airport names. This can be a tedious and error-prone process as you validate data values manually or bring in expected values from other data sources. Tableau Prep now recognizes a set of real-world entities including the eight geographic roles Tableau Desktop knows about, as well as email addresses and URLs (see details here). Now you can set up the Data Role of a field to let Tableau Prep know what real-world entity the field represents ... Read More