Combining Data in Alteryx - A crash course in Unions and Joins

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

A brief exploration of ways to combine data in Alteryx - focussing on Unions and Joins, including examples.

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

A self-reflection on my failed application viz

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

Hi, I am Stanley, a new guy getting into the Data School as a member of cohort 37. In a blink of time, I have gone through my first week in Data School. I feel Data School is a place where you can learn state-of-the-art data techniques. Although I...

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

So What’s All This Talk about Zero-ETL Integration ?

Dec 13, 2022 Anjan Banerjee | medium.com

So What’s All This Talk about Zero-ETL Integration?Those who followed AWS’s re:Invent 2022 event may have caught multiple mentions of zero-ETL ingestions — but you’d be forgiven for not being caught up with what zero-ETL is and, even more importan...

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

Using a Python Stored Procedure to Execute Snowflake Metadata Commands i...

Dec 13, 2022 Chris Hastie | interworks.com

In another post earlier this year, we discussed how to store the results of a Snowflake SHOW/LIST/DESCRIBE metadata command in a table. Refresher To refresh our memory, in Snowflake, there are several commands that can be used to retrieve metadata...

Data,Metadata,python,Snowflake,storedprocedures

Why colour is so important? Data Viz 101.

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

Colour helps to attract attention of the viewers, communicate meaning and evoke emotions.

Data,Curator,DataWomen,Snowflake,Tableau,VisualDesign

The Data School Differentiators

Dec 12, 2022 Boglarka Lipka | www.thedataschool.co.uk

After one week, I would like to list my observations that I gathered in the last days at the Data School.

Data,Curator,DataWomen,Snowflake,Tableau,VisualDesign

Tableau Analyst Certification: Tips and Resources

Dec 12, 2022 Carol Mhlanga | www.thedataschool.co.uk

The Tableau Analyst Certification is relatively new. We wrote it as a cohort and I was happy to pass the first time.

Data,Curator,DataWomen,Snowflake,Tableau,VisualDesign

Improving the Accessibility of Tableau using Alteryx Automation

Dec 12, 2022 Finn Charlton | www.thedataschool.co.uk

If you’ve ever tried to use Tableau Server without a mouse, you’ll have realised how much of a mess it is. Pressing ‘tab’ to move through a dashboard just bounces you around random graphs and filters with no regard for any logical order. This is b...

Data,Curator,DataWomen,Snowflake,Tableau,VisualDesign

Common errors I made in the application process so you can avoid them!

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

I will take you through common mistakes I made during my application process to the data school and what I learned from making them.

Data,Curator,DataWomen,Snowflake,Tableau,VisualDesign

After my first Data Viz lesson, what would I have done differently in my...

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

It may have been a very straightforward and logical lesson, yet somehow it’s the small details that slip the mind.

Data,Curator,DataWomen,Snowflake,Tableau,VisualDesign

InterWorks Blog Roundup — November 2022

Dec 12, 2022 Mark Cordeiro | interworks.com

We’ve made it to the tail end of 2022. Holiday season is upon us, and it’s fitting that Snowflake is the most blogged about topic for us to share in this edition of the InterWorks Blog Roundup — we randomly had a night of golfball-sized…The post I...

Data,Curator,DataWomen,Snowflake,Tableau,VisualDesign

Intro to LODs

Dec 11, 2022 Diaraye Barry | www.thedataschool.co.uk

Level of Detail calculations, often referred to as LOD is a type of calculation that allows you to perform aggregations at a different level of detail to what is in your view.

Data,Curator,DataWomen,Snowflake,Tableau,VisualDesign

Half Donut Chart in Tableau

Dec 11, 2022 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

I am regularly asked how to create a half-donut chart in Tableau, kind of like this:     My first response is always to recommend another chart, partially because there is typically a better chart that is easier to understand and takes...

DataViz,How-To,Tableau,Templates

What did it take to get into DS37?

Dec 9, 2022 Lorna Brown | www.thedataschool.co.uk

It’s the end of week 1 for DS37, who are the final cohort to start in the year 2022, what a year! But what did it take to get in? The images below show each persons initial application followed by their final interview dashboard!

Using MAKEPOINT & MAKELINE over Traditional Tableau Maps

Dec 9, 2022 Eamonn Woodham | www.thedataschool.co.uk

With this weeks client project, I was creating a map that tracked train journeys from one city to another, the client wanted a map that could be interacted with to show only key cities and the most popular destinations and origins of train journey...

Data,Curator,DataWomen,Snowflake,Tableau,VisualDesign

Three impressive looking charts, made easy!

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

Learn how to transform three standard charts, into three charts that have a little more of a wow factor!

Data,Curator,DataWomen,Snowflake,Tableau,VisualDesign

My first week at The Data School DE

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

Talking about my first experiences as a member of the 4th DS Cohort in Hamburg.

Data,Curator,DataWomen,Snowflake,Tableau,VisualDesign

Map routes

Dec 9, 2022 Archie Boswell | www.thedataschool.co.uk

In the following example, we have information about the origin and destination of flights. We want to drill down into this data by looking at the different routes and filter them by the distance travelled.

Data,Curator,DataWomen,Snowflake,Tableau,VisualDesign

How was my first week at the Data School?

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

To sum it up, it was nerve-racking but exciting at the same time. A lot of questions were going through my mind: Will I be able to understand all the information in German? Will I be able to answer the coaches’ questions?

Data,Curator,DataWomen,Snowflake,Tableau,VisualDesign

How to make a bar-in-bar chart

Dec 9, 2022 Ross Killington | www.thedataschool.co.uk

In today’s blog I’ll be demonstrating how to make a bar-in-bar chart where you have 2 bars fused together with one overlaying the other to represent 2 values for the same dimension.

Data,Curator,DataWomen,Snowflake,Tableau,VisualDesign

How to Create a Navigation Button for Dashboards

Dec 9, 2022 Tara Robinson | www.thedataschool.co.uk

When doing projects we have been producing one dashboard with navigation buttons to switch between dashboards. I am going to go through a tutorial on how to create these buttons.

Data,Curator,DataWomen,Snowflake,Tableau,VisualDesign

Can you make a pie chart?

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

In his final challenge for 2022, Luke set this challenge asking us to recreate this pie chart. Although not mentioned in the challenge text, there was a hint on the splash page that map layers would be required. I’ve only really used map layers in...

How to Conduct Customer Retention & Cohort Analysis

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

In this tip, I’m going to show you how to analyze customer retention and conduct cohort analysis in Tableau.With cohort analysis you group your users based on a shared characteristic to better track and understand their behaviors. Cohort analysis ...

cohortanalysis,comparison,context,dataanalysis,howto,levelofdetail,LOD,tableau,tip,trianglechart,tutorial

#ThrowbackThursday - Week 5 at The Data School

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

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

cloud-computing,data-engineering,data,cloud,data-engineer

Tableau Server - Built In Server Status Dashboards

Dec 8, 2022 Annie Casey | www.thedataschool.co.uk

This week we dove deep into the depths of Tableau Server. We learned how to build our own servers and how to view the status of processes running in Tableau Server.

cloud-computing,data-engineering,data,cloud,data-engineer

Sprint Delivery Circle Timeline

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

When I do not know how to visualize my data, I like to walk around the room. Andy Kriebel’s Visual Vocabulary is hung on the walls, so I approach each canvas and determine which visualization is best suited. After this decision, I come back to my ...

cloud-computing,data-engineering,data,cloud,data-engineer

Look Out for These Data Engineering Trends in 2023

Dec 8, 2022 Anjan Banerjee | medium.com

2022 saw large-scale layoffs and departures across major industries, and things generally seem to be on track towards a big reset. Credible voices are claiming we’re moving into a recession. So how can data-driven organizations prepare themselves ...

cloud-computing,data-engineering,data,cloud,data-engineer

Step-by-Step Guide: Configuring Notion API for Retool

Dec 8, 2022 | andredevries.dev

Are you looking to connect Notion to Retool, but not sure where to start? In this blog post, I’ll show you how to use the Notion API and set up a generic REST API connection in Retool to easily integrate these two powerful tools.

The Journey From Being an Applicant to a Consultant-in-Training (Final C...

Dec 7, 2022 Kinley Ly | www.thedataschool.co.uk

So, after the initial interview, I was given the final task to design another dashboard. However, instead of having the choice to freely select data, I was provided a dataset. Also, I had less time - I needed to have the dashboard completed and re...

accessibility,ui,data-visualization,dataviz,ux

Parameters (How to make a TOP N)

Dec 7, 2022 Kinley Ly | www.thedataschool.co.uk

Parameters are extremely useful functions we can use in Tableau. Parameters are used to quickly change the information shown in your worksheets and dashboards. It essentially allows for user interactivity, similar to filtering.

accessibility,ui,data-visualization,dataviz,ux

How to create a density map with spatial data in Tableau

Dec 7, 2022 Ross Killington | www.thedataschool.co.uk

In this blog I’m going to demonstrate how to make a basic density map using spatial data in Tableau. For this example I will be using rat sighting data based in New York.

accessibility,ui,data-visualization,dataviz,ux

2 Ways To Create Bar in Bar Chart

Dec 7, 2022 Michael Apau | www.thedataschool.co.uk

Bar in bar charts aid in comparing two numerical values based on the length of the individual bars. There are two ways to do this if I want to compare year 2020 sales to year 2021 sales based on each category.

accessibility,ui,data-visualization,dataviz,ux

Data Visualization in 2023 — Seven Trends to Watch

Dec 7, 2022 Hanna Bekefi | medium.com

Data Visualization in 2023 — Seven Trends to WatchFor those professionally involved in data visualization — either as a practitioner or consumer — don’t expect to be here in a year viewing dashboards in a VR headset. 2023 most likely won’t be domi...

accessibility,ui,data-visualization,dataviz,ux

Tableau IF THEN Logic Function Explained

Dec 7, 2022 Eric Parker | onenumber.biz

Every application seems to have it’s own syntax for IF logic statements, right? SQL, Excel and Tableau IF statements all look a little different.

Data,adreporting,dbt,Fivetran

#MakeoverMonday Week 49 - How good are Americans at perceiving demograph...

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

I really liked the original visualization by YouGovAmerica this week, so during Watch Me Viz, I spent the hour working to replicate it. Easy to replicate:Barbell chart with dots on the ends and a line connecting themColoring the lines by the large...

America,barbellchart,colorpicker,dashboard,dotplot,formatting,gridlines,howto,labels,linechart,MakeoverMonday,measurenames,measurevalues,referenceline,survey,tableau,tooltip,YouGov

The Magic of Excalidraw

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

Excalidraw is an amazing tool for visualizing dashboards. It is essentially an online whiteboard, where people can collaboratively design diagrams with a hand-drawn look and feel.

Data,adreporting,dbt,Fivetran

The DateTime function in Alteryx

Dec 6, 2022 Almeera Hasham | www.thedataschool.co.uk

The DateTime function allows you to convert between date and string formats.

Data,adreporting,dbt,Fivetran

Learn What the Data School Learn.

Dec 6, 2022 Tara Robinson | www.thedataschool.co.uk

We were tasked with teaching a session for the general public on specific topics that we have been previously taught. This blog is going to give general tips for how we went about this.

Data,adreporting,dbt,Fivetran

How to map an image background in Tableau

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

I wrote this post while listening to this song. Hit the play button and enjoy!

Data,adreporting,dbt,Fivetran

How to make a bump chart

Dec 6, 2022 Archie Boswell | www.thedataschool.co.uk

At first glance bump charts may look rather complicated or difficult to make, however you’re in luck; this blog will give you a step-by-step guide of how to build them in Tableau.

Data,adreporting,dbt,Fivetran

How to create row ID in Tableau Prep

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

In Alteryx, when we don’t have row ID we can just put a Record Id tool in that creates them. How do we do that in Tableau Prep?There’s not a straightforward function in Tableau Prep. But with these 2 steps can create row IDs.:

Data,adreporting,dbt,Fivetran

Using Mapbox to Make Better Maps in Tableau

Dec 6, 2022 John McKenzie | interworks.com

I recently read this great post by Sarah Battersby about using QGIS to isolate a specific geography on a map in Tableau. Isolating geography is a great way to draw your user’s attention to the focus area, reduce dashboard clutter and give your map...

Data,GeoMask,map,Mapbox,Tableau

How to Use the Fivetran + dbt Ad Reporting Package

Dec 6, 2022 Jason Hoehn | interworks.com

There is a simple and effective way to ingest and transform ad reporting data from multiple platforms by using Fivetran and dbt in tandem. Fivetran is used to ingest the data from a variety of platforms including Apple Search, Facebook, Google, Li...

Data,adreporting,dbt,Fivetran

clean up your workflow

Dec 5, 2022 Daniel Glasenapp | www.thedataschool.co.uk

In today’s blogpost I want to talk about something I always neglected in the beginning. I never annotated or labeled my workflows properly. But it’s not that hard to create a readable flow. It doesn’t matter if it’s a small workflow with only 10 t...

machine-learning,ai,artificial-intelligence,data-science,healthcare

Pivot (Tableau Prep) vs Crosstab & Transpose (Alteryx)

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

This blog will demonstrate the difference between pivoting in Tableau and Alteryx through examples.

machine-learning,ai,artificial-intelligence,data-science,healthcare