Tableau – How to hide Null in the filter option?

Aug 24, 2022 Sreekanth Arathil Condoth | www.thedataschool.co.uk

In the databases, sometimes we confront with Null values. While creating Viz, they can be hidden by simply filtering them out. But when we provide the filter option to the user, the Null is still displayed in the selection.

Data,Performance,relationships,Tableau,Tableaurelationships,VizQL

Snowflake - Connecting The Snowflake Server To Tableau

Aug 24, 2022 Maha Hussari | www.thedataschool.co.uk

When the dataset is in snowflake, instead of trying to download the data into an excel, save it and then load it up into tableau. It is much easier to directly connect snowflake into tableau.

Data,Performance,relationships,Tableau,Tableaurelationships,VizQL

Snowflake 101

Aug 24, 2022 Maha Hussari | www.thedataschool.co.uk

Beginner to snowflake? Lets learn the basics of snowflake!

Data,Performance,relationships,Tableau,Tableaurelationships,VizQL

Set Actions in Tableau. Basic examples

Aug 24, 2022 Ana-Casiana Tarita | www.thedataschool.co.uk

In response to a user action in the visualization, set actions alters the values of an existing set. Set Actions are really important if you want to analyze multiple fields in a set.

Data,Performance,relationships,Tableau,Tableaurelationships,VizQL

SQL Basics In Snowflake - Part 1

Aug 24, 2022 Maha Hussari | www.thedataschool.co.uk

SQL in snowflake - how to structure your code!

Data,Performance,relationships,Tableau,Tableaurelationships,VizQL

How to Make a Set Variance Chart on Tableau

Aug 24, 2022 Zachary Ryan | www.thedataschool.co.uk

We were playing around with sets and parameter actions today and found out about this pretty fun chart called a variance. Learn how to make one here!

Data,Performance,relationships,Tableau,Tableaurelationships,VizQL

How To: Show/Hide Marks

Aug 24, 2022 Gerda Staurylaite | www.thedataschool.co.uk

A step-by-step guide on how to make this particular chart.

Data,Performance,relationships,Tableau,Tableaurelationships,VizQL

Dynamic Title

Aug 24, 2022 Pooja Srivastava | www.thedataschool.co.uk

In this blog, we will talk about dynamic titles. So, what is dynamic title? Dynamic title is when title or part of title gets changed based on user click. Perfect example of dynamic title would be when you want to change date based on user selecte...

tableau,tableau-server,dashboard,extension,data-visualization

Don't Forget Your Nested Calculations!

Aug 24, 2022 Lauren Halliwell | www.thedataschool.co.uk

This week, we were challenged to recreate many Workout Wednesday visualisations, on either table calculations or parameters. This blog is about the former.

Data,Performance,relationships,Tableau,Tableaurelationships,VizQL

Data Sources 101 In Tableau

Aug 24, 2022 Maha Hussari | www.thedataschool.co.uk

Want to know how to input, close and replace new datasets in tableau? This is the blog for you!

Data,Performance,relationships,Tableau,Tableaurelationships,VizQL

Custom Views in Tableau Server

Aug 24, 2022 Finn Charlton | www.thedataschool.co.uk

Learn how Custom Views in Tableau Public can save you and your clients time.

Data,Performance,relationships,Tableau,Tableaurelationships,VizQL

Alteryx Core Certification

Aug 24, 2022 Ben Winsey | www.thedataschool.co.uk

A Guide to the Alteryx Core Certification

Data,Performance,relationships,Tableau,Tableaurelationships,VizQL

Tableau Relationships: Performance – Speed and Cardinality

Aug 24, 2022 Sebastian Deptalla | interworks.com

It may happen that we work with really big tables that are not just a few rows but millions or even billions of rows. Tableau’s VizQL’s SQL (what a beginning of a sentence!) has to query all these tables, and that takes time. When we…The post Tabl...

Data,cardinality,Performance,relationships,Tableau,Tableaurelationships

Tableau Relationships: Performance – A Few Introductions

Aug 24, 2022 Sebastian Deptalla | interworks.com

From here on out (at least for a few posts), we will have a look into the Performance Options of Relationships that are shown when we design a relation between two tables. If you have no idea what I am talking about, chances are that…The post Tabl...

Data,Performance,relationships,Tableau,Tableaurelationships,VizQL

How to Create a Two-Level Drill Down in Tableau

Aug 23, 2022 VizWiz (noreply@blogger.com) | www.vizwiz.com

There are tons of ways to create a single level drill down, but if you’re having issues creating a second drill down, this video is a guaranteed way to help you fix this problem.Additional video - Single Level Drill Down  ...

action,barchart,boolean,calculatedfield,chart,color,datavisualization,drilldown,filter,formatting,graph,howto,howtodrilldown,interactive,parameter,parameteraction,tableau,tip

Tips for using the Tableau Tooltip Tool

Aug 23, 2022 Beau Foletti | www.thedataschool.co.uk

Tooltips are a powerful way to allow users to find out more information about a visualisation on Tableau. They function by either hovering or functioning over a data point. The tooltips hold whatever information the creator wants. They can be used...

tableau,tableau-server,dashboard,extension,data-visualization

Separating Legends

Aug 23, 2022 Beau Foletti | www.thedataschool.co.uk

Tableau gives users an option to separate measures, making it easier to format different fields all in the same chart. An easy technique to make it clearer for users to distinguish different values/measures.

tableau,tableau-server,dashboard,extension,data-visualization

How to Aggregate Data in Tableau Prep in under 5 minutes

Aug 23, 2022 Ana-Casiana Tarita | www.thedataschool.co.uk

Tableau Prep is very useful when it comes to quick analyzing data. It is much more easier than Alteryx and it can take you less than 5 minutes to do everything.

tableau,tableau-server,dashboard,extension,data-visualization

How To Switch Between Multiple Charts With Parameters

Aug 23, 2022 Tristan Kelly | www.thedataschool.co.uk

After a challenging week of Alteryx exams, at The Data School we have ‘pivoted’ back to Tableau Desktop and have begun to explore more advanced tools within the program. One of my personal favorites so far has been parameters because it has allowe...

tableau,tableau-server,dashboard,extension,data-visualization

Format Borders and Lines

Aug 23, 2022 Peter Hajnal | www.thedataschool.co.uk

This blogpost is as the title gives it away about basic formatting tips in the format borders and format lines pane in Tableau. There’s no universal way to format charts, it will depend on individual use cases, but I will show you how to format th...

tableau,tableau-server,dashboard,extension,data-visualization

Desktop vs Web Editor (tableau)

Aug 23, 2022 Bridget Ama Boateng | www.thedataschool.co.uk

What is the difference between tableau desktop vs tableau web editor?

tableau,tableau-server,dashboard,extension,data-visualization

Calculation Refresh Part One

Aug 23, 2022 Kerstin Möller | www.thedataschool.co.uk

After 78 days in the Data School i refresh my knowledge about calculations.

tableau,tableau-server,dashboard,extension,data-visualization

Major Elements for Tableau Update Adds Managed Databases, Easy Scriptabi...

Aug 23, 2022 Zsolt Palmai | medium.com

In its biggest update yet, Elements for Tableau — Starschema’s write-back and dashboard collaboration extension — expands its feature set to enable even easier and deeper integration into workflows. For organizations of all kinds and sizes, these ...

tableau,tableau-server,dashboard,extension,data-visualization

Upserting Data in Matillion

Aug 23, 2022 Scott Perry | interworks.com

In my last blog, I showed you how to iterate through a variable to bring multiple tables into the raw layer of your data warehouse. Today, I’m going to build on that concept by creating a DIM table and performing an UPSERT. Now, to start,…The post...

Data,Matillion,TechnicalTuesday,Upserting

Understanding your data

Aug 22, 2022 Arnold Quarcoo | www.thedataschool.co.uk

A short blog post on the explain data tab in Tableau.

The Table Calculation Pane in Tableau

Aug 22, 2022 Cammy Phillips | www.thedataschool.co.uk

A few table calculation tips, including some ideas about the table calculation pane

Tableau : Advanced Conditional Formatting

Aug 22, 2022 Ana-Casiana Tarita | www.thedataschool.co.uk

Today we are looking to create the following table which has an advanced conditional formatting option in Tableau.

It's All About SQL

Aug 22, 2022 Pooja Srivastava | www.thedataschool.co.uk

This is the time to talk about one of my favorite topic YASSS it’s SQL.

Alteryx Core - How to Pass

Aug 22, 2022 Lauren Halliwell | www.thedataschool.co.uk

For a free online exam, that you can resit as many times as you would like, the Alteryx core exam is not as easy as you would think. The questions can be tricky, understanding what the question is asking is key, as well as making sure to keep trac...

VOTD - How to get Viz of the Day

Aug 22, 2022 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 Pictured above are VOTDs from Will Sutton, Ethan Lang, Nicole Klassen, Luke Abraham, Sam Parsons, Chimdi Nwosu, Johanna Josodipuro, Fuad Ahmed, Julianne Kelso, Ha PL, Priya Padham, and Saverio RocchettiIn this blog post, I will be dis...

Tableau

Including a script of code to Tableau Prep

Aug 21, 2022 Viktoria Von Laer | www.thedataschool.co.uk

Including a script of code to Tableau Prep ( example with a python script, written in Jupyter Notebook)

Heat Table with a Dimension

Aug 19, 2022 Tanya Fischer | www.thedataschool.co.uk

Let’s say you have a table that shows the profit in each region for different segments of you store, just like that:

Alteryx Micro-Credential Certification | Taking it at the start of your ...

Aug 18, 2022 Robbin Vernooij | www.thedataschool.co.uk

Data School Cohort 34 (DS34) has had the pleasure of starting their Alteryx journey very recently and we set them a surprise challenge at 4 pm on a Wednesday after having worked with Alteryx for just 3.5 days without any particular Micro-Credentia...

Data,extracts,logicallayer,physicallayer,relationships,Tableau,Tableaurelationships,tables

How to Add Labels to the Beginning and End of Bars in Tableau

Aug 18, 2022 Eric Parker | onenumber.biz

There are three certainties in life; death, taxes and running out of space on your dashboard.

Design

Tableau Relationships: Extracts

Aug 18, 2022 Sebastian Deptalla | interworks.com

The new data model brought us the Logical Layer, from which we can draw specific tables without being forced to load the data from all the related tables. Remember, with traditional joins, all sheets that worked with that join had to load the full...

Data,extracts,logicallayer,physicallayer,relationships,Tableau,Tableaurelationships,tables

Analyzing Seasonality with Cycle Plots

Aug 17, 2022 VizWiz (noreply@blogger.com) | www.vizwiz.com

Cycle plots are exceptionally useful for analyzing seasonality in time series data. In this video, I walk you through two examples that show the limitations of traditional time series analysis and two examples of how cycle plots overcome these pro...

analysis,calculatedfield,change,color,context,cycleplot,difference,howtocreateacycleplot,linechart,referenceline,seasonality,tablecalculation,tableau,timeseries,tip,variance

How to: Variance Chart

Aug 17, 2022 Ben Mangel | www.thedataschool.co.uk

What is an variance chart? It shows the difference from, for example the sales, of a selected category to the other categories. It could look like this:

Design

Data School Roundup - August 1-14, 2022

Aug 17, 2022 Andy Kriebel | www.thedataschool.co.uk

Check out these 75 tips from our Data School consultants covering the first two weeks of August

Design

Can you compare the latest month to the prior X months average?

Aug 17, 2022 Donna Coles | donnacoles.home.blog

Lorna set this challenge this week to test some LoD fundamentals. My solution has a mix of LoDs and table calculations – there weren’t any ‘no table calcs’ allowed instructions, so I assumed they weren’t off limits and in my opinion, were the quic...

Snowflake: The Basics

Aug 16, 2022 Imogen Emmett | www.thedataschool.co.uk

An introduction to Snowflake…and no not the icy kind

programming,tableau,tableau-extension,dashboard

Music Blog: Unique Guitarists

Aug 16, 2022 Finn Charlton | www.thedataschool.co.uk

I need a break from the work blogs, so thought I’d share some music I love. I’ve themed this one as “unique guitarists”: guitarists who have a unique life story and way of playing.

programming,tableau,tableau-extension,dashboard

More Than an Analyst

Aug 16, 2022 Carol Mhlanga | www.thedataschool.co.uk

The assumption of a data analyst is that we need to be great at being technical and produce visually pleasing reports. That is a very important aspect of the job, however, its not the only important part of being a consultant.  Instead, we need to...

programming,tableau,tableau-extension,dashboard

Introducing TabCSS, Your Shortcut to Styled Backgrounds in Tableau

Aug 16, 2022 Rody Zakovich | medium.com

TabCSS is a new extension I wrote to help Tableau developers create awesome dashboard designs quickly and easily by adding styled backgrounds to dashboard objects and containers without having to use external tools and background image...

programming,tableau,tableau-extension,dashboard

A Definitive Guide to Python Stored Procedures in the Snowflake UI

Aug 16, 2022 Chris Hastie | interworks.com

Snowpark for Python is the name for the new Python functionality integration that Snowflake has recently developed. At the Snowflake Summit in June 2022, Snowpark for Python was officially released into Public Preview, which means anybody is able ...

Data,python,Snowflake,storedprocedures

Why SQL and Mini Snowflake Intro

Aug 15, 2022 Karen D. Hamilton | www.thedataschool.co.uk

You recently learned how to drive and all of your cars have had automatic transmission.  You land a driving job and one day management tells you sometimes you will have to drive manual transmission vehicles, depending on the client.

data-engineering,airbyte,data-integration,wrike,modern-data-stack