Category: Tableau

Feed: What's New. Author: Marissa Michelotti. You already know Tableau is great for exploring and analyzing data, but did you know you can also use Tableau to create a robust project management tool? All you have to do is build a Gantt chart. Looking for a project management viz template? Download this Gantt chart workbook: To refresh your memory, Gantt charts display a series of horizontal lines that track completed work over time. The chart type was invented in 1910 by Henry Gantt, a mechanical engineer and management consultant. He was called on to create a data view for the ... Read More

Feed: The Information Lab. Author: Nai Louza. 16 July, 2017 | Nai Louza Putting the R in AlteRyx: CART Models Challenge 1: CART Models and Predicting Supreme Court Decisions This post is part of a series I am writing to translate R scripts I have seen or written into Alteryx workflows. Original post can be found here. This script comes from MIT’s Data Analytics course (which you can sign up for here). In the section where they introduce Classification and Regression Trees (CART), they use data showcasing decisions made by US supreme court judges and try to predict if a supreme ... Read More

Feed: The Information Lab. Author: Gwilym Lockwood. 12 July, 2017 | Gwilym Lockwood Between order and (statistical) model: how the crosstab tool in Alteryx orders things alphabetically but inconsistently I was using my Mahalanobis Distance calculation recently on some of my Spotify listening data, and I ran into difficulty. When I calculated the MD value of one song compared to the benchmark group, it gave me a value of 3.12. Nice. But, when I calculated the MD values of several songs at once compared to the same benchmark group, I got a value of 0.67 for that same song that ... Read More

Feed: What's New. Author: Piper Stull-Lane. You’ve got data, and you’ve got smart people. In Tableau 10.4, join the two with data source certifications. Your data experts can now approve data sources uploaded to Tableau Server and Tableau Online for broader use. You’ll trust your analysis, because it’s based on blessed, up-to-date data. IT will be happy, too, knowing that data prep and ETL investments are being used across your organization. On the Data Sources pane, select the “certified” icon to ensure the quality of data sources for others to use. Try this for sources that are frequently accessed, perfectly ... Read More

Feed: The Information Lab. Author: Benedetta Tagliaferri. 28 June, 2017 | Benedetta Tagliaferri Data + Women: Machine Learning with Alteryx Last Thursday (22nd June) I had the chance to speak at one of the most awesome meetup in London, data + women. I talked about Machine learning (ML) and how Alteryx enables any analyst to apply ML without a line of code. Here it’s a quick summary! What’s machine learning? You probably use it dozens of times a day without even knowing it. Each time you do a web search in google, machine learning works so well cause their ML ... Read More

Feed: The Information Lab. Author: Andre De Vries. 27 June, 2017 | Andre de Vries Alteryx’s Drive Time Engine Alteryx takes out a lot of the heavy lifting for the data analyst with its data preparation and advanced predictive tools. In addition, one of the strong points of Alteryx is that it also gives the regular user the ability to perform spatial analytics. As an extra, Alteryx offers a Spatial Data license. In this blog I’ll discuss how you can setup this Spatial Data add-on and quickly leverage this additional package. When you purchase an Alteryx Designer license you can ... Read More

Feed: The Information Lab. Author: Ravi Mistry. 23 June, 2017 | Ravi Mistry The Data School; 2 years on. On the 23rd of June 2015, there was a spark in Central London. And two years later, this spark is now a burning flame, which has been a roaring success. I am, of course, talking about the Data School. An idea started by Tom Brown, Craig Bloodworth and (perhaps the most important piece of the jigsaw) Andy Kriebel ended up in eight complete strangers taking a leap of faith and joining an immersion programme like no other. It promised four months ... Read More

Feed: The Information Lab. Author: Dan Watt. 22 June, 2017 | Dan Watt The boss knows first: how to use tableau user calculations to allow high level users to see the latest data before everyone else Giving all employees access to the latest sales data is the norm in some companies. However, some managers insist on having a preview of the data before the rest of the company. One project I was working on required a period of five days where only the senior managers could view the latest data. On the sixth day, the latest report became available to ... Read More

Feed: The Information Lab. Author: Ben Moss. 16 June, 2017 | Ben Moss Weighting Survey Data in Alteryx When looking at survey data, there are a number of quirks that can come up. I’m going to tackle one in this post – Imagine you’ve designed with the desire to represent a population correctly but when you first begin to look at the demographics of your respondents you identify that isn’t the case. It’s not uncommon – in fact it happens in almost all surveys – but there are a number of ways around this through what is known as ‘weighting’, which ... Read More

Feed: The Information Lab. Author: Nai Louza. 11 June, 2017 | Nai Louza Things to Watch When Replacing Data Sources When creating workbooks that will have future iterations (i.e. not one-time, static infographics), there may come a time when you have to either refresh the data in your dashboard or replace is with another data source. In the ideal scenario, especially if you have your workbook on Tableau Server, your workbook would be connected to a live data source and you would just update your data source (without changing the name of the data source or field names) and your ... Read More