Dashboard Week Day 3

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

Today, we were given a website related to our interests and were tasked with webscraping/ using an API to extract the data and then build a dashboard.

Design,TableauPublic,TableauDashboards

Using Alteryx to Connect to the Spotify API

Jan 29, 2025 Dominic Brady | www.thedataschool.co.uk

If you are looking to access Spotify’s wealth of data for your analytical needs, then an Alteryx to API connection could well be your answer.

Design,TableauPublic,TableauDashboards

Using API-Football in Alteryx

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

Today for dashboard week I got set a task to call data from the following API: https://www.api-football.com/documentation-v3?ref=thedataschool.co.uk#section/Authentication.

Design,TableauPublic,TableauDashboards

Formatting with Default Properties in Tableau Save Time and Effort

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

Are you also annoyed when building a dashboard or chart and using metrics that appear on multiple sheets, and you have to adjust the desired formatting on each sheet every time?It takes a lot of time and requires many repetitive clicks.If this is ...

Design,TableauPublic,TableauDashboards

First Client Project as a PM

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

This week, our cohort began working on the first client project, which will run for one week. Each week, a different person will take on the role of the Project Manager. With a total of seven projects lined up, this means that everyone will have t...

Design,TableauPublic,TableauDashboards

DS47 Dashboard Week Day 3

Jan 29, 2025 Lorna Brown | www.thedataschool.co.uk

Today they are going to be focusing on an Alteryx Workflow. Today is going to be a tough day as they will have to definitely work independently as each person has a different Website / API to scrape. In order to also complete their last dashboard ...

Design,TableauPublic,TableauDashboards

Alteryx core in a week

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

Last week we had our first look at Alteryx and were already tasked to pass the core examination by Friday. With this test dangling over our heads like the sword of Damocles we started exploring Alteryx. After a first look it is easy to get overwhe...

Design,TableauPublic,TableauDashboards

How to Build a Dashboard on Tableau Public

Jan 29, 2025 Ollie Linley | onenumber.biz

If you want to use Tableau for free and don’t need to ensure your data is perfectly private, you can use Tableau Public! This free-to-use option is perfect for Tableau newbies, testers, or people working for organizations where expensive Tableau l...

Design,TableauPublic,TableauDashboards

Advice for New Data Engineers from a New Data Engineer

Jan 29, 2025 Matthew Moffatt | interworks.com

Having recently been brought on as one of InterWorks’ newest Data Engineers, I wanted to compile a list of advice that I’ve found helpful during the onboarding process. Hopefully, if you’re in a similar position of starting your data engineering j...

Data,dataengineer,dataengineering

How to use box plots in tableau

Jan 28, 2025 Bethan Donovan | www.thedataschool.co.uk

Box plots can be an excellent way to visualise the distribution of data points across a selected measure. Box plots allow you to see the median, upper and lower interquartile range (IQR) , and the whiskers extend to 1.5 times the IQR, which allows...

Data,analytics,dataarchitecture,dataengineering,DataGovernance,Enablement,ThoughtLeadership

How to build a Beeswarm chart no extensions needed

Jan 28, 2025 Dominic Brady | www.thedataschool.co.uk

A beeswarm chart displays individual data points, arranged to avoid overlap, in order to provide a clear and detailed view of distribution. They are not however, easy to build intuitively within Tableau natively.

Data,analytics,dataarchitecture,dataengineering,DataGovernance,Enablement,ThoughtLeadership

How To Create a Music Player in a Tableau Dashboard

Jan 28, 2025 Cecily Santiago | www.thedataschool.co.uk

Recently, I worked on Mike Monsoon’s Progress Journal, a project management/album progress tracker dashboard for the musician Mike Monsoon, who releases his music on SoundCloud. Starting this project, I knew I could calculate song and album comple...

Data,analytics,dataarchitecture,dataengineering,DataGovernance,Enablement,ThoughtLeadership

Dashboard Week- Day 2

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

Today we were tasked with converting the dashboard below into an insightful infographic of our choice.

Data,analytics,dataarchitecture,dataengineering,DataGovernance,Enablement,ThoughtLeadership

Dashboard Week Day 1

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

As training comes to a close, DS47 have reached dashboard week where we will receive topics/ brief and have to create dashboards. To ease us in, we were given the Data+ TV challenge, where we have to take IMDB data and create a dashboard.

Data,analytics,dataarchitecture,dataengineering,DataGovernance,Enablement,ThoughtLeadership

Snowflake Notebooks SQLPython made easy

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

Snowflake now has notebooks!

Data,analytics,dataarchitecture,dataengineering,DataGovernance,Enablement,ThoughtLeadership

DS47 Dashboard Week Day 12 - DataTV

Jan 27, 2025 Lorna Brown | www.thedataschool.co.uk

It’s dashboard week for DS47, and to ease them in we’ve decided to do a double day. For the next 2 days, we’d like DS47 to take on a challenge set by Tableau themselves! Data + TV invites you to find data stories about the TV series you love, from...

Data,analytics,dataarchitecture,dataengineering,DataGovernance,Enablement,ThoughtLeadership

InterWorks 2025 Data Ins and Outs

Jan 25, 2025 Kevin Pemberton | interworks.com

While there is no crystal ball that can predict exactly where the data industry will go in 2025, or which tools or practices will make the largest impact, we at InterWorks are uniquely positioned to help our customers take the next best step on th...

Data,analytics,dataarchitecture,dataengineering,DataGovernance,Enablement,ThoughtLeadership

dbt for dummies

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

In today’s data-driven world, businesses rely on analytics to make informed decisions. However, the process of transforming raw data into actionable insights can be complex and time-consuming. Enter dbt (Data Build Tool), a powerful analytics engi...

WorkoutWednesday,WOW2025,BarChart,HighlightAction,LineChart,parameter,ParameterActions,ReferenceLines,week4

Organising a dbt Project Best Practices

Jan 24, 2025 Curtis Paterson | www.thedataschool.co.uk

Organising a dbt Project: Best Practices

WorkoutWednesday,WOW2025,BarChart,HighlightAction,LineChart,parameter,ParameterActions,ReferenceLines,week4

Normalised Vs Denormalised Data

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

Normalising data is a way of structuring datasets that reduces redundancy (duplication of the same information across multiple rows). This is done by storing data in multiple tables and creating relationships between them, often with the purpose o...

WorkoutWednesday,WOW2025,BarChart,HighlightAction,LineChart,parameter,ParameterActions,ReferenceLines,week4

Loading Data from Cloud Platforms into Snowflake Part 1 - Stages

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

In our last blog we covered loading local data files into Snowflake via the GUI, in this blog we’re going to get a little more advanced and look at how to bring in data from external cloud storage services, of which Snowflake supports three; Amazo...

WorkoutWednesday,WOW2025,BarChart,HighlightAction,LineChart,parameter,ParameterActions,ReferenceLines,week4

Exploring the Versatility of the ON Clause in SQL Joins

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

Master the power of SQL joins! Discover how the ON clause goes beyond simple equality to handle complex conditions, pre-filter data, and unlock advanced self-joins. Learn how to write efficient, dynamic queries that give you deeper insights into y...

WorkoutWednesday,WOW2025,BarChart,HighlightAction,LineChart,parameter,ParameterActions,ReferenceLines,week4

Can you compare to a selected months value

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

This week’s challenge by Lorna was to deliver some functionality without using LODs or table calculations. She hinted that parameters and parameter actions would be your friends. Setting up the parameters Create a parameter to capture the month se...

WorkoutWednesday,WOW2025,BarChart,HighlightAction,LineChart,parameter,ParameterActions,ReferenceLines,week4

L-Shaped Bars The Chart You Didnt Know You Needed

Jan 22, 2025 VizWiz (noreply@blogger.com) | www.vizwiz.com

In this Tableau tutorial, I’ll walk you through how to create L-shaped bar charts, a unique and visually way to display your data, perfect for giving your dashboards a fresh, modern look.You’ll learn:- How to connect and prepare your data using Su...

advanced,barchart,calculatedfield,charts,comparison,graphs,l-shapedbars,LOD,makepoint,maplayers,tableau,tip,tutorial

Vom Training zur Praxis Die wchentlichen Kundenprojekte

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

Nach den Freitagsprojekten ist die Kohorte bereit, sich an die Kundenprojekte (auch Labore genannt) zu wagen. In diesen Kundenprojekte der Data School  wird nun für einen echten Kunden gearbeitet, indem das Team zusammen, aber mit unterschiedliche...

WorkoutWednesday,WOW2025,BarChart,HighlightAction,LineChart,parameter,ParameterActions,ReferenceLines,week4

Power BI Data Models The Basics You Need to Know

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

Creating impactful reports in Power BI requires a solid foundation: your data model. Sure, Power BI allows you start visualizing as soon as you connect your data. But taking the time to understand and structure your data model will make your analy...

WorkoutWednesday,WOW2025,BarChart,HighlightAction,LineChart,parameter,ParameterActions,ReferenceLines,week4

Lost in the Source A Guide to Sources in dbt

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

The following blog explains what dbt sources are, how they are configured including an exhaustive list of properties options with added notes on how they function and ending on why dbt sources are important and can provide value to a business.

WorkoutWednesday,WOW2025,BarChart,HighlightAction,LineChart,parameter,ParameterActions,ReferenceLines,week4

Adding A Help Overlay To Your Dashboards

Jan 22, 2025 Holly Jones | www.thedataschool.co.uk

Creating an intuitive Tableau dashboard is an art, but sometimes even the most user-friendly dashboards require additional guidance for users. Adding a help overlay can provide essential instructions or context, ensuring that your audience underst...

WorkoutWednesday,WOW2025,BarChart,HighlightAction,LineChart,parameter,ParameterActions,ReferenceLines,week4

What Are Macros In Alteryx

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

Believe it or not, macros in Alteryx are designed to make your workflow simpler. In general they are reusable components or workflows designed to perform specific tasks that can be invoked in other workflows.

News,Events,Recap,socialmedia,Webinars,whitepaper

Understanding APIs in Alteryx

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

API stands for Application Programming Interfaces and can be integrated into workflows to connect with external systems and pull or send data to services.

News,Events,Recap,socialmedia,Webinars,whitepaper

Preppin Data with SQL 2024Wk4

Jan 21, 2025 Dominic Brady | www.thedataschool.co.uk

Here is the challenge: https://preppindata.blogspot.com/2024/01/2024-week-4-unpopular-seats.html

News,Events,Recap,socialmedia,Webinars,whitepaper

Preppin Data with SQL 2024Wk3

Jan 21, 2025 Dominic Brady | www.thedataschool.co.uk

Here is the challenge: https://preppindata.blogspot.com/2024/01/2024-week-3-performance-against-targets.html

News,Events,Recap,socialmedia,Webinars,whitepaper

Explorativ oder erklrend

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

Daten erkunden und mit Daten erklären

News,Events,Recap,socialmedia,Webinars,whitepaper

Ein einzigartiges Training DS Kundenprojekte

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

Was ist ein DS-Kundenprojekt?

News,Events,Recap,socialmedia,Webinars,whitepaper

Snowflake Cortex Parsing Unstructured Data with Document AI

Jan 21, 2025 Roger Garcia | interworks.com

Snowflake has transformed how businesses manage and interact with data, providing a powerful platform for handling large-scale data processing, analytics and integration with modern tools. One of Snowflake’s standout capabilities is its integratio...

Data,AI,DocuementAI,human-centered,Snowflake,SnowflakeCortex

New Viz SNL Five-Timers Club and a Journey into Midjourney AI Image Gene...

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

 If you read our Favorite Vizzes of 2024 blog post, you know that I’m pretty obsessed with Saturday Night Live. We grew up in a “Saturday Night Live” family. Our parents “taped” every episode on VHS. Some of our earliest memories are f...

Tableau

Transform Makeover Monday Marvel Edition

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

In the sixth week of The Data School, we were tasked with the topic for Makeover Monday (MoM): creating a clear story and drawing conclusions from a highly experimental dashboard about Marvel movies.

So organisierst du ein einwchiges Kundenprojekt als PM

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

Was ist ein Data School Kundenprojekt?

Recycle MakoverMakeoverMonday

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

Ziel dieser Challenge war es, ein bereits von uns erstelltes Dashboard zu überarbeiten. Anfänglich entschied ich mich für meine Visualisierung zu Dog Bites in New York City, die ich vor meiner Zeit in der Data School erstellt hatte. Leider stellte...

Marvel an der Kinokasse Ein Dashboard-Makeover

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

Makeover Monday ist eine wöchentliche Datenviz-Challenge, bei der die Community bestehende Visualisierungen neu interpretiert und verbessert. Mehr Details zur Initiative findet ihr in Olivias Blog-Post zu Makeover Monday.

Make over Make over Monday

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

The topic of my blog posts a few weeks ago was Makeover Monday. A cool Idea from our coach is to now revisit one of our old dashboards we did for MoM and do it again.Now in this position I have four dashboards to choose from:

How I Madeover my Makeover Monday

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

This week, Peter assigned us a special task. We are to choose a previously created Makeover Monday dataset from the past and give it another makeover. In this blog, you’ll learn how I approached this task and what ideas I came up with for my new d...

Git Version Control Setup for dbt Cloud

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

In this blog, I discuss the version control configuration for a dbt project discussing the available options recommending the use of GitHub/GitLab to maximize the integrations dbt Cloud has to offer whilst allowing you to retain visibility and con...

Die Arbeit als Data School Consultant - Projektwoche

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

In unserer Trainingsphase lernen wir neben der professionellen Arbeit mit Tools wie Tableau, Power BI und Alteryx auch einiges zum Thema Projektmanagement und die Arbeit mit Kunden. Dieser Post soll einen Leitfaden darstellen, wie die wöchentliche...

DS KundenProjekte Ein Ausblick auf das was da kommen wird

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

Nächste Woche ist es endlich soweit: Unser erstes Dataschool (DS) Kundenprojekt !!! Langsam steigt die Aufregung. Wir können endlich das gelernte in die Tat umsetzen und den Sprung ins kalte Wasser wagen. Jeder geneigten Leser meines Blogs würde j...