Author: Tableau

Feed: What's New. Author: Joshua Milligan. At this point, I’ll split out the values from the remaining text. Most of that will be the account name. And where it’s not, I can filter. I’ll do this with a couple of calculated fields. Account BalanceMID([F1], 0, FIND(F1, “.”) + 2) Not only did the decimal point tell me which fields were useful, it also helps me split the string. Starting from the left (0) and going to the position of the decimal + 2, I’ll get the amount. (I’ll also get a $ symbol, but I can use the REPLACE() function ... Read More

Feed: What's New. Author: Melody Cheung. Editor’s Note: This piece is part of the Generation Data series on the Tableau blog. At Tableau, we feel that data skills are essential for the next generation of professionals and business leaders. The Tableau Academic Program seeks to arm students with the valuable analytical skills needed to think strategically and make an impact, both academically and professionally. If you are a student, download your free Tableau license today to start learning data skills. Melody Cheung with the Academic Programs team at Tableau sat down with Leon Lok to talk about his experience with ... Read More

Feed: The Information Lab. Author: Gwilym Lockwood. 19 July, 2019 | Gwilym Lockwood Simulating data in Alteryx – what to do when data points are consecutive Peter’s blog covered a lot of ways to generate dummy data in Alteryx, which I highly recommend reading if you’re generating dummy data in Alteryx for the first time. This blog covers a more complicated, more specific use case. How do you simulate or generate dummy data which has to have consecutive data points? For example, let’s say you’re monitoring the temperature in your house, and you don’t have the data yet, so you ... Read More

Feed: The Information Lab. Author: Craig Bloodworth. 18 July, 2019 | Craig Bloodworth Export All Extension for Tableau v2 Released Well it’s been a while since I last wrote a blog post…any blog post. I can’t put my finger on why that is. I’ve been up to a whole bunch of things development, mainly internal to The Information Lab. When you pass 200 active users with at least 8 joining every couple of months you realise that system automation becomes somewhat important. That doesn’t mean that I don’t intend to be totally open with all my automation-based development, there’ll be ... Read More

Feed: The Information Lab. Author: Alexandra Hanna. 16 July, 2019 | Alexandra Hanna Why I attended #Inspire19 and why you should too! This year’s Alteryx conference was held in Nashville and was jam-packed with learning opportunities. As a certified trainer my objective was to gather use cases and best practices to enrich my classes, and here are my top take-aways. Country music was at the heart of the conference. Dean Stoecker (Alteryx CEO) quoted the song “Burn” by Johnny Cash to echo an analyst’s cry for automation. The next big trend in analytics is to get rid of repetitive tasks ... Read More

Feed: What's New. Author: Matt Illuzzi. Tapping into our team of expert analysts, we identified our data sets and integrated data sources by creating the appropriate connections utilizing Tableau. Utilizing Alteryx, we created a repeatable workflow including all the various steps and information we needed with automated refreshes so anyone from executive stakeholder to business user could access the data in real-time. Integrated dashboards were created to provide a one-stop view of all our key metrics. From an operations perspective, we created a contract-pacing dashboard which highlighted our number of active contracts, our number of billable hours by hourly rate, ... Read More

Feed: The Information Lab. Author: Iwona Wiktorowska. 15 July, 2019 Show/Hide Tabs – why does it matter? When you publish a workbook to Tableau server, the pop-up window you get in Tableau Desktop has a small checkbox: “Show sheets as tabs”. People don’t pay attention to it, but the decision of whether to show or hide tabs can impact the performance, permissions, actions and the rendering speed of a dashboard. So let’s go through the consequences of hiding/showing tabs in depth. Permissions When you show views as tabs, workbook permissions are propagated to all views. When you hide tabs, the ... Read More

Feed: What's New. Author: Andy Cotgreave. Welcome to the Best of the Tableau Web! To keep you going for another month, here are more tips, tricks, and inspiration. Iteration of ideas is crucial to any field, and visual analytics is another. One post I want to highlight this month is “Evolution and Variation with ‘line and slope’ charts in Tableau” by Dorian Banutoiu. It epitomizes everything I look for when reading our community content. First of all, Dorian is trying out new ideas, such as combining slopes and lines. Second, there is humility in the acceptance that no idea is ... Read More

Feed: The Information Lab. Author: Alexandra Hanna. 12 July, 2019 | Alexandra Hanna Viz for Social Good Hackathon – July The Information Lab is committed to give back to the community. We help charities and non-profit organisations make sense of data through hackathons hosted at the Data School. In this month’s #VizforSocialGood project we helped Kiron Open Higher Education. The goal was to create visualisations about education opportunities for refugees and asylum seekers in Germany, and raise awareness through social media. The evening began with Soha showing the art of the possible. She also provided expert advice on how to ... Read More

Feed: What's New. Author: Sasha Rabkin, Jessica Paulson. 1. We’ve made our data actionable. School districts will only be able to close their equity gaps if the right people have the right data at the right time. We see that happening more and more with our school district clients. One of the biggest barriers to school change is that so much of the data is “post-mortem”—looking back after the fact. This makes action challenging, but providing equitable opportunities is urgent, and waiting is no longer an option—there are too many qualified students being left across the hall from the education ... Read More