Changing the Metric using Buttons

Jul 10, 2023 Asha Daniels | www.thedataschool.co.uk

Tableau is a powerful data visualization tool that allows users to explore and analyze data from various perspectives. One key aspect of data analysis is choosing the right metric to measure and track. For a more exploratory dashboard, what if you...

An Inner Join in the Context of Alteryx

Jul 10, 2023 Jessica Kwan | www.thedataschool.co.uk

An Inner Join pulls through records that matched from the left input (table 1) to the right input (table 2). In this type of join, the values from the left input that do not match to values in the right input are then left out.

Duplicate Your AddShow Buttons for THE BEST User Experience

Jul 10, 2023 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

Just recently at the Tableau Conference in 2023, Ken and I were lucky enough to get to present “How To do Cool Stuff 2023” to two large audiences. Ken showed a bunch of mapping techniques then brought the house down with his synchroniz...

Tableau

Monday Music Musings Jeff Becks Rock Roll Party Part 2

Jul 9, 2023 Steve Wexler | www.datarevelations.com

Welcome to another journey into somewhat obscure, but terrific music performances. There won’t be any data viz stuff here, just some good music. While the Rock & Roll party I wrote about last week was in honor of Les Paul, there were plenty of...

MusicMusings,SportsandEntertainment,ImeldaMay,JeffBeck,LesPaul,music

How to make a Tableau Dashboard interactive

Jul 7, 2023 Sakif Chowdhury | www.thedataschool.co.uk

A major benefit of using Tableau for data visualization is how easy making a dashboard interactive is. Having an interactive dashboard can allow the user to view data in a more efficient way by hiding what is unnecessary and potentially tell a bet...

Dashboards,Strategy,TechnicalFeatures,TipsTricks

How to Web Scrape - Alteryx

Jul 7, 2023 Habeeb Gayle | www.thedataschool.co.uk

Web scraping is the process of extracting data from websites.

Dashboards,Strategy,TechnicalFeatures,TipsTricks

Understanding the Tools Blend Your Data Using the JOIN Tool in Alteryx

Jul 6, 2023 Jessica Kwan | www.thedataschool.co.uk

In my previous blog, I covered the UNION tool and how to blend data using the UNION tool. Another tool that blends data in Alteryx is the JOIN tool. The JOIN tool can combine two inputs based on either common field(s) or based on record position. ...

WorkoutWednesday,WOW2023,DualAxis,DynamicZoneVisibility,INDEX,ParameterActions,Path,ShowHideObjects,SIZE,TableCalcs,TableCalculations,Total,Week27,WindowMax,Window_Min

How to Manipulate Dates in Alteryx

Jul 6, 2023 Nick Cassara | playfairdata.com

Whether you work with data as a hobby or as your career, it is all but certain that you will…The post How to Manipulate Dates in Alteryx appeared first on Playfair Data.

Advanced,DataPrep,TipsTricks

3 Ways to Optimize Tableau Workbook File Size

Jul 6, 2023 Felicia Styer | playfairdata.com

Are you running into file size issues when you attach Tableau workbooks to emails? Has IT asked your team to…The post 3 Ways to Optimize Tableau Workbook File Size appeared first on Playfair Data.

Dashboards,Strategy,TechnicalFeatures,TipsTricks

Re-viz Discovery Dashboard

Jul 6, 2023 Donna Coles | donnacoles.home.blog

For the next few Workout Wednesdays, the coaches will be revisiting old challenges – retro month! Erica kicked the month off with this challenge, to recreate Ann Jackson’s challenge from 2018 Week 38. I completed this challenge at the time (see he...

WorkoutWednesday,WOW2023,DualAxis,DynamicZoneVisibility,INDEX,ParameterActions,Path,ShowHideObjects,SIZE,TableCalcs,TableCalculations,Total,Week27,WindowMax,Window_Min

Understanding the Tools Blend Your Data Using the Union Tool in Alteryx

Jul 5, 2023 Jessica Kwan | www.thedataschool.co.uk

The Union tool takes two or more datasets with similar structures and stacks the data one on top of the other.  Notice how the Union tool has a grey anchor on the left with two angle brackets (»). This means that there can be more than two dataset...

TableauParameters

Teaching for the Stars

Jul 5, 2023 Vivian Ng | www.thedataschool.co.uk

Something I’ve learned a lot about during training (and post-training as well) is how to teach. It’s a bit different from doing a presentation, though there is some overlap. I just did some teaching recently, so I decided to write about my experie...

TableauParameters

SQL 101

Jul 5, 2023 Olivier Newman | www.thedataschool.co.uk

Today DS40 had our first session on SQL “Structured Query Language “.  Arguably the most commonly used data tool it is an important skill to pick up at the data school both for placements and post-data school life. SQL allows us to query data sets...

TableauParameters

Interactivity Using Parameter Actions to Highlight Selected Fields in Ta...

Jul 5, 2023 Afnan Foyez | www.thedataschool.co.uk

In Tableau you can set up parameter actions in order to highlight fields selected by the user.In this blog we will cover the steps required to do so.

TableauParameters

How to make a Circle Timeline Chart - Tableau

Jul 5, 2023 Habeeb Gayle | www.thedataschool.co.uk

Circle timeline charts are useful for showing discrete values of varying size across a time period.

TableauParameters

Changing the Bar Colour Size and Label using Parameters

Jul 5, 2023 Asha Daniels | www.thedataschool.co.uk

I explain how to change the size, colours and labels of bars in bar charts depending on the parameter.

TableauParameters

Change the Automatic Color Palette on Tableau

Jul 5, 2023 Sabrina Vazquez | www.thedataschool.co.uk

Why did my personal color palette upload to automatic?!

TableauParameters

Parameter-Driven Reference Lines in Tableau

Jul 5, 2023 Ollie Linley | onenumber.biz

A reference line is a useful worksheet element. It’s a simple tool - just a line based on a single value that we want to reference in our views.

TableauParameters

Tableau Prep Builder for Beginners Going from Raw Data to Dashboard

Jul 5, 2023 Gavin Holzworth | interworks.com

Have you ever wondered how Tableau Prep Builder can help your data flow game? I’m a beginner at using Tableau Prep, and I think having a low-fidelity tutorial is the perfect way to help new users understand the platform’s basic of use cases. In th...

Data,Dashboarding,dataprep,Tableau,TableauDesktop,TableauPrep

Skills for Conflict Resolution in Consulting

Jul 5, 2023 Debbie Yu | interworks.com

At InterWorks, we pride ourselves on making genuine connections with our clients and delivering excellent value and service at the same time. We’ve written about our approach to great consulting in a blog series, and I’ve called out the particular...

Data,consulting,ProfessionalDevelopment,skills

Create 10 ACTIONABLE IMPACTFUL KPIs in Tableau

Jul 4, 2023 VizWiz (noreply@blogger.com) | www.vizwiz.com

What is a KPI?KPIs are measurable values that indicate how well a business is performing in achieving its key objectives and goals. They provide a clear and concise snapshot of critical areas within a business. KPIs help to:Monitor progressIdentif...

barchart,bignumbers,color,comparison,context,dashboard,howto,keyperformanceindicators,kpis,levelofdetail,linechart,LOD,performance,sparkline,tableau

Summarising YouTube Video Descriptions with Alteryx and OpenAI

Jul 4, 2023 Ollie Matthews | www.thedataschool.co.uk

The aim of this project was to leverage the natural language processing power of Open AI’s GPT language model in order to automatically generate video descriptions for our YouTube channel. This was achieved using Alteryx and Google Sheets. Here yo...

Formatting Time Only in Alteryx

Jul 4, 2023 Lorenz Nacilla | www.thedataschool.co.uk

Having completed Alteryx challenge 106 recently, I thought I’d make a small blog in giving a small tip in formatting time only in Alteryx.

Alteryx Community Challenge 1

Jul 3, 2023 Nitesh Shrestha | www.thedataschool.co.uk

The Alteryx community challenges offer opportunities to improve your Alteryx skills. I have decided to participate in these challenges on a regular basis. So, to begin, I have completed Challenge #1: Join to Range, and would like to share a brief ...

Monday Music Musings Jeff Becks Rock Roll Party Part 1

Jul 3, 2023 Steve Wexler | www.datarevelations.com

Welcome to my weekly journeys into terrific music performances. There won’t be any data viz stuff here, just some good music. About ten years ago I played a gig in Massachusetts, way too far to drive home. Although I got to my hotel around 1 AM, I...

BusinessVisualizations,MusicMusings,SportsandEntertainment,ImeldaMay,JeffBeck,LesPaul,music

Understanding the Tools Oh Peaches Peaches Peaches Its the Alteryx Brow...

Jun 30, 2023 Jessica Kwan | www.thedataschool.co.uk

Last month, I finally watched the Super Mario Bros. movie and Jack Black’s song as Bowser was just so great that it inspired the title of this blog!

Formatting,Tableau

The Design Element of a Business Dashboard

Jun 30, 2023 Afnan Foyez | www.thedataschool.co.uk

Creating an effective business dashboard requires careful consideration and attention to detail. Unlike personal project dashboards meant for public display on Tableau Public for example, a business dashboard is tailored to a specific audience and...

Data,BISolutions,dashboards,SolutionDesignSprint,workshop

Pride Month Vizzes

Jun 30, 2023 Elaine Yuan | www.thedataschool.co.uk

Happy Pride Month! ❤️🧡💛💚💙💜🖤

Formatting,Tableau

Tableau Outline Spatial Function

Jun 30, 2023 Marc Reid | datavis.blog

Version 2023.2 of Tableau adds two new spatial functions: OUTLINE and SHAPETYPE. This post introduces the OUTLINE function with a few example use cases including the use of set actions and map layers.

Spatial,outline,polygons,Tableau

Understanding the Tools Select Tool I Choose You

Jun 29, 2023 Jessica Kwan | www.thedataschool.co.uk

As a general rule of thumb, after inputting the dataset into Alteryx, the starter tool is the Select tool.

Data,BISolutions,dashboards,SolutionDesignSprint,workshop

Too Much Tuna

Jun 29, 2023 Lex Devlin | www.thedataschool.co.uk

KPI Dashboards. We love them because they show us heaps of business intelligence all at once. It can however get quickly overwhelming to have dozens of KPIs on a single dashboard. Too much of a good thing, such as tuna on a tuna sandwich, can turn...

Data,BISolutions,dashboards,SolutionDesignSprint,workshop

How to Write a User Story

Jun 29, 2023 Nitesh Shrestha | www.thedataschool.co.uk

The primary focus in dashboard design lies in answering the questions of the business issue, making it a crucial aspect of the project. Therefore, it becomes vital to determine the user’s intentions and the specific answers they seek. During the f...

Data,BISolutions,dashboards,SolutionDesignSprint,workshop

How I Understand LODs

Jun 29, 2023 Tom Gould | www.thedataschool.co.uk

LODs in Tableau can be very difficult to wrap your head around. In this blog I outline my way of understanding the syntax behind them so that I can hopefully help others!

Data,BISolutions,dashboards,SolutionDesignSprint,workshop

Critiquing my application dashboards.

Jun 29, 2023 Terrence Miller | www.thedataschool.co.uk

My 1st month of the data school is coming to an end and this seems like a great time to look back at the dashboards I used for my applications and pick them apart. I felt really good about both of them at the time I submitted each and felt like th...

Data,BISolutions,dashboards,SolutionDesignSprint,workshop

Alteryx Core Exam Tips

Jun 29, 2023 Tabitha Diaz | www.thedataschool.co.uk

Last week, I had the opportunity to take both the Alteryx Foundational Micro-Credential and the Designer Core Certification. As someone who hasn’t taken an exam of over two hours in 10 years, I was nervous to begin. Here are some tips I can share ...

Data,BISolutions,dashboards,SolutionDesignSprint,workshop

Develop Purpose-Built BI Dashboards with InterWorks Solution Design Sprint

Jun 29, 2023 Anna Hadzic | interworks.com

Let’s be honest, most things dashboard developers build for their users don’t meet those users’ needs. There’s a reason Googling “dashboards are dead” can lead you down a rabbit hole compelling enough to sack the whole team and dust off your own S...

Data,BISolutions,dashboards,SolutionDesignSprint,workshop

Develop Purpose-Build BI Dashboards with InterWorks Solution Design Sprint

Jun 29, 2023 Anna Hadzic | interworks.com

Let’s be honest, most things dashboard developers build for their users don’t meet those users’ needs. There’s a reason Googling “dashboards are dead” can lead you down a rabbit hole compelling enough to sack the whole team and dust off your own S...

Data,BISolutions,dashboards,SolutionDesignSprint,workshop

Antarctic Ice Extent

Jun 29, 2023 Donna Coles | donnacoles.home.blog

It was Luke’s turn to set the #WOW2023 challenge this week and he chose to focus on remaking a visualisation relating to the change in the Antarctic Sea Ice, inspired by charts created by Zach Labe. The challenge involved the use of extensive calc...

WorkoutWednesday,WOW2023,BaselineDate,datenormalise,DualAxis,Formatting,MovingAverage,TableCalcs,Week26,WINDOW_AVG

Understanding the Tools Manually Enter Data Using the Text Input Tool

Jun 28, 2023 Jessica Kwan | www.thedataschool.co.uk

Use Case:

TableauRelationships,Data

Understand Your Row Level

Jun 28, 2023 Tristan Kelly | www.thedataschool.co.uk

Here’s a quick thought I’d like to share:

TableauRelationships,Data

How to make a TagWord Cloud

Jun 28, 2023 Olivier Newman | www.thedataschool.co.uk

When first applying to the data school I had the idea of making a word cloud. To enable the to viewer to easily see which Majors and Major categories had how many students. Being new to Tableau I spend several hours trying to do it. The end produc...

TableauRelationships,Data

Fixed LODs

Jun 28, 2023 Olivier Newman | www.thedataschool.co.uk

Level-of-detail calculations known as LODs allow us to control the granularity of our data.

TableauRelationships,Data

Client Project Management What to expect in a client project week

Jun 28, 2023 Nitesh Shrestha | www.thedataschool.co.uk

As we are in the 4th week of the training, we are learning how client projects are structured in the data school. Although a few weeks are remaining for our client project to start, we are grasping the concepts and strategies to efficiently implem...

TableauRelationships,Data

Back to Basics Alteryx Keyboard Shortcuts

Jun 28, 2023 Jessica Kwan | www.thedataschool.co.uk

Inspired by DSNY 4’s Sabrina Vasquez and her blog about Tableau keyboard shortcuts, I thought it would be a good idea to share some keyboard shortcuts for Alteryx Designer as well!

TableauRelationships,Data

Why Tableau Created Relationships

Jun 28, 2023 Eric Parker | onenumber.biz

In 2020, Tableau unveiled a new way to combine multiple tables of data in Tableau Desktop: a Relationship. Billed as “smart joins”, relationships provide the capability to merge multiple tables of data horizontally on shared dimensions (like a joi...

TableauRelationships,Data