Friday PowerBI Project How did it turn out

Mar 4, 2025 Victor Yuan | www.thedataschool.co.uk

As part of DS training, we are required to prepare and execute a task in 4 hours. Here was what I didSpoiler alert… I had some lunch inbetween

From A Sketch to A Functional Power BI Dashboard

Mar 3, 2025 Aronas Zilys | www.thedataschool.co.uk

Progress and Objectives

Data Prepping Planning what to do with your data

Mar 3, 2025 Miffy Allen | www.thedataschool.co.uk

When given a large dataset it can feel overwhelming. Where to start?Before you begin to analyse the data, you need to understand your data and then transform it into something you can gain insights from.

Context Filters How to Control Tableaus Order of Operations

Mar 3, 2025 Ahsen Polat | www.thedataschool.co.uk

When building complex dashboards in Tableau, you’ll work with many filters and table calculations. What many people don’t realize—especially those new to Tableau—is that filters always run in a specific order called the “Order of Operations.” This...

Aspiring Data Analyst Impress a hiring with these Tableau dashboard tips

Mar 3, 2025 Dan Wade | www.thedataschool.co.uk

If you’re early in your data career and looking to impress with your Tableau dashboards, here’s a secret: most stakeholders don’t care about fancy charts. What they actually need is a dashboard that is clear, easy to use, and functional. One that ...

Understanding Mean Median and Mode The Basics of Descriptive Statistics

Mar 1, 2025 Olivia Esau | www.thedataschool.co.uk

In this post, we’ll explore the three fundamental measures of descriptive statistics: Mean, Median, and Mode. These are essential tools for summarizing data and identifying key patterns. To illustrate, we’ll use the following dataset:

Snowflake Execution Order

Mar 1, 2025 Rosh Khan | www.thedataschool.co.uk

If you are learning Snowflake or SQL for the first time, it can be hard to grasp the execution order and remember it. This blog will help you understand how SQL queries are processed step by step, with an example and mnemonic to remember by.

Erfolgreiche Client-Projekte Best Practices fr Consultants

Mar 1, 2025 Olivia Esau | www.thedataschool.co.uk

Wer schon mal in einem Client-Projekt gearbeitet hat, weiß: Es kann richtig gut laufen – oder komplett chaotisch werden. Damit es eher in die erste Richtung geht, habe ich mich mit erfahrenen Kolleginnen und Kollegen ausgetauscht und ihre bewährte...

Enhancing Your Visualizations with Reference Bands in Tableau

Mar 1, 2025 Olivia Esau | www.thedataschool.co.uk

In Tableau, we have four different options to reference our graphs: Reference Lines, Reference Bands, Distributions, and Box Plots. Each of these tools helps with data interpretation by providing visual context. Today, we will take a closer look a...

Week 4 DS49 Project

Feb 28, 2025 Zaman Bilal Iqbal | www.thedataschool.co.uk

The completion of my first month at The Data School has coincided nicely with the 4th week project; I was tasked with building on the work of my colleague, who had produced a design sketch for a dashboard showing the breakdown of the revenues of t...

Data,PowerBI,Tableau

SQL Window Functions Effiziente Analysen ohne Umwege

Feb 28, 2025 Marcel Wiechmann | www.thedataschool.co.uk

SQL-Abfragen für kontextbezogene Analysen werden schnell unübersichtlich: Den monatlichen Umsatz eines Produkts mit dem Kategoriedurchschnitt vergleichen, Kunden nach Kaufvolumen in Quartile einteilen oder kumulierte Verkäufe über Zeitperioden ber...

Data,PowerBI,Tableau

Preppin Data in Python 6 Ranks Pivots and Aggregate

Feb 28, 2025 Harvey Joyce | www.thedataschool.co.uk

Data preparation is a crucial skill for anyone working with data, whether in analytics, machine learning, or business intelligence. Raw data often needs cleaning, restructuring, and transformation before it can be analyzed effectively. This is whe...

Data,PowerBI,Tableau

Preppin Data in Python 5 Dealing with Duplicates

Feb 28, 2025 Harvey Joyce | www.thedataschool.co.uk

Data preparation is a crucial skill for anyone working with data, whether in analytics, machine learning, or business intelligence. Raw data often needs cleaning, restructuring, and transformation before it can be analyzed effectively. This is whe...

Data,PowerBI,Tableau

Preppin Data in Python 4 Joins Pivots For Loops

Feb 28, 2025 Harvey Joyce | www.thedataschool.co.uk

Data preparation is a crucial skill for anyone working with data, whether in analytics, machine learning, or business intelligence. Raw data often needs cleaning, restructuring, and transformation before it can be analyzed effectively. This is whe...

Data,PowerBI,Tableau

Tableau and Power BI Terminology Differences

Feb 28, 2025 Wesley Cannatti | interworks.com

As a Tableau Consultant or Data Analyst, many of us may find ourselves looking at the blank canvas of our first Power BI report, trying to understand the terminology of this new tool that many of us may find ourselves switching to or adding to…The...

Data,PowerBI,Tableau

InterWorks Blog Roundup February 2025

Feb 28, 2025 Mark Cordeiro | interworks.com

Man, the shortest month of the year always has a habit of feeling like the longest, huh? But we’ve done it, dear readers: the second month of the year is behind us. Only ten more to go! Welcome back to our monthly roundup, where we…The post InterW...

Data,BI,News,Snowflake

Binary Parameters

Feb 28, 2025 Donna Coles | donnacoles.home.blog

This week’s challenge was a guest post by Felicia Styer, who wanted us to make multiple selections using just a single parameter, rather than any groupings or sets. We’ll start by focusing on the initial requirement, which was to bucket into Sub-C...

WorkoutWednesday,WOW2025,deselectmarks,LEFT,ParameterActions,Parameters,Rank,StringFunctions,Week9

What is DAX in Power BI

Feb 27, 2025 Zaman Bilal Iqbal | www.thedataschool.co.uk

DAX stands for Data Analysis EXpressions. We use this in Power BI Desktop rather than the Power Query Editor to most commonly create:

Data,PowerBI,Tableau

Show Me Everything PowerBI Finding the Gaps Your Data Model Creates

Feb 27, 2025 Marcel Wiechmann | www.thedataschool.co.uk

In my previous post on Power BI Data Models, I explained how a well-structured data model separates facts and dimensions. Today, I want to highlight a practical implication of this structure that can significantly impact your analysis.

Data,PowerBI,Tableau

Stringing It Together Mastering Tableaus String Functions

Feb 26, 2025 Amy Peacham | www.thedataschool.co.uk

A string is a collection of characters, including letters, numbers, and symbols, that represent text-based data in databases and analytics tools. In Tableau, effectively handling strings is essential for data manipulation and visualisation. Master...

TableauRelationships,Data

Diving into Power Query and Power BI A First-Week Experience

Feb 26, 2025 Aronas Zilys | www.thedataschool.co.uk

This week, I took on the WorkOutWednesday NCAA Revenues & Expenses dataset challenges (Weeks 1-3), diving deep into Power Query and Power BI. It was an exciting opportunity to work through the full data process—cleaning, modelling, and visuali...

TableauRelationships,Data

How to Build Multi-Fact Relationship Data Models in Tableau

Feb 26, 2025 Eric Parker | onenumber.biz

One of the biggest areas of technical advancement in Tableau Desktop over the last several years is the ability to model complex data sources. Relationships first debuted in 2020 but were only usable for simple data models because you could only u...

TableauRelationships,Data

How to connect to Ravelry API in Alteryx

Feb 25, 2025 Bethan Donovan | www.thedataschool.co.uk

RavelryRavelry

Blau oder Grn Dimensionen und Kennwerte in Tableau

Feb 25, 2025 Marcel Wiechmann | www.thedataschool.co.uk

Als ich zum ersten Mal Tableau öffnete, war ich verwirrt: Warum sind manche Felder blau, andere grün? Die Unterscheidung schien auf den ersten Blick willkürlich. Dabei ist diese Farbkodierung der Schlüssel zu einem der wichtigsten Konzepte in Tabl...

Variable Offset Label Bar Chart

Feb 25, 2025 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 I recently released a viz about the Saturday Night Live Five-Timers club - stars that have hosted the show at least 5 times. In that viz, I created, what started off being a simple bar chart of those hosts, that just did not work beca...

Tableau

Makeover Monday PowerBI 2024 Wk11

Feb 24, 2025 Miffy Allen | www.thedataschool.co.uk

My first attempt at Makeover Monday in PowerBI.

Makeover Monday 2024 - Week 11 Housing Vacancy Analysis

Feb 24, 2025 Aronas Zilys | www.thedataschool.co.uk

This week, I participated in Makeover Monday 2024 - Week 11, where we explored housing vacancy rates across various U.S. metropolitan areas. The dataset was sourced from LendingTree’s study on vacant homes, highlighting the percentage of empty pro...

Makeover Monday 2024 Week 11 Exploring Housing Vacancies Across USA Metr...

Feb 24, 2025 Amy Peacham | www.thedataschool.co.uk

This week, we took on the Makeover Monday 2024 Week 11 challenge, which focused on housing vacancies across USA metro areas. The dataset was sourced from an article by LendingTree, which utilised US Census Bureau data to create initial visualisati...

MakeoverMonday 2024W11

Feb 24, 2025 Victor Yuan | www.thedataschool.co.uk

My attempt at a Makeover Monday

Make Over Monday 1 Hour Visualization Challenge

Feb 24, 2025 Gabriel Louks-Kirwan | www.thedataschool.co.uk

This week we were challenged to visualise vacancy rate data for the many homes across the U.S. that sit vacant. There are just over 5.6 million vacant housing units across the nation’s 50 largest metropolitan areas.

2nd Makeover Monday

Feb 24, 2025 Zaman Bilal Iqbal | www.thedataschool.co.uk

For our second Makeover Monday, we were tasked with completing Makeover Monday for the USA Housing Vacancies Data from Week 11 2024. Below I’ve outlined in order what my process was, what the end result was and what could have gone better.

Logical Functions... Makes sense right

Feb 23, 2025 Victor Yuan | www.thedataschool.co.uk

Logical Functions are extremely useful for dynamic data categorisation in Tableau. But what are they and how are they used?

Green and Blue in Tableau It Rhymes

Feb 21, 2025 Aronas Zilys | www.thedataschool.co.uk

As we dive into Tableau, it’s essential to understand the difference between green and blue pills, and what better way to do that than with a coffee analogy? Grab your mug, and let’s get straight to it!

News,partners,partnerships

Calculations and Functions

Feb 21, 2025 Zaman Bilal Iqbal | www.thedataschool.co.uk

Calculations and functions can help us elevate our analysis and save us from a large amount of manual work. We will discuss the differences between the two, some use cases and different types.

News,partners,partnerships

Can you display a ratio and volume on the same chart

Feb 21, 2025 Donna Coles | donnacoles.home.blog

This week’s #WOW2025 challenge was a guest post by Kieran Adair and had two parts to it; one to show Sales and Profit Ratio for 2024 only on the same chart, and the other to show comparisons to 2023 data on the same chart. I built the first one wa...

WorkoutWednesday,WOW2025,DotPlot,DualAxis,MeasureNames,MeasureValues,ReferenceLines,Week8

How to Create a Multi Column Dot Plot

Feb 20, 2025 VizWiz (noreply@blogger.com) | www.vizwiz.com

Want to make comparing multiple measures across multiple dimensions in Tableau easy to understand?

analytics,data,datavisualization,dotplot,dualaxis,measurenames,measurevalues,tableau,tip,tutorial

Box Plots Unboxed A Simple Guide to a Powerful Tool

Feb 20, 2025 Victor Yuan | www.thedataschool.co.uk

Box plots are powerful tools in data analysis, however tend to be misunderstood.

Extracting Data from API with Tableau Prep Builder

Feb 19, 2025 Le Luu | www.thedataschool.co.uk

I wrote two blogs about extracting data from API in Tableau Desktop. In the first part of that series, I introduced API, JSON structure, and how to parse JSON to extract data in Tableau Desktop (Part 1). In the second part of that series, I shared...

Best Practice for Building a Dashboard

Feb 19, 2025 Zaman Bilal Iqbal | www.thedataschool.co.uk

Building a dashboard is a great way to centralise the location of various types of visual data. They contain related pieces of information that help the intended users better understand the current challenges they are facing in their business. The...

Understanding Tableau Blue and Green

Feb 18, 2025 Miffy Allen | www.thedataschool.co.uk

One of the first things I learnt when exploring Tableau is that blue indicates a dimension whilst green indicates a measure. It’s Tableau 101. Except it isn’t.

Data,Snowflake,Streamlit

Preppin Data in Python 3 Loops Pivots Group Bys

Feb 18, 2025 Harvey Joyce | www.thedataschool.co.uk

Data preparation is a crucial skill for anyone working with data, whether in analytics, machine learning, or business intelligence. Raw data often needs cleaning, restructuring, and transformation before it can be analyzed effectively. This is whe...

Data,Snowflake,Streamlit

Preppin Data in Python 2 Aggregating Regex and Date Diffs

Feb 18, 2025 Harvey Joyce | www.thedataschool.co.uk

Data preparation is a crucial skill for anyone working with data, whether in analytics, machine learning, or business intelligence. Raw data often needs cleaning, restructuring, and transformation before it can be analyzed effectively. This is whe...

Data,Snowflake,Streamlit

Preppin Data in Python 1 Cleaning Filtering and Dates

Feb 18, 2025 Harvey Joyce | www.thedataschool.co.uk

Data preparation is a crucial skill for anyone working with data, whether in analytics, machine learning, or business intelligence. Raw data often needs cleaning, restructuring, and transformation before it can be analyzed effectively.

Data,Snowflake,Streamlit

Data Before the Dashboards Planning Prepping Proofing for Project Success

Feb 18, 2025 Amy Peacham | www.thedataschool.co.uk

Stepping into my first week at The Data School, I quickly realised that the key to success in data projects starts long before the first dashboard is built. Understanding data—where it comes from, how it’s structured, and how to prepare it—lays th...

Data,Snowflake,Streamlit

Stop Floating Around Build Better Dashboards with Containers

Feb 17, 2025 Victor Yuan | www.thedataschool.co.uk

Why are tiled layouts the better option for dashboards? How do you use containers instead?

WorkoutWednesday,WOW2025,DashboardActions,deselectmarks,DualAxis,fakeaxis,HighlightAction,Highlighttable,Sets,Week7