Nested LOD Window Max across a dimension but as an LOD

Sep 17, 2023 Terrence Miller | www.thedataschool.co.uk

Decided to challenge myself by doing what would be a pretty simple Window_Max as an LOD for a Workout Wednesday.

Dashboard Design Best Practices Whitespace

Sep 17, 2023 Tobias Fitschen | www.thedataschool.co.uk

Hello everyone! This blog post is about why and how you should use whitespace when designing dashboards in Tableau. So if you are interested in improving the accessibility of your dashboards stay tuned.

Ten Tableau Gauge Styles

Sep 17, 2023 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 I built my firstgauge chart in Tableau way back in 2017, only about a year after I startedworking with Tableau. Since then, I’ve created several other styles of gauges.Some of those have resulted in blog posts, while others were an attempt toaddr...

DataViz,How-To,Tableau

Viz Best Practice

Sep 15, 2023 Habeeb Gayle | www.thedataschool.co.uk

This blog will go through some of the best practice techniques when building a visualisation. Going over colour and chart choices as well as underlying data.

Culture,BestPeople,culture,InterWorks

Presentation Story Telling

Sep 15, 2023 Habeeb Gayle | www.thedataschool.co.uk

There are many different methods of telling a story to get across a point during a presentation. Many of these help to be a more engaging speaker and convey your message across with more focus.

Culture,BestPeople,culture,InterWorks

Historical Spotlight William Playfair

Sep 15, 2023 Adam Sultanov | www.thedataschool.co.uk

Born in Scotland in 1759, William Playfair is credited with inventing the bar chart, the pie chart, the line chart, and the area chart. In the 200 years since his death the field of statistical graphics has grown exponentially, but our use of visu...

Culture,BestPeople,culture,InterWorks

Why InterWorks

Sep 15, 2023 Sebastian Deptalla | interworks.com

My name is Sebastian, I am an Analytics Lead in Germany and I just celebrated my three year anniversary at InterWorks. My job today is to explain a few things for you about who we are. Why InterWorks? There are three groups of people who…The post ...

Culture,BestPeople,culture,InterWorks

Optimizing Tableau Relational Models With Row-Level Security

Sep 15, 2023 Jubail Caballero | interworks.com

Since Tableau’s release of relational data sources (AKA, “Noodle”) and the introduction of a logical layer, conventional wisdom has carried over into leveraging both physical and logical layers when modeling Tableau data sources. Typically, we see...

Uncategorized,models,Optimization,Tableau

Can you show placeholders for a maximum of 6 goals

Sep 15, 2023 Donna Coles | donnacoles.home.blog

It was Lorna’s turn to set the challenge this week, based on a real world scenario she’s encountered with a colleague. The premise was to be able to show the progress, by country, against a maximum of 6 goals selected by the user. Placeholders for...

WorkoutWednesday,WOW2023,ATTR,COUNTD,FIXEDLOD,INDEX,SetControl,Sets,TableCalcs,Week37

New Kid on the Document Part 1 - Alteryx

Sep 14, 2023 Vivian Ng | www.thedataschool.co.uk

Handoff vs. Hands-off

Data,Coding,Logic,TheQuestGame,Typeform

First experience on Alteryx

Sep 14, 2023 Jules Claeys | www.thedataschool.co.uk

I finally got to use Alteryx for the first time as part of the Dataschool this week! It was very exciting to learn about another data cleaning tool. After many data prep challenges done on tableau prep, I feel comfortable with more advanced challe...

Data,Coding,Logic,TheQuestGame,Typeform

How a Fortune 10 Company Builds Great Tableau Dashboards Faster Than You

Sep 14, 2023 Hanna Bekefi | medium.com

I’m going to give it away right at the top: they do it by using something called a “design system.” And not just any hodge-podge of nebulous and lofty principles, but “a complete set of standards intended to manage design at scale using reusable c...

bi-dashboards,design-and-development,data-visualization,tableau,design-systems

The Quest Game Exploring My Favorite Typeform Capabilities

Sep 14, 2023 Bridget Marrara | interworks.com

As a Marketing Research and Analytics student at Oklahoma State University, I find exploring a new survey platform very exciting. When I was given my first Typeform project, I knew I needed to start getting familiar with the Typeform interface. Ex...

Data,Coding,Logic,TheQuestGame,Typeform

The Power of Dashboard Wireframes

Sep 13, 2023 Afnan Foyez | www.thedataschool.co.uk

A dashboard wireframe is a visual representation or sketch of how you intend to design a dashboard, usually made at an early stage of the dashboard creating process.

bi-dashboards,design-and-development,data-visualization,tableau,design-systems

Tables in Tableau

Sep 13, 2023 Juhie Radia | www.thedataschool.co.uk

Blog to help excel users transition towards more visual views using Tableau

bi-dashboards,design-and-development,data-visualization,tableau,design-systems

Tableau Dummy Fields

Sep 13, 2023 Tabitha Diaz | www.thedataschool.co.uk

Ever work in Tableau and have all your bars unhighlight once a user selects one? Sometimes, this is exactly what you want your dashboard to do, but other times that might not be the case.

bi-dashboards,design-and-development,data-visualization,tableau,design-systems

Making a Butterfly Chart

Sep 13, 2023 Tabitha Diaz | www.thedataschool.co.uk

Butterfly charts are a great way to show a comparison between two values. In two recent Makeover Mondays, I have decided to build butterfly charts to visualize the data. What I love about butterfly charts is that they are fairly simple to create a...

bi-dashboards,design-and-development,data-visualization,tableau,design-systems

How can we replace the data source for existing charts in Tableau

Sep 13, 2023 Nitesh Shrestha | www.thedataschool.co.uk

There are various compelling reasons why you might find it necessary to replace the data source for your existing charts within Tableau. Perhaps you initially constructed your charts and dashboard using one data source, only to realize later that ...

bi-dashboards,design-and-development,data-visualization,tableau,design-systems

Formatting Numbers- Formatting Best Practices on Tableau

Sep 13, 2023 Sabrina Vazquez | www.thedataschool.co.uk

Use default properties to make formatting much quicker.

bi-dashboards,design-and-development,data-visualization,tableau,design-systems

Building a Box Whisker Plot

Sep 13, 2023 Lex Devlin | www.thedataschool.co.uk

My fellow Tableau wizard, I am thankful to have found you here, with your eyes keenly fixed upon the words of my blog. Tonight we will perform a powerful spell … we will summon a Box & Whisker plot. This spell will require several components, ...

bi-dashboards,design-and-development,data-visualization,tableau,design-systems

Basic Statistics Interquartile Range IQR

Sep 13, 2023 Lex Devlin | www.thedataschool.co.uk

Fellow Tableau wizards … by the power I possess, I shall herein bestow upon you the deep astral knowledge of … STATISTICS … and later on, the extraordinary capacity to construct a Box & Whisker plot … beware wizard, ye have been warned …

bi-dashboards,design-and-development,data-visualization,tableau,design-systems

Alteryx Challenge 210

Sep 13, 2023 Sakif Chowdhury | www.thedataschool.co.uk

Intermediate Alteryx challenges normally take several different types of tools to complete. Challenge #210 required tools for parsing, joining, and transforming.

bi-dashboards,design-and-development,data-visualization,tableau,design-systems

Puedes mostrar un mximo de KPIs

Sep 13, 2023 Rosario Gauna | rosariogaunag.wordpress.com

El propósito de este blog es proporcionar una guía paso a paso para abordar el desafío de la semana 37 de #WOW2023. En este desafío, pondremos en práctica la utilización de conjuntos (Sets). Los principales requisitos de este desafío son los sigui...

Espaol,CONTROLVISIBILTY,Sets

Can you show a Maximum of KPIs

Sep 13, 2023 Rosario Gauna | rosariogaunag.wordpress.com

The purpose of this blog is to provide a step-by-step guide to tackling the #WOW2023 Week 37 challenge. In this challenge, we will put into practice the use of Sets. The main requirements of this challenge are the following: Below I will share the...

English,ControlVisibility,Sets

Build a Custom Color Palette for Tableau

Sep 13, 2023 Ollie Linley | onenumber.biz

Have you ever needed to use your own colors in Tableau? Maybe you need to use your company’s colors, or a brand’s colors, but you’re not sure how to save those colors into Tableau for repeated use.

Design

What Does an IT Director Do

Sep 13, 2023 Blaine Stephens | interworks.com

The modern workplace is constantly evolving, and the need for experienced IT directors has never been greater. In this article, we’ll explore what an IT director does, and the skills and qualifications needed to be an IT director. Then, we’ll dive...

IT,DaaS,Director

Visualizing Uncertainty with Longitudinal Likert Data

Sep 13, 2023 Steve Wexler | www.datarevelations.com

Helping your stakeholders see and understand margin of error in survey data. A deep thanks to Anna Foard and Jonathan Drummey for their assistance, Ben Jones for the foundational work behind for my initial explorations, and Ryan Corser for asking ...

BusinessVisualizations,VisualizingSurveyData

MakeoverMonday Week 37 - First time home buyers in the UK are being shut...

Sep 12, 2023 VizWiz (noreply@blogger.com) | www.vizwiz.com

Have you ever heard of the “sunken cost fallacy”? If you haven’t, it is where you continue a task based on previously invested resources, such as time, despite new evidence suggesting that the cost, beginning immediately, outweighs the expected be...

animation,areachart,barbell,charts,houseprices,howto,labels,linechart,pages,stackedareachart,storytelling,tableau,UK,unitedkingdom

How to Calculate Weekday-Only Sales in Tableau

Sep 12, 2023 VizWiz (noreply@blogger.com) | www.vizwiz.com

Have you ever wondered how to compare sales performance between two sets of weekdays? In this video, I’ll show you how to calculate and compare sales for the last 10 weekdays against the prior 10 weekdays—all while excluding weekends. What You Wil...

aggregation,barchart,bulletgraph,comparison,howto,last,last10,previous,tablecalculation,tableau,weekday,weekends,window_sum

Likert Chart

Sep 12, 2023 Juhie Radia | www.thedataschool.co.uk

Steps on making a Likert Chart, which are useful charts for visualising survey data.

Data,ActiveDirectory,Azure,ETL,Matillion,OpenID,security,SSO

How to Make Current and Previous Financial Year in Tableau

Sep 12, 2023 George Ledger | www.thedataschool.co.uk

When working on real life cases with data across time periods, it is important to know that company’s do not often work according to the calendar year. For example, in the finance industry most companies work within the Financial Year (1st April t...

Data,ActiveDirectory,Azure,ETL,Matillion,OpenID,security,SSO

InterWorks Blog Roundup August 2023

Sep 12, 2023 Mark Cordeiro | interworks.com

Welcome, everyone, to the recap of our August blogs. You may look at your calendars and say, “Mark, my friend, it’s September 12. We’re almost halfway through September. Why is this recap so late?” That, my dear reader, is an astute question. It a...

Data,AWS,Dataiku,PYD,Snowflake,Tableau

Embrace the Data Dance OpenID SSO Lights Up Your Matillion ETL Experience

Sep 12, 2023 John Saunders | interworks.com

Step right up, data enthusiasts! Get ready to kick up your heels and waltz into a world of simplified access, unbridled fun and electrifying efficiency with OpenID Single Sign-On (SSO) for Matillion ETL! Prepare to groove to the beat of seamless a...

Data,ActiveDirectory,Azure,ETL,Matillion,OpenID,security,SSO

No-Coding ETL in Azure vs. Alteryx

Sep 11, 2023 Frederik Egervari | www.thedataschool.co.uk

Azure Data Factory (ADF) is a tool within Microsoft’s Cloud Platform that provides an environment for executing data transformations. While it integrates well with coding-based transformation tools such as Databricks, Python Notebooks, etc., it al...

Basics of Parameter

Sep 11, 2023 Charles Yi | www.thedataschool.co.uk

After covering a few things in Alteryx, we are back to Tableau! This post will be all about parameters. What is a parameter? The textbook Tableau definition of a parameter is a workbook variable such as a number, date, or string that can replace a...

AuthorExperience,Dashboards,TipsTricks,UserExperience

Applying Modular Arithmetic to Group Data in Alteryx

Sep 11, 2023 Le Luu | www.thedataschool.co.uk

Multi-row Formula tool is one of my favorite tools because it’s very convenient in iterating each row in the table. I can control the data in the row from the previous rows, the current row and the next rows. In the final interview at The Data Sch...

The Ultimate Guide to Getting High Resolutions In and Out of Tableau

Sep 11, 2023 Rafael Simancas | playfairdata.com

What makes dashboards attractive, engaging, and thought-provoking? While data can craft a compelling narrative, the human eye is naturally drawn…The post The Ultimate Guide to Getting High Resolutions In and Out of Tableau appeared first on Playfa...

AuthorExperience,Dashboards,TipsTricks,UserExperience

Dynamic Zones for Custom Date Range Options in Tableau

Sep 11, 2023 Keith Dykstra | interworks.com

On a recent client project, my colleague Emily Miley and I found a practical use case for dynamic zones that I’ll be using often. If you’re unfamiliar with the dynamic zones feature, we’ve got you covered! Check out this blog post first and then c...

Data,dateranges,dates,DynamicZones,Tableau,TipsandTricks

Let Stakeholders Have Their Pie Eat it Too

Sep 11, 2023 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 Stakeholders (and the whole world if I am being honest) LOVE PIE CHARTS! If you do a Google image search for “dashboard template”, you’ll find some form of a pie chart (pie, donut, etc.) in nearly every single one. Or try going on Mid...

How-To,Tableau

What are Parameters in Tableau

Sep 10, 2023 Erin Potter | www.thedataschool.co.uk

A parameter is a workbook variable, such as a numerical value, date, or string, that has the capability to substitute a fixed value within a calculation, filter, or reference line.

Unlocking the Palette Deciphering Calculated Fields and Colors in Tableau

Sep 10, 2023 Samantha Fitzsimmons | www.thedataschool.co.uk

What is a Calculated Field?

Dashboard para Mtricas Preagrupadas

Sep 9, 2023 Rosario Gauna | rosariogaunag.wordpress.com

El propósito de este blog es proporcionar una guía paso a paso para abordar el desafío de la Semana 36 de #WOW2023. Este desafío se centra en la creación de un panel de visualización a partir de datos segmentados y preagrupados, con el objetivo pr...

Espaol,Filters,Parameter

Dashboard for Pre-aggregated Metrics

Sep 9, 2023 Rosario Gauna | rosariogaunag.wordpress.com

The purpose of this blog is to provide a step-by-step guide for tackling the #WOW2023 Week 36 challenge. This challenge centers around creating a visualization dashboard from pre-segmented and pre-grouped data, with the primary objective of counti...

English,Filters,Parameter,Pre-aggregated

Tableau Server and Tableau Cloud

Sep 8, 2023 Numa Begum | www.thedataschool.co.uk

Both platforms in Tableau are used to store visualisations, data sources and workflows however there are some key differences. Below you will find a summary of the points of difference.

Espaol,Filters,Parameter

Date Time Functions In Tableau Explained

Sep 8, 2023 Afnan Foyez | www.thedataschool.co.uk

Date and time are crucial aspects of data analysis in Tableau. They allow us to visualize time-related data effectively. In this blog post, we’ll explore some of the most essential date and time functions Tableau has to offer, along with real-worl...