How to Stage Email Attachment Data with Matillion

Jul 21, 2021 Azucena Coronel | interworks.com

Transferring datasets via email is definitely not ideal, and while we try to avoid it as much as we can, there are occasions where our data providers do not have the resources to provide their datasets any other way. Maybe they are able to impleme...

Data,cloud,email,Matillion,python,Snowflake,staging

The 5-4-3-2-1 Technique

Jul 20, 2021 Henry Mak | www.thedataschool.co.uk

In this blog post, Henry describes the 5-4-3-2-1 technique which aims to bring you back to the present and may help you calm your presentation nerves.

Data,analyticsengineer,cloud,core,datatransformation,dbt

Exploring dbt Cloud vs. Core

Jul 20, 2021 Derek Hecksher | interworks.com

In our previous post, we briefly introduced dbt and an emerging role on modern data teams called an analytics engineer. If you’ve had a chance to dig into dbt, you’ve likely asked the questions, “What is dbt Core?” and “What is dbt Cloud?”. In thi...

Data,analyticsengineer,cloud,core,datatransformation,dbt

#MakeoverMonday 2021 Week 29 - Non-Whites Are At Higher Risk of Dying Fr...

Jul 19, 2021 VizWiz (noreply@blogger.com) | www.vizwiz.com

Another COVID-19 data set this week and a great visualization that shows how much more likely ethnic minorities in the UK are to die from COVID.In the video, I worked through rebuilding the original viz since I liked it so much. Interact with the ...

chart,circle,color,colorpicker,connected,covid,customsequential,formatting,graphs,InformationisBeautiful,line,MakeoverMonday,measurenames,measurevalues,shape,tableau

Error Reporting with Message/Test Tools | Alteryx Tools Explained

Jul 19, 2021 Harry Osborne | www.thedataschool.co.uk

Nobody has ever used Alteryx with no errors - but futureproofing workflows is not only a great habit, but fairly intuitive. This blog details a couple of tools that excel in this depoartment.

Business,PowerBI,Tableau,main,tableau

Alteryx Macros Part 1: The Standard Macro

Jul 19, 2021 George Pattinson | www.thedataschool.co.uk

This blog shows how to set up a Standard Macro by inserting into a data field a smiley of your choice.

Business,PowerBI,Tableau,main,tableau

Aggregation in Tableau - Part 2 - Attribute (ATTR) functions

Jul 19, 2021 Liu Zhang | www.thedataschool.co.uk

ATTR() is one of the most common aggregation function in Tableau, but it is also less easy to understand.

Business,PowerBI,Tableau,main,tableau

Choosing the BI Tool that is Right For You

Jul 19, 2021 Spencer Baucke | www.tessellationtech.io

Choosing the BI Tool That is Right for You Choosing a BI tool for your organization can be tedious. Get the decision right, and you’re a hero. Choose a tool that ends up not meeting people’s needs and being too … Read MoreThe post Choosing the BI ...

Business,PowerBI,Tableau,main,tableau

App to Visualize the Size of the Wildfires

Jul 19, 2021 Rosario Gauna | rosariogaunag.wordpress.com

The challenge for week 28 of # WOW2021 was given by Josh Jackson. He tells us that he likes to create calculators in Tableau so he can use them from his phone at any time. Josh lives in Phoenix, a place where sadly many wildfires occur and on the ...

English,Buffer,MapLayer

App para Visualizar el Tamaño de los Incendios Forestales

Jul 19, 2021 Rosario Gauna | rosariogaunag.wordpress.com

El desafío de la semana 28 de #WOW21 estuvo a cargo de Josh Jackson y él nos comenta que le gusta crear calculadoras en Tableau para poder utilizarlas desde su teléfono en cualquier momento. Josh vive en Phoenix, un lugar en donde tristemente se p...

Español,Buffer,MapLayers

Regex Part II: Basic Examples & Exercises

Jul 19, 2021 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

We’re excited to have Don Wise back for part 2 in his series on regular expressions. Don is a Tableau Forums Ambassador, has an incredibly deep knowledge of Tableau as a whole, and is one of the top contributors on the Tableau Community Forums. If...

How-To,Tableau

DS24 Training Blog - Week 6

Jul 16, 2021 Liu Zhang | www.thedataschool.co.uk

Various topics are covered in week 6 of training. The technical sessions are on Alteryx Apps and data security, while soft skills on project planning and management.

Data,datavisualization,housing,lumber,Tableau

Auto Field | Alteryx Tools Explained

Jul 16, 2021 Harry Osborne | www.thedataschool.co.uk

Auto Field is a tool that can help avoid some very repetitive resizing when concerning strings. This blog post talks about some of its pros and cons.

Data,datavisualization,housing,lumber,Tableau

A Data Viz of U.S. Lumber Prices in 2021

Jul 16, 2021 Dan Murray | interworks.com

My wife and I moved into our downsized home three years ago. Our timing was good. There was some available inventory, and we were able to purchase a very nice home for a reasonable price. This weekend we received a letter from a realtor who…The po...

Data,datavisualization,housing,lumber,Tableau

Aggregation in Tableau - Part 1 - AGG functions

Jul 15, 2021 Liu Zhang | www.thedataschool.co.uk

Series on different type of aggregation within Tableau.

Alteryx,Tableau,TableauPrep,Tutorial,alteryxtraining,tutorial

How to Restructure Data in Alteryx: Files With Two Column Headers

Jul 15, 2021 Aidan Bramel | www.tessellationtech.io

How to Restructure Data in Alteryx: Files With Two Column Headers As analysts and developers, we don’t always have control over the data we receive and how it is formatted. We still need to do our best to deliver what … Read MoreThe post How to Re...

Alteryx,Tableau,TableauPrep,Tutorial,alteryxtraining,tutorial

How to Create Summary Tiles for Tableau Dashboards

Jul 15, 2021 Eric Parker | onenumber.biz

I provide summary tiles at the top of most dashboards I build to provide easy-to-find, bite-size information for my end users. There are a couple primary approaches to creating summary tiles in Tableau and a few tricks you can utilize to make them...

Design,TableauDashboards

Getting Started with Python Scripts in Tableau Prep

Jul 15, 2021 Jack Hulbert | interworks.com

In the last few years, we have seen an ever-growing number of codeless data-prep solutions made available to analysts and developers. At InterWorks, we are constantly vetting these technologies, especially those that are extensible with powerful i...

Data,python,Tableau,TableauPrep,TabPy

Can you build an app to visualise wildfires?

Jul 15, 2021 Donna Coles | donnacoles.home.blog

Ann Jackson’s husband Josh (@VizJosh) set the challenge this week, to build an ‘application’ to help visualise the scale of wildfires; that is when a fire is said to be 5000 acres, you can use the app to view how that compares to an area of the wo...

Using tabcmd in Command Prompt to edit Tableau Server

Jul 13, 2021 Harry Osborne | www.thedataschool.co.uk

There are benefits of having control of Command Prompt’s functionality when influencing Tableau Server; however, this is a fairly intimidating experience. This blog post walks through some simple use cases for tabcmd.

DataScience

How to Weight Survey Data

Jul 13, 2021 Henry Mak | www.thedataschool.co.uk

In this blog post, Henry walks you through the method of weighting survey data. He demonstrates this via an example in Excel.

DataScience

All things data: Part 1

Jul 13, 2021 Garth Turner | www.thedataschool.co.uk

The first part in a series that will aim to discuss all things data, and how Tableau and Alteryx can make the journey that much easier.

DataScience

Customer Retention Analysis: How Data Science Can Predict Customer Churn

Jul 13, 2021 Christina Bernard | www.tessellationtech.io

Customer Retention Analysis: How Data Science Can Predict Customer Churn As an analytics consultant, I talk to a lot of managers that wonder what data science can actually do for their business. Oftentime I hear: … it’s just an overrated … Read Mo...

DataScience

The Transformational Power of dbt in Analytics

Jul 13, 2021 Colin Murray | interworks.com

Many of us have seen the recent news that dbt received another round of funding to continue growing its platform. For those unfamiliar with dbt, now is the perfect time to give you an introduction and discuss how it can play a role in your…The pos...

Data,analyticsengineer,datatransformation,dbt,ELT,ETL

#MakeoverMonday 2021 Week 28 - COVID Vaccination Rates by Ethnicity and ...

Jul 12, 2021 VizWiz (noreply@blogger.com) | www.vizwiz.com

How can ethnic groups be treated differently when it comes to the COVID vaccine? It’s terrible! And this data from NHS England clearly demonstrates the racial divisions that exist in this country.I’m not sure what happened during the recording, bu...

age,areachart,color,combinedaxis,covid,dualaxis,ethnicity,health,heatmap,herdimmunity,inequality,levelofdetail,linechart,LOD,MakeoverMonday,race,rate,tablecalc,vaccine,wellness

15 Tips for being a Project Manager

Jul 12, 2021 Henry Mak | www.thedataschool.co.uk

After reflecting on his experience of being a PM, Henry gives some tips for running a successful project

Dashboards,Tableau,Technical,dashboard,dashboarddesign,dashboarding,prototyping,tableau

How to Use Multiple Collapsible Containers in Tableau

Jul 12, 2021 Luke Stanke | www.tessellationtech.io

How to Use Multiple Collapsible Containers in Tableau Tableau 2021.2 presented a new feature that allowed for collapsible containers on dashboards. This tutorial shows you how to use multiple collapsible containers on a dashboard. For background, ...

Dashboards,Tableau,Technical,dashboard,dashboarddesign,dashboarding,prototyping,tableau

Track and Understand Tableau Dashboard Usage with a Free and Open-Source...

Jul 12, 2021 Istvan Korompai | medium.com

We are thrilled to announce that Tableau Usage Tracker, Starschema’s Tableau extension for measuring and understanding dashboard usage, is now free and open-source. To help you make the most of the software, we’ve put together a quick-start guide ...

monitoring,data-visualization,open-source,tableau,admin

Tableau 2021.2 New Feature: Show and Hide Everything!

Jul 12, 2021 Sebastian Deptalla | interworks.com

With the recently released version 2021.2 of Tableau Desktop, Tableau fulfilled a wish I never knew I had: I am now going to use the Show/Hide button on any tiled element on every future dashboard I will ever build! (Well, at least I hope so.)…The...

Data,2021.2,newfeature,show/hide,Tableau

Week 15: Running Average - Alteryx | DS23

Jul 11, 2021 Auguste Navickyte | www.thedataschool.co.uk

Using Multi-Row Formula tool on Alteryx to calculate 3 and 6 month running averages.

DS24 Training Blog - Week 5

Jul 11, 2021 Liu Zhang | www.thedataschool.co.uk

Photo by Marvin Meyer[https://unsplash.com/@marvelous?utm_source=ghost&utm_medium=referral&utm_campaign=api-credit] / Unsplash[https://unsplash.com/?utm_source=ghost&utm_medium=referral&utm_campaign=api-credit]Day 1:This week, we s...

Sheet Swapping in Tableau

Jul 10, 2021 Harry Osborne | www.thedataschool.co.uk

Swapping between sheets in Tableau can be a bit fiddly, particularly when using buttons. This blogpost is a walkthrough of how to build this sheet swapping functionality.

Regex vs Text to Columns

Jul 9, 2021 Hannah Murphy | www.thedataschool.co.uk

A brief overview of the Text to Columns and Regex tools, their uses, limitations and when and how to use them to split your data

Data,Tableau,TableauTableCalculationHighlights

Tableau Table Calculation Highlights: Advanced Options

Jul 9, 2021 Robin Schouten | interworks.com

The final blog in this mini series on Tableau table calculations focuses on more advanced capabilities users can execute. The first post discussed a foundational understanding of table calculations, and the second tackled the various types of calc...

Data,Tableau,TableauTableCalculationHighlights

Tableau: filtering a filter

Jul 8, 2021 Ali Agah | www.thedataschool.co.uk

In this blog, I explore two ways of creating cascading filters.

Alteryx,Dashboards,alteryxtraining,dashboarddesign,prototyping

Dashboard Design Best Practices: How To Prototype

Jul 8, 2021 Jacob Blizzard | www.tessellationtech.io

Dashboard Design Best Practices: How To Prototype This blog is the second in a series on prototyping. In this series, Autumn Battani and I will walk you through why prototyping can help benefit your development process, options that you have … Rea...

Alteryx,Dashboards,alteryxtraining,dashboarddesign,prototyping

Month to Date Compared to Last 12 Months in Tableau

Jul 8, 2021 Eric Parker | onenumber.biz

By: Eric Parker

TableauDates,TableauCalculations

How to Build an XmR Chart in Tableau

Jul 8, 2021 Steve Taylor | interworks.com

In this blog, I’ll run through the steps to build an XmR control chart, which is typically used to determine if a manufacturing or business process is in a state of control. In this example, I’m using call volume data to pick out any weeks…The pos...

Data,chart,movingrange,Tableau,XmR

Can you find the top and bottom performers?

Jul 8, 2021 Donna Coles | donnacoles.home.blog

The challenge this week came from Candra McRae, where the focus was to use statistics to identify the top & bottom performers, rather than the more common ‘top n’ and ‘bottom n’. By statistics, we’re specifically looking records within the top...

#WOW2021 Week 26 - Profitability With a Dual Axis Chart

Jul 7, 2021 VizWiz (noreply@blogger.com) | www.vizwiz.com

Typically our Wise Up Wednesday crew do these together but today, I was on my own In this video, I take you through how I completed Workout Wednesday 2021 week 26. It’s a bit of a ramble since I started from scratch, but I got there.Video and solu...

analysis,calculatedfield,charts,color,dualaxis,formatting,graphs,howto,levelofdetail,LOD,parento,tablecalculation,tableau,tip,tutorial,WorkoutWednesday,WOW2021

Where to find all Alteryx tool icons

Jul 7, 2021 Liu Zhang | www.thedataschool.co.uk

Finally the complete set of icons for all Alteryx tools in one place.

Alteryx,Tutorial,alteryxtraining

Level of Detail Calculations - The Basics

Jul 7, 2021 Adam Ratcliffe | www.thedataschool.co.uk

LODs: Level of Detail Calculations. The calculation monster under the Tableaubed. Marred with confusing complexity. Nah! Let’s talk about it, it isn’t thatbad I promise.

Alteryx,Tutorial,alteryxtraining

Generate Rows | Alteryx Tools Explained

Jul 7, 2021 Harry Osborne | www.thedataschool.co.uk

Generate Rows is an extremely useful tool that lives inside the Preparation tab. Here, I explain some use cases in depth.

Alteryx,Tutorial,alteryxtraining

Taking Apart Toys to Tessellation: Taguma Nicholas’ Journey to Analytics...

Jul 7, 2021 Taguma Nicholas | www.tessellationtech.io

Taking Apart Toys to Tessellation: Taguma Nicholas’ Journey to Analytics Consulting Curiosity Turned to Passion The most distinguishing attribute I inherited from my Father is a sense of curiosity, his interest in Computer Programs and Design, and...

Careers,journey,CareerInsights,Consulting,JourneytoTessellation

How I Went from High-Fashion Showroom Manager to Data & Tech Client Mana...

Jul 7, 2021 Jessica Welch | interworks.com

Ever since I was a little girl, I was determined to live in New York City. The buildings, the lights, the shows … but I also think the grit that one had to have in order to live there drew me to The Big Apple….The post How I Went from High-Fashion...

Culture,culture,fashion,HowIWentFrom,sales