How to Build a Dot Plot with Average Lines in Tableau

Sep 22, 2022 Eric Parker | onenumber.biz

One of my favorite, underutilized charts is a dot plot! A dot plot is like a 2-D Scatter Plot and it’s great for visualizing ranges of data. Often, I’ll pop an average line on the chart for reference so the user can compare across categories as we...

TableauHow-Tos,TableauGeneralKnowledge

Weighted Averages in Tableau

Sep 21, 2022 Zachary Ryan | www.thedataschool.co.uk

In the world of Stats 101 today, we learnt about weighted averages and their benefit in scenarios with weightings. I share how you can bring that information into the likes Tableau!

TableauHow-Tos,TableauGeneralKnowledge

Stats: Using P-Values in Alteryx

Sep 21, 2022 Ana-Casiana Tarita | www.thedataschool.co.uk

What is a P-Value?

TableauHow-Tos,TableauGeneralKnowledge

Stats 101 : Z-Score

Sep 21, 2022 Peter Hajnal | www.thedataschool.co.uk

A Z-score is a numerical measurement that describes a value’s relationship to the mean of a group of values. Z-score is measured in terms of standard deviations from the mean. If a Z-score is 0, it indicates that the data point’s score is identica...

TableauHow-Tos,TableauGeneralKnowledge

Standard Deviation: Building Dynamic Charts That Spark Exploration

Sep 21, 2022 Sundus Jamaal | www.thedataschool.co.uk

Standard deviation chart is a good tool to explore your data and gain insights about outliers in your data. The standard deviations show how far a data point is away from the mean (average) and allows you to create segway’s for further analysis.

TableauHow-Tos,TableauGeneralKnowledge

How to make and use box plots

Sep 21, 2022 Bridget Ama Boateng | www.thedataschool.co.uk

Firstly what is a box plot?

TableauHow-Tos,TableauGeneralKnowledge

How to build a dynamic histogram

Sep 21, 2022 Nermine Obeng | www.thedataschool.co.uk

Histograms are great for summarising and showing you the distribution of values within your dataset. It does this by grouping these values into ‘bins’. There are also a variety of distributions: Normal, bimodal, right-skewed, left-skewed and rando...

TableauHow-Tos,TableauGeneralKnowledge

Control Charts in Tableau

Sep 21, 2022 Beau Foletti | www.thedataschool.co.uk

Control Charts are a way of studying how a process changes over time. It can be used to understand if a data point is consistent, or unpredictable.

TableauHow-Tos,TableauGeneralKnowledge

Comparing Change Between Time Periods with a Scatterplot

Sep 20, 2022 VizWiz (noreply@blogger.com) | www.vizwiz.com

Displaying change in a scatterplot can be challenging. One of the simplest methods, if you only have 2 time periods (e.g., this year vs. last year), is with a connected scatterplot. These are a fantastic visualization for showing the direction of ...

amountofchange,analysis,change,chart,connectedscatterplot,direction,scatterplot,significance,tableau,timeseries,tip,variance,yearoveryear

Making Macro's

Sep 20, 2022 Angelica Obi | www.thedataschool.co.uk

Simple, Batch and Iterative Macros…..WHAT ARE THEY ?!?!?!?!?!?!?! 😖

Data,python,Snowflake,SnowPark,storedprocedures

A Definitive Guide to Creating Python Stored Procedures in Snowflake usi...

Sep 20, 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,SnowPark,storedprocedures

Isolate a Map Component for Tableau

Sep 20, 2022 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

We’re once again excited to have Sarah Battersby, our honorary sister, joining us for the sixth post in her series about QGIS for Tableau users. Sarah has been a member of Tableau Research since 2014. Her primary area of focus is cartography, with...

DataViz,How-To,Maps,QGIS

#MakeoverMonday Week 38 - American Business Applications

Sep 19, 2022 VizWiz (noreply@blogger.com) | www.vizwiz.com

Well, this was a pretty epic fail. No, it was a really big fail. Those that tuned in to Watch Me Viz will be well aware of my struggles with this data set. I don’t know why. Maybe it was a concentration issue. I hope it was still useful to everyon...

barchart,business,comparison,dashboard,dashboardaction,filter,heatmap,hexmap,linechart,MakeoverMonday,parameter,startup,tableau,timeseries,trellischart,trends,UnitedStates,USA

Let these bars fly! ('Filled' Gantt Chart)

Sep 19, 2022 Heinrich Preuß | www.thedataschool.co.uk

Let’s imagine a use case where we want to compare different ranges, each starting above zero. For example, using the Superstore dataset, we could query the ranges of monthly profits for each year.The problem with this, however, is that these bars ...

How to compare a selected value with parameter action.

Sep 19, 2022 Ronaldo Licaj | www.thedataschool.co.uk

I decided to write this blog because the topic I am about to engage in has been bugging me ever since I created encountered it. I am talking about, how can someone compare a selected value with parameter actions in Tableau.

How to Add a Circle ●/○ to a Drilldown Bar Chart

Sep 19, 2022 Kerstin Möller | www.thedataschool.co.uk

An impressive graphic (Sample Superstore) in just a few steps!

How to Add a Circle ●/○ to a Drilldown Bar Char

Sep 19, 2022 Kerstin Möller | www.thedataschool.co.uk

Gant in Gant Chart with monthly min and max sales for each year

Sep 19, 2022 Viktoria Von Laer | www.thedataschool.co.uk

Gant in Gant Chart with min and max monthly sales per year

Fixed LODs Explained and How to Compare Current Year to Previous Year.

Sep 19, 2022 Sophie Higson | www.thedataschool.co.uk

This is a very useful and specific example of when to use Fixed LODs, with some theory behind what they are doing.

Fix an axis with a reference line

Sep 19, 2022 Ben Mangel | www.thedataschool.co.uk

Tableau offers the possibility to fix an axis. This has different advantages, but from it’s strenght, and that’s in the name, it ist fixed. It is always, always, always the same unless you change it.

Connected Dot Plot

Sep 19, 2022 Daniel Glasenapp | www.thedataschool.co.uk

A connected dot plot is a simple an very easy way to visualize differences between e.g. years, locations, categories etc.

How to Create an Empty Column Name in Tableau

Sep 16, 2022 Fabricia | tarsolutions.co.uk

Quick tip on how to create a blank field name in Tableau. Create a calculated field to be the blank column and save it as … Read moreSource

Tableau,calculatedfield,tableau

What’s a “Handmade Data Object” Anyway?

Sep 16, 2022 Istvan Korompai | medium.com

At the Starschema data visualization team, we pride ourselves on keeping up and engaging with the global dataviz community, including industry trends and publications. Sometimes, that inspires us to throw our tried-and-true, state-of-the-art tools...

watches,data-visualization,steampunk,dataviz,data-art

How to update a production file in Excel very carefully

Sep 16, 2022 Gwilym | gwilymlockwood.com

First things first – keeping and updating important data in an Excel file is not a good idea. There’s a massive risk of human error, which is why there’s a whole industry of information management tools that do a much better job at it. But sometim...

Uncategorized,csv,data,excel,versioncontrol

Prototyping in Figma Part 1: Why You Should

Sep 15, 2022 Lindsay Betzendahl | vizzendata.com

Note this post is an adaptation from my video series Figma + Tableau. I’ve been using Figma for about 2Continue reading

Figma+Tableau,Design,DesignThinking,DoubleDiamond,Figma,Iteration,Prototyping

Table Calculations vs. Level of Detail Expressions - % of Total

Sep 15, 2022 VizWiz (noreply@blogger.com) | www.vizwiz.com

In this video, I show you the difference between table calculations and level of detail expressions with the % of total calculation.

percoftotal,analysis,comparison,contextfilter,dimension,filter,howto,leveldetail,LOD,orderoperations,percenttotal,tablecalc,tablecalculation,tableau,tip,tutorial

How to remove the yellow highlight on a Chart when using a Dashboard fil...

Sep 15, 2022 John Power | www.thedataschool.co.uk

So to actually example what the title means:

Data,analysis,data,football,soccer,Tableau

How to Display Counts in Tableau

Sep 15, 2022 Eric Parker | onenumber.biz

“How do you display counts in Tableau?”

TableauGeneralKnowledge

Exploring Football Transfer Window Spending with Tableau

Sep 15, 2022 Matthew Whiteley | interworks.com

If we cast our minds back to April 2021, fans of football around Europe came together to squash the proposed “European Super League” idea, which would see a select few teams played against each other in a closed shop league with no relegation or p...

Data,analysis,data,football,soccer,Tableau

Can you create a common starting point?

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

Kyle set the challenge this week, revisiting his favourite topic – baseball. The aim was to build what I’ve often referred to as a ‘rocket chart’, as it charts progress from a single ‘launch’ date/point. However having had a quick google, I can’t ...

Presentation Tips and Tricks

Sep 14, 2022 Cammy Phillips | www.thedataschool.co.uk

A few tips and tricks to smash presentations

TableauGeneralKnowledge

How to view the Top 3 States by Sales within each Region using RANK

Sep 14, 2022 Nermine Obeng | www.thedataschool.co.uk

A step by step for how to build a chart that shows the top 3 states within each region. There are various way to do it but we will use the table calculation RANK to create this.

Data,hashkeys,Matillion,MD5,Snowflake

Figma + Tableau: Creating Menu/Navigation Panels

Sep 13, 2022 Lindsay Betzendahl | vizzendata.com

In a 2021 post I shared how to use “blank” or “empty” characters as a placeholder in a Tableau textContinue reading

Design,Figma,menuPanel,Navigation

Using a table calculation to work out the running total

Sep 13, 2022 Bridget Ama Boateng | www.thedataschool.co.uk

Right click and drag order date onto column and select year. Then Right click and drag order date onto column and select quarter. Create a calculated field and name it ‘running total calc’ (always name your calculated field to something you re...

Data,hashkeys,Matillion,MD5,Snowflake

Sparkline with indicator: Tableau calculations

Sep 13, 2022 Ana-Casiana Tarita | www.thedataschool.co.uk

Today we’ve learned how to create a Sparkline with Indicator in Tableau with “decrease” and “increase” feature for the previous and current month.

Data,hashkeys,Matillion,MD5,Snowflake

My First Client Project

Sep 13, 2022 Lauren Halliwell | www.thedataschool.co.uk

Last week, we (DS34) presented our first internal client project, ‘Allchains’, and throughout this process, I have learned a lot about how to work with very large amounts of data. The data set we were tasked to work with consisted of 91 different ...

Data,hashkeys,Matillion,MD5,Snowflake

How to: Rank Things Without Using A Rank Table Calculation

Sep 13, 2022 Gerda Staurylaite | www.thedataschool.co.uk

Here’s how to rank things without using Rank as a table calculation.

Data,hashkeys,Matillion,MD5,Snowflake

How to Highlight the Start and End of your Lines on Tableau

Sep 13, 2022 Zachary Ryan | www.thedataschool.co.uk

We learnt how to put circles at the start and end of a line chart. If you’re jealous of this and wanting to learn about how we did it, click this!

Data,hashkeys,Matillion,MD5,Snowflake

Creating MD5 Hash Keys in Snowflake via Matillion

Sep 13, 2022 Scott Perry | interworks.com

In my last blog, I discussed how to do an Upsert in Snowflake using Matillion. Using the same workflow, I will discuss how we got the key value using the MD5 hash functionality available in Snowflake and why we need to do it. The why…The post Crea...

Data,hashkeys,Matillion,MD5,Snowflake

Tiny Tableau Tips - Round 2

Sep 13, 2022 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 This is the second round of Tiny Tableau Tips…tips shared by others on social media and I’m just providing a more permanent home.  For more information, check out Round 1 of tips.  In Round 2, we will be featuring tips from just two f...

How-To,Tableau

#MakeoverMonday 2022 Week 37 - Berkshire Hathaway Holdings

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

During Watch Me Viz, I covered set actions, parameter actions, highlighting, boolean calculations, table calculation, dashboard layout, and I failed at a starburst chart (I couldn’t get the years to sort properly; I’ll post it when I figure it out...

barchart,berkshirehathaway,boolean,calculatedfield,dashboard,highlight,layout,MakeoverMonday,parameteraction,race,setaction,starburst,tablecalculation,tableau,WatchMeViz

My Experience as Project Manager: Tips and Advice

Sep 12, 2022 Imogen Emmett | www.thedataschool.co.uk

My tips and advice for being a successful Project Manager

Data,hashkeys,Matillion,MD5,Snowflake

Books for Your Business: The Phoenix Project

Sep 12, 2022 Scott Perry | interworks.com

I don’t know about you, but I love to read. I read for pleasure but, more relevantly to this series, I also read to learn. This is why I have decided to start a new series, “Books for Your Business.” I will discuss books I…The post Books for Your ...

Culture,IT,ProfessionalDevelopment,Reading,thephoenixproject

Webscrapping 101

Sep 11, 2022 Gerda Staurylaite | www.thedataschool.co.uk

Introduction into Webscrapping!

Intro to SQL

Sep 11, 2022 Gerda Staurylaite | www.thedataschool.co.uk

Little intro to SQL and Snowflake.