Write CTEs in dbt Cloud for free with this one easy trick. Analysts hate...

Jul 28, 2025 Lex Devlin | www.thedataschool.co.uk

Here in The Information Lab’s Data Engineering (DEng) extension program, we learn all sorts of things. We learn advanced SQL, python, even Jinja in dbt. What if I told you I learned to tap into all three? Using the power of Jinja, I learned to mak...

Data,datavisualization,LineChart,Sigma

Visueller Lebenslauf in Tableau

Jul 28, 2025 Svetlana Brazukevich | www.thedataschool.co.uk

Meine Trainingsphasen sind schon fast vorbei, und das ist echt viel los mit den Herausforderungen pro Woche. Jeden Tag muss ein neues Dashboard gebaut, präsentiert und dokumentiert werden. 😨 Deswegen teile ich meine Erfahrungen täglich. Bleibt dran!

Data,datavisualization,LineChart,Sigma

Fundamentals with dbt

Jul 28, 2025 Agnes Amer | www.thedataschool.co.uk

What is dbt and why is it so powerful?

Data,datavisualization,LineChart,Sigma

Dashboardweek - Monday

Jul 28, 2025 Stefan Ladwig | www.thedataschool.co.uk

We started off on the first day with a visual CV in Tableau as our topic and Tool.

Data,datavisualization,LineChart,Sigma

Dashboard Woche Tag 1

Jul 28, 2025 Birthe Claussen | www.thedataschool.co.uk

Die Aufgabe am ersten Tag der sogenannten Dashboard Week war, einen Lebenslauf (CV) in Tableau zu erstellen.

Data,datavisualization,LineChart,Sigma

Dashboard Week - Tag 1

Jul 28, 2025 Gabriela Scherbinek | www.thedataschool.co.uk

Heute hatten wir die Aufgabe, ein sogenanntes „Visual CV“ – also einen visuellen Lebenslauf – mit Tableau zu erstellen und auf Tableau Public zu veröffentlichen.Dazu bin ich wie folgt vorgegangen:

Data,datavisualization,LineChart,Sigma

Dashboard Week Resume

Jul 28, 2025 Mariia Sapsai | www.thedataschool.co.uk

Heute möchte ich euch mein erstes Projekt aus der letzten Woche, der „Dashboard Week“, zeigen. Heute hatten wir das Thema „Resume“.

Data,datavisualization,LineChart,Sigma

Dashboard Week Day 1 Webscraping and Spatial Challenges in Alteryx and T...

Jul 28, 2025 Harry Caplin | www.thedataschool.co.uk

Dashboard Week Day 1 Brief:

Data,datavisualization,LineChart,Sigma

Dashboard Week Day 1 Webscraping

Jul 28, 2025 Hannah Norfolk | www.thedataschool.co.uk

As DS50’s training draws to a close, today we began our dashboard week journey. Here’s how it went:

Data,datavisualization,LineChart,Sigma

Dashboard Week Day 1 - The Perfect Summer Adventure

Jul 28, 2025 Lorna Brown | www.thedataschool.co.uk

It’s that time of a cohort again where we have dashboard week. Given it’s nearly summer I thought a summer theme would be appropriate. The tasks this week won’t be easy. It’ll have a mixture of tools used and it’s ultimate week to put all their sk...

Data,datavisualization,LineChart,Sigma

Dashboard Week Day 1 Backpackers MEA Travel guide

Jul 28, 2025 Ted Evans | www.thedataschool.co.uk

So we made it to the final week of training and after 4 intense months it’s nearly time for celebration… enter: Dashboard Week. A new project every single day for our final week! Starting the week strong with a webscraping project on ‘The Perfect ...

Data,datavisualization,LineChart,Sigma

Dashboard Week Day 1 Backpackers Guide to South America

Jul 28, 2025 Louis Phipps | www.thedataschool.co.uk

The Brief

Data,datavisualization,LineChart,Sigma

Dashboard Week Day 1 Backpacker Beers

Jul 28, 2025 Ollie Ross Russell | www.thedataschool.co.uk

For the first day of Dashboard Week, I decided to explore something light-hearted yet surprisingly insightful for travellers: the price of beer in 31 popular backpacking destinations across Asia. While it may sound like a novelty topic, understand...

Data,datavisualization,LineChart,Sigma

Dashboard Week Day 1

Jul 28, 2025 Kristupas Justas Jucaitis | www.thedataschool.co.uk

Scraping the Backpacker Index with Python and Alteryx

Data,datavisualization,LineChart,Sigma

CALCULATE and FILTER Functions in PowerBI

Jul 28, 2025 Louis Phipps | www.thedataschool.co.uk

Understanding the CALCULATE function

Data,datavisualization,LineChart,Sigma

Improving Sigma Line Chart Over Time

Jul 28, 2025 Bennett Frohock | interworks.com

Although summer is almost over, it is never too late to start to work on your beach body. My friends challenged me to do a sit-up every day for 100 days while increasing the number of sit-ups each day by one, so on the last…The post Improving Sigm...

Data,datavisualization,LineChart,Sigma

Getting Started with Measures and DAX Calculations in Power BI For Begin...

Jul 27, 2025 Zainul Abedin Natha | www.thedataschool.co.uk

If you’re new to Power BI, one of the most important concepts to understand is DAX (Data Analysis Expressions) and how to use it to create Measures. Measures help you perform powerful calculations on your data, such as sums, averages, percentages,...

Data,datavisualization,LineChart,Sigma

Everything There Is To Know About LODs

Jul 27, 2025 Amy Afriyie | www.thedataschool.co.uk

LOD (level of detail) expressions in Tableau allow you to show values at a different level of detail or level of granularity than a visualisation is set at. This enables you to show calculations which are independent of the dimensions in a specifi...

Data,datavisualization,LineChart,Sigma

Can you highlight a treemap

Jul 26, 2025 Donna Coles | donnacoles.home.blog

This week, Sean decided to revisit a challenge from 2017, week 12, which was originally posted by Emma Whyte, one of the #WorkoutWednesday founding coaches. I’ve been completing the #WOW challenges since their inception, so had the original soluti...

WorkoutWednesday,WOW2025,ATTR,ColourwithMultipleDimensions,DualColourEncoding,GradientColour,ParameterActions,Treemap,Week30

dbt - seeds

Jul 25, 2025 Jules Claeys | www.thedataschool.co.uk

Every organisation has some secret csv containing crucial information you might want to use with data stored in your cloud database. Seeds are dbt’s solution to that. Your dbt project should have a seeds folder, in there you can copy csvs which wi...

Data,datavisualization,LineChart,Sigma

dbt Cloud Command Cheat Sheet

Jul 25, 2025 Erin Potter | www.thedataschool.co.uk

Disclaimer: dbt has a lot of power under the hood- this guide just covers what we’ve learned about and utilized this week in data engineering!

Data,datavisualization,LineChart,Sigma

How to Add Two Values to One Parameter in Tableau

Jul 24, 2025 VizWiz (noreply@blogger.com) | www.vizwiz.com

Most people think parameters can only hold one value.But what if I told you… you can hack them to hold two?

daterange,dynamic,howto,levelofdetail,LOD,multiplevalues,parameter,parameteraction,referenceband,tableau

Reshaping Data in Alteryx

Jul 24, 2025 Joseph Darton | www.thedataschool.co.uk

In honour of passing the Alteryx Core exam, I have decided to write a blog post on the Cross Tab and Transpose tools.

TableauTextTables,TableauTotals,LevelofDetail

The Sigma Action Guide

Jul 24, 2025 Bennett Frohock | interworks.com

What are Sigma Actions?  Imagine enabling users to instantly filter a dashboard to just their regional sales, then automatically opening a detailed breakdown page with a single click. Or picture giving analysts the ability to launch a stored proce...

Data,Sigma

Using Spotifys API in Alteryx Part 1

Jul 23, 2025 David Gandary | www.thedataschool.co.uk

APIs allow you to pull live data from platforms like Spotify directly into Alteryx. This guide walks through how to authenticate and retrieve data about your favorite artist.

TableauTextTables,TableauTotals,LevelofDetail

Mein Einblick in dbt eine Brcke zwischen Data Engineering und Analytics

Jul 23, 2025 Ahsen Polat | www.thedataschool.co.uk

Vergangene Woche durfte ich an einer internen dbt-Session bei The Information Lab teilnehmen. Die Session wurde von unseren Kolleg:innen aus UK – Ollie Clarke und Jonathan MacDonald – durchgeführt und war eine Mischung aus Theorie, Praxis und Aha-...

TableauTextTables,TableauTotals,LevelofDetail

Intro to SQL

Jul 23, 2025 Jaden Matthias | www.thedataschool.co.uk

We’ve finally reached the SQL section of training and I thought it would be great to share a bit of an introduction to SQL and the most important things to know to get started.

TableauTextTables,TableauTotals,LevelofDetail

How to Add Input Filters in Tableau Prep Improve Performance

Jul 23, 2025 Eric Parker | onenumber.biz

One of the biggest gripes about Tableau Prep is that it isn’t as fast as people want. However, most people aren’t leveraging the best way to improve performance; input filters!

TableauTextTables,TableauTotals,LevelofDetail

Using the Spotify API in Alteryx to Analyse Your Favourite Artist

Jul 22, 2025 Tyler McKillop | www.thedataschool.co.uk

What is an API?

TableauTextTables,TableauTotals,LevelofDetail

How to create the LIQUID GLASS effect in Figma

Jul 22, 2025 Miffy Allen | www.thedataschool.co.uk

Figma is a great way to enhance your dashboards from good to incredible, and this liquid glass effect is just too cool not to share.

TableauTextTables,TableauTotals,LevelofDetail

X Functions in DAX

Jul 21, 2025 Andrew Buchanan | www.thedataschool.co.uk

X Functions are iterator functions used in DAX, the programming language of Power BI. They are different to other functions in that they take each row into account in their calculations. For example, function SUMX() calculates the sum of expressio...

TableauTextTables,TableauTotals,LevelofDetail

SQL Anti-Patterns to Avoid on a Modern Analytics Warehouse

Jul 21, 2025 Edward Hayter | www.thedataschool.co.uk

An anti-pattern is a piece of code that looks reasonable but leads to negative outcomes often related to query execution and optimization.

TableauTextTables,TableauTotals,LevelofDetail

Rounded Containers In Tableau No Figma Needed

Jul 21, 2025 Jaden Matthias | www.thedataschool.co.uk

Rounded containers can help to give your dashboards a nice and polished look. Here’s a quick guide on one method you can use to achieve this effect. This method details how to create these without using a graphic design tool like Figma and focuses...

TableauTextTables,TableauTotals,LevelofDetail

How to create a drill down boxplot in PowerBI - without downloading a cu...

Jul 21, 2025 Kieran Joymungul | www.thedataschool.co.uk

As boxplots are not a default visual in PowerBI, creating one often requires downloading 3rd party created custom visuals where there’s a chance it will not work as you want.

TableauTextTables,TableauTotals,LevelofDetail

Drill-Downs in Tableau Using Sets

Jul 21, 2025 Claudina Mukangabo | www.thedataschool.co.uk

Create interactive drill-downs in 4 simple steps.

TableauTextTables,TableauTotals,LevelofDetail

Becoming a Project Manager for The First Time

Jul 21, 2025 Claudina Mukangabo | www.thedataschool.co.uk

Tackling a PM Role with Confidence

TableauTextTables,TableauTotals,LevelofDetail

Alteryx Challenge 472 Complete

Jul 21, 2025 Mandy Wan | www.thedataschool.co.uk

Alteryx Challenge #472 looked at a topic close to home for many parents around the world: calculating the cost of school supplies for one child in each grade of elementary school (from kindergarten to sixth grade). 

TableauTextTables,TableauTotals,LevelofDetail

Getting Started with Plugins in Sigma

Jul 21, 2025 Josias Hernandez Perez | interworks.com

As data teams seek more flexibility and customization in their business intelligence workflows, plugins in Sigma have emerged as a powerful way to extend the platform’s capabilities. Whether you’re embedding interactive visualizations or building ...

Data,Plugins,Sigma

Measure Names Values Overiew with Some Tips Tricks Guest Blog Post fro...

Jul 21, 2025 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

      The following is a guest blog post from Ethan Hahn (a regular contributor on our site). Ethan works at the University of Cincinnati and runs a small analytics team in the Office of Research. Previously, he spent 27 years at Unifu...

Tableau

Competitor Comparison

Jul 20, 2025 Donna Coles | donnacoles.home.blog

Erica set this week’s challenge, focusing on the ability to compare specific entities against themselves and ‘the whole’ without resulting in a mess of coloured spaghetti. 3 levels of difficulty were provided. As it stated the levels didn’t necess...

WorkoutWednesday,WOW2025,HighlightAction,ParameterActions,Parameters,TableCalculations,Unhighlightmarks,Week29,WindowMax

Web Scraping in Alteryx

Jul 19, 2025 Andrew Buchanan | www.thedataschool.co.uk

Web scraping is a powerful technique that enables you to programmatically extract relevant data from websites, making it easier to perform analysis for a wide range of purposes. For instance, you can gather competitor information to support pricin...

TableauTextTables,TableauTotals,LevelofDetail

Start-to-Finish Beginners Guide Creating a Basic Dashboard in Tableau Next

Jul 18, 2025 Harry Caplin | www.thedataschool.co.uk

Tableau Next is an agentic analytics platform built on the Salesforce platform. It aims to democratize data access and insights by providing personalized, contextual, and actionable insights to users across various workflows.

Espaol,Asimtrico,DrillDown,DrillUp,Tableau,blog

Spatial Tools in Alteryx Part 4 Combining Comparing Areas with the Spat...

Jul 18, 2025 Ollie Ross Russell | www.thedataschool.co.uk

Introduction

Espaol,Asimtrico,DrillDown,DrillUp,Tableau,blog

Spatial Tools in Alteryx Part 3 Finding the Best Hotel for Course Cover...

Jul 18, 2025 Ollie Ross Russell | www.thedataschool.co.uk

In Part 2, we used the Find Nearest Tool to identify the closest golf courses to each hotel. But what if you want to know which hotel gives you access to the most courses within a reasonable travel distance?

Espaol,Asimtrico,DrillDown,DrillUp,Tableau,blog

Spatial Tools in Alteryx Part 2 Planning the Perfect Golf Tour with Fin...

Jul 18, 2025 Ollie Ross Russell | www.thedataschool.co.uk

In Part 1, we prepared our hotel and golf course data by creating spatial points in Alteryx. Now, we’re going to use one of the most practical spatial tools for real-world analysis: Find Nearest.

Espaol,Asimtrico,DrillDown,DrillUp,Tableau,blog