Dynamic YoY Comparison Flag for Financial Years using Alteryx

Jun 21, 2022 timea.demeter | www.theinformationlab.co.uk

Using Alteryx to create “This year” and “Last year” flags for Financial Years in order to calculate a Year on Year comparison. The post Dynamic YoY Comparison Flag for Financial Years using Alteryx appeared first on The Information Lab.

Blog,Alteryx,Dynamic,FinancialYear,FormulaTool,YearonYear

There's nothing tastier than a Waffle Chart

Jun 21, 2022 Megan Coutts | www.thedataschool.co.uk

Waffle charts are commonly used as an alternative to pie charts, as they’re really simple to comprehend, and also exhibit a clean aesthetic too, making them very easy on the eye. Below I’ll show you how to make one, with the final chart displaying...

Data,branch,commit,Git,Squash

The Tableau Slang Glossary

Jun 21, 2022 Fergus Smith | www.thedataschool.co.uk

A-Z

Data,branch,commit,Git,Squash

'Show-me-free' highlight table

Jun 21, 2022 Zdravka Bratuhtcheva | www.thedataschool.co.uk

In this blog I will show you how to make a highlight table without using the show me shortcut. I use the Sample Superstore data set. Lets begin.

Data,branch,commit,Git,Squash

Quick Tip: instant calc building

Jun 21, 2022 Caitlin Walsh | www.thedataschool.co.uk

Save time when you build common calculated fields, with the help of this drag and drop method.

Data,branch,commit,Git,Squash

Project 2: Reshaping data

Jun 21, 2022 Ben Mangel | www.thedataschool.co.uk

The Friday of our second week was project time again! We worked together in pairs. I had the opportunity - and pleasure - to work with Ozlem from the DS 32, how we spent our day can you read here in her blog!

Data,branch,commit,Git,Squash

Pivoting Tables in Tableau Prep

Jun 21, 2022 Tristan Kelly | www.thedataschool.co.uk

When preparing a table for visualization in Tableau, its structural layout may make it difficult to effectively visualize the data. This week at the Data School New York we discussed this common problem and the easy solution that can be found in T...

Data,branch,commit,Git,Squash

Parameter to Switch Between Year, Month, and Day

Jun 21, 2022 Skomantas Tamulaitis | www.thedataschool.co.uk

In Tableau you can let the user choose what part of the date they want the chart to be showing. Here I will show you how to do it using parameters. The data for this example is taken from Tableau’s Sample – Superstore dataset.

Data,branch,commit,Git,Squash

Parameterized Heatmap

Jun 21, 2022 Fergus Smith | www.thedataschool.co.uk

In this blog I’ll guiding you step by step on how to create a heatmap which uses parameters to change the dimensions of the X and Y axis.

Data,branch,commit,Git,Squash

Making Calculated Fields Easier to Use in Tableau

Jun 21, 2022 Sophie Higson | www.thedataschool.co.uk

Want to make calculated fields easier to use and understand? Here are a list of suggestion to get you started.

Data,branch,commit,Git,Squash

How to make a Hex Map

Jun 21, 2022 Zdravka Bratuhtcheva | www.thedataschool.co.uk

In this blog I will show you how to make a Hex Map. Hex map are a great way to visualise data when the actual location is not that relevant, or when there are some outliers, like Alaska and Hawaii in the USA for example or when the size of the loc...

Data,branch,commit,Git,Squash

How To Create A Dynamic Bar In Bar Chart

Jun 21, 2022 Valerie Madojemu | www.thedataschool.co.uk

In a previous blog, I explained how to create a bar in bar without hardcoding dates.(https://www.thedataschool.co.uk/valerie-madojemu/creating-bar-in-bar-chart-without-hardcoding-dates)

Data,branch,commit,Git,Squash

Hex Tile Maps

Jun 21, 2022 Megan Coutts | www.thedataschool.co.uk

Hex tile maps are really useful if you don’t want the size of a geographical region to be a key factor for analysis within your dashboard, with each region displayed as a hexbin of equivalent size. It is important to note that as this is a map, yo...

Data,branch,commit,Git,Squash

Hex Maps

Jun 21, 2022 Carlos Pacheco | www.thedataschool.co.uk

Hex maps are a great way of visualising an area.

Data,branch,commit,Git,Squash

Filter Actions: using Menu

Jun 21, 2022 Caitlin Walsh | www.thedataschool.co.uk

A short guide to adding Dashboard filter actions, using the ‘Menu’ option to navigate to a new view.

Data,branch,commit,Git,Squash

Creating Bar In Bar Chart Without Hardcoding Dates

Jun 21, 2022 Valerie Madojemu | www.thedataschool.co.uk

Before joining the data school, I made a bar in the bar by hardcoding dates

Data,branch,commit,Git,Squash

Alteryx Tools 101-Sort & Unique

Jun 21, 2022 Maha Hussari | www.thedataschool.co.uk

Sort Tool

Data,branch,commit,Git,Squash

A color legend for each value

Jun 21, 2022 Zdravka Bratuhtcheva | www.thedataschool.co.uk

How to use separate colour legend for each separate value.

Data,branch,commit,Git,Squash

2 Ways to Create a Highlight Table in Tableau

Jun 21, 2022 Skomantas Tamulaitis | www.thedataschool.co.uk

There are two ways to create a highlight table in Tableau: 1. Utilizing “Show Me” function; 2. Manually. Here are the steps that you need to follow to create a highlight table both ways. In this example I will be using Tableau’s Sample – Superstor...

Data,branch,commit,Git,Squash

Git Nested Branching with Squash

Jun 21, 2022 Matthew Orr | interworks.com

Bird nests? Tree limbs? Summer squash? There sure are a lot of plant, animal and food terms in that title. What are we talking about here, and how is it related to source code repositories? As the Curator team has grown, so has the concurrent…The ...

Data,branch,commit,Git,Squash

#WatchMeViz - Workout Wednesday 2022 Week 1

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

Below is the livestream and link to the workbook I created as I took on Workout Wednesday 2022 week 1 - FAA Wildlife Strikes. Enjoy!

areachart,barchart,challenge,dashboard,dashboardaction,faa,learn,livestream,map,parameter,parameteraction,tableau,tip,tooltip,trick,WatchMeViz,wildlife,WorkoutWednesday,wow2022

What did it take to get into DS30?

Jun 20, 2022 Andy Kriebel | www.thedataschool.co.uk

To get into DS30, the team worked with data about either fish counts in the UK or restaurant inspections in New York. They all went with a long-form storytelling type of viz. Have a look for inspiration for your own application.

Data,dataprep,datapreparation,Performance,WebinarReplay

What Is A Parameter?

Jun 20, 2022 Maha Hussari | www.thedataschool.co.uk

Parameters help the user to interact and see specific data on their dashboard - it can also help answer specific questions the user may want. It sounds similar to filters as they both manipulate the data but at different levels.

Data,dataprep,datapreparation,Performance,WebinarReplay

How to Build a Cohort Analysis graph

Jun 20, 2022 John Power | www.thedataschool.co.uk

Finished graph:

Data,dataprep,datapreparation,Performance,WebinarReplay

Data School Roundup - June 13-19, 2022

Jun 20, 2022 Andy Kriebel | www.thedataschool.co.uk

59 tips this week from Australia to Germany to London to New York. Learn what The Data School is learning in this week’s blog roundup.

Data,dataprep,datapreparation,Performance,WebinarReplay

A lesson in international collaboration

Jun 20, 2022 Ozlem Sigbeku | www.thedataschool.co.uk

Working on a short-term project with someone you haven’t met before can be hard. Harder still working exclusively on video conferencing. But two tips helped me and could help you too!

Data,dataprep,datapreparation,Performance,WebinarReplay

Webinar Replay: Data Prep for Really Good Analytics

Jun 20, 2022 Ryan Callihan | interworks.com

A video replay for this webinar is available at the bottom of the blog. In this webinar, our analytics team covers what data prep looks like in a modern analytics stack and makes suggestions for a solid data prep environment. The Data Preparation ...

Data,dataprep,datapreparation,Performance,WebinarReplay

Iron Viz Reflections: A Guest Blog Post by Kimly Scott

Jun 20, 2022 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 The following is a guest post from Kimly Scott. Kimly is a Tableau Public Ambassador and was one of this year’s Iron Viz finalists. She was the recipient of the Data Storyteller Extraordinaire Vizzie award for 2021 and 2022. Kimly use...

IronViz,Tableau

How to Build Reference Line Parameter Action

Jun 19, 2022 Longyan Chen | www.thedataschool.co.uk

I have shown how to build reference line parameter action step by step.

Dynamic SQL Queries in Alteryx

Jun 19, 2022 Frederik Egervari | www.thedataschool.co.uk

When connecting to databases within an Alteryx Workflow it can be a useful option to pull the data in dynamically. This way the amount of data that has to be pulled from the database can be reduced to increase the speed of the workflow. Especially...

BLUE vs GREEN FIELDS in Tableau

Jun 19, 2022 Imogen Emmett | www.thedataschool.co.uk

What is the difference between the BLUE and GREEN FIELDS in Tableau?

What did it take to get into DSNY1?

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

We’ve officially kicked off training for the first cohort of The Data School New York!

Data,dataprep,datapreparation,Performance,WebinarReplay

Using floating object for customized images

Jun 18, 2022 Tram Nguyen | www.thedataschool.co.uk

Hey everyone, hmm let’s see what have in another Friday’s afternoon to share. There are plenty of inspirations for infographics with amazing images that you can incorporate into your dashboards. I’m going to show you a tip to make your Dashboard m...

Tips for being a Project Manager

Jun 18, 2022 Thanoshaan Thayalan | www.thedataschool.co.uk

Tips for being a Project Manager

Parameter controlled sorting

Jun 18, 2022 Zdravka Bratuhtcheva | www.thedataschool.co.uk

Step 1: Create a sort by parameter.

How to add a red alert dot

Jun 18, 2022 Zdravka Bratuhtcheva | www.thedataschool.co.uk

In this blog I will show you how to add a red dot in the begging of a horizontal bar chart. I will use a bar chart I created for my previous blog. For this example I will indicate what orders it took above the average days to ship.

Custom shape color palettes in Tableau

Jun 18, 2022 Zdravka Bratuhtcheva | www.thedataschool.co.uk

Its 2022 and it’s all about the looks, isn’t it?

How is the Arctic ice melt trending?

Jun 18, 2022 Donna Coles | donnacoles.home.blog

This week’s #WOW2022 challenge required us to build an horizon chart. While I’m familiar with them, I haven’t had to build one before. Luke provided references to a workbook and blog post as part of the challenge. I was also aware that Marc Reid h...

The red therad

Jun 17, 2022 Daniel Glasenapp | www.thedataschool.co.uk

After two weeks of Data School, all the initial input finally unravels. Since I think too complicated in some things, I’m responsible for the thick information knot that was created in my head during the first days. Today I also unfortunately didn...

Tableau Prep tips.

Jun 17, 2022 Oksana Kirschbaum | www.thedataschool.co.uk

Today I would like to share some tricks in Tableau Prep.   I rarely used this tool before, but lately I used it to clean the datasets during our weekly projects and dashboard week. I find this tool user-friendly, and I am absolutely delighted with...

Sets and Groups

Jun 17, 2022 Reuben Clayman | www.thedataschool.co.uk

A quick explanation and walk through of sets and groups.

Notes for Week 2 training

Jun 17, 2022 Longyan Chen | www.thedataschool.co.uk

What is the difference between discrete and continuous data in Tableau?

Guided analytics for more informed audiences

Jun 17, 2022 Ronaldo Licaj | www.thedataschool.co.uk

Hello and welcome to my first blogging attempt. While embarking in the field of analytics a year ago, I was struggling myself to understand the topic, and therefore I decided now that I had my first week in Tableau training at “The Data School Deu...

Drilldown erstellen.

Jun 17, 2022 Oksana Kirschbaum | www.thedataschool.co.uk

Für einen Drilldown brauchen wir Sets, Calculated Fields and Set Actions.Zunächst müssen wir festlegen, welche Ebenen wir aufbauen wollen. Für unser Beispiel nehme ich die Category, die Sub-Category und die Manufacturer aus dem EU Superstore-Daten...

Tableau fixed calculations explained as an Alteryx workflow

Jun 16, 2022 Ozlem Sigbeku | www.thedataschool.co.uk

I made a fixed calculation workflow in Alteryx so you don’t have to.

News,Alteryx,cloud,Event,Inspire