#MakeoverMonday Week 27 - If Only _____ Voted

Jul 6, 2021 VizWiz (noreply@blogger.com) | www.vizwiz.com

This week’s data set was one of the most interesting we’ve had for Makeover Monday. I found it fascinating to see some of the extreme polarization in the demographics of US voters in the 2020 election.Resources:1. Data Set - https://data.world/mak...

biden,bumpchart,Democrat,demographics,election,heatmap,MakeoverMonday,republican,stackedbarchart,Trump,UnitedStates,USA,vote,voting,WatchMeViz

How to Disable Sorting on a Worksheet

Jul 6, 2021 VizWiz (noreply@blogger.com) | www.vizwiz.com

Let’s say you have multiple metrics on a chart (not required) and you have sorted the chart in a specific way, for example by sales, and you want to prevent your users from sorting by something else.It’s quite simple! All you have to do is turn of...

axis,disable,header,menu,showsortcontrols,sort,sorting,tableau,tip,worksheet

Week 14: Survey Data: Weighting | DS23

Jul 6, 2021 Auguste Navickyte | www.thedataschool.co.uk

Step by step guide to adjust your survey data with weighting in order to avoid bias.

Culture,history,InterWorks,Oklahoma,Stillwater

The Buffer Function in Tableau

Jul 6, 2021 Harriet Owen | www.thedataschool.co.uk

In the 2020.1 release of Tableau a new function, Buffer, was added which allows you to create a radius (or boundary) around a specific spatial point. This blog demonstrates when and how to use it!

Culture,history,InterWorks,Oklahoma,Stillwater

Drag and Drop Labels in Tableau - Part 3 - Shared vs Dual axis

Jul 6, 2021 Liu Zhang | www.thedataschool.co.uk

A lot graphs involve x-axis vs y-axis, so how does Tableau handle multiple measures?

Culture,history,InterWorks,Oklahoma,Stillwater

Converting AM/PM Time to 24 Hours format, in Alteryx

Jul 6, 2021 Henry Mak | www.thedataschool.co.uk

In this blog post, Henry shows you how to convert from a 12 hour AM/PM time into a 24 hour format, in Alteryx.

Culture,history,InterWorks,Oklahoma,Stillwater

How I Used Alteryx to Solve Sudoku Puzzles 4,000 Times Faster

Jul 6, 2021 Michael Green | www.tessellationtech.io

How I Used Alteryx to Solve Sudoku Puzzles 4,000 Times Faster Anyone who knows me well knows that I love board games and puzzles. I also love to develop algorithms that play board games or solve puzzles for me. In … Read MoreThe post How I Used Al...

Alteryx,Tutorial,alteryxtraining

The InterWorks Mantra: Do the Best Work for the Best Clients with the Be...

Jul 6, 2021 Behfar Jahanshahi | interworks.com

I’ve always found it hard to attach labels and definitions to things, especially InterWorks, for a lot of reasons. In a recent blog post, I detailed how and why InterWorks came to be. When I started InterWorks, we didn’t have a super defined mantr...

Culture,culture,history,InterWorks,mantra

An InterWorks History: Our Origins to Our Why

Jul 6, 2021 Behfar Jahanshahi | interworks.com

When you start your own company, the concept of “having made it” is one that rarely sinks in – no matter how objectively successful you become (whatever that means). I don’t doubt that there’s a part of my mind that views InterWorks in the exact…T...

Culture,history,InterWorks,Oklahoma,Stillwater

Week 13: Salesforce, Mockaroo & Tableau

Jul 5, 2021 Auguste Navickyte | www.thedataschool.co.uk

Creating a mock dataset for Salesforce and visualising it on Tableau.

Tableau,date,DateParse,tableau,time

Ranking (Dense) in Alteryx

Jul 5, 2021 Joselito Bondoc | www.thedataschool.co.uk

During an Alteryx Challenge (challenge 9), I found that creating a dense ranking in Alteryx isn’t straightforward. So I will be showing two methods: using a lookup table and using the Multi-row formula tool.

Tableau,date,DateParse,tableau,time

Drag and Drop Labels in Tableau - Part 2 - Measure Label

Jul 5, 2021 Liu Zhang | www.thedataschool.co.uk

Continue the series on understanding Tableau’s visual indication of drag and drop labels within the view.

Tableau,date,DateParse,tableau,time

Format time in Tableau

Jul 4, 2021 Fabricia | tarsolutions.co.uk

This post shows how to format time in Tableau. Similar to formatting a date, use a Custom Format to format a time. The best approach … Read moreSource

Tableau,date,DateParse,tableau,time

DS24 Training Blog - Week 4

Jul 3, 2021 Liu Zhang | www.thedataschool.co.uk

Weekly blog on Data School Training and Notes

8 Best Practices for Working with Your Data Science Vendor — from Data S...

Jul 2, 2021 Eszter Windhager-Pokol | medium.com

8 Best Practices for Working with Your Data Science Vendor — from Data ScientistsWhen you leverage data science expertise from outside your company for a project, you face a multi-layered challenge. There’s likely to be a gap in domain knowledge b...

data-science,machine-learning,ai

Tableau Table Calculation Highlights: Types of Calcs

Jul 2, 2021 Robin Schouten | interworks.com

In my previous blog post, I started with some basics of table calculations in Tableau. This post and the next are going to build on that foundation by walking through the various kinds of table calcs there are and finally discussing more advanced ...

Data,TableCalculations,Tableau,TableauTableCalculationHighlights

PYD113 – Data Literacy with Analytics Consultant, Rachel Kurtz

Jul 2, 2021 InterWorks | interworks.com

Data literacy is the cornerstone of advanced decision making. Individuals and organizations grow when they learn to correctly crack the data code. Today, InterWorks Communications Manager Garrett Sauls speaks with Analytics Consultant Rachel Kurtz...

Data,Dataliteracy,healthcare,Podcast,PodcastYourData,Tableau

#WOW2021 Week 22 - Can You Structure the Unstructured?

Jul 1, 2021 VizWiz (noreply@blogger.com) | www.vizwiz.com

Week 22 was quite the tricky challenge. The idea itself is quite simple, but you had to (1) use REGEX to get the number of bedrooms (thanks to Sylvie Imbert at The Data School for her help!) and (2) know how to create bins without using the BIN fu...

barchart,bins,calculatedfield,contains,filter,levelofdetail,map,referenceline,regex,sys_numbin,tableau,WorkoutWednesday

Tableau - Fix Map Size Without Zoom

Jul 1, 2021 Liu Zhang | www.thedataschool.co.uk

Quick tip to fix Tableau map size to prevent accidentally zoom over it while scrolling.

Dashboards,Tableau,Technical,dashboard,dashboarddesign,dashboarding,prototyping,tableau

Live Stream – Why Data Analysts Need to know SQL

Jul 1, 2021 Analytics Events | www.tessellationtech.io

Join this one-hour webinar with Data Coach Co-Founder & SQL expert, Alex Christensen, to learn why SQL is important for data analysts, which SQL you should learn, and how to master SQL quickly. … Read MoreThe post Live Stream – Why Data Analys...

Careers,UpcomingLiveStream,Webinar,careeradvice,CareerInsights,Consulting,DataAnalytics,Livestream,SQL

How to Highlight an Entire Row in Tableau

Jul 1, 2021 Eric Parker | onenumber.biz

In Excel, you can easily highlight an entire row in a spreadsheet by selecting a row and adding fill to the background of the cells. How about Tableau however? Tableau highlight tables get you close, but one of their shortcoming is they don’t high...

Design,TableauHow-Tos

InterWorks Blog Roundup – June 2021

Jul 1, 2021 Andrea Avey | interworks.com

Another month down! We can feel things beginning to normalize in the world, and that was even reflected on the blog. With 21 new pieces of content – including two posts guest authored on partner blogs – and 30 different InterWorks contributors, we...

News,Matillion,monthlyblogroundup,Tableau

Profitability with Dual Axis Charts

Jul 1, 2021 Donna Coles | donnacoles.home.blog

Luke Stanke returned for this week’s challenge, to build a pareto chart & bar chart on an unsynchronised dual axis. The crux of this challenge is table calculations, so as with any challenge like this, I’m going to build out what I need in tab...

Sample KPI Dashboard

Jun 30, 2021 VizWiz (noreply@blogger.com) | www.vizwiz.com

This week at The Data School, I was teaching DS24 about dashboard best practices and how to effectively use containers. We picked a visualization from the wild (this one by Ryan Sleeper) as an example for us to rebuild and to learn about effective...

color,comparison,containers,context,dashboard,design,KPI,kpidashboard,layout,levelofdetail,LOD,sample,tableau,tableaudashboard,template,trend

Tableau Tip: Two ways to create a clear BAN in your title

Jun 30, 2021 George Pattinson | www.thedataschool.co.uk

Learn how to insert big numbers into your title (BANs) effectively

Design,TableauHow-Tos

Drag and Drop Labels in Tableau - Part 1 - Dimension Label

Jun 30, 2021 Liu Zhang | www.thedataschool.co.uk

Tableau offers multiple ways of bring data into the worksheet. In this blog, we will have a look how Dimension labels are indicated when being drag and dropped in the view.

Design,TableauHow-Tos

Dashboard Design Best Practices: Why You Should Prototype

Jun 30, 2021 Autumn Battani | www.tessellationtech.io

Dashboard Design Best Practices: Why You Should Prototype When building dashboards, there’s a large part of the job that happens outside of Tableau. In a previous blog, I talked about the importance of managing user feedback and how I go … Read Mo...

Dashboards,Tableau,Technical,dashboard,dashboarddesign,dashboarding,prototyping,tableau

Tableau Simples #9: Date Properties

Jun 29, 2021 Henry Mak | www.thedataschool.co.uk

In this new blog series, Henry shows you small tips and techniques in Tableau… in a short and simple way. This blog post shows you how to change the date properties of your data source.

Spatial,area,polygons,Tableau

How to make an Alteryx workflow run faster in 9 steps?

Jun 29, 2021 Anastasija Starkina | www.thedataschool.co.uk

During the first weeks of our training we had to build a dozen of differentworkflows. Particularly complex workflows and combined data sets took up tocouple of minutes to run. Therefore, I had to find a way to make the process runfaster. In this p...

Spatial,area,polygons,Tableau

Area Spatial Function

Jun 29, 2021 datavis.blog | datavis.blog

Version 2021.2 sees the introduction of a new spatial function: Area. This blog and workbook include a few examples along with a couple of cautionary notes.

Spatial,area,polygons,Tableau

Webinar Replay: Designing Efficient Tableau Dashboards

Jun 29, 2021 InterWorks | interworks.com

We love working in Tableau, so it was a great privilege to support them when they approached us and asked, “Write down everything you know.” The outline of the idea was to take a previously written whitepaper from Alan Eldridge and update it to su...

Data,Optimization,performancerecorder,Server,Tableau,WebinarReplay

#MakeoverMonday Week 26 - How Popular Is Your Birthday?

Jun 28, 2021 VizWiz (noreply@blogger.com) | www.vizwiz.com

The original visualization this week was superb. I don’t think what I created was better, but I did come up with a slightly different take and I showed how to build a marginal histogram. I also failed trying to create a starburst chart (I’m going ...

birthday,color,heatmap,histogram,howto,MakeoverMonday,marginalhistogram,MattStiles,preferences,WatchMeViz

How to Rank by Group in Alteryx - Part 3 - Fractional Ranking

Jun 28, 2021 Liu Zhang | www.thedataschool.co.uk

Part 3 of the series will focus on Fractional Ranking method, use average ranking for equal measure.

Culture,culture,HowIWentFrom,music,sales,theatre,theory

Basic Web Scraping with Power BI

Jun 28, 2021 Henry Mak | www.thedataschool.co.uk

In this blog post, Henry explains how to carry out basic web scraping with Power BI. The data set he uses is IMDb’s Top 250 Films by Rating.

Culture,culture,HowIWentFrom,music,sales,theatre,theory

How I Went from Music Theorist to Client Manager

Jun 28, 2021 Renae Perry | interworks.com

Most of my earliest memories involve music: singing along as my mom practiced hymns for our church on the piano, putting a pillow over my head in a feeble attempt to drown out the sound of my dad’s rock band in the garage and smiling…The post How ...

Culture,culture,HowIWentFrom,music,sales,theatre,theory

Understanding Table Calculations Using Fixed LODs

Jun 28, 2021 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 Table calculations aren’t the easiest thing to understand.  I struggle with them often.  I can typically get them to work the way I want them to, but it’s often through a bit of trial and error.  However, Fixed LODs come really natura...

How-To,Tableau

DS24 Training Blog - Week 3

Jun 27, 2021 Liu Zhang | www.thedataschool.co.uk

Weekly blog on Data School Training and Notes

TableauEnterprise

How to create a governed self-service model

Jun 27, 2021 markwu2000@gmail.com | enterprisetableau.com

I manage a large Tableau platform with a few hundred of cores. In last a few years when we scale the server, we also put together some good governance processes to ensure scalability. When you ramp up a server to 20K, 50K or 100k users, there are ...

TableauEnterprise

Write to Google BigQuery Using Tableau Prep

Jun 25, 2021 Rajeev Pandey | vizartpandey.com

With 2021.2, Tableau Prep expands its output capabilities to include Google BigQuery. This enables you to add or update data in Google BigQuery with clean, prepped data from your flow each time the flow is run.The post Write to Google BigQuery Usi...

Home,Tableau,TableauPrep,PreppingData

Tableau’s DataDev Day: 5 sessions to watch

Jun 25, 2021 anna.prosvetova | www.theinformationlab.co.uk

Tableau developers or DataDevs play an active part in Tableau’s community. Bringing together their creativity, coding skills, and knowledge of Tableau, they use Tableau’s APIs to embed dashboards into websites, run machine learning models in Table...

Blog

Tableau 2021.2 has been released!

Jun 25, 2021 Sophie Sparkes | www.theinformationlab.co.uk

Hello Tableau 2021.2! This latest version of Tableau has a lot of new features to make digging into your data easier for all users – and when we say all users, we mean it! From Collections for Server Admins, to Ask Data and Explain Data for Viewer...

Blog,Tableau,TableauPrep,TableauServer

How to Rank by Group in Alteryx - Part 2 - Modified Competition Ranking

Jun 25, 2021 Liu Zhang | www.thedataschool.co.uk

Continue from the previous blog in the series, we will demonstrate how to calculate a modified version of standard competition ranking.

Data,COVID-19,healthcare,Podcast,PodcastYourData,Tableau

Academic Years + Tableau: All You Need to Know (Webinar Recording)

Jun 25, 2021 Eric Parker | onenumber.biz

Tableau is optimized to perform date comparisons and calculations relative to a standard calendar. If your organization’s year starts on the first of a month other than January, Tableau can still handle that relatively well. The flexibility breaks...

TableauDates,TableauCalculations,Data

PYD112 – Greater Manchester Health and Social Care Partnership

Jun 25, 2021 InterWorks | interworks.com

Today on Podcast Your Data, InterWorks Analytics Lead Steve Taylor sits down with the Greater Manchester Health and Social Care Partnership’s Head of BI, Graham Beales, and Senior BI Analyst, Paul Langton. They discuss how GMHSCP works alongside m...

Data,COVID-19,healthcare,Podcast,PodcastYourData,Tableau

Can you make Spine Charts?

Jun 25, 2021 Donna Coles | donnacoles.home.blog

Sean Miller provided the challenge for this week, resurrecting a challenge originally set by Emma Whyte in 2017. Revisiting these older challenges is great fun, as often newer product features provide a different way of solving. For me, I also lik...