Find Replace tool in Alteryx

Dec 20, 2022 Stanley Chan | www.thedataschool.co.uk

Find Replace is a tool for matching the value in the target table using a lookup table. Don’t fool by its name, ‘find and replace’ isn’t its only function. It has two use cases.

Data,CRON,python,Snowflake,UDF

Communicating with Charts

Dec 20, 2022 Lyon Abido | www.thedataschool.co.uk

In this article, I want to talk through three different charts that convey the same information. The purpose of this is to reinforce the importance that charts are tools of communication. My hope is that this article may help to promote thoughtful...

Data,CRON,python,Snowflake,UDF

Can an AI Bot Explain Data Models Better Than Me?

Dec 20, 2022 Stephen Moyse | www.thedataschool.co.uk

Who’s better at explaining? Me or a bot?

Data,CRON,python,Snowflake,UDF

Alteryx Core Certification Practice: Cross Tab, Summarize, DateTime and ...

Dec 20, 2022 Anita Longa | www.thedataschool.co.uk

Task for today was to gather some information and examples about tools within Alteryx. Let me share what I and Kate found about some of those tools.

Data,CRON,python,Snowflake,UDF

Snowflake with Python: Determine Next Event from CRON with a Python UDF

Dec 20, 2022 Chris Hastie | interworks.com

Snowflake itself is really strong at reporting task schedules and history. If you ever use the TASK_HISTORY table function, you can even view the NEXT_SCHEDULED_TIME for each scheduled task. However, it is common to be in a situation where you are...

Data,CRON,python,Snowflake,UDF

9 Tableau Desktop Time Savers

Dec 20, 2022 Robby White | interworks.com

For those who live by the Benjamin Franklin-inspired mantra “every second saved is a second earned” (or maybe that was actually about pennies?), this Tableau time saver post is for you. It’s incredibly refreshing to know that regardless of whether...

Data,Tableau,timesavers,tips

How to Connect to Google API in Alteryx!

Dec 19, 2022 Gerda Staurylaite | www.thedataschool.co.uk

Here’s how to connect to the Google API in Alteryx!

New Viz: Jerry Seinfeld's Girlfriends

Dec 19, 2022 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 Back in July, I posted a viz about my favorite show ever, Seinfeld.  In that viz, I explored the most commonly recurring characters on the show.  If you haven’t seen it, I hope you will check it out.In reality, this isn’t what I was e...

Tableau

How to create and deliver a Key Message

Dec 18, 2022 Lucas Carvalhal Sirieiro | www.thedataschool.co.uk

What is a key message?

Reflective Log

Dec 17, 2022 Keren Aharon | www.thedataschool.co.uk

Client: Great British Rail Transition Team

What and why did I change my application dashboard?

Dec 16, 2022 Sherina Mahtani | www.thedataschool.co.uk

After a full week of Tableau Time and learning about data visualization best practices, its made me view my initial application a lot differently. There are a lot of changes, whether big or small that I could implement in my dashboard which made a...

What I would change about my first application to the data school!

Dec 16, 2022 Kaitlin MacDonnell | www.thedataschool.co.uk

I have reached the end of week 2 at the data school and I was set the challenge of improving my initial application.

Telling a story with squirrel data

Dec 16, 2022 Jack Arnaud | www.thedataschool.co.uk

Every Data School member has a soft spot for their first Tableau dashboard. Not only did we get a job through it, but it’s a great reminder of the progress that we’ve made. With that in mind, DS37 were tasked with improving on their first viz now ...

Tableau Prep and the Profile pane

Dec 16, 2022 Elena Raluca Mazareanu | www.thedataschool.co.uk

My first task as a DSer was preparing a 10-minute presentation on a chosen subject we learned during the week.  My topic was “Cleansing and organizing data using the profiling pane in Tableau Prep”. We also received some presentation points to tal...

Remake of my first application to The Data School.

Dec 16, 2022 Anita Longa | www.thedataschool.co.uk

At the end of week two, DS 37 was asked to rebuild one of our application viz using what we have learnt this week from Data Visualisation best practice along with new calculations and charting techniques.

Redesign my application viz to DS

Dec 16, 2022 Stanley Chan | www.thedataschool.co.uk

In the last blog, I discussed how my failed application viz to DS was terrible. Today I have redesigned it in a more pleasant way!

Redesigning and Dashboarding

Dec 16, 2022 Morgan A Rennie | www.thedataschool.co.uk

A reflective redesign of my initial tableau application to The Data School for DS37 - utilising colour theory, dynamic charts, parameters, and dashboarding.

How to Make a Quadrant Scatter Plot

Dec 16, 2022 Linda Duong | www.thedataschool.co.uk

Let’s use Sample Superstore data to create a scatter plot divided into quadrants using sets.

How I Improved My Application Viz

Dec 16, 2022 Curtis Paterson | www.thedataschool.co.uk

It’s the end of week 2 in DS 37 and our cohort has been asked to improve on one of our application vizzes. I decided to take a look at the viz I had created for the first stage of the application process as I thought it should have plenty of areas...

Five Easy Ways to Improve a Bar Chart

Dec 16, 2022 Elaine Yuan | www.thedataschool.co.uk

I have seen a lot of bar charts that look similar to this:I’m guilty of making such charts, especially at the beginning of my data visualization journey. For anyone applying to the Data School, here are five easy ways to improve a bar chart:

5 Top Tips for Presentations

Dec 16, 2022 Serena Purslow | www.thedataschool.co.uk

Here are my 5 top tips for improving your presentation, and presentation skills (based on what I know so far!!).

Understanding the Metadata (Alteryx)

Dec 15, 2022 Morgan A Rennie | www.thedataschool.co.uk

A brief breakdown of what metadata is, what different data types are available in Alteryx, and the usefulness of data descriptions.

#Throwback Thursday - Week 6 at The Data School

Dec 15, 2022 Serena Purslow | www.thedataschool.co.uk

It’s #throwbackthursday so join me for my weekly reflection on life at the Data School.

LOL: LODs of Love

Dec 15, 2022 Bianca Ng | www.thedataschool.co.uk

What is Level of Detail (LOD)?

How to create a Standard Macro in Alteryx

Dec 15, 2022 Flavio Matos | www.thedataschool.co.uk

You are going to see the different types of Macros and learn how to create a Standard Macro in Alteryx.

TableauGeneralKnowledge

How to change table orientation in Alteryx (2 mins reading)

Dec 15, 2022 Stanley Chan | www.thedataschool.co.uk

This blog is about changing table orientation (or say rotating the table), which I just learn in doing the Alteryx weekly challenge. In excel, we can copy the range of the table and then right-click and select paste with ‘transpose’.

How to calculate the differences between dates in Tableau

Dec 15, 2022 Kaitlin MacDonnell | www.thedataschool.co.uk

As part of my data school training this week, I have learned how to use dates in tableau to find valuable insights. I will take you through how calculate the differences between dates for use in visualisations and calculations. This can be useful ...

Hierarchies - what is it all about?

Dec 15, 2022 Sherina Mahtani | www.thedataschool.co.uk

When connecting your dataset into Tableau, it separates fields that are the date data types into hierarchies so you can easily break down your dashboard. You can also create custom hierarchies for your own convenience, for example - if you have a ...

Dimension vs. Measure. Tableau Fundamentals.

Dec 15, 2022 Anita Longa | www.thedataschool.co.uk

After two sessions in Tableau Fundamentals, I decided to summarise and organise my understanding of dimensions and measures.

Before & After: Butterfly Chart

Dec 15, 2022 Elaine Yuan | www.thedataschool.co.uk

#ThrowbackThursday

A look back on my Final Dashboard Application - What could I have done b...

Dec 15, 2022 Kate Joyce | www.thedataschool.co.uk

In this blog, I am going to look back over my final application dashboard and show what I could have done differently.

Interactive Proportional Brushing

Dec 15, 2022 Donna Coles | donnacoles.home.blog

For her final challenge of #WOW2022, Erica set this interesting challenge; to show how the sales of the top n Products within each Sub-Category compared against the total sales. An added twist was to flip the display between actual sales, and % of...

Tableau - Dynamic axis using parameter

Dec 14, 2022 Stanley Chan | www.thedataschool.co.uk

When making charts for dashboards, very often we analysts have decided which measures be to the x/y axis. However, what should we do if there are too many measures or if we want the user themselves to control which measure to show on the chart? In...

TableauGeneralKnowledge

Parameter - a key to the interactivity of your viz.

Dec 14, 2022 Anita Longa | www.thedataschool.co.uk

I heard about parameters when I was trying to complete my first ever dashboard, however, they seemed to me so mysterious that I didn’t even try using them in my visualization - what a shame!

TableauGeneralKnowledge

My First Week at The Data School

Dec 14, 2022 Curtis Paterson | www.thedataschool.co.uk

It’s been four months since I was accepted into DS 37 at The Data School. It’s been a long wait that’s seemed even longer as I’ve been itching to get going and begin my journey to becoming a Tableau/Alteryx consultant. I arrived on my first day fu...

TableauGeneralKnowledge

How to use parameters to filter the graphs in Tableau.

Dec 14, 2022 Kaitlin MacDonnell | www.thedataschool.co.uk

One of the powerful features of Tableau is the ability to use parameters to filter your charts and data. This allows you to quickly and easily switch between different views of your data without having to create multiple charts or manually change ...

TableauGeneralKnowledge

How to set up a moving reference line in Tableau

Dec 14, 2022 Jack Arnaud | www.thedataschool.co.uk

Reference lines are wonderful visual aides for any line graph. They draw the eye, leading the user to a specific date, while making it simpler to view across different lines at the same point.

TableauGeneralKnowledge

How to Create a Dynamic Measure on Tableau

Dec 14, 2022 Kate Joyce | www.thedataschool.co.uk

In this blog I’m going to demonstrate how to make dynamic measures on Tableau which will allow us to switch between two different measures. I will do this using the Sample Superstore Data.

TableauGeneralKnowledge

Dynamic Parameters - What are they? How do we use them?

Dec 14, 2022 Sherina Mahtani | www.thedataschool.co.uk

What are Dynamic Parameters?

TableauGeneralKnowledge

Creating a Dynamic Measures in Tableau

Dec 14, 2022 Morgan A Rennie | www.thedataschool.co.uk

A photo guide to the creation of Dynamic Measures in Tableau, using the Superstore Data Set!

TableauGeneralKnowledge

How to Tableau: Cross-Database Joins

Dec 14, 2022 Ollie Linley | onenumber.biz

A huge benefit of using joins in Tableau is that we can combine data from multiple tables into a single table for analysis. When those tables are in different databases, it can be a little tricky to work out where to start. If you know how to join...

TableauGeneralKnowledge

#MakeoverMonday Week 50 - Which Countries Get the Most Vacation Days?

Dec 13, 2022 VizWiz (noreply@blogger.com) | www.vizwiz.com

This week’s data set focused on the vacation time and paid public holidays (or lack thereof) of countries around the World.I remember when I started working at Coca-Cola. I got 10 days of vacation time for my first 2 years. Then I got 1 additional...

MakeoverMonday,tableau,tip,WorkoutWednesday

SCOPE CREEPIN’

Dec 13, 2022 Mohammed Uddin | www.thedataschool.co.uk

Scope creep is when a client adds new requests; on top of their initial requests. At this point you have to optimize how much work you agree to do; versus how you can do it.

gcp,data-replication,data-engineering,snowflake,aws

My First Week in the Data School - DS37

Dec 13, 2022 Kate Joyce | www.thedataschool.co.uk

It feels like an age since I started my journey with the Information Lab. I started my application 4 months ago when I had not even moved to London yet! A week in and it already feels like I am settled in. I guess gatecrashing the Christmas Party ...

gcp,data-replication,data-engineering,snowflake,aws

Forming a Negative Intercept Line

Dec 13, 2022 Morgan A Rennie | www.thedataschool.co.uk

A brief photo guide to adding a negative intercept line to your scatterplot in Tableau

gcp,data-replication,data-engineering,snowflake,aws