Eigene Farbpalette mit Adobe Color

May 15, 2022 Oksana Kirschbaum | www.thedataschool.co.uk

Mit Adobe Color kann man seine eigene Farbpalette für ein Dashboard entwickeln.Direkt auf der Startseite gibt es die Möglichkeit Farben auf dem Farbrad zuwählen.

Dashboard Buttons

May 15, 2022 Oksana Kirschbaum | www.thedataschool.co.uk

Some users prefer to use buttons instead of switching parameters or filters,especially when a small number of variables are used. Such buttons can becreated in Tableau.

Yes, you can update PowerPoints with Alteryx!

May 13, 2022 Patrice Tiana Grant | www.thedataschool.co.uk

DS29 had a challenge that has never been done before. How to update and change PowerPoint slides using an Alteryx Workflow. Including the detailed workflow.

Tableau

Color individual Columns in a Table in Tableau

May 13, 2022 Frederik Egervari | www.thedataschool.co.uk

Tableau’s strong side aren’t tables. That’s why it is sometimes difficult tofind all the different settings to format your table the way you want to.

Tableau

Tips for passing the Alteryx Designer Advanced certification

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

Thinking about tackling the Alteryx Designer Advanced certification? Make sure to give this blog a read for some core information and tips to get you ready!

TableauGeneralKnowledge

How to edit PowerPoint slides with Alteryx

May 12, 2022 Robson Hemans-Alexander | www.thedataschool.co.uk

During this week’s client project we had a unique task to dynamically update PowerPoint templates with through Alteryx. If you ever encounter this niche problem this how to do it!

TableauGeneralKnowledge

How to bench a Barbell Chart

May 12, 2022 Robson Hemans-Alexander | www.thedataschool.co.uk

Want to make granularity gains? You’ve come to the right place.

TableauGeneralKnowledge

Cumulative sales by region since first order date

May 12, 2022 Tram Nguyen | www.thedataschool.co.uk

It is very interesting to find out how many days it takes since the first orderdate to get a specific amount of sales. To do that, it’s worth taking intoaccount the running total calculation and a fixed LOD.

TableauGeneralKnowledge

Cohort Analysis

May 12, 2022 Tram Nguyen | www.thedataschool.co.uk

Another interesting sales topic I would like to cover today is cohort analysis.You would learn to do a break down analysis of sales over year based on new andexisting customers. Why would this topic so widely used in the business world?Because It’...

TableauGeneralKnowledge

Calculated Fields in Tableau

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

Calculated fields enables users to create fields in the data source and thesefields will operate just as any other field from the original source.   Somecommon functionality that calculations can be used for include: Segmenting data,converting dat...

TableauGeneralKnowledge

How to Tableau: Conditional Formatting (Highlight a Cell)

May 12, 2022 Eric Parker | onenumber.biz

Can Tableau do conditional formatting like Excel?

TableauGeneralKnowledge

Tableau Conference 2022 Presentation

May 12, 2022 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 Ken and I feel so incredibly blessed to have the opportunity to present at the Tableau Conference on May 18 LIVE in Las Vegas.  Our presentation is titled “How to do Cool Stuff in Tableau” and will focus on tips, tricks, and techniques that we ho...

Tableau

Can you format the dashboard?

May 12, 2022 Donna Coles | donnacoles.home.blog

This week’s #WOW2022 challenge was focused on dashboard layout, specifically the use of containers and padding to give your charts room ‘to breathe’ and be aligned beautifully. This has come at a great time for me, as now I’m spending more time in...

How to Color BANs by Positive or Negative Change

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

In this tip, I show you two methods for coloring BANs based on whether there is a positive or negative change. The first method colors the entire BAN, whereas the second method only colors the value of the change itself. ...

analysis,BAN,calculatedfield,charts,color,comparison,context,formatting,graphs,howto,howtomakeaBAN,levelofdetail,LOD,tableau,tip,tutorial,worksheet

Is instant eyedropper a jawdropper?

May 11, 2022 Tram Nguyen | www.thedataschool.co.uk

Have you ever wondered how to capture an exact color in any picture or any pieceof visuals that you saw by chance anywhere on Internet? You need this toolurgently 😊 I would like to introduce to you guys an insatiable tool for colordesigning which ...

TableauGeneralKnowledge

Improving Pie Charts (Part 3/3) – Expanding Donut Chart

May 11, 2022 Frederik Egervari | www.thedataschool.co.uk

So far I have covered how to build a Donut Chart[https://www.thedataschool.co.uk/frederik-egervari/improving-pie-charts-part-1-3-donut-chart] and a Sunburst Donut Chart[https://www.thedataschool.co.uk/frederik-egervari/improving-pie-charts-part-2-...

TableauGeneralKnowledge

Improving Pie Charts (Part 2/3) – Sunburst Donut Chart

May 11, 2022 Frederik Egervari | www.thedataschool.co.uk

In the last blog of this series, I have covered how to build a Donut Chart[https://www.thedataschool.co.uk/frederik-egervari/improving-pie-charts-part-1-3-donut-chart]. Now let’s get a bit more advanced and build a chart that also includes anaddit...

TableauGeneralKnowledge

Improving Pie Charts (Part 1/3) – Donut Chart

May 11, 2022 Frederik Egervari | www.thedataschool.co.uk

Pie Charts are one of the most basic visualization types. They can be understoodquickly and are visually pleasing. But they are also often misused – As a ruleof thumb: Try to use only up to five colors per pie.

TableauGeneralKnowledge

How dummy data is generated in Alteryx

May 11, 2022 Tram Nguyen | www.thedataschool.co.uk

In this blog I’d like to show another way to generate a set of dummy Data inAlteryx. You can also refer to my colleage’s blog[https://www.thedataschool.co.uk/ghost/#/site], which is about Mockaroo, a veryuser-friendly dummy data generator software...

TableauGeneralKnowledge

Friendly Neighbourhood Web-Scraper

May 11, 2022 Dorinna Pentchev | www.thedataschool.co.uk

Revisiting an old project, fixing the web-scraped data with Alteryx this time.

TableauGeneralKnowledge

Alteryx: union two columns and remove duplicate values

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

While working on one of the Alteryx Weekly Challenges (173) I encountered aninstance where I had two columns full of city names. Origin column representedthe starting location of the race and the Destination column represented the endof the race. ...

TableauGeneralKnowledge

How the Portland TUG Survives and Thrives

May 11, 2022 Danny Steinmetz | interworks.com

Getting people together can be hard. Getting people together for a work tool virtually and trying to make it both exciting and consistent is harder. In this article, I’ll be discussing how the Portland Tableau User Group (PDX TUG) leadership team ...

Culture,PDX,Portland,Tableau,TableauUserGroup,TUG

You know the (Z)-score

May 10, 2022 Fergus Smith | www.thedataschool.co.uk

What is a Z-score?

power-bi,learning-design,plotly,data-visualization,tableau

What did it take to get into DS29?

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

We’re 29 cohorts into our adventure at The Data School and the quality of applications continues to impress. Here’s what it took to get into DS29.

power-bi,learning-design,plotly,data-visualization,tableau

What are quartiles?

May 10, 2022 Megan Coutts | www.thedataschool.co.uk

Within the paradigm of statistics, quartiles are a key type of quantile thatallow you to observe the distribution of values in a data set at a more granularlevel, compared to solely using, say, the mean, or the minimum and maximum. Thedistribution...

power-bi,learning-design,plotly,data-visualization,tableau

The Analytics Pane

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

Tableau’s analytics pane includes easy to use drag-and-drop analytics toolsnamely reference lines, totals, forecasts, clusters, box plots and more.  Sometools may be available only for specific use or configuration. Once a tool isdrag in the view,...

power-bi,learning-design,plotly,data-visualization,tableau

Table calculation and LOD

May 10, 2022 Tram Nguyen | www.thedataschool.co.uk

This week I will show you two methods to create a visualization using TableCalculation and Level of Detail. Let’s create the following visualizationtogether. The goal is to show the highest profit subcategory as per each state.The states are color...

power-bi,learning-design,plotly,data-visualization,tableau

Stats 101 - Weighted Average

May 10, 2022 Zdravka Bratuhtcheva | www.thedataschool.co.uk

Most of us know what an average is. Simply add all values and devide by thenumber of values. Its pretty simple until it is not.

power-bi,learning-design,plotly,data-visualization,tableau

Simple Regression and r² value

May 10, 2022 Carlos Pacheco | www.thedataschool.co.uk

Regression models are used to describe relationships between variables byfitting a line of best fit through the data points. Regression analysis allowsyou to explore how a dependent variable changes as the independent variable(s)change.

power-bi,learning-design,plotly,data-visualization,tableau

P-value, samples and population

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

The reports of statistical tests usually include a measure called p-value. If itdoes not, it is probably not a very reliable analysis. P-values are commonlyused when comparing two or more groups. P-values are necessary because analystsrarely have ...

power-bi,learning-design,plotly,data-visualization,tableau

Intro To Histograms In Tableau

May 10, 2022 Valerie Madojemu | www.thedataschool.co.uk

Histograms provide a graphical representation of the distribution of numericalvalues. They look similar to bar charts but are different. Bar charts comparedifferent categories of data while histograms display the distribution of avariable.

power-bi,learning-design,plotly,data-visualization,tableau

How to create a Control Chart

May 10, 2022 John Power | www.thedataschool.co.uk

Finished graph:

power-bi,learning-design,plotly,data-visualization,tableau

Geospatial Data

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

Geospatial Data in Tableau comes in two primary forms namely: geographic fieldsand spatial data files.

power-bi,learning-design,plotly,data-visualization,tableau

Combining Data in Tableau

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

While preparing for the Data Analyst certification exams, I realized there are alot of basic but essential topics and terms that needs to be recalled. Therefore I am writing a couple of blogs to help me go through them, as wellas, hopefully these ...

power-bi,learning-design,plotly,data-visualization,tableau

Building Box and Whisker Plots

May 10, 2022 Caitlin Walsh | www.thedataschool.co.uk

Box and Whisker Plots are a simple but effective tool for understanding the distribution of our data: here is a short summary of the steps for making one.

power-bi,learning-design,plotly,data-visualization,tableau

Four Things Data Viz Practitioners Can Do to “Get Better at Design”

May 10, 2022 Desiree' Abbott | medium.com

Photo by Nick Fewings on UnsplashSo, you’ve gotten pretty good at making visualizations in your chosen tool. Your next challenge, should you choose to accept it, is to learn about how to make them look better. I’ve seen dozens of data viz communit...

power-bi,learning-design,plotly,data-visualization,tableau

Adding a Dynamic Reference Line to Viz-in-Tooltips

May 10, 2022 datavis.blog | datavis.blog

This post shows you how to change the default behaviour of viz-in-tooltips, removing the filter and adding a dynamic reference line using a parameter action.

Tips,Viz-in-tooltip,referenceline,Tableau

Maximize Tableau Conference 2022 with the Strategic Session Picker

May 10, 2022 Madeline Cook | interworks.com

Attention, in-person Tableau Conference-goers! Like us, you probably spent the past two years with no choice but to take in all the excitement of Tableau Conference from your couch (thanks, Covid). This year, we are so happy for the opportunity to...

Data,datavisualization,Session,TableauConference,TC22

Write Back Extension on Tableau (by Xpand IT)

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

For the project last week, Kristine and I built a Write Back Extension to thedashboard. I will tell more about it in this blog post.

Tips,Viz-in-tooltip,referenceline,Tableau

Using Containers When Dashboarding

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

One of the things that makes Tableau nice and user friendly is the number oftimes you can simply drag something and drop it wherever you want and it’ll looksomewhat between “quite nice” and “that’ll do”. But if you want to level up yourdashboardin...

Tips,Viz-in-tooltip,referenceline,Tableau

Nested sort to add multilevel sorting on the view in Tableau

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

Sometime, there is the case when you sort items, for example to sort thestudents according to their scores, it happens  that many students have the samescore. Then you might want to have a second sorting saying, for instance, amongthose students w...

Tips,Viz-in-tooltip,referenceline,Tableau

How to quickly copy a color in Tableau

May 9, 2022 John Power | www.thedataschool.co.uk

In this example we will use the Sample - Superstore dataset.

Tips,Viz-in-tooltip,referenceline,Tableau

HOW TO MANAGE A PROJECT

May 9, 2022 Romina Wiechern | www.thedataschool.co.uk

So, last week was finally the week, when it was my turn to take over the role ofbeing a project manager for our one-week customer project at the Data SchoolGermany.

Tips,Viz-in-tooltip,referenceline,Tableau

Custom SQL Queries in Tableau

May 9, 2022 Frederik Egervari | www.thedataschool.co.uk

Connecting to big databases can slow Tableau down significantly since it cantake quite a long time to run the calculations. Since the speed of Tableau isone of the reasons why it is so fun to work with, this is quite annoying.Therefore filtering t...

More Than One Way to Skin a Cat...in Tableau (Part 2)

May 9, 2022 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 Disclaimer: this is part 2 of a two-part series.  Be sure to check out Part 1 for the for lots more content as well as the background behind this blog series.  No cats (or any other animal) were harmed in the development of this blog ...

How-To,Tableau