This is me

May 9, 2022 Donna Coles | donnacoles.home.blog

In a break from tradition, this isn’t a #WorkoutWednesday solution guide. Instead this is likely to be more of a ‘heart on my sleeve’ type of post; a bit of self-reflection and musings on my current state of mind. Don’t be alarmed – I’m perfectly ...

General

The Data Model in Tableau

May 8, 2022 Frederik Egervari | www.thedataschool.co.uk

The Tableau Data Model describes how you connect multiple data sources areconnected. Here Tableau differentiates between two different types.

Tableau tip: how to add data last updated date time to dashboard

May 7, 2022 Nhung Le | www.thedataschool.co.uk

In particular cases, it is practical to know when is your data last updated. Forexample, for a client project we built the write back extension in ourdashboard. The write back allows users to add more rows, which are saved in anextra data file and...

Data,gridvariable,Matillion,orchestration,scalar,transformation

How to create a star rating system in Tableau

May 7, 2022 Nhung Le | www.thedataschool.co.uk

There are multiple ways to rank items. In a ordinal scale (for example, how goodis the product rating from 1-9), we have to define first there 1 means the bestor the worst.

Data,gridvariable,Matillion,orchestration,scalar,transformation

How to Combine Values of a Matillion Grid Variable into a Scalar Variable

May 7, 2022 Chris Hastie | interworks.com

Recently, I came across a request from a member of the Matillion community to leverage the values of a Matillion grid variable in a SQL Script component. To be more precise, they had populated a grid variable with a list of values and wanted to us...

Data,gridvariable,Matillion,orchestration,scalar,transformation

Creating dynamic symbols/indicators for KPI's

May 6, 2022 Algirdas Grajauskas | www.thedataschool.co.uk

There’s an easy way to create a dynamic symbol/indicator for KPI’s which wouldchange based on values. For example, if I wanted to show the difference(positive/negative) between two values (Year over Year sales).

Data,AmazonAthena,AWS,sql,Tableau

Tableau and Amazon Athena: Sharp, Simple Data Analysis

May 6, 2022 Roger Garcia | interworks.com

Today, I will cover how to make these two great platforms work together in just a few steps. We will be using the guides provided by AWS and Tableau as reference points to effectively open a connection from Tableau to a CSV file that will…The post...

Data,AmazonAthena,AWS,sql,Tableau

Time flies when you're using Dateparse()

May 5, 2022 Tom Stinson | www.thedataschool.co.uk

Week 4 was a rollercoaster of Tableau, covering everything from the data modelto teaching. One of the topics touched on was date functions and their uses. Wecovered several of the date functions and in this blog I will attempt to clearup how they ...

Culture,anniversary,blog,Thunder,TimeCapsule

Tableau Tutorials: Makepoint and Makeline

May 5, 2022 Thanoshaan Thayalan | www.thedataschool.co.uk

Spatial data is rarely touched upon in Tableau but when using such data,Makepoint and Makeline calculations can become very important. Both calculationsare self-explanatory with Makepoint being a calculation that creates a pointwhilst Makeline cre...

Culture,anniversary,blog,Thunder,TimeCapsule

Tableau Joining 2; Intersecting Spatial Boogaloo

May 5, 2022 Tom Stinson | www.thedataschool.co.uk

Joining spatial data that intersects is easier in Alteryx than it is in Tableau(my opinion, see for yourself). However, if you really want to do it this is howyou can.

Culture,anniversary,blog,Thunder,TimeCapsule

Spatial visualisation in Alteryx

May 5, 2022 Charalambos Pavlou | www.thedataschool.co.uk

How to visualise maps in Alteryx

Culture,anniversary,blog,Thunder,TimeCapsule

Spatial Data: Finding the Lengths of Routes

May 5, 2022 Dorinna Pentchev | www.thedataschool.co.uk

Combining Alteryx and Tableau to display London bus routes and their length.

Culture,anniversary,blog,Thunder,TimeCapsule

Rank + Suffix: A Simple Fix

May 5, 2022 Tom Dobson | www.thedataschool.co.uk

Image AI-generated from [trophy, rank, data] | StarryaiAppending appropriatesuffixes to numeric ranks  (1, 2, 3 → 1st, 2nd, 3rd etc.) is a problem I’verepeatedly encountered in Tableau. What’s more, I haven’t spotted a definitiveonline solution. H...

Culture,anniversary,blog,Thunder,TimeCapsule

Quick is the name Speed is the game

May 5, 2022 Algirdas Grajauskas | www.thedataschool.co.uk

A lot of time is wasted when making mundane calculations in Tableau, such as %of total, making spatial points and so on.

Culture,anniversary,blog,Thunder,TimeCapsule

How to Poly-Build: Drawing the line.

May 5, 2022 Edward Sinclair-Hughes | www.thedataschool.co.uk

Poly-Build is a tool found in Alteryx which is used to create a polygon from agiven set of points. In order to start creating a polygon using Poly-Build youmust first have a set of points to which you can reference, in the examplebelow, I have the...

Culture,anniversary,blog,Thunder,TimeCapsule

A Spatial Match Made in Heaven

May 5, 2022 Abiramm Thavajothy | www.thedataschool.co.uk

Just a quick guide on how to use and better understand the spatial match tool in Alteryx.

Culture,anniversary,blog,Thunder,TimeCapsule

Tableau Blending; Why am I getting an asterisk (*)?

May 5, 2022 Eric Parker | onenumber.biz

Blending is nearly as old as Tableau Desktop itself. Executing a blend in Tableau is a method for relating data from multiple different tables so it can be analyzed together. For instance, a sales value and a quota.

Data

Opening the InterWorks Blog’s Virtual Time Capsule

May 5, 2022 Mark Cordeiro | interworks.com

InterWorks is a company that’s been around for more than a quarter century. In the grand scheme of things, that could be argued as the blink of an eye. For instance, the oldest company in the world was Kongō Gumi Co., Ltd., which was founded…The p...

Culture,anniversary,blog,Thunder,TimeCapsule

Can You Optimize This?

May 5, 2022 Donna Coles | donnacoles.home.blog

For #WOW2022 week 18, Lorna set this challenge to allow us to familiarise ourselves with the new Tableau Workbook Optimizer feature released in version 2022.1 (so you’ll need this version of Tableau Desktop to complete this challenge). You need to...

Pareto Charts in Tableau

May 4, 2022 Frederik Egervari | www.thedataschool.co.uk

The Idea of Pareto Charts

Data

Year to Date vs. Prior Year to Date Comparison

May 3, 2022 Tanya Fischer | www.thedataschool.co.uk

I believe there is more than one way to calculate a Year to Date vs. Prior Yearto Date comparison in Tableau. Like in most cases with Tableau there are severalways to Rome.

The Day After Tomorrow: Time Functions in Tableau

May 3, 2022 Tom Dobson | www.thedataschool.co.uk

As the name suggests, Tableau’s date functions are used to work with date valuesin a dataset. These can be used to modify existing dates, create new ones, andreturn values for specific dates. In this blog post, we’ll overview somecommonly used fun...

News,April,BIMagicQuadrant,BlogRoundup,Tableau,ThoughtSpot

Data School Roundup - April 25 to May 1, 2022

May 3, 2022 Ann Jackson | www.thedataschool.co.uk

It’s my last week filling in on this roundup (Global Coach Andy is back from hissabbatical), and it’s FULL of fresh blog posts.  I can tell that DS30 had awonderful time this week exploring Set and Parameter Actions in Tableau, andyou’ll see some ...

News,April,BIMagicQuadrant,BlogRoundup,Tableau,ThoughtSpot

InterWorks Blog Roundup – April 2022

May 3, 2022 Mark Cordeiro | interworks.com

Another month has passed, which means it’s time for another blog roundup! We’re deep in the throes of preparation for ThoughtSpot’s upcoming Beyond 2022 conference and Tableau’s TC22, but we’ve made sure to include some extra special blog content ...

News,April,BIMagicQuadrant,BlogRoundup,Tableau,ThoughtSpot

The Quadrant dilemma

May 2, 2022 Charalambos Pavlou | www.thedataschool.co.uk

How to create a dynamic coloured quadrant

News,April,BIMagicQuadrant,BlogRoundup,Tableau,ThoughtSpot

Predicting Values in the Future – Time Forecasting Tools in Alteryx

May 2, 2022 Frederik Egervari | www.thedataschool.co.uk

The Time Series tools in Alteryx offer an easy way to predict how a value islikely to behave in the future by looking back at historical values. Thefunction is similar to the Predictive tools. But instead of determiningcontributing factors, like T...

Understanding {LOD} Level of Detail Expression

May 1, 2022 Kristine Wiesner | www.thedataschool.co.uk

One of the things I could not get around while learning Tableau is this conceptof LOD or Level of Detail Expression.  By doing some practical challenges in Workout Wednesday [https://www.workout-wednesday.com/], it has helped me tounderstand the c...

Creating an Extended Bar Chart in Tableau

May 1, 2022 Frederik Egervari | www.thedataschool.co.uk

There are some fancy Chart Types in Tableau. The Extended Bar Chart is one ofthem. The advantage of an Extended Bar Chart compared to normal Bar Charts isthat you can display more text at the start of a bar.

ChartTypes,horizonchart,Tableau

Tableau – Adding „All“ Option in Parameter

Apr 30, 2022 Sreekanth Arathil Condoth | www.thedataschool.co.uk

The parameter enables the user to interact with the dashboard or the graph inmultiple ways. One of those is to filter the data to be displayed. It is similarto the Quick filter option, the main difference being the inability to selectall the provi...

ChartTypes,horizonchart,Tableau

Joining tables with different date ranges

Apr 30, 2022 Dorinna Pentchev | www.thedataschool.co.uk

Whether you’re joining, blending or relating data, having different dates inboth tables may give you some trouble. For example, if you have different tablesfor sales and sales targets over time, the target table may have some laterdates to display...

News,April,BIMagicQuadrant,BlogRoundup,Tableau,ThoughtSpot

How to Create Horizon Charts in Tableau

Apr 30, 2022 datavis.blog | datavis.blog

Horizon charts can show trends across many data series in a relatively small space. This blog steps through a method for creating them in Tableau.

ChartTypes,horizonchart,Tableau

Time & Expectation management when doing customer projects

Apr 29, 2022 Nhung Le | www.thedataschool.co.uk

The DSDE2 has went through the fifth customer project this week. We are comingslowly to the end of the journey (what??? so fast???). We have learnt a lot thelast weeks. I remember the first weeks started with a mix of excitement, stress,confusion,...

Data,Dashboard,ETL,NaturalLanguageProcessing,NLP,WebinarReplay

Tableau Tutorials: Table Calculation Parameter

Apr 29, 2022 Thanoshaan Thayalan | www.thedataschool.co.uk

Table calculations are a backbone of maximising the potential of Tableau andadding a parameter to them will allow the user to have control over thecalculation. This blog post will go through how to insert a parameter into tablecalculations using S...

News,April,BIMagicQuadrant,BlogRoundup,Tableau,ThoughtSpot

Ramen Review: Implementing Interactivity with Parameters

Apr 29, 2022 Tom Dobson | www.thedataschool.co.uk

During a sunny morning at TIL HQ, my cohort (DS31) and I were exploringparameters and parameter actions. By implementing these tools the end-user isgranted the ability to filter on-screen data, significantly enhancing the valueof the visualisation...

Data,Dashboard,ETL,NaturalLanguageProcessing,NLP,WebinarReplay

My week as Project Manager

Apr 29, 2022 Patrice Tiana Grant | www.thedataschool.co.uk

A description and overview of how the week went as a Project Manager. The challenges encountered and a bit of advice for future leadership roles.

Data,Dashboard,ETL,NaturalLanguageProcessing,NLP,WebinarReplay

Interaction between different Dashboards using Dashboard Actions in Tabl...

Apr 29, 2022 Nhung Le | www.thedataschool.co.uk

In today’s blog I would like to show you a tip to set up interactions betweendifferent dashboards. An example in this context is: I have one dashboard whichshows me the aggregated values of countries (showed in dots, shapes, bars,etc.). What I wan...

Data,Dashboard,ETL,NaturalLanguageProcessing,NLP,WebinarReplay

Webinar Replay: Intro to Natural Language for Business Intelligence

Apr 29, 2022 Jack Hulbert | interworks.com

Video replays for this webinar are available at the bottom of the blog. Today, we’re going to dive into the world of Natural Language Processing (NLP), some popular industry use cases for NLP and how you can leverage NLP in a common business intel...

Data,Dashboard,ETL,NaturalLanguageProcessing,NLP,WebinarReplay

The Devil's in the details

Apr 28, 2022 Abiramm Thavajothy | www.thedataschool.co.uk

I lost a bet and a post is my forfeit. The way I lost said bet however, does give rise to an interesting discussion about paying attention to small details. Read more to learn more about both the bet and the importance of being thorough.

News,April,BIMagicQuadrant,BlogRoundup,Tableau,ThoughtSpot

Dynamische Überschriften für einen Wechsel erstellen

Apr 28, 2022 Romina Wiechern | www.thedataschool.co.uk

Wenn in einem Dashboard mit Wechseln zwischen Metriken oder Grafiktypen in einerGrafik durch z.B.: Parameter gearbeitet wird, ist es gut, dies auch in derÜberschrift zu erkennen. So weiß derdie Betrachterin worauf sich die geänderteGrafik bezieht.

data-replication,data-engineering,saas,fivetran,hvr

Dual vs Shared, which is which

Apr 28, 2022 Algirdas Grajauskas | www.thedataschool.co.uk

We often might find ourselves using different axes in our visualizations butwhat is the difference between them and are there any advantages of one over theother?

News,April,BIMagicQuadrant,BlogRoundup,Tableau,ThoughtSpot

Fivetran Acquires HVR: You’re in for a Treat

Apr 28, 2022 Zsolt Palmai | medium.com

Fivetran’s acquisition of HVR recently made waves across the data world. Both technologies have been staples of modern data stack design: Fivetran is a leader in automated data integration and HVR has been a major player in large-scale data replic...

data-replication,data-engineering,saas,fivetran,hvr

Top 10 Tableau Formatting Tricks

Apr 28, 2022 Eric Parker | onenumber.biz

Tableau formatting is a world of its own. While there are loads of options, there are also some under the radar tricks which can help you build workbooks faster and cut down on repeat work.

TableauGeneralKnowledge,TableauHow-Tos

Spotlight on ThoughtSpot: Poised for Enterprise Data Success

Apr 28, 2022 Karl Riddett | interworks.com

Welcome to part four of our introductory series on ThoughtSpot. We at InterWorks are very excited about ThoughtSpot, and we would love to help you and your organization understand how ThoughtSpot can help you in your data and analytics journey. If...

Data,enterprise,row-levelsecurity,SpotlightonThoughtSpot,ThoughtSpot

Can you switch between KPIs?

Apr 28, 2022 Donna Coles | donnacoles.home.blog

In this instalment of #WOW2022, Kyle posed a challenge based on a previous viz he had published which in turn was inspired by Lindsey Poulter‘s Set Actions workbook. I made an attempt to build a solution without referencing Lindsey’s viz, but ende...

Parameter Drill Down in Tableau

Apr 27, 2022 Skomantas Tamulaitis | www.thedataschool.co.uk

There are two ways to create drill downs in Tableau. One way is to use sets andthe other is to use parameters. Here I will outline the steps involved increating drill downs with parameters.

TableauGeneralKnowledge,TableauHow-Tos