Tableau Aggregator

Filters in Tableau Desktop and the Order in Which They Operate.

Mar 14, 2024 Tobias Colmer | www.thedataschool.co.uk

Do you have an abundance of filters applied? Not sure why they’re not returning the values you’d looked for? Look no further!

Blending

Mar 14, 2024 Jessica Kirk | www.thedataschool.co.uk

This week DS43 tackled blending as part of our client project. We’d been advised against blending in some cases as it can make things more difficult. In my previous blog, I spoke about optimising workbook performance. In Tableau’s optimizer featur...

Can you filter a small multiples chart

Mar 14, 2024 Donna Coles | donnacoles.home.blog

Erica set the challenge this week, and I’m not gonna lie, I found this tough. On the face of it, it looks like something I felt I should be ok at, but nuances cropped up as I was building that meant I often had to change tact and try something dif...

WorkoutWednesday,WOW2024,CustomSort,Dates,Fillinginblankswith0s,FIXEDLODs,INDEX,LOOKUP,ShowMissingValues,SmallMultiple,TableCalcs,Trellis,Week11

The Data Model

Mar 13, 2024 Calvin Gao | www.thedataschool.co.uk

Any part of a data analysis or data visualization requires the data itself to be connected. In Tableau, there are several ways of joining data if there are multiple files or multiple excel sheets to obtain an appropriate data model.

LevelofDetail,TableCalculations

Optimizing Relationships in Tableau

Mar 13, 2024 Calvin Gao | www.thedataschool.co.uk

While it is useful to have relationships in Tableau, it is important to understand how the joins work and how it can be optimized for performance.

LevelofDetail,TableCalculations

Long vs Wide Data Tables

Mar 13, 2024 Luke Bennett | www.thedataschool.co.uk

Data tables come in many different shapes and sizes, and sometimes it’s unclear which format is best for the analysis you want to do. In this post, I will explain the differences between wide and long format data tables and help you understand the...

LevelofDetail,TableCalculations

IntotheArchives Week 2 2017

Mar 13, 2024 Lorraine Ferrusi | www.thedataschool.co.uk

For week 2 , we’re creating a line chart to show sales over time and a bar chart to show the best performing categories based on their sales. You’ll also notice that the bar chart colour density corresponds with profit - more profit means the bar ...

LevelofDetail,TableCalculations

Dimension Measures Discrete and Continuous Values..oh my

Mar 13, 2024 Salome Grasland | www.thedataschool.co.uk

In Tableau, dimensions and measures are fundamental concepts that define the type of data being analyzed and how it can be used in visualizations. In Tableau’s Data pane, each field is categorized as either a dimension or a measure based on the na...

LevelofDetail,TableCalculations

Alteryx Challenges backtothebasics

Mar 13, 2024 Lorraine Ferrusi | www.thedataschool.co.uk

Sometimes it’s good to take a step back and practice the fundamentals. For this week I decided to go back to an earlier Alteryx Challenge that is labeled as ‘Foundation’.

LevelofDetail,TableCalculations

How FIXED Tableau Level of Detail Function Works

Mar 13, 2024 Ollie Linley | onenumber.biz

FIXED Level of Detail Functions (LODs) let you specify the level of detail you want to aggregate a particular measure at. This allows us to work around the natural limitations of the level of detail in the worksheet we’re working in.

LevelofDetail,TableCalculations

Tableau Hacks Range-Based Labels and Axis

Mar 13, 2024 Robin Schouten | interworks.com

If the axis on your viz can change from anywhere between single numbers to millions depending on your filters, it might sometimes be a bit annoying that the number formatting on the axis and labels doesn’t change. However, as always, there are way...

Data,Axis,labels,Tableau,TableauHacks

InterWorks Wins Four 2024 Matillion Emerald Partner Network Awards

Mar 13, 2024 Mark Cordeiro | interworks.com

On Friday, March 8, our partners at Matillion announced that InterWorks had won four of their Emerald Partner Network Awards: APAC Partner of the Year Customer Obsessed Individual Award: Paul Middlewick Individual Award: Chris Hastie We’re incredi...

Data,awards,EmeraldPartnerAward,Matillion

How To Build the Best Metrics in Tableau Pulse

Mar 13, 2024 Alex Madrigal | interworks.com

Tableau Pulse is here! The newest development of the Tableau world, launched and driven by artificial intelligence. If you haven’t seen much about what Tableau Pulse is and how it works, check out some of the blogs my colleagues and I have already...

Data,Metrics,Tableau,TableauPulse

Mind the Gap Choices and Problems with Missing Date Values in Tableau

Mar 12, 2024 Aaron Potts | www.thedataschool.co.uk

When working on a time-sensitive project for a client, I was tasked with making sure that missing values values were represented as zeros in various graphs. You might be thinking “Aaron, why not just click ‘Show Missing Values’ on the axis? This i...

Data,benchmarking,flattables,Performance,Snowflake,SQLServer,starschema

How Assist by InterWorks Supports Your Entire Data Stack

Mar 12, 2024 Dustin Wyers | interworks.com

Assist by InterWorks has been helping hundreds of InterWorks clients for years now. Assist got its beginnings as an on-demand, Tableau assistance offering connecting users directly with our consultants. Tableau users could easily hop on a call, wh...

Data,Alteryx,Assist,AWS,Azure,Databricks,Matillion,PowerBI,Snowflake,Support,Tableau

Comparing Query Performance of Star Schemas vs. Flat Tables

Mar 12, 2024 Mike Oldroyd | interworks.com

I was doing some performance tuning for a client recently, trying to improve their query performance from a SQL Server Parallel Data Warehouse. As part of the benchmarking process, I compared performance of a classic star schema (separate fact and...

Data,benchmarking,flattables,Performance,Snowflake,SQLServer,starschema

MakeoverMonday 2024 Week 11 - Housing Vacancies in America

Mar 11, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

This week I decided to turn Makeover Monday into a Workout Wednesday of sorts. I wanted to try a technique I haven’t used in a while…showing elements on either side of a rank and filtering out the rest.Want to give it a try? Get the data here.Req...

barchart,filter,housing,howto,interactive,MakeoverMonday,map,MSA,rank,setaction,tablecalc,tableau,vacancy,window_max

LWTDSL My Experience Teaching

Mar 11, 2024 Saampave Sanmuhanathan | www.thedataschool.co.uk

On the 15th of February DS43 taught clients and members of the public either introduction to Tableau or Introduction to Power Bi. The topic I chose to teach interactivity in Tableau Desktop. The lesson itself needed to be an hour and a half long c...

How-To,SeriesTips,Tableau

8 Random Tableau Tips Alias a Dimension Simple Table Sorting Scaling Pro...

Mar 11, 2024 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

If you’re a regular reader of thisblog, you know that Kevin regularly shares fantastic tips. I have only everwritten one tips blog myself so I figured I’d try my hand at another. So, inthis blog, I’m going to share 8 random Tableau tips that I lo...

How-To,SeriesTips,Tableau

Examples of Data Cleansing with SQL

Mar 10, 2024 Michał Mioduchowski | www.thedataschool.co.uk

Below are five SQL query examples demonstrating some of the most common data cleansing tasks improving the quality of your dataset.

data-engineering,data-quality,data,product-management,analytics

Creating user-defined function UDF with SQL

Mar 10, 2024 Michał Mioduchowski | www.thedataschool.co.uk

Some SQL environments allow to create so called user-defined functions (UDFs) to expand the coding capabilities beyond the default functions. Once specified, UDFs can be repeatedly called just like any other functions (SELECT, FROM etc.).

data-engineering,data-quality,data,product-management,analytics

Alteryx Challenge 9 Tutorial

Mar 10, 2024 Daniel Bostrom | www.thedataschool.co.uk

Today we’ll be going through Alteryx Challenge 9 together, which you can find here.

Espaol,Densification,ParameterAction,Time,Timeslots

Adding Dynamic Zoom functionality to Scatter Plots in Tableau

Mar 10, 2024 Michał Mioduchowski | www.thedataschool.co.uk

This guide provides step-by-step instructions for the advanced Tableau users to implement dynamic axis range adjustments in any scatter plot using parameters.

data-engineering,data-quality,data,product-management,analytics

Understanding Data Quality and Why Teams Struggle with It

Mar 10, 2024 Elliott Stam | medium.com

Data quality: the catch-all term for business logic, reliability, validity, and consistencyContinue reading on TDS Archive »

data-engineering,data-quality,data,product-management,analytics

How many patients were waiting at each 30-minute interval

Mar 9, 2024 Rosario Gauna | rosariogaunag.wordpress.com

For week 10 of #WOW2024, Yoshitaka Arakawa launched the challenge of designing a dashboard that shows the number of patients waiting in 30-minute intervals. This challenge will test your skills in managing date-times and using data densification t...

English,Densification,ParameterActions,Time,Timeslots

Cuntos pacientes esperan en intervalos de 30 minutos

Mar 9, 2024 Rosario Gauna | rosariogaunag.wordpress.com

Para la semana 10 de #WOW2024, Yoshitaka Arakawa lanzó el desafío de diseñar un tablero que muestre la cantidad de pacientes en espera en intervalos de 30 minutos. Este desafío pondrá a prueba tus habilidades en el manejo de fechas-horas y el uso ...

Espaol,Densification,ParameterAction,Time,Timeslots

Visualizing Time Series Data in Tableau

Mar 8, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

Last night I was invited to speak at the Chicago Tableau User Group about visualizing time series data. Other than spatial data, time series data is my favorite to visualize. There seem to be endless methods for making time series data useful for ...

barbell,beeswarmplot,Chicago,combinationchart,cycleplot,DNAchart,dotplot,dualaxis,enclosed,howto,line,sparkline,starburst,stripplot,tableau,TableauUserGroup,timeseries,tug,unithistogram

Transforming Power BI Feedback into a Dynamic Tableau Dashboard Bite-Siz...

Mar 8, 2024 Jeffrey Brian Thompson | www.thedataschool.co.uk

Switching from Power BI to Tableau Desktop on a project comes with its challenges and opportunities. Here’s how we navigated through client feedback to enhance a dashboard, distilled into actionable tips.