Blue vs. Green - What does it mean

Jun 27, 2023 VizWiz (noreply@blogger.com) | www.vizwiz.com

When I first started using #Tableau, I assumed that blue meant dimensions and green meant measures. They don’t.Blue means DiscreteGreen means ContinuousIt took me a couple of years to get my head around this most foundational concept in Tableau.Di...

aggregate,blue,continuous,continuousdimension,continuousmeasure,count,dimension,disaggregate,discrete,discretedimension,discretemeasure,fill,green,group,headers,howto,measure,split,tableau

Tableau Containers Understanding the concepts

Jun 27, 2023 Nitesh Shrestha | www.thedataschool.co.uk

Have you ever faced challenges in positioning your charts in Tableau as per your desired layout? I can certainly relate to that struggle, and I used to assume that using floating charts was the only solution for good design, which is not true. Flo...

DataPrep,Fundamentals,Strategy,TipsTricks

SQL Databases The Basics

Jun 27, 2023 Nayeli Jaime | www.thedataschool.co.uk

One of the most fundamental tools that a data analyst can have in their arsenal is SQL, also known as Structured Query Language. SQL allows users to interact with relational databases. More specifically, it is a programming language that allows yo...

Data

From personal project to Data School app.

Jun 27, 2023 Terrence Miller | www.thedataschool.co.uk

There was a lot of growth from me learning about Tableau during my Fullstack Academy bootcamp to me submitting my initial application for the data school.

Data

Back to Basics Using a Wildcard with the Input Tool in Alteryx

Jun 27, 2023 Jessica Kwan | www.thedataschool.co.uk

In the event that there are multiple sheets in an Excel workbook or multiple files that need to be brought into Alteryx, there are various ways to do this. One way would be to bring them all in using an Input tool for each file and blend the data ...

Data

Getting SaaSy with Matillions Data Productivity Cloud

Jun 27, 2023 Fadi Al Rayes | interworks.com

In today’s tech landscape, the rapid increase of data and the migration of systems to the cloud has significantly diversified the range of data loading and processing tools available. For a data engineer, it’s like being in a room full of differen...

Data

MakeoverMonday 2023 Week 26 The UKs Drinking Culture

Jun 26, 2023 VizWiz (noreply@blogger.com) | www.vizwiz.com

This week I delve into drinking, a topic that has long been integral to British culture. We covered lots during the live stream. I started by attempting to recreate the original, but couldn’t get it to work. I went on to build:1. Stacked bars2. St...

bulletgraph,combinationchart,donutchart,drinking,floating,howtocreate,howmake,MakeoverMonday,mobile,roundedbars,stackedbarchart,tableau,tip,tutorial,UK

Taking the Alteryx Designer Core Exam

Jun 26, 2023 Afnan Foyez | www.thedataschool.co.uk

I am writing this to document my experience preparing for and taking the Alteryx Designer Core exam as someone without any prior experience with Alteryx.I hope that you, the reader, might benefit from it.

DataPrep,Fundamentals,Strategy,TipsTricks

How I got an 100 on the Alteryx Foundation Micro-Credential

Jun 26, 2023 Sabrina Vazquez | www.thedataschool.co.uk

This week I took my Alteryx Foundation Micro-Credential and got an 100% on my first try with only around 16 hours of intense prep.

DataPrep,Fundamentals,Strategy,TipsTricks

Back to Basics Set Up a Connection Using the Input Tool in Alteryx

Jun 26, 2023 Jessica Kwan | www.thedataschool.co.uk

As I mentioned in my previous blog, as part of the preparation for my first placement, I wanted to spend some time going through the basics of Alteryx. Coincidentally, Cohort 4 is also currently learning about Alteryx and getting their Micro and C...

DataPrep,Fundamentals,Strategy,TipsTricks

Ten Questions for ChatGPT about Tableau and Level of Detail Expressions

Jun 26, 2023 Dan Murray | interworks.com

I had some fun with ChatGPT asking it questions about cohort analysis this week. I’ll spare you the 4,000 words it created on general questions I prompted on cohort analysis and focus on the topics related to Tableau, Level of Detail expressions a...

Data,AI,ChatGPT,LOD,Tableau

Building Solutions with InterWorks at Coriniums Data Architecture Confer...

Jun 26, 2023 Robert Curtis | interworks.com

InterWorks was a proud sponsor of the Data Architecture Conference hosted by Corinium in Melbourne on 21 and 22 June 2023. Hundreds of data professionals gathered to hear about the latest trends, explore use cases and hear about the latest feature...

Data,News,Australia,CDAO,Events,Melbourne

How to Use Parameter Actions to Compare Two Points for Analysis

Jun 26, 2023 Sean Miller | www.hipstervizninja.com

Check out this tutorial covering how to use parameter actions to compare two points for analysis in Tableau. This is based on the Workout Wednesday challenge for 2023 week 25.The post How to Use Parameter Actions to Compare Two Points for Analysis...

WorkoutWednesday,CommunityProjects,dualaxis,linechart,parameteraction,parameters,referenceline,tablecalcs,variance

Make Your Tableau Bins Dynamic

Jun 26, 2023 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

I find histogramsto be fascinating—both in the insights that they can bring us and in thevarious complexities we run into when creating them in Tableau. If you’re aregular reader of our blog or you happened to catch Kevin and I at TableauConferenc...

DataViz,How-To,Tableau

Bringing Tables Together Tableaus Physical Layer

Jun 24, 2023 Felicia Styer | playfairdata.com

Welcome to our series on bringing tables together in Tableau! This first article is all about the physical layer, including…The post Bringing Tables Together: Tableau’s Physical Layer appeared first on Playfair Data.

DataPrep,Fundamentals,Strategy,TipsTricks

Data Types in Alteryx

Jun 23, 2023 Nitesh Shrestha | www.thedataschool.co.uk

In Alteryx, a comprehensive understanding of the data types is essential as the data preparation and calculations rely on data types. Alteryx supports multiple data types including String, Numeric, Date-time, Boolean, and Spatial objects. Most of ...

WorkoutWednesday,WOW2023,ConnectLines,CustomFormat,DottedLine,DualAxis,MovingAverage,ParameterActions,Path,SpecialValues,TableCalcs,Week25,WindowMax

Back to Basics Intro to Alteryx Design - Interface

Jun 23, 2023 Jessica Kwan | www.thedataschool.co.uk

As preparation for my first placement, I am going back to the basics of Alteryx and aim to attempt the Alteryx Advanced certification some time in July. While I review, I would also like to create a series of blogs covering everything from the bas...

WorkoutWednesday,WOW2023,ConnectLines,CustomFormat,DottedLine,DualAxis,MovingAverage,ParameterActions,Path,SpecialValues,TableCalcs,Week25,WindowMax

Applying for The Data School

Jun 23, 2023 Nadia Holloway | www.thedataschool.co.uk

So you’ve found The Data School and are keen on applying (great choice by the way!) but don’t really know what to expect? Well, the application process is a little different to the standard (and quite frankly boring and outdated) application proce...

WorkoutWednesday,WOW2023,ConnectLines,CustomFormat,DottedLine,DualAxis,MovingAverage,ParameterActions,Path,SpecialValues,TableCalcs,Week25,WindowMax

Alumni Spotlight Thomas Luthi-Bhatti

Jun 23, 2023 Mel Niere | www.thedataschool.co.uk

Learn more about Thomas’ experience, from the time he applied to The Data School, to his career as a Sustainability Manager at BCG. Thomas was part of Cohort 11 of The Data School London, which took place from October 2018 to February 2021.

WorkoutWednesday,WOW2023,ConnectLines,CustomFormat,DottedLine,DualAxis,MovingAverage,ParameterActions,Path,SpecialValues,TableCalcs,Week25,WindowMax

Alchemy in Alteryx Design

Jun 23, 2023 Otto Richardson | www.thedataschool.co.uk

My thoughts on the icons in Alteryx

WorkoutWednesday,WOW2023,ConnectLines,CustomFormat,DottedLine,DualAxis,MovingAverage,ParameterActions,Path,SpecialValues,TableCalcs,Week25,WindowMax

Transpose makes rows how to use the transpose tool in Alteryx

Jun 22, 2023 Toby Horne | www.thedataschool.co.uk

Unlike Tableau Prep, Alteryx has two separate tools used for pivoting data: ‘Cross Tab’ and ‘Transpose’. The Cross Tab tool is used to transform rows to columns and the Transpose tool transforms columns to rows. “Transpose makes rows” is a simple ...

Data,conference,Event,liveblog,Snowflake,SnowflakeSummit

The Summarize Tool

Jun 22, 2023 Afnan Foyez | www.thedataschool.co.uk

In summary, the Summarize tool in Alteryx is used to aggregate and summarize data based on specified grouping criteria. It allows you to perform calculations and generate a summary of statistics for different groups which you can choose within a d...

Data,conference,Event,liveblog,Snowflake,SnowflakeSummit

Moving My Tableau Repository What is the Tableau Repository and how can ...

Jun 22, 2023 Jessica Kwan | www.thedataschool.co.uk

What is “My Tableau Repository”?

Data,conference,Event,liveblog,Snowflake,SnowflakeSummit

Colors in Calculated Fields Tableau

Jun 22, 2023 Tabitha Diaz | www.thedataschool.co.uk

As our first week diving into Alteryx comes to a close, I have developed an appreciation for Tableau’s coloring within calculated fields.

Data,conference,Event,liveblog,Snowflake,SnowflakeSummit

Live Snowflake Summit 2023

Jun 22, 2023 Danny Tishenko | interworks.com

The post Live Snowflake Summit 2023 appeared first on InterWorks.

Data,conference,Event,liveblog,Snowflake,SnowflakeSummit

Can you calculate a percent difference between a range of dates

Jun 22, 2023 Donna Coles | donnacoles.home.blog

This week’s challenge, set by Lorna, made use of the newly released ‘dotted line’ format in v2023.2, so you’ll need that version in order to achieve the dotted line that spans the 2 marks being compared. If you don’t have this version, you can sti...

WorkoutWednesday,WOW2023,ConnectLines,CustomFormat,DottedLine,DualAxis,MovingAverage,ParameterActions,Path,SpecialValues,TableCalcs,Week25,WindowMax

Intro to the Salesforce Developer Universe

Jun 22, 2023 | www.anyalitica.dev

As a Tableau Visionary and DataDev Ambassador, I was excited to have participated in my first Salesforce conference: TrailblazerDX’23. The conference took place in San Francisco on March 7-8, 2023, and is designed for developers working with the e...

tableau,datadev

Using parameters to switch between charts on a dashboard

Jun 21, 2023 Nadia Holloway | www.thedataschool.co.uk

Ever needed to switch between two chart types on your dashboard - maybe you want to conserve a little room? Here’s a way to do it!

Advanced,ChartTypes,DataPrep,Storytelling

User Filtering in Tableau Server

Jun 21, 2023 Zhengyi Qiu | www.thedataschool.co.uk

In Tableau, the “User Filtering” aka “Row-level Security”  is a feature that allows us to control the data that specific users or groups of users can see and interact with in a Tableau workbook or dashboard. It helps us to customize the data visib...

Advanced,ChartTypes,DataPrep,Storytelling

Inside Tableau Prep Clean Step Filter Clean

Jun 21, 2023 Tabitha Diaz | www.thedataschool.co.uk

Cleaning data is an important part of preparing your data for working with it at any stage. By cleaning your data you are ensuring that the data is the correct quality. When preparing for analysis we want to spend extra care within the cleaning ph...

Advanced,ChartTypes,DataPrep,Storytelling

Ctrl Tableau - Tableau Tips

Jun 21, 2023 Sabrina Vazquez | www.thedataschool.co.uk

There are many “hidden” keyboard shortcuts within Tableau that when utilized, can help make the user experience more seamless.

Advanced,ChartTypes,DataPrep,Storytelling

Breaching Containment

Jun 21, 2023 Vivian Ng | www.thedataschool.co.uk

DSNY4 just started training, and that got me thinking back to my application viz on HIPAA breaches, which I’ve been meaning to go back to, so that I can implement some things I learned during my own training.

Advanced,ChartTypes,DataPrep,Storytelling

Adding an Ordered Sequential Color Palette to Tableau Desktop Example wi...

Jun 21, 2023 Jessica Kwan | www.thedataschool.co.uk

In my previous blog, I made a hexbin map as part of a Workout Wednesday challenge. As part of the Workout Wednesday, Sean Miller (who created the challenge), asked those attempting the WoW to add in a custom color palette. The color range in the i...

Advanced,ChartTypes,DataPrep,Storytelling

A Beginners Guide to Alteryxs Cross Tab

Jun 21, 2023 Olivier Newman | www.thedataschool.co.uk

When dealing with data we often want to go for the long and thin format. Ie transform columns into rows (transpose function). We do have use cases for the inverse. In Alteryx the tool for this is Cross Tab found in the transform section.

Advanced,ChartTypes,DataPrep,Storytelling

How to Build a Reset Filters Button in Tableau

Jun 21, 2023 Ollie Linley | onenumber.biz

I was recently working on a project for a client that had a lot of dimension filters - anywhere from 5-10 on each dashboard. This allowed us to drilldown to the level of information we needed!

TableauDashboards

Tableau Tutorial for Beginners Create Your First Dashboard

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

Learn how to use Tableau and created impressive dashboards. Tableau is easy to use, but it can seem quite complex and confusing at first. The best way for you to learn Tableau is to download the files from the description of this video and follow ...

basics,dashboard,fundamentals,howtocreateadashboard,interactive,publish,server,share,tableau,tableauforbeginners,tip,tutorial

Tableau Prep Challenge Recap Bike Sales Analysis 2021 Week 2

Jun 20, 2023 Michael Bellamy | www.thedataschool.co.uk

During our first week of training at The Data School New York, DSNY 4 completed the Preppindata Challenge - 2021 Week 2, we had the task of analyzing bike sales data. The objective was to generate two separate outputs, one focusing on Sales by Bra...

Tableau

Spell Check on Tableau

Jun 20, 2023 Olivier Newman | www.thedataschool.co.uk

During my final stage interview, a couple of spelling errors were pointed out by the coaching team. I once again found myself cursing Tableau’s lack of spell checker.   Despite being fantastic software this is one aspect that many feel is lacking....

Tableau

Running Sums in Alteryx

Jun 20, 2023 Lydia Wren | www.thedataschool.co.uk

Using the running calculation tool in Alteryx vs the Tableau Prep workaround (spoiler - its easier in Alteryx). Read to the end for some lil Alteryx tips…

Tableau

Pivots in Alteryx

Jun 20, 2023 Asha Daniels | www.thedataschool.co.uk

Pivots in Alteryx feel a little confusing, for starters they aren’t even called Pivots, they’re called Crosstabs and reverse Pivots are Transposes. Once you get going everything starts to make sense and you realise that Alteryx gives quite a lot o...

Tableau

How to check your output on Alteryx

Jun 20, 2023 Olivier Newman | www.thedataschool.co.uk

When carrying out exercises on Alteryx we often end up with a file that looks very similar to the output file. If the data set is small enough we can simply have a quick look. However, if the file is large enough this can be challenging. We can do...

Tableau

Alteryx Using Formulas

Jun 20, 2023 Francisco Rei | www.thedataschool.co.uk

New week = new tool learn. Have a look at how and when to use formulas in Alteryx

Tableau

Alteryx - Text To Columns

Jun 20, 2023 Nadia Holloway | www.thedataschool.co.uk

When preparing data in Alteryx you may at times need to split concatenated data/text into separate columns to make it easier to work with. For example, splitting full names into first and last names or addresses into first line, town, city, postco...

Tableau

Tableau 2023.2s Dotted Lines - Where Should We Use Them

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

Tableau Desktop 2023.2 was just recently released.  It has a lot of great new features including the ability to change a standard line into a dotted (or dashed) line. As I started playing around with it in Tableau, I started to think a...

Tableau

Making dashboards interactive with parameters

Jun 19, 2023 Toby Horne | www.thedataschool.co.uk

Parameters in Tableau are variables that the user can change in order to control what is in view in a dashboard. They are useful for adding interactivity or for helping answer “what if?” questions.

data-monetization,telecommunication,data-science