How to Calculate YTD vs. Prior YTD Based on a Selected Date

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

In this tip, I show you how to calculate year over year change based on a date selected with a parameter. The use case is to calculate YTD sales depending on the date selected and compare it to the prior YTD sales for the same period. ...

analysis,boolean,calculatedfield,change,comparison,context,difference,howto,parameter,percentchange,prioryeartodate,tableau,tip,tutorial,variance,yearoveryear,yeardate

Finding the Nearest Anything in Alteryx

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

There are several example where one might be interested in finding the nearestoption available. As a company you might be interested whether your warehousesare in a reasonable distance from the stores where the products are being soldor as a city ...

Data,BIMagicQuadrant,datavisualization,Gartner,Tableau

Diverging bar charts with consistent scales

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

In my second week at the Data School, I learnt how to produce a diverging barchart in Tableau without having to use negative values for one of the axes, andwith consistent scaling for both sets of bars.

Data,BIMagicQuadrant,datavisualization,Gartner,Tableau

Alteryx Spatial - Create Points

Apr 19, 2022 Robson Hemans-Alexander | www.thedataschool.co.uk

A wise Data School coach named Ruth once told me ‘aLONGitude’ the hallway and ‘upTITUDE’ the stairs? Or something along (alat) those lines.

Data,BIMagicQuadrant,datavisualization,Gartner,Tableau

Visualizing the 2022 Gartner BI Magic Quadrant in Tableau

Apr 19, 2022 Kent Sloan | interworks.com

Gartner has released its annual Magic Quadrant report for 2022, and, per tradition, I’ve visualized the report in Tableau. Each year, the report announcement is highly anticipated as people look to see who and where Gartner has decided the BI indu...

Data,BIMagicQuadrant,datavisualization,Gartner,Tableau

Data School Roundup - April 11-17, 2022

Apr 18, 2022 Ann Jackson | www.thedataschool.co.uk

Wow!  This week we added close to 30 new blogs to our growing library ofcontent.  DS31 out of the UK is on week 2, so you can find out how they’rehandling the process of remaking and reimaging data sets for sharing.  And it’sclear that DS30 has be...

Culture,IWU,ProfessionalDevelopment,Training,University

A week as Project Manager on Client Project

Apr 18, 2022 Mary-Leena Tchenkoue | www.thedataschool.co.uk

Two weeks ago, I had the opportunity to manage our weekly client project andwould like to share my experience. It started on Monday with the kick-off callduring which the client’s requirement for the project were gathered. The nextfew steps were i...

Culture,IWU,ProfessionalDevelopment,Training,University

InterWorks University: Our Solution for Learning

Apr 18, 2022 Scott Matlock | interworks.com

I was never taught how to study. I know this because of the overwhelming anxiety I felt recently as I attempted to prepare for a certification exam at a well-known proctored testing facility. The exam consisted of 200 random questions out of a pos...

Culture,IWU,ProfessionalDevelopment,Training,University

Makeover Monday: Visualisations are Coming

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

Warning, spoilers for game of thrones ahead. I found an interesting visualisation with the game of thrones kill count data, but I reckon there’s still room for improvement. Read this post to find out how I got on.

Project Management Part 3 (Finale)

Apr 15, 2022 Robson Hemans-Alexander | www.thedataschool.co.uk

The time to present our dashboards to the clients had arrived and with it came a new problem.

Project Management Part 2

Apr 15, 2022 Robson Hemans-Alexander | www.thedataschool.co.uk

Disaster struck. Not for the project but me. Unfortunately for day 2 of our client project I was ill and bedridden and contributed little to nothing.

KPI's & a Chart in one sheet

Apr 15, 2022 Zdravka Bratuhtcheva | www.thedataschool.co.uk

How to build a single worksheep KPI with a chart. The main benefit of this isthat it allows us to use less sheets on out dashboards, it saves time formatingand the sheets look uniform.

Week 2- ReVIZiting #MakeoverMonday

Apr 14, 2022 Edward Sinclair-Hughes | www.thedataschool.co.uk

The weekly challenge this week involved taking a previous Viz created for aprevious #makeovermonday, critique and then reproduce with improvements.

Week 2: Makeover Monday but it's Thursday

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

For this week’s project, I chose to rework the viz from Makeover Monday 2020week 9: Costing Kids Sleep.

Top Three Application Tips from Current Data Schoolers

Apr 14, 2022 Sophie Sparkes | www.thedataschool.co.uk

Want to join the Data School? Check out these tips to help you make your application dashboards as strong as possible.

Making charts was slow until I met Tableau

Apr 14, 2022 Tom Stinson | www.thedataschool.co.uk

Second week started with an in-depth dive into graph types and how to make them.Continuing from the data cleaning techniques learnt in the first week, learningwhich plots to make and how to make them feels like a natural progression as itseems I h...

#Makeover Monday, learning how to analyse and input changes

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

For the end of our week 2 training, we had to do a #makeover Monday exercise.We’ve picked a dataset that we liked, I went with “What animal could you beat ina fight?” which was based on statistics where people answered what animal theycould beat i...

Makeover Monday End of week 2

Apr 14, 2022 Charalambos Nicholas Pavlou | www.thedataschool.co.uk

End of week 2 project

Let's Rework: Mobile Data

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

On July 3, 2020, Carmen Ang at the Digital Capitalist released the following article and visualisation[https://www.visualcapitalist.com/cost-of-mobile-data-worldwide/]. She aimed toexplore international differences in the price of mobile data. Whi...

Fixing a viz is the name of the biz(ness)

Apr 14, 2022 Tom Stinson | www.thedataschool.co.uk

The project for week 2 was to recreate a Makeover Monday Viz of our choice anduse skills leant that week to critique and improve the viz in Tableau. Ioriginally chose to remake a bicycle statistic viz, but was persuaded not to bymy cohort after re...

Data School Week 2 Project: Critiquing a #MakeoverMonday Visualisation

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

Re-designing a visualisation used on Makeover Monday for the Data School weekly project

DS31 Training Blog: Week 2

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

A review of the second week of the Data School

Controlling the size of graphs when filtering

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

I recently came across a few useful tips about managing chart size on thedashboard when filters are applied. When you use filter on a graph or use filteraction to show or hide additional chart, there are a few different ways to makesure that the s...

How to Keep Superstore Data Sets Up to Date for Tableau

Apr 14, 2022 Eric Parker | onenumber.biz

The superstore data that Tableau provides is a helpful tool for practice, mockups and trying out concepts. However, one of the frustrations is that it can get “out of date” so to speak so the latest date in the data set might be December 31, 2021 ...

Data

Filter Challenge : How well do you know Tableau’s Order of Operations?

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

It was Erica Hughes’ turn to set the #WOW challenge this week. This ended up being a bit of a journey for me, because of one requirement – to use the max date of the dataset. I typically use a FIXED LOD to determine the max date, which I did initi...

Tips to survive your first week online

Apr 13, 2022 Charalambos Nicholas Pavlou | www.thedataschool.co.uk

Tips for your first week if it’s online

Data

How to create a donut chart in Tableau

Apr 13, 2022 Robson Hemans-Alexander | www.thedataschool.co.uk

Want to make a pie chart? Donut make that mistake! Donut charts grant a more professional look to your dashboard. They’re quick and easy to make in Tableau and I’ll show you how.

Data

Alteryx Joins with Alan, Annie and Andy (but not Barney)

Apr 13, 2022 John Power | www.thedataschool.co.uk

The Join tool in Alteryx is used to combine two data streams, and with the helpof Alan, Annie and Andy can we see just how this is done.

Data

Spotlight on ThoughtSpot: It’s All About the Data

Apr 13, 2022 Karl Riddett | interworks.com

Welcome to part three of our introductory series on ThoughtSpot. If you missed the first two blogs, the first one lays the foundation for our partnership with ThoughtSpot and the second walks through the hierarchy of processes within the solution....

Data,cloud,Metadata,SaaS,SpotlightonThoughtSpot,ThoughtSpot

How to Show Data for Only Completed Periods

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

In this tip, I show you how to filter your data to only completed weeks. This method can be extended to completed months, quarters or years. All you have to do is swap out the word ‘week’ in the filter calculation. ...

boolean,calculatedfield,chart,comparison,complete,context,date,filter,graph,howto,linechart,month,quarter,tableau,tip,tutorial,week,year

Week 2 - One chart at a time

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

Week two kicked off and excitement from week one stayed there, every day is anew challenge and a new puzzle that gets to be solved. With breaks in between,we got to understand what are the best visual practices and how to apply them toour data set...

How-To,Tableau,TableauServer&Online

Tableau Tutorials: Barbell Charts

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

Barbell charts are great to compare two different values within a category andare quite aesthetically pleasing too. This blog post serves as a basic tutorialto create a barbell (also known as dumbbell) chart in Tableau in a few easysteps. For this...

How-To,Tableau,TableauServer&Online

Starting your Data School application: top tips

Apr 12, 2022 Caitlin Walsh | www.thedataschool.co.uk

A short guide for people thinking of applying to the Data School, including some pointers on the application process, and some useful resources for making a start in Tableau.

How-To,Tableau,TableauServer&Online

Nerves & Curves | Week One at the Data School

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

Coming from a small town, moving to London to start a new job at The InformationLab was daunting. One week in, sitting at a benched table at the TIL offices andsurrounded by the chatter of ping-pong and keyboards, I can report that Ishouldn’t have...

How-To,Tableau,TableauServer&Online

Condition-based hiding of Worksheets

Apr 12, 2022 Frederik Egervari | www.thedataschool.co.uk

If you are building a dashboard, you often run into the situation that you mightonly want to show a certain worksheet if a condition is met. Tableau offers thepossibility to make a worksheet seemingly disappear when it is blank

Building a Chart Chooser

Apr 12, 2022 Tanya Fischer | www.thedataschool.co.uk

Sometimes it might be nice for the users of your dashboard to not only selectcertain metrics or parameters for the view but also to change the chart typeitself.

Project Management Part 1

Apr 11, 2022 Robson Hemans-Alexander | www.thedataschool.co.uk

After sitting back for the last three weeks letting my friends in DS29 take charge for client projects, my time has finally come. This week in the data school we have been challenged to assist a payment solutions company for software firms.

MOVE SELECTED ITEMS TO TOP

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

It is nice to see the values of a selected item or category directly at firstsight. Sometimes if you have a great amount of values it is difficult to alwaysfocus on the line/ value which you have selected, to compare it to others. Forthat you can ...

How to create a Toggle Switch with Parameters?

Apr 11, 2022 Robin von Malottki | www.thedataschool.co.uk

Was ist ein Toggle Switch?

Block Until Done - Alteryx

Apr 11, 2022 Robson Hemans-Alexander | www.thedataschool.co.uk

A quick a blog for a new tool I found interesting in Alteryx, Block Until Done. This tool allows you to queue flows out of the output anchor so they’re completed in a specific order.

Tableau Data Sources Part 2: Published Data Sources & More

Apr 11, 2022 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 Welcome back to my two-part series which deals with the ins and outs of Tableau data sources. If you missed Tableau Data Sources Part 1: Data Source Types, then be sure to go back and read it first as I’ll be building upon some of the...

How-To,Tableau,TableauServer&Online

Teamarbeit und Projekt Management Skills

Apr 10, 2022 Tram Nguyen | www.thedataschool.co.uk

Es ist zu lang her seit ich einen deutschen Blog geschrieben habe. Letzte Wochebesuchten Kristine, Nhung und Ich zum Kristines Geburtstag ein koreanischesRestaurant in Hamburg, http://www.hanmi.de/, das super leckeres Essen anbietet,denke ich. Des...

How to create a quick LOD in Tableau

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

LOD (Level of Detail) expressions are used to compute values on different levelsof granularity. Among the expression, FIXED expression is very powerful as itallow users to control the calculation an entirely independent level. From theversion 2021...

Creating a Grid Map using Alteryx and Tableau.

Apr 9, 2022 Oksana Kirschbaum | www.thedataschool.co.uk

Data maps are great tools to combine spatial and statistical data. Grid maps arevery useful when associating the size of a geographic area with statistical datarelated to the area. Let’s see how we can make it with Alteryx and Tableau using a data...

A Londoner’s guide to Proper Bri'ish

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

No this isn’t a guide on how to speak like Thomas Shelby. Instead, the focus of this post is on things to consider when trying to sound interesting - even if you’re not sure it is.