Replicating a Dashboard with Containers

Aug 10, 2022 Zachary Ryan | www.thedataschool.co.uk

We were tasked with replicating a dashboard that we found, with only using containers. Here’s how I did mine!

Data,constants,joins,queries,relationships,Tableau,TableauTips

Recreating Dashboards: Containers

Aug 10, 2022 Nermine Obeng | www.thedataschool.co.uk

Containers: you either love them or hate them.

Data,constants,joins,queries,relationships,Tableau,TableauTips

Imposter syndrome

Aug 10, 2022 Angelica Obi | www.thedataschool.co.uk

Mental health is not only affected by people around you. The expectations you place upon yourself can be damning too. I’ve found that with imposter syndrome.

Data,constants,joins,queries,relationships,Tableau,TableauTips

How to remove duplicates in tableau prep

Aug 10, 2022 Joel Akaje-Macauley | www.thedataschool.co.uk

Learn and follow along on how to remove duplicates within tableau prep

Data,python,Snowflake,SnowPark,UDF

How To: Dashboard Design (Containers)

Aug 10, 2022 Gerda Staurylaite | www.thedataschool.co.uk

Here’s how to use containers for your dashboard design!

Data,constants,joins,queries,relationships,Tableau,TableauTips

Containers in Tableau

Aug 10, 2022 Beau Foletti | www.thedataschool.co.uk

Making a dashboard look appealing should be high in your priorities as a dashboard designer. Containers in Tableau make it easy to structure your work so you can present it in many different ways and also make it easy to resize and reorganise things.

Data,constants,joins,queries,relationships,Tableau,TableauTips

Containers/Excalidraw

Aug 10, 2022 Peter Hajnal | www.thedataschool.co.uk

Week 6 and we are learning about dashboards. One good idea is to always draw your ideas, drawing is great. Helps you clarify what and how do you want to show data on your dash. It also makes dashboarding a whole lot quicker.

Data,constants,joins,queries,relationships,Tableau,TableauTips

Containers 101

Aug 10, 2022 Bridget Ama Boateng | www.thedataschool.co.uk

Firstly, what are containers?

Data,constants,joins,queries,relationships,Tableau,TableauTips

Average vs Weighted Average

Aug 10, 2022 Pooja Srivastava | www.thedataschool.co.uk

To understand weighted average first we need to understand what is average? In calculating a simple average, or arithmetic mean, all numbers are treated equally and assigned equal weight. But a weighted average assigns weights that determine in ad...

Data,python,Snowflake,SnowPark,UDF

Tableau Relationships: Tips and Tricks

Aug 10, 2022 Sebastian Deptalla | interworks.com

There are quite a few tips and tricks out there for Relationships in Tableau; just not nearly as many as for every other topic in Tableau, which is a shame. Nevertheless, this article is supposed to grow over time, and we start with something very...

Data,constants,joins,queries,relationships,Tableau,TableauTips

‘Why should you apply early to The Data School New York?’

Aug 9, 2022 ross.easton | www.theinformationlab.co.uk

The deadline to apply for The Data School New York’s second cohort DSNY2 is August 12, but you don’t need to wait that long to apply! Here are our top 5 reasons why you should apply early to The Data School New York.The post ‘Why should you apply ...

Blog,DataSchool,DSNY,NewYork

Relationships in Tableau: Direct and Indirect connections

Aug 9, 2022 ali.agah | www.theinformationlab.co.uk

Intro I was introduced to relationships in PowerBI and wished Tableau had an equivalent. So, I was ecstatic when Tableau 2020.2 added relationships AND made them more flexible than they are in PowerBI! However, with great flexibility comes great r...

Blog,Database,Joins,Relationships,TableauDesktop

‘Why should you apply early to The Data School New York?’

Aug 9, 2022 Ross Easton | www.thedataschool.co.uk

The deadline to apply for The Data School New York’s second cohort DSNY2 is August 12, but you don’t need to wait that long to apply! Here are our top 5 reasons why you should apply early to The Data School New York.

Data,python,Snowflake,SnowPark,UDF

Some things to consider when creating data visualisations

Aug 9, 2022 Cammy Phillips | www.thedataschool.co.uk

Some considerations that will make your visualisations stand out aside from what charts are being used

Data,python,Snowflake,SnowPark,UDF

Organisation is key

Aug 9, 2022 Lauren Halliwell | www.thedataschool.co.uk

Today, I started my second week in training at the Data School. On day 6 of training, we were asked how we had organised all the information we had previously received.

Data,python,Snowflake,SnowPark,UDF

Containers Design in Tableau

Aug 9, 2022 Ana-Casiana Tarita | www.thedataschool.co.uk

Containers are a critical part of a dashboard.  You can have more control over your sheets using containers while building your dashboard.

Data,python,Snowflake,SnowPark,UDF

A Definitive Guide to Python UDFs in the Snowflake UI

Aug 9, 2022 Chris Hastie | interworks.com

Snowpark for Python is the name for the new Python functionality integration that Snowflake has recently developed. At the Snowflake Summit in June 2022, Snowpark for Python was officially released into Public Preview, which means anybody is able ...

Data,python,Snowflake,SnowPark,UDF

Unionising and Joining Data in Tableau Prep and Alteryx

Aug 8, 2022 Cammy Phillips | www.thedataschool.co.uk

Examples of why you would join or unionise data in softwares such as tableau prep and alteryx

Español,#KPI,#Parameter,#ParameterActions

Modern Data Architecture: What is it, and why is it so important?

Aug 8, 2022 Ben Winsey | www.thedataschool.co.uk

An insight into modern data architecture, and why it is relevant.

Español,#KPI,#Parameter,#ParameterActions

Comparing Cumulative Sales Current vs. Prior Years in Tableau

Aug 8, 2022 Kristine Wiesner | www.thedataschool.co.uk

One of the useful chart to show comparison of multiple years performance or metrics is a cumulative chart. Say I want to compare the cumulative Sales for the last year and current year up to the current month.  The calculation is straight forward:

Español,#KPI,#Parameter,#ParameterActions

Panel de KPIs – #WOW2022 W31

Aug 8, 2022 Rosario Gauna | rosariogaunag.wordpress.com

Los principales requerimientos del desafío de Sean Miller para la semana 31 de #WOW2022 son:   Desplegar los totales de 4 KPIs, cada uno utilizando un formato personalizado de números: Sales:          $2.30M Profit:             $286.4K Profit %: ...

Español,#KPI,#Parameter,#ParameterActions

Let’s Build a KPI Dashboard – #WOW2022 W31

Aug 8, 2022 Rosario Gauna | rosariogaunag.wordpress.com

The main requirements of Sean Miller’s challenge, for week 31 of #WOW2022 are:   Display totals for 4 KPIs, each using a custom number format: Sales:          $2.30M Profit:              $286.4K Profit %:      12.5% # of Orders:    5,009 Allow wi...

English,#Parameter,#ParameterActions

Swapping Sheets on a Dashboard

Aug 6, 2022 Daniel Glasenapp | www.thedataschool.co.uk

Imagine you have two or more different charts and you want to display them in full size in a single dashboard.

Modern Analytics Architecture

Aug 5, 2022 Angelica Obi | www.thedataschool.co.uk

Analytics today, analytics 10 years ago….. has much changed? And WHAT!!!! is analytics architecture.

Joining by Range in Alteryx

Aug 5, 2022 Finn Charlton | www.thedataschool.co.uk

Learn how to Join By Range in Alteryx.

I've found home

Aug 5, 2022 Angelica Obi | www.thedataschool.co.uk

Week one has ended and honestly, The Data School is a family and the community feels like home. Here’s how my first week went.

Building a sankey chart

Aug 5, 2022 Heinrich Preuß | www.thedataschool.co.uk

In our first external client project, we worked with a company that provides heating, cooling and electricity for facilities. We were asked by the client to create a Sankey diagram showing the energy (in kWh) flowing through the building.

5 things I have gained in my first week of the Data School

Aug 5, 2022 Cammy Phillips | www.thedataschool.co.uk

A few thing I have learnt and recognised in my first 5 days at the data school

ATTR - The Most Confusing Aggregation in Tableau

Aug 4, 2022 VizWiz (noreply@blogger.com) | www.vizwiz.com

Aggregations can be difficult to understand. In Tableau, I find the ATTR (attribute) aggregation the hardest to get my head around. In this video, I teach you: What an attribute isWhy the attribute aggregation exists Examples that show how it work...

aggregation,analysis,attribute,calculatedfield,comparison,context,howto,scatterplot,tableau,tip,tooltip,tutorial,vizintooltip

Using Templates in Tableau – Sankeys Made Easy

Aug 4, 2022 ross.easton | www.theinformationlab.co.uk

Ever wanted to build a Sankey diagram in Tableau but felt like you were out of your depth? This blog serves as a guide to quickly and easily produce a Sankey diagram, as well as providing an introduction to using templates in Tableau more generall...

Blog,sankey,TableauDesktop,template

Why should I care about Tableau Prep? - Day 1 of Tableau Prep

Aug 4, 2022 Lauren Halliwell | www.thedataschool.co.uk

Alteryx is an intuitive, code-free data science software, which comes preinstalled with almost all of the data science tools you would need. However, it has a lot of functions which are not required purely for data preparation. This is where Table...

TableauDashboards

Testing statistical significance in tableau and Alteryx

Aug 4, 2022 Joel Akaje-Macauley | www.thedataschool.co.uk

Explaining Pearsons correlation and P-values in alteryx

TableauDashboards

Stats 101: Average vs. Weighted Average

Aug 4, 2022 Imogen Emmett | www.thedataschool.co.uk

What is the difference between a normal average and a weighted average?

TableauDashboards

Joining Tables in Tableau Prep

Aug 4, 2022 Arnold Quarcoo | www.thedataschool.co.uk

A short tutorial on how to join separate tables in Tableau Prep.

TableauDashboards

How to make Z-Score in Tableau

Aug 4, 2022 Longyan Chen | www.thedataschool.co.uk

Requirement: Make the Z-Score to outliers of average price by room type.

TableauDashboards

How to get rid of a highlighted chart when it is selected in Tableau.

Aug 4, 2022 Sophie Higson | www.thedataschool.co.uk

If you get confused between count and count distinct and which one you should use then hopefully this can clarify a few things.

TableauDashboards

How to Write Multiple Excel Sheets in Alteryx

Aug 4, 2022 Maha Hussari | www.thedataschool.co.uk

If you want to write in multiple sheets in the same excel file, this is the blog for you!

TableauDashboards

How to Calculate Z-scores in Tableau pt. 1

Aug 4, 2022 Marcelo Ramos | www.thedataschool.co.uk

Do you want to find the biggest outliers in your view on your Tableau Worksheet? Calculating z-scores will allow you to find how many standard deviations away from the mean your values are, and in turn show you those that are the furthest away fro...

TableauDashboards

Cleaning Data in Tableau Prep

Aug 4, 2022 Hannah Laughton | www.thedataschool.co.uk

How to clean a quantity field containing both values and units (different units) to have values only - all of which correspond to the same unit.

TableauDashboards

Banter and Networking

Aug 4, 2022 Ozlem Sigbeku | www.thedataschool.co.uk

A short reflection on presenting with Maha at the meet and greet.

TableauDashboards

Alteryx vs Tableau Prep - Battle of the Preps

Aug 4, 2022 Carol Mhlanga | www.thedataschool.co.uk

We don’t hear much about Tableau Prep because most people are fascinated by Alteryx. In my opinion, Tableau is consistent with it’s brand - its quick to learn and simple to use. Its not as advanced as Alteryx so people tend to default to Alteryx.

TableauDashboards

How to Expand and Contract a Text Table in a Tableau Dashboard

Aug 4, 2022 Eric Parker | onenumber.biz

Users love text tables. No matter how much we steer them toward data visualizations that do a better job of exposing patterns, outliers and areas of interest, many users are still most comfortable viewing data in a table.

TableauDashboards

Tableau Relationships: Basics – The Ground Rules

Aug 4, 2022 Sebastian Deptalla | interworks.com

Until Tableau version 2020.1, whenever we had two or more tables that we wanted to connect with each other, we had to either join them or blend them. If you aren’t sure about joins, please take a minute and get yourself up to speed. We…The post Ta...

Data,joins,measures,relationships,Tableau,tables

Let’s Build a KPI Dashboard

Aug 4, 2022 Donna Coles | donnacoles.home.blog

Sean set this fun and very relevant challenge this week displaying key measures (KPIs) along with further details for a selected measure displayed in a horizontal layout rather than the more traditional long-form, using ranking. The ‘gotcha’ part ...

Wildcard in Alteryx (*)

Aug 3, 2022 Hannah Laughton | www.thedataschool.co.uk

Using the Input Data tool and want to import multiple files simultaneously? Wildcard is your friend!