How to use a Parameter to select a range of dates on a line graph

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

Finished Graph:

TableauGeneralKnowledge,TableauHow-Tos

How to create a single / double drill down bar graph

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

Finished single drill down graph:

TableauGeneralKnowledge,TableauHow-Tos

How to create a quadrant changing color scatter graph

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

Finished graph:

TableauGeneralKnowledge,TableauHow-Tos

Highlight chart selection

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

in 6 steps using parameters

News,Beyond2022,conference,embeddedanalytics,ThoughtSpot

Good table manners-- Using cognitive load to improve presentation

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

In this post we’re going from bad table to good table, using cognitive load to give context as to why changes have been made. Click here to learn more about cognitive load and ‘table manners.’

News,April,BIMagicQuadrant,BlogRoundup,Tableau,ThoughtSpot

Giving a Great Presentation

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

Today we had a webinar with Sarah Cruise about giving presentations, during thewebinar Sarah Cruise described what makes presentation great, and what can befocused on in order to make them better and more engaging.

TableauGeneralKnowledge,TableauHow-Tos

Double layer drill down

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

The purpose of this blog is to show how to make a double drill down bar chart. Iwill use the usual Superstore dataset. In essence, I would like to be able toclick on one of the category bars and see the subcategory bars and then click onone of the...

TableauGeneralKnowledge,TableauHow-Tos

Changing your spots: Dynamic Highlight Scatterplots

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

Highlighting a certain area of a scatter plot can be a useful way to focus the user’s attention: this blog gives a quick overview of how to colour a scatter plot dynamically.

TableauGeneralKnowledge,TableauHow-Tos

Accessing Password Protected Spreadsheets in Alteryx

Apr 27, 2022 James Driver | www.thedataschool.co.uk

You might come across password protected spreadsheets in the workplace as theyhelp to improve security within a company, however Alteryx will not let you justdrag in and read these files. (Note: you will still need the password to accessthe spread...

TableauGeneralKnowledge,TableauHow-Tos

Using a Coordinate System to generate Tableau Visualizations

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

Most Charts that are built and used in Tableau are pretty simple. If you drag aDimension onto Rows,  a Measure onto Columns, and select the Bar Chart on theMarks Card, the Chart is built easily and quickly. This is why Tableau is greatfor inexperi...

Data,Dashboard,Starter,styleguide,template,Workbook

Ten second tip - Replacing sheets in Tableau dashboards

Apr 26, 2022 Nathan Purvis | www.thedataschool.co.uk

Here I demonstrate a super quick method to replace worksheets in your Tableau dashboard.

News,Beyond2022,conference,embeddedanalytics,ThoughtSpot

Tableau order of operations - overview

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

The order in which Tableau executes varios actions is called Order ofOperations. In this context operations are all filtering actions, sets,parameter actions, LOD actions, table calculations, total, MIN and MAXfunctions, trend lines, reference lin...

News,Beyond2022,conference,embeddedanalytics,ThoughtSpot

How to create a highlight parameter action bar chart

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

Finished chart:

News,Beyond2022,conference,embeddedanalytics,ThoughtSpot

How to create a basic timeline in Tableau

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

Do you sometimes have the idea of creating a timeline in tableau, showing thedevelopment or evolution of the values through years? It is practical to havethe years/times of event showed in your dashboard. Here are several examples ofthat I found i...

Data,Dashboard,Starter,styleguide,template,Workbook

Embed link to a bar chart? It is easier than you think

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

Today’s blog show you how to embed URLs link into your dashboard. In some casesit is really practical that you could click directly on the visualization, to goto the websites for more detail or to link to the videos/songs/movies mentioned.For demo...

Data,Dashboard,Starter,styleguide,template,Workbook

Dashboard Design - Excalidraw

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

I’m writing this blog to show some appreciation to Excalidraw. This tool/website has helped myself and DS29 a lot over these last few weeks. It allows users to quickly make dashboard sketches, which can clearly convey the dashboard design and char...

News,Beyond2022,conference,embeddedanalytics,ThoughtSpot

InterWorks Sponsoring ThoughtSpot Beyond 2022 as a Gold Partner

Apr 26, 2022 Mark Cordeiro | interworks.com

For the first time, InterWorks is joining the lineup at ThoughtSpot’s Beyond 2022, one of the biggest data and analytics events of the year. Not only that, but we’re going all in as an official Gold Partner! Our relationship with ThoughtSpot start...

News,Beyond2022,conference,embeddedanalytics,ThoughtSpot

Tableau Connected Apps

Apr 25, 2022 Craig Bloodworth | www.theinformationlab.co.uk

Achieve the ultimate goal of Tableau. Embed the viz, let the software disappear & put the data at your fingertips!The post Tableau Connected Apps appeared first on The Information Lab.

All,Blog

Web Scraping in Alteryx

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

Web Scraping can be an effective way to pull much data from an internet sourceand Alteryx is very helpful at doing so. Here I want to share with you how youcan quickly get publicly available data from a website and transform it to makeit useable.

Hexbin Heatmaps in Tableau

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

I like maps. They don‘t always add value to a visualization but when they dothey are great for adding context. For example in this week’s Workout Wednesday[https://www.workout-wednesday.com/2022/04/19/2022w16tab/] they make perfectsense in order t...

Data,Dashboard,Starter,styleguide,template,Workbook

Data School Roundup - April 18-24, 2022

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

So what’s been on the mind of the Data School this week?  Spatial analysis,maps, SQL, and chart types - just as a start!  Check out each of the blogs belowfor an in-depth discussion on the topics.

Data,Dashboard,Starter,styleguide,template,Workbook

Alteryx Spatial - Generalize & Poly-Build

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

The Poly-Build tool in Alteryx is used to join multiple spatial points, It can make a line, polygon or convex hull. The Generalize tool skips/ignores certain spatial points (nodes) to quite literally give a more general picture.

Data,Dashboard,Starter,styleguide,template,Workbook

Tableau Dashboard: Create a Starter Workbook

Apr 25, 2022 Kendra Allenspach | interworks.com

Do you have a style guide but have trouble getting your analysts and teams to incorporate it into their dashboard development? Are you tired of all your dashboards not having a consistent look and feel? These problems are more common for data anal...

Data,Dashboard,Starter,styleguide,template,Workbook

Tiny Tableau Tips - Round 1

Apr 25, 2022 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 If you’re on Twitter and follow the datafam (if you’re not, I hope you join us), you’ve probably seen the hashtag #TinyTableauTip.  When you see this hashtag, you know you’re gonna see a Tableau tip.  Maybe you know about it already a...

How-To,Tableau

Tableau – Synchronize Axes across Sheets

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

In Tableau, one can synchronize axes created in the same sheet with a couple ofclicks. Sometimes one has to confront situations where the axes created in twodifferent sheets needs to be synchronized. I had a similar situation during myplacement. I...

Revisiting the Unique Tool in Alteryx

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

“This won’t come up on the exam much, right?” Famous last words.

Español,CustomColorPalette,CustomShape,Hexbin,Map

¿Puedes Construir un Mapa Hexbin?

Apr 23, 2022 Rosario Gauna | rosariogaunag.wordpress.com

Sean Miller nos compartió el desafío de la semana 16 de #WOW, en donde destacan los siguientes requerimientos:  Crear un mapa de “avistamiento de ratas” usando hexbins. Añadir una forma personalizada de hexágono. Añadir una paleta de colores perso...

Español,CustomColorPalette,CustomShape,Hexbin,Map

Can You Make a Hexbin Map?

Apr 23, 2022 Rosario Gauna | rosariogaunag.wordpress.com

Sean Miller shared with us the challenge for week 16 of #WOW, where the following requirements are highlighted: Create a “rat sighting” map using hexbins. Add a custom hexagon shape. Add a custom color palette. Before we get into Tableau Desktop, ...

English,CustomColorPalette,CustomShape,Hexbin,Map

Snowflake Time Travel

Apr 22, 2022 Yana Arkhipenka | www.thedataschool.co.uk

To empower your business decisions with data, you need Real-Time High-Qualitydata from all of your data sources in a central repository. Snowflake TimeTravel is best feature suited for these purposes.

Data,basics,Dashboard,desktop,Tableau,Training

Snowflake Parsing

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

Interesting queries learnt in Snowflake and how DS29 used Snowflake during our client project week.

Data,basics,Dashboard,desktop,Tableau,Training

Replace special characters using RegEx in Tableau, Alteryx and python

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

Sometimes some letters are displayed incorrectly because files have been misreador formatted.

Data,basics,Dashboard,desktop,Tableau,Training

How to Use Snowflake Time Travel as a Parameter in Tableau

Apr 22, 2022 Yana Arkhipenka | www.thedataschool.co.uk

Connect to snowflake through tableau. In the table section choose new custom SQL.

Data,basics,Dashboard,desktop,Tableau,Training

Granularity & Fixed LOD Introduction

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

Yesterday I completed my ‘Learn what the Data School learns’ lesson on the Fixed LOD calculation in Tableau. As an introductory lesson to LOD’s the basis of the lesson revolved around the concept of granularity and how LOD calculations are related...

Data,basics,Dashboard,desktop,Tableau,Training

Generate Test Data with Mockaroo

Apr 22, 2022 Kristine Wiesner | www.thedataschool.co.uk

Mockaroo [mockaroo.com] is an online tool that generates test data quickly andeasily with few clicks, with no programming skills required.  It has a simpleuser interface that allows you to generate 1,000 rows of random data (for thefree version) a...

Data,basics,Dashboard,desktop,Tableau,Training

Discovering spatial objects in Alteryx.

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

A while ago I wrote a blog about how to create a heatmap in Alteryx andvisualize it in Tableau. This week, continuing with the spatial theme inAlteryx, I’m going to show you the usage of a couple of other spatial tools inAlteryx, namely Poly – Spl...

Data,basics,Dashboard,desktop,Tableau,Training

Creating a Burndown Chart in Tableau

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

A Burndown Chart is a nice method to display how a value decreases over time. Sofor example if you want to display how fast a certain budget decreases overtime.

News,APAC,Award,premierpartner,Snowflake

Alteryx Spatial - Smooth

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

A very quick blog on the Alteryx tool ‘Smooth’. This tool simply rounds corners the corners of a spatial object by a user determined amount.

Data,basics,Dashboard,desktop,Tableau,Training

Can you make a hexbin map?

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

Sean Miller was back this week to set this challenge to recreate a ‘rat sighting’ map using hexbins. I’ve only used hexbins in other #WOW challenges, so needed a bit of a refresher (the previous challenges pre-dated my own blog, so I couldn’t use ...

#B2VB - 2022/W4 - Design Some KPIs

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

In this session, I worked on Back to Viz Basics (#B2VB) week 4 and designed as many KPIs as I could in an hour. The video and workbook are below the resources and links.Resources:Back to Viz BasicsWeek 4 ChallengeMy Workbook

areachart,b2vb,BAN,barchart,boolean,charts,color,dualaxis,formatting,KPI,linechart,shape,square,tableau,text,tips,title,triangle,WatchMeViz

Working With Charts- 5 Tips on Good Practice

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

1) Understand your data- Knowing what your data represents will help determinethe types of charts which you will be able to create.

News,APAC,Award,premierpartner,Snowflake

Alteryx Spatial - Find Nearest

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

The ‘Find Nearest’ tool in Alteryx allows you to locate the closest (find nearest) spatial point when compared to a selection of other spatial points.

News,APAC,Award,premierpartner,Snowflake

Calculate Quarter to Date vs Previous Quarter to Date in Tableau

Apr 21, 2022 Eric Parker | onenumber.biz

Hey everyone! We are back with another one of the “To Date” calculation videos many people know us for.

TableauDates,TableauCalculations

InterWorks Achieves Snowflake Premier Partner Status for Asia Pacific

Apr 21, 2022 Garrett Sauls | interworks.com

InterWorks takes a lot of pride in both the quality of our work and the quality of our partnerships, and one of our favorite partnerships happens to be with Snowflake. For the past few years, we’ve worked closely with Snowflake to transform how or...

News,APAC,Award,premierpartner,Snowflake

Get Started with Tableau Desktop in Two Hours or Less

Apr 21, 2022 Michelle Gaudette | interworks.com

Tableau’s suite of tools allows you to connect to a variety of data sources, analyze and visualize your data to find insights, and securely share those insights with the people who need them. Tableau Desktop’s drag-and-drop interface makes it quic...

Data,basics,Dashboard,desktop,Tableau,Training

Alteryx Spatial - Distance

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

The Alteryx ‘Distance’ tool is used to quite literally find the distance between to two spatial points.

TableauDates,TableauCalculations