Countdown zur Projektphase

Jan 20, 2025 Marcel Wiechmann | www.thedataschool.co.uk

Kundenprojekte sind ein Kernbestandteil der Data School Ausbildung. Nach acht intensiven Wochen Training in Analytics und Business Intelligence - von Datenaufbereitung und Visualisierung bis hin zu Consulting-Methoden - kommt die erste echte Herau...

A Makeover Monday Update Visualizing Marvel Movie Success

Jan 20, 2025 Ahsen Polat | www.thedataschool.co.uk

One Makeovermonday topics related to the successes of the Marvel Movies. In order to evaluate the success of a film, various metrics come into play, as these are crucial for answering the question. These criteria range from Audience Score, Critica...

How to Present a Data Driven Story - Step 1 Prepare your Context

Jan 19, 2025 Johann Shin | www.thedataschool.co.uk

In this new blog series, I want to share some tips and tricks on how to effectively turn data into a story and present it to an audience.

The difference between LEFT JOIN INNER JOIN RIGHT JOIN which SQL defau...

Jan 17, 2025 Yoan Caboste | www.thedataschool.co.uk

Wondering which SQL join is right for you? 🤔 Whether it’s INNER, LEFT, or RIGHT JOIN, knowing the differences can boost your queries. This post breaks down each type and shows when to use them—plus, find out the default join Snowflake uses! Let’s ...

TableauCalculations,TableauDates

Snowflake SQL School Creating Loading Tables

Jan 17, 2025 Trea McElhone | www.thedataschool.co.uk

Snowflake is a cloud based data platform within which users can store, process, and analyse their data.

TableauCalculations,TableauDates

Reporting On A Pipeline

Jan 17, 2025 Zoe Reed | www.thedataschool.co.uk

Reporting on a pipeline is all about monitoring what’s going on in the pipeline, its performance and any errors should they occur. This helps to identify issues as far upstream as possible, so that they can be prevented from moving downstream and ...

TableauCalculations,TableauDates

Preppin Data 2021 WK01 in Python

Jan 17, 2025 Dan Booth | www.thedataschool.co.uk

Last week I wrote a blog on completing the Preppin’ Data 2021 WK01 challenge in SQL. This week I challenged myself to complete it in Python. I am uploading my solutions for each Preppin’ Data challenge on Git Hub. Feel free to check it out here: h...

TableauCalculations,TableauDates

My Three Favourite Things About dbt

Jan 17, 2025 Dan Booth | www.thedataschool.co.uk

This week I completed the dbt fundamentals course. This was my first time using dbt and three particular features really stuck out.

TableauCalculations,TableauDates

How dbt Cloud guides a user through the basics of Version Control

Jan 17, 2025 Edward Hayter | www.thedataschool.co.uk

dbt Cloud is a powerful tool for analysts transitioning to an engineering-like role, after all dbt Labs popularized the termn analytics engineer. One of the strong product features of dbt Cloud is how it makes version control as accessible as poss...

TableauCalculations,TableauDates

Extract Load Airbyte S3 Snowflake

Jan 17, 2025 Annie Casey | www.thedataschool.co.uk

Here’s an example of what tools you can use to extract and load data.

TableauCalculations,TableauDates

DBT Testing Documentation

Jan 17, 2025 Priya Kondola | www.thedataschool.co.uk

Two of the most valuable capabilities of DBT are testing and documentation. DBT offers the ability to test the data as it moves through your pipeline therefore mitigating any errors in the future. It also allows the user to document both the struc...

TableauCalculations,TableauDates

DBT Models and Sources

Jan 17, 2025 Priya Kondola | www.thedataschool.co.uk

One of the key advantages of DBT is the modularisation aspect were it refers to the practice of breaking down complex data into smaller, more manageable pieces. The main way to do this is through building models and sources as seen in the lineage ...

TableauCalculations,TableauDates

How are EPL Football Teams performing this season compared to previous s...

Jan 17, 2025 Donna Coles | donnacoles.home.blog

I set this week’s challenge and I tried to deliver something to hopefully suit everyone wherever they are on their Tableau journey. The primary focus for this challenge is on table calculations, but there’s a few other features/functionality inclu...

WorkoutWednesday,WOW2025,DataModelling,DualAxis,Filters,LAST,LOOKUP,Pivot,RunningTotal,Sets,SteppedLineChart,TableCalcs,Week3,Window_Max

What is dbt Data Build Tool and Why Does It Matter

Jan 16, 2025 Thomas Duong | www.thedataschool.co.uk

If you’re new to dbt (Data Build Tool), think of it as the link between raw data and actionable insights. dbt transforms messy, unstructured data into clean, analysis-ready tables—empowering data teams to work smarter, not harder. But while dbt is...

TableauCalculations,TableauDates

TABLEAU UNLOCKED Wie nutzt du den ShowHide Button richtig

Jan 16, 2025 Maria Maske | www.thedataschool.co.uk

Im Rahmen der Blog-Reihe: “Tableau Unlocked: Dein Boost für die Bewerbung” teilen wir mit dir wichtige Tipps für die Dashboard-Erstellung für deine Bewerbung bei The Data School Hamburg. Im Fokus des heutigen Posts steht die Frage: Wie nutzt Du de...

TableauCalculations,TableauDates

TABLEAU UNLOCKED Wie kannst Du Tooltips formatieren

Jan 16, 2025 Maria Maske | www.thedataschool.co.uk

Im Rahmen der Blog-Reihe: “Tableau Unlocked: Dein Boost für die Bewerbung” teilen wir mit dir wichtige Tipps für die Dashboard-Erstellung für deine Bewerbung bei The Data School Hamburg. Heute beantworte ich dir die Frage: Wie kannst Du Tooltips f...

TableauCalculations,TableauDates

TABLEAU UNLOCKED Wie kannst Du Filter formatieren

Jan 16, 2025 Maria Maske | www.thedataschool.co.uk

Im Rahmen der Blog-Reihe: “Tableau Unlocked: Dein Boost für die Bewerbung” teilen wir mit dir wichtige Tipps für die Dashboard-Erstellung für deine Bewerbung bei The Data School Hamburg. In diesem Post zeige ich dir, wie du deine Filter formatiere...

TableauCalculations,TableauDates

TABLEAU UNLOCKED Was sind BANs KPIs und wie kannst du sie formatieren

Jan 16, 2025 Maria Maske | www.thedataschool.co.uk

Im Rahmen der Blog-Reihe: “Tableau Unlocked: Dein Boost für die Bewerbung” teilen wir mit dir wichtige Tipps für die Dashboard-Erstellung für deine Bewerbung bei The Data School Hamburg. Diesmal dreht sich alles um die Frage: Wie kannst du BANs un...

TableauCalculations,TableauDates

TABLEAU UNLOCKED Dos bei der Dashboard-Erstellung

Jan 16, 2025 Maria Maske | www.thedataschool.co.uk

Im Rahmen der Blog-Reihe: “Tableau Unlocked: Dein Boost für die Bewerbung” teilen wir mit dir wichtige Tipps für die Dashboard-Erstellung für deine Bewerbung bei The Data School Hamburg. Wie angekündigt, verrate ich Dir dieses mal die Do’s der Das...

TableauCalculations,TableauDates

TABLEAU UNLOCKED Donts bei der Dashboard-Erstellung

Jan 16, 2025 Maria Maske | www.thedataschool.co.uk

Im Rahmen der Blog-Reihe: “Tableau Unlocked: Dein Boost für die Bewerbung” teilen wir mit dir wichtige Tipps für die Dashboard-Erstellung für deine Bewerbung bei The Data School Hamburg. In einem zweiteiligen Post gebe ich Dir dieses mal Tipps daf...

TableauCalculations,TableauDates

TABLEAU UNLOCKED Balken- vs. Liniendiagramm

Jan 16, 2025 Maria Maske | www.thedataschool.co.uk

Im Rahmen der Blog-Reihe: “Tableau Unlocked: Dein Boost für die Bewerbung” teilen wir mit dir wichtige Tipps für die Dashboard-Erstellung für deine Bewerbung bei The Data School Hamburg. In diesem beantworte ich dir die Frage, wann du Balken- und ...

TableauCalculations,TableauDates

Schema-on-Write vs. Schema-On-Read

Jan 16, 2025 Lydia Wren | www.thedataschool.co.uk

In a data engineering pipeline the design of the underlying source files will inevitably change at some point in time. This might be well communicated or it might not be.

TableauCalculations,TableauDates

From SQHell to SQLightenment A Girlie Guide to String Cleaning

Jan 16, 2025 Sandy Wlodarczyk | www.thedataschool.co.uk

Welcome back, darlings, to another fabulously fun instalment of SQL! This week, we’re diving into the art of tidying up string data, much like decluttering your wardrobe or applying just the right shade of lipstick to perfect your look.

TableauCalculations,TableauDates

Data Validation Ensuring Data Quality

Jan 16, 2025 Myles Stevenson | www.thedataschool.co.uk

Data validation is crucial for ensuring data quality and accuracy. It involves verifying several key dimensions: completeness, timeliness, uniqueness, consistency, validity, and integrity. This post outlines common issues, identification methods, ...

TableauCalculations,TableauDates

Overlay Custom Time Periods in a Tableau Line Graph

Jan 15, 2025 Eric Parker | onenumber.biz

Comparing one time period to another is a common use case in Tableau. In our experience, one of the best ways to do that is to overlay one on top of the other. The question is, how do you do that dynamically for both a current and comparison period?

TableauCalculations,TableauDates

Unlock Faster Tableau Workbooks with These Easy Tweaks

Jan 14, 2025 Robby White | interworks.com

Recently, I have been involved in working with larger datasets. Anyone who has done extensive data preparation with datasets at scale, in order to get the data cleaned and shaped for Tableau visualization purposes, will soon realize the importance...

Data,Tableau,TableauTips

Visualising Ranges

Jan 14, 2025 Donna Coles | donnacoles.home.blog

This week’s challenge was set by Sean and was a recreation of a PowerBI WOW challenge set a few weeks ago. The data set just contains 2 pieces of information – a datetime field and a glucose measurement. Creating the calculations On a new sheet, a...

WorkoutWednesday,WOW2025,AreaChart,DualAxis,LineChart,Median,Percentile,ReferenceLines,Week2

Configuring Private Connectivity between Snowflake and Azure Storage

Jan 13, 2025 Chris Hastie | interworks.com

Snowflake recently started supporting a whole range of new private connectivity functionality when interacting with Azure, and as a security-conscious architect I really couldn’t be happier. We’ve already seen private connectivity support between ...

Data,Azure,Snowflake

New Viz Road Trippin

Jan 13, 2025 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

In October and November of 2024, I tooka road trip through Kentucky, Tennessee, North Carolina, and Virginia. I stayedin several towns and cities along the way, including Red River Gorge, KY,Nashville, Chattanooga, Gatlinburg, Charlotte, and Roano...

DataViz,Maps,Tableau

What are Tableau Viz Extensions

Jan 10, 2025 Robby White | interworks.com

In one of its newer releases from 2024 (version 2024.2 to be exact), Tableau began to offer Viz Extensions. These are newly offered chart types, which are available as point-and-click selections from within the Marks cards area. Essentially, they ...

Data,Extensions,Tableau

Tiny Tips Power BI - Conditional Colouring Bar Charts

Jan 9, 2025 Sandy Wlodarczyk | www.thedataschool.co.uk

Welcome to my new series, where we dive into the quick, chic tips for data analytics and visualization that can (hopefully) be implemented faster than you can flag down a black cab in Central London. Think of it as the Pret A Manger of analytics a...

Data,Extensions,Tableau

SQL CTEs

Jan 9, 2025 Priya Kondola | www.thedataschool.co.uk

A CTE stands for common table expressions and is a named subquery normally defined with a WITH course.

Data,Extensions,Tableau

PowerBI DAX - Related Column Calculations

Jan 9, 2025 Lina Duong | www.thedataschool.co.uk

In PowerBI, you have the ability to create measures and column calculations in a table.

Data,Extensions,Tableau

Make over Monday

Jan 9, 2025 Thomas Hoefer | www.thedataschool.co.uk

Its Christmas Blog and we are working from Home, in my case from my hometown in Bavaria. Not a lot is happening so lets talk about Makeover Monday (MoM) 🥳

Data,Extensions,Tableau

How to create a Bar out of shapes ... and some radial bar chart catastro...

Jan 9, 2025 Thomas Hoefer | www.thedataschool.co.uk

Before reading this Blog pls visit last weeks blog about Makeover Mondays. The concept is explained there.As promised there, this weeks blog will concentrate on my third MoM all about engagement ring spending. For reference:original article and vi...

Data,Extensions,Tableau

What did it take to get into DSDE9

Jan 8, 2025 Peter Gamble-Beresford | www.thedataschool.co.uk

We are now at six weeks of training for this most recent group of budding data professionals at The Data School in Hamburg. They are flying! We’ve tackled lots of interesting topics already and the fundamental skills of data preparation and visual...

Data,Extensions,Tableau

UXUI Design Principles in Data Analytics Dashboards

Jan 8, 2025 Melvin Speckamp | www.thedataschool.co.uk

UX/UI Design Principles in Data Analytics Dashboards

Data,Extensions,Tableau

Storytelling mit Daten

Jan 8, 2025 Melvin Speckamp | www.thedataschool.co.uk

Wie finde ich Stories in meinem Datensatz?

Data,Extensions,Tableau

Start With The Why Part 1 When Philosophy Meets Analytics

Jan 8, 2025 Marcel Wiechmann | www.thedataschool.co.uk

Picture this: First day of lectures at the London School of Economics, sometime in the 1950s. Karl Popper, one of the most influential philosophers of science of the 20th century, enters the room. As every year, he begins the first lecture of the ...

Data,Extensions,Tableau

SQL-Joins

Jan 8, 2025 Melvin Speckamp | www.thedataschool.co.uk

Daten aus verschiedenen Tabellen zusammenführen

Data,Extensions,Tableau

Quick-Filter in Tableau

Jan 8, 2025 Takhmina Pirmahmadova | www.thedataschool.co.uk

Mit Filtern in Tableau kannst du deine Datenvisualisierungen verfeinern und anpassen, indem du die angezeigten Informationen auf bestimmte Kriterien eingrenzt. Sie dienen dazu, irrelevante Daten auszuschließen oder bestimmte Aspekte hervorzuheben....

Data,Extensions,Tableau

Interaktivitt in Deiner Visualisierung

Jan 8, 2025 Takhmina Pirmahmadova | www.thedataschool.co.uk

Was ist Interaktivität?

Data,Extensions,Tableau

How to Create an Info-Button in Tableau

Jan 8, 2025 Olivia Esau | www.thedataschool.co.uk

Today, we’re diving into Info-Buttons — a handy tool to enhance the usability of your Tableau dashboards. One of the first lessons I learned during my job application at the Data School phase was the importance of simplifying and decluttering my d...

Data,Extensions,Tableau

Design Thinking

Jan 8, 2025 Melvin Speckamp | www.thedataschool.co.uk

Datenprojekte und Design Thinking

Data,Extensions,Tableau

Daten sprechen lassen So prsentierst du Dashboards erfolgreich

Jan 8, 2025 Melvin Speckamp | www.thedataschool.co.uk

Als Data School Consultants ist es unsere Aufgabe, aus Zahlen Wissen zu generieren. Doch dieses Wissen muss auch kommuniziert werden. Dashboards sind dabei ein mächtiges Werkzeug, aber nur wenn sie richtig präsentiert werden. Dieser Beitrag gibt d...

Data,Extensions,Tableau