What is the difference between the Q and the Lighting Bolt anchors in to...

Jul 21, 2022 Gerda Staurylaite | www.thedataschool.co.uk

What is the difference between the Q and the ‘Bolt’ anchors in Alteryx?

TableauCalculations,StringFunctions

What are Macro's?

Jul 21, 2022 Zachary Ryan | www.thedataschool.co.uk

A (very) brief definition of Macro’s, what they are and what types of Macro’s you can find on Alteryx.

TableauCalculations,StringFunctions

What are 'Batch' Macros?

Jul 21, 2022 Bridget Ama Boateng | www.thedataschool.co.uk

Batch Macros allows your data to be grouped into batches and process each batch separately one at a time

TableauCalculations,StringFunctions

User Input - Interface Tools in Macros

Jul 21, 2022 Beau Foletti | www.thedataschool.co.uk

How to set up a user interface in a macro in Alteryx

TableauCalculations,StringFunctions

Standard Macro's

Jul 21, 2022 Sundus Jamaal | www.thedataschool.co.uk

What are Macros?

TableauCalculations,StringFunctions

Macros: Navigating the Interface Designer

Jul 21, 2022 Nermine Obeng | www.thedataschool.co.uk

A whistle-stop tour of the Interface Designer.

TableauCalculations,StringFunctions

Iterative Macro in Alteryx Designer

Jul 21, 2022 Ana-Casiana Tarita | www.thedataschool.co.uk

One useful thing that we’ve learned today is how to use the Iterative Macro in the Alteryx Designer.

TableauCalculations,StringFunctions

How to Concatenate Text Values in Tableau

Jul 21, 2022 Eric Parker | onenumber.biz

So you want to concatenate multiple text values in Tableau, huh? Great!

TableauCalculations,StringFunctions

What is the time-weighted return?

Jul 21, 2022 Donna Coles | donnacoles.home.blog

Indeed! What is the time-weighted return? It’s not a term I’d ever heard of until Luke set the challenge this week. Fortunately he provided a link to a web page to explain all about it – phew! I actually approached the challenge initially by downl...

Tableau Prep Things

Jul 20, 2022 Ozlem Sigbeku | www.thedataschool.co.uk

If you want to be an expert in Tableau Prep generate rows, converting dates and ranking, read through these things!

Tableau Prep: Creating Fiscal Dates

Jul 20, 2022 Imogen Emmett | www.thedataschool.co.uk

How do you create fiscal dates in Tableau Prep?

Show Missing Values vs Show Empty Columns

Jul 20, 2022 Tommaso Ferri | www.thedataschool.co.uk

A quick tip for Quick Viz in tooltip action!

How to Union Multiple Tables in Tableau Prep Using a Wildcard.

Jul 20, 2022 Sophie Higson | www.thedataschool.co.uk

Rather than dragging three separate tables into Prep, you can union them very easily using a wildcard.

How to Join in SQL

Jul 20, 2022 Charalambos Pavlou | www.thedataschool.co.uk

Firstly lets start with an inner join, the main thing to remember with joins is you need to sign your tables a unique identifier for example below “TIL_PLAYGROUND”.”KEEP”.”Superstore_Orders” s, has been assigned the letter s and below where we spe...

A customer project with DSDE2 – Data School Hamburg

Jul 20, 2022 Nhung Le | www.thedataschool.co.uk

A four-month-training program offers all data schoolers various opportunities to learn and experience the work as a data analyst. As a part of the program, we have 8 one-week-projects, so that each of us could take the role of being project manage...

How to Add Custom Shapes to Tableau

Jul 19, 2022 VizWiz (noreply@blogger.com) | www.vizwiz.com

Tableau comes with a limited number of shape palettes. However, I have had use cases when I need to use my own shapes. In this tip, I show how I add a custom shape palette to Tableau.Here are some websites to download shapes. Note that some of the...

howto,howtoaddshapes,palette,shape,tableau,tip

Year on Year table calculation

Jul 19, 2022 Algirdas Grajauskas | www.thedataschool.co.uk

In order to show how ones business or anything is performing, it is good to do year on year comparisons. This way we have a large data span and see if the values are increasing or decreasing.

Culture,Events,London,recruiting,UK,UniversityCollegeLondon

Year on Year (Level of detail expression)

Jul 19, 2022 Algirdas Grajauskas | www.thedataschool.co.uk

As mentioned in my previous post, in order to show how a business is performing, it is good to do a year on year comparison. This allows for a quick overview to see if the values are increasing or decreasing.

Culture,Events,London,recruiting,UK,UniversityCollegeLondon

Using window_*** in Tableau

Jul 19, 2022 Tom Stinson | www.thedataschool.co.uk

Using window_something calculations in Tableau took me a long time to wrap my head around. This blog is here to help anyone else who might need a push in the right direction to begin understanding them too.

Culture,Events,London,recruiting,UK,UniversityCollegeLondon

Using a Filter as a Go to Sheet Button

Jul 19, 2022 Abiramm Thavajothy | www.thedataschool.co.uk

In Tableau there are two common ways of navigating from one dashboard to another. 1) The navigation button in the objects pane and 2) the go to sheet button found in the dashboard actions pane. But did you know there’s a third?

Culture,Events,London,recruiting,UK,UniversityCollegeLondon

Tableau Tutorials: Include LOD

Jul 19, 2022 Thanoshaan Thayalan | www.thedataschool.co.uk

Include LODs in Tableau

Culture,Events,London,recruiting,UK,UniversityCollegeLondon

Tableau Tutorials: Fixed LOD

Jul 19, 2022 Thanoshaan Thayalan | www.thedataschool.co.uk

Fixed LODs in Tableau

Culture,Events,London,recruiting,UK,UniversityCollegeLondon

Tableau Tutorials: Exclude LOD

Jul 19, 2022 Thanoshaan Thayalan | www.thedataschool.co.uk

Exclude LODs in Tableau

Culture,Events,London,recruiting,UK,UniversityCollegeLondon

Tableau Tutorials: Current Year vs Previous Year KPI's with Table Calcul...

Jul 19, 2022 Thanoshaan Thayalan | www.thedataschool.co.uk

Dynamic Current Year vs Previous Year KPI’s with Table Calculations

Culture,Events,London,recruiting,UK,UniversityCollegeLondon

Tableau Tutorials: Creating a Reset Button

Jul 19, 2022 Thanoshaan Thayalan | www.thedataschool.co.uk

Creating a Reset Button on Tableau

Culture,Events,London,recruiting,UK,UniversityCollegeLondon

Quantile Models in Tableau

Jul 19, 2022 Edward Sinclair-Hughes | www.thedataschool.co.uk

Tableau is capable of generating predictive models with relative ease, you only need to know which type of model you want to create; it is possible to create Linear Regression, Regularized Linear Regression and Gaussian Process Regression. We will...

Culture,Events,London,recruiting,UK,UniversityCollegeLondon

Parameter Actions

Jul 19, 2022 Algirdas Grajauskas | www.thedataschool.co.uk

Parameter actions are a great way to dynamically update your views. Therefore, how do we build them out?

Culture,Events,London,recruiting,UK,UniversityCollegeLondon

Making Dynamic KPI's using Table Calculations: part 1

Jul 19, 2022 Dorinna Pentchev | www.thedataschool.co.uk

Using table calculations to create KPI’s of total sales and percentage changes from prior year, which will automatically update when new data is brought in.

Culture,Events,London,recruiting,UK,UniversityCollegeLondon

Latitude & Longitude: X-Axis or Y-Axis?

Jul 19, 2022 Jessica Haire | www.thedataschool.co.uk

User Story: Bei der Arbeit mit Geo-Objekten und geografischen Punkten

Culture,Events,London,recruiting,UK,UniversityCollegeLondon

KPI's and Table Calculations 2: The Wrath of Window Functions

Jul 19, 2022 Dorinna Pentchev | www.thedataschool.co.uk

Building a dynamic KPI chart of sales over region with comparisons to prior year, using window functions this time.

Culture,Events,London,recruiting,UK,UniversityCollegeLondon

How to create a dynamic Rank scroll

Jul 19, 2022 Charalambos Pavlou | www.thedataschool.co.uk

How to maintain rank

Culture,Events,London,recruiting,UK,UniversityCollegeLondon

Recapping Our Talk with the Consultancy Club at Imperial College London

Jul 19, 2022 Mike Oldroyd | interworks.com

Robin Bergmans and I greatly enjoyed presenting to around 25 members of the “Consultancy Club” at Imperial College London just recently. We were there to tell them about InterWorks and about what life was like working as a data consultant, and may...

Culture,Events,London,recruiting,UK,UniversityCollegeLondon

Workshop Projektmanagement

Jul 18, 2022 Kerstin Horscht | www.thedataschool.co.uk

Last week we were able to experience a comprehensive workshop on the topics of project management, requirements gathering and the custumer projects by Moritz Schirmboek.

Culture

What did it take to get into DS33?

Jul 18, 2022 Ruth Amarteifio | www.thedataschool.co.uk

DS33 is 2 weeks into their training, so it’s a great time to look at what it took for them to get into The Data School.

Culture

Row vs Column level security

Jul 18, 2022 Algirdas Grajauskas | www.thedataschool.co.uk

Column and row level security are types of security which can be applied to your views. The difference between them is significant. As it ends up changing how data is aggregated/shown. For example (ex 1) if we have three different blue fields: Reg...

Culture

Multi-Row and Multi-Field Formulas - What's the difference?

Jul 18, 2022 Zachary Ryan | www.thedataschool.co.uk

Tackling Multi-Field Formulas and Multi-Row Formulas in our third week of the Data School. Here is how I was able to differentiate between the two and when to use the right one.

Culture

Model Comparisons in Alteryx

Jul 18, 2022 Charalambos Pavlou | www.thedataschool.co.uk

In Alteryx you can do predictive modelling for time series data and compare which model is more efficient. In Alteryx there are 2 time series models you can use ARIMA (Autoregressive integrated moving average) or the ETS model (Error, Trend, Seaso...

Culture

Linear Regression in Alteryx

Jul 18, 2022 Thanoshaan Thayalan | www.thedataschool.co.uk

Predicting the future is very valuable and it is something that is possible within both Tableau and Alteryx. This blog will focus a section of predictive analysis, Linear Regression, in the latter software.

Culture

Interpreting the results report of a linear regression

Jul 18, 2022 Dorinna Pentchev | www.thedataschool.co.uk

What do all of these statistics mean?

Culture

How to perform a Social Network Analysis with Alteryx?

Jul 18, 2022 Robin von Malottki | www.thedataschool.co.uk

This blog will give you a brief introduction to social network analysis (SNA) with Alteryx. In the first part of the blog, you’ll get insights into the basics of SNA. Afterwards, I will explain an application example with Alteryx.

Culture

Forecasting- A Time Series

Jul 18, 2022 Edward Sinclair-Hughes | www.thedataschool.co.uk

Time Series is set of predictive tools on Alteryx which can be used to forecast data values in the future, what sets these tools apart from the normal predictive tools is the element of time.

Culture

Data Transformation: Cross-Tabs and Transpose

Jul 18, 2022 Beau Foletti | www.thedataschool.co.uk

A quick example of how to use the basic functions of the Transpose and Cross-Tab Tools in Alteryx

Culture

Clustering in Alteryx

Jul 18, 2022 Tom Stinson | www.thedataschool.co.uk

Clustering is an interesting concept. Being able to group members is extremely powerful, as is any predictive analytics, but you have to be sure to be careful when deciding what to group by and how many clusters you build as this can massively swi...

Culture

Automatically dropping columns and rows with a selected number of missin...

Jul 18, 2022 Abiramm Thavajothy | www.thedataschool.co.uk

Normally, when thinking about which columns and rows to drop from our data, we start off by dropping all the columns and rows that are 100% missing. But what happens if we wanted to get rid of columns where over 95% are missing etc?

Culture

Alteryx: Time series analysis

Jul 18, 2022 Algirdas Grajauskas | www.thedataschool.co.uk

Time series analysis is used to analyse specific data collected through time. In a nutshell it predicts the outcome of a variable when seasonality (i.e. time) has significant influence. It has to be evaluating consistent time intervals otherwise i...

Culture