Displaying multiple Charts in one Worksheet – The Trellis Chart

Jun 5, 2022 Frederik Egervari | www.thedataschool.co.uk

Trellis Charts are used to display multiple charts on one worksheet. They aregreat to get a quick overview. For example, you could build charts forindividual countries, categories, etc. An example is shown in Fig. 1.

Dashboard Week Day Three

Jun 5, 2022 Tram Nguyen | www.thedataschool.co.uk

Today we received an interesting dataset from Gov.UK, the gender pay gap.Personally, I like the way the website is designed that viewers can downloaddata of companies of their interest with some specific customized filters. Soondid I come to the d...

Tableau – Expand and Collapse Hierarchy using Parameter

Jun 4, 2022 Sreekanth Arathil Condoth | www.thedataschool.co.uk

In Tableau one can create a hierarchy using multiple dimensions, which enablesan easier drill down on the views. The drill-down is done by clicking the + or –symbol on respective views. This way of expanding and collapsing the hierarchiescan be cu...

How to create Top or Bottom N chart

Jun 4, 2022 John Power | www.thedataschool.co.uk

Finished chart:

Bezüglich Container, es geht nur um Übungen

Jun 3, 2022 Tram Nguyen | www.thedataschool.co.uk

Container war schon immer eines der mit Abstand herausforderndsten Themen, wennich ein Dashboard erstelle. Daher entscheide ich mich das Thema Objekthierachiezu detaillieren. Die Verwendung des Containers hilft Ihnen, eine Menge Zeit fürdie Layout...

Jun 3, 2022 Adam McCann (noreply@blogger.com) | duelingdata.blogspot.com

Word Cloud in Tableau

Jun 2, 2022 Mary-Leena Tchenkoue | www.thedataschool.co.uk

Today we had to work with data of Elon Musk’s tweets and one interesting chartthat came to my mind was doing a word cloud of his most tweeted words. You needto have a column containing these tweets; this was also in the dataset.

TableauCalculations

Try not to freak out

Jun 2, 2022 Romina Wiechern | www.thedataschool.co.uk

Today was day three of the Dashboard Week and it is the last week as DataSchooler. Lena gave us a very cool topic: The Gender Pay Gap (https://gender-pay-gap.service.gov.uk/viewing/download). I was very happy towork with the data – till the proble...

How to link your public dataset or anything (elegantly) on your dashboard

Jun 2, 2022 Nhung Le | www.thedataschool.co.uk

Today is the third day of the dashboard week. Each day we receive a dataset fromour mentor, from public sources, and work on an dashboard during the day. Wehave learned that it is nice to have the data source cited in the dashboard, sothat your au...

Dashboard Week Project 3: "The Gender Pay Gap in UK"

Jun 2, 2022 Kristine Wiesner | www.thedataschool.co.uk

“Two individuals, about same age, with degrees, equally smart… one earns less,over qualified, have to work part time and less chances of getting promoted…because shes a woman. “

Dashboard Week Project 2: "Elon Musk's Tweets"

Jun 2, 2022 Kristine Wiesner | www.thedataschool.co.uk

Our second dataset for dashboard week was about Elon Musk’s tweet taken from the Kaggle [https://www.kaggle.com/datasets/ayhmrba/elon-musk-tweets-2010-2021] site.  This is another first, I have not made a dashboard for text analysisbefore.

TableauCalculations

Dashboard Week Day Two

Jun 2, 2022 Tram Nguyen | www.thedataschool.co.uk

The second day of Dashboard Week (3 day in a row that I create 1 dashboardeach). The topic today is quite easy to breath without too many calculations orspecific requirements. Once again, we were allowed to apply our creativity atmost. It deals wi...

Dashboard Week Day 3 – UK’s Gender Pay Gap

Jun 2, 2022 Tanya Fischer | www.thedataschool.co.uk

Today we spent our time analyzing government data on the Gender Pay Gap in theUK. As I learned today apparently every company above 250 employees has toreport the percentage of differences between mean/median hourly pay and bonuspayments.

Dashboard Week Day 3 - Gender Pay Gap UK

Jun 2, 2022 Mary-Leena Tchenkoue | www.thedataschool.co.uk

The famous week finally arrived. The task for the last week of training at theData School is straightforward: everyone gets the same dataset and has topresent  a dashboard at the end of the day. There is vast room for creativity.However, this was ...

10 Tableau String (Text) Functions in 10-ish Minutes

Jun 2, 2022 Eric Parker | onenumber.biz

Manipulating text is one of the primary use cases for Tableau calculations. There are all sorts of things you may want to accomplish with string functions.

TableauCalculations

ZWEITER TAG DER DASHBOARD WEEK

Jun 1, 2022 Romina Wiechern | www.thedataschool.co.uk

Heute war der zweite Tag der Dashboard Week in der Data School. Wir haben amMorgen Daten zu den Tweets der letzten Jahre von Elon Mask bekommen (Quelle: https://www.kaggle.com/datasets/ayhmrba/elon-musk-tweets-2010-2021?select=2019.csv). Ich habe ...

TableauCalculations

Showing dynamic photos on your dashboard

Jun 1, 2022 Nhung Le | www.thedataschool.co.uk

For today’s Dashboard we got this Dataset[https://www.kaggle.com/datasets/ayhmrba/elon-musk-tweets-2010-2021?select=2010.csv]about Elon Musk’s tweets on Kaggle. As a part of the Dashboard, I built aTweeter-liked table showing his tweets and photos...

TableauCalculations

HOW TO: CREATE A BUMP CHART

Jun 1, 2022 Romina Wiechern | www.thedataschool.co.uk

A bump chart is a nice way to visualise the preferences or sales over time. Forthat you have to rank a specific dimension. In my example, I used data thatprovide information on inflows to and outflows from Hamburg (data source: https://www.govdata...

Data,cloud,scalability,Snowflake,WhatMakesGoodAnalytics

Dashboard week Day 3: Fancy Charts

Jun 1, 2022 Patrice Tiana Grant | www.thedataschool.co.uk

Today was the last day of DS29’s dashboard week and we were tasked with creating‘fancy’ charts using a very simple dataset.  This chart would also do some sortof  storytelling using the data, but coming up with a good story was challengingbecause ...

TableauCalculations

Dashboard Week Day One

Jun 1, 2022 Tram Nguyen | www.thedataschool.co.uk

After the Dashboard’s Accessibility session with Ruth on Monday, we began ourDashboard Week with good knowledge of understanding audiences. Tuesday’s gone byexhaustingly with a dataset of Hamburg Migration from the site Gov Data. Thetask is freely...

TableauCalculations

Dashboard Week Day 3 - Art Garfunkel's library

Jun 1, 2022 James Charnley | www.thedataschool.co.uk

For our final day of diminished dashboard week, our data set was a list of everybook Art Garfunkel has ever read, which I actually found interesting on a numberof levels. Additionally, our task was to create something ‘fancy’, which we’vebeen warn...

TableauCalculations

Dashboard Week - Day 3

Jun 1, 2022 Robson Hemans-Alexander | www.thedataschool.co.uk

Today’s challenge was to investigate Art Garfunkel’s library, or more specifically a data set containing a record of all the books he has read and when, year they were published and whether they made it into Garfunkel’s favourite books list.

TableauCalculations

Dashboard Week Day 2 – Elon’s Twitter Career

Jun 1, 2022 Tanya Fischer | www.thedataschool.co.uk

I never thought that I would actually end up having fun with something Elon Muskdoes on Twitter. But today we got to analyze his tweets over the last 12 years.

TableauCalculations

DS29 - Dashboard Week Day 3 - Art Garfunkel’s Library

Jun 1, 2022 Andy Kriebel | www.thedataschool.co.uk

Art Garfunkel is a legendary folk singer that catalogues every book he has read since 1968. The team needs to get creating today and visualize the data with a story and/or chart(s) they’ve never created before.

Data,cloud,scalability,Snowflake,WhatMakesGoodAnalytics

DS29 Dashboard Week - Day 3

Jun 1, 2022 Nathan Purvis | www.thedataschool.co.uk

Dashboard Week and DS training is finally over! Have a read to see what I decided to build and how on my last day!

TableauCalculations

Conditional Formatting for Text in Tableau

Jun 1, 2022 Frederik Egervari | www.thedataschool.co.uk

The feature to color text based on a condition is not built into Tableaunatively, but - as with so many things in Tableau - there is a workaround on howto still include this into your vizzes.

TableauCalculations

Proportional Brushing with a Set Action

May 31, 2022 VizWiz (noreply@blogger.com) | www.vizwiz.com

Proportional brushing allows you to view an item you choose from one chart as a proportion of another chart. For example, you can view the sales for Corporate (from the Segment dimension) as a proportion of the sales of each Region.

analysis,barchart,changesetvalues,chart,comparison,context,createset,dashboardaction,highlightaction,proportionalbrushing,proportions,set,setaction,tableau,tip

Makepoint and Makeline functions in Tableau: easy explanation and tutori...

May 31, 2022 Nhung Le | www.thedataschool.co.uk

For today’s dashboard we have this dataset showing number of people moving fromHamburg to other states in Germany and the other way round. The dataset is here[https://www.govdata.de/web/guest/suchen/-/searchresult/q/Wanderungen+Hamburg/f/groups%3A...

Data,cloud,scalability,Snowflake,WhatMakesGoodAnalytics

Dynamic Top N Filter

May 31, 2022 Mary-Leena Tchenkoue | www.thedataschool.co.uk

One of the common charts for visualisation are Top N charts, for exmaple, top 10Products by sales or profit. Top N filters can be created by putting thedimension on the filter card and using the ‘TOP’ pane in the filterconfiguration pop up. Howeve...

Data,cloud,scalability,Snowflake,WhatMakesGoodAnalytics

Dashboard Week Project 1: "Bevölkerungswanderung in Hamburg"

May 31, 2022 Kristine Wiesner | www.thedataschool.co.uk

Today we worked on the migration data of Hamburg taken from the official GermanData Portal.  The data covers the information from 2020 to 2021 (upto Q3 only).  I used Tableau Prep to clean the data and also referred to my colleague Oksanawho loves...

Data,cloud,scalability,Snowflake,WhatMakesGoodAnalytics

Dashboard Week Day 1 – Migration to/from Hamburg

May 31, 2022 Tanya Fischer | www.thedataschool.co.uk

As in every cohort of the Data School the Dashboard Week marks the end of ourtraining period. This means that each day we are getting a data source in themorning, which we then have to prep and visualize in a way that our dashboardanswers some sor...

Data,cloud,scalability,Snowflake,WhatMakesGoodAnalytics

Compare to a Selected Dimemsion

May 31, 2022 Mary-Leena Tchenkoue | www.thedataschool.co.uk

It is possible to use quick table calculations to display the difference orchange in a quantity, e.g Sales, along a given axis. These table calculationscan also be configured to compare to either the FIRST, LAST, NEXT or PREVIOUSpoint on the given...

Data,cloud,scalability,Snowflake,WhatMakesGoodAnalytics

Bar Charts with Candlestick showing difference in Tableau

May 31, 2022 Nhung Le | www.thedataschool.co.uk

For today’s dashboard, I built a bar chart with candlesticks showing differencebetween bars. This blog is a tutorial on how to do this in Tableau.

Data,cloud,scalability,Snowflake,WhatMakesGoodAnalytics

What Makes Good Analytics: The Beauty & Danger of Scalable Systems

May 31, 2022 Mike Oldroyd | interworks.com

In this post, we’re launching a new blog series that will take a closer look at what makes good analytics. We’ll attempt to home in on various facets of the analytics experience, from the perspectives of developers and end-users alike, and walk th...

Data,cloud,scalability,Snowflake,WhatMakesGoodAnalytics

How to Build Lovely Histograms in Tableau

May 31, 2022 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

At Tableau Conference 2022, Kevin and I did a presentation called How to do Cool Stuff in Tableau.   Note: This was an in-person only session so it’s not available to be viewed, but since we’ve had a lot of requests, we’ll look for an...

How-To,Tableau

Tableau Server: Set Dynamic Row-Level Filters

May 30, 2022 Skomantas Tamulaitis | www.thedataschool.co.uk

There are 2 main stages at which content permissions can be set on TableauServer: 1. Project; 2. Row-level. The most appropriate option will depend on howmuch overlap there is between users interacting with the content. Today I willfocus on the la...

Dashboard week (day 1) - Federal Infrastructure Projects

May 30, 2022 Yana Arkhipenka | www.thedataschool.co.uk

In the morning we received dashboard requirements from Andy:

Dashboard Week Day 1 - Federal Infrastructure Projects

May 30, 2022 James Charnley | www.thedataschool.co.uk

DS29 kicked off dashboard week looking at a US permitting dashboard. Seems fitting. Here’s how it went for me:

Dashboard Week - Day 1

May 30, 2022 Alban Halili | www.thedataschool.co.uk

Today we were given data that tracks the United States Federal government’senvironmental review and authorization processes for large or complexinfrastructure projects. The data can be found on the Permitting DashboardWebsite[https://data.permits....

DS29 - Dashboard Week Day 1 - Federal Infrastructure Projects

May 30, 2022 Andy Kriebel | www.thedataschool.co.uk

For Dashboard Week day 1, DS29 will start by analyzing Federal infrastructure projects in the United States. The focus is on analysis, not design.

DS29 Dashboard Week - Day 1

May 30, 2022 Nathan Purvis | www.thedataschool.co.uk

Day one of the infamous ‘dashboard week’ is finally here! Have a read of my journey through the first dataset of the week.

Alteryx Predictive - Linear Regression

May 30, 2022 James Charnley | www.thedataschool.co.uk

In this blog I’ll give you a brief run down of how the linear regression tool works in Alteryx!

Recreating Hans Rosling's Work in Tableau

May 28, 2022 Kristine Wiesner | www.thedataschool.co.uk

Hans Rosling (1948 - 2017)  was the Swedish physician and professor behind thefamous “Joy of Stats” [https://www.youtube.com/watch?v=jbkSRLYSojo] in 2010 andfounder of Gapminder Foundation.  He made this amazing visualization ofinternational stati...

Tableau Conference Recap – My First But Not My Last!

May 27, 2022 joe.stokes | www.theinformationlab.co.uk

It was a week of firsts: My first trip to Yosemite National Park with an incredibly keen Andy Kriebel leading us up to what at times felt like certain death.My first time in Denny’s, an establishment so generous in portion size no other meal has s...

Blog,TableauConference,TC22

Inspire 2022 Recap

May 27, 2022 Oliver Clarke | www.theinformationlab.co.uk

One week on and the dust has just about settled from my first US Inspire, and my first in-person conference in 4 years. I thought I’d recap my main takeaways along with my favourite sessions from #AlteryxInspire22. Before I start, I should throw a...

Blog,Alteryx,AlteryxInspire,Conference,Inspire2022