MoM KPI in Power BI

Nov 30, 2024 Maria Maske | www.thedataschool.co.uk

Have you ever wondered how you can actually visualise a KPI in Power BI in which you can also display the percentage comparison to the previous month?I asked myself this question last week in the Dashboard week and would like to share my solution ...

WorkoutWednesday,WOW2024,DualAxis,FIXEDLOD,Gantt,GoogleFonts,LineChart,Week48,YoY

Dashboard Week Witch Trials in Europe

Nov 30, 2024 Maria Maske | www.thedataschool.co.uk

On the last day of our Dashboard Week, we had the opportunity to work on a personal data project and design a Tableau dashboard accordingly.

WorkoutWednesday,WOW2024,DualAxis,FIXEDLOD,Gantt,GoogleFonts,LineChart,Week48,YoY

StreamStats - NETFLIX

Nov 29, 2024 Takhmina Pirmahmadova | www.thedataschool.co.uk

The last day of Dashboard Week was dedicated to our personal projects. Therefore, my task for the day was to visualize my Nextflix data to understand my habits and preferences better and discover useful recommendations.

WorkoutWednesday,WOW2024,DualAxis,FIXEDLOD,Gantt,GoogleFonts,LineChart,Week48,YoY

How to Show Seasonality in Tableau

Nov 28, 2024 Otaro Namakwa | www.thedataschool.co.uk

Understanding seasonality in data is critical for identifying recurring patterns and planning strategies. Tableau provides powerful tools to uncover these trends effectively. Seasonality Analysis helps businesses anticipate demand, plan resources,...

Data,consulting,projects

Dashboard Week Final Day

Nov 28, 2024 Rory Moxom | www.thedataschool.co.uk

The final day of dashboard week for us involved creating an infographic around a dataset looking at every boy band to chart in the Billboard Top 100 since 1980. Infographics combine data with visual storytelling, making them engaging and informative.

WorkoutWednesday,WOW2024,DualAxis,FIXEDLOD,Gantt,GoogleFonts,LineChart,Week48,YoY

Dashboard Week Day 4 The Internet Boy Bands Database

Nov 28, 2024 Thomas Duong | www.thedataschool.co.uk

The fourth and final day of Dashboard Week brought an exciting challenge: creating an infographic dashboard. Unlike typical dashboards, infographics are static, highly stylised, and designed to be print-ready—perfect for displaying information in ...

WorkoutWednesday,WOW2024,DualAxis,FIXEDLOD,Gantt,GoogleFonts,LineChart,Week48,YoY

Dashboard Week Day 4 - Creating a Boyband Infographic

Nov 28, 2024 Joe O'Connor | www.thedataschool.co.uk

Our fourth and final day of dashboard week - creating a boyband infographic

WorkoutWednesday,WOW2024,DualAxis,FIXEDLOD,Gantt,GoogleFonts,LineChart,Week48,YoY

Dashboard Week Day 4 Boybands

Nov 28, 2024 Kealan Daly | www.thedataschool.co.uk

Today marked the final day of dashboard week for us and we were tasked with creating infographics from a dataset centered around boybands that have made it into the Billboard Top 100 charts.

WorkoutWednesday,WOW2024,DualAxis,FIXEDLOD,Gantt,GoogleFonts,LineChart,Week48,YoY

Dashboard Week Day 4 Boy Bands

Nov 28, 2024 Robbin Vernooij | www.thedataschool.co.uk

Time to wrap it up early this week with some boy band data!

WorkoutWednesday,WOW2024,DualAxis,FIXEDLOD,Gantt,GoogleFonts,LineChart,Week48,YoY

Dashboard Week Day 3 Video Games

Nov 28, 2024 Kealan Daly | www.thedataschool.co.uk

On the third day of dashboard week our coaches gave to me… a data dump on the video game Path of Exile. Path of Exile is an online action RPG that has a sophisticated trading system that players track day by day (s0metimes multiple times a day), c...

WorkoutWednesday,WOW2024,DualAxis,FIXEDLOD,Gantt,GoogleFonts,LineChart,Week48,YoY

Dashboard Week Day 3 The Path of Exile Economy

Nov 28, 2024 Thomas Duong | www.thedataschool.co.uk

For Day Three of Dashboard Week, the challenge took us into uncharted territory—building a dashboard using data from the video game Path of Exile. As someone unfamiliar with the game, this was an entirely new experience for me.

WorkoutWednesday,WOW2024,DualAxis,FIXEDLOD,Gantt,GoogleFonts,LineChart,Week48,YoY

Dashboard Week Day 3

Nov 28, 2024 Rory Moxom | www.thedataschool.co.uk

Exploring Path of Exile’s In-Game Economy

WorkoutWednesday,WOW2024,DualAxis,FIXEDLOD,Gantt,GoogleFonts,LineChart,Week48,YoY

Building a Stacked Radial Chart

Nov 28, 2024 Georgia Webb | www.thedataschool.co.uk

This post will explain how I built a stacked radial chart. Today is day 4 of dashboard week and I saw this chart online and was inspired to try and build it myself. We have been given a dataset about boybands (this blog post will illustrate how to...

WorkoutWednesday,WOW2024,DualAxis,FIXEDLOD,Gantt,GoogleFonts,LineChart,Week48,YoY

Can you make a candle line chart

Nov 28, 2024 Donna Coles | donnacoles.home.blog

Sean provided this week’s #WOW2024 challenge, to produce a dual axis chart which he labelled a ‘candle line’ chart. The line displays the 2024 sales per month, while the candles represent the absolute difference from the previous year. Setting up ...

WorkoutWednesday,WOW2024,DualAxis,FIXEDLOD,Gantt,GoogleFonts,LineChart,Week48,YoY

Using dbt and Jinja to Write Custom SQL - Unioning Data

Nov 27, 2024 Edward Hayter | www.thedataschool.co.uk

Revolutionizing SQL with Jinja

Data,consulting,projects

Dynamic Rename Tables in SQL with dbt and Jinja

Nov 27, 2024 Edward Hayter | www.thedataschool.co.uk

Macro Script{% macro dynamic_rename(rename_table, source_relation) %} ...{% endmacro %}

Data,consulting,projects

Dashboard Week-UK Crime

Nov 27, 2024 Eden Thiede-Palmer | www.thedataschool.co.uk

Tuesday’s dashboard week objective was to analyse UK Street Crime data between September 2023 and September 2024. Part of this process was to build an Alteryx app that allowed users to access data for specific dates for specific areas. This app wo...

Data,consulting,projects

Dashboard Week KPIs Power BI

Nov 27, 2024 Maria Maske | www.thedataschool.co.uk

Our second day in the Dashboard week had the topic KPIs and done in Power BI. Our data set contained the familiar Super Store data set but arranged in a Star Shema as you can see below:

Data,consulting,projects

Dashboard Week Day 3 Video Game Economy

Nov 27, 2024 Robbin Vernooij | www.thedataschool.co.uk

Today I would like you to design and build a dashboard that allows you to dive into a slice of the Path of Exile economy!

Data,consulting,projects

Dashboard Week Day 3 - Creating a Dashboard for Path of Exile

Nov 27, 2024 Joe O'Connor | www.thedataschool.co.uk

Dashboard week day 3

Data,consulting,projects

Dashboard Week Day 3

Nov 27, 2024 Georgia Webb | www.thedataschool.co.uk

Challenge: Today’s challenge was to build a dashboard from data sets about a video game called Path of Exile. I have never heard of this game before and don’t play video games so this was new territory for myself.

Data,consulting,projects

Dashboard Week Day 2 - Superstore Analysis in PowerBi

Nov 27, 2024 Davy Ly | www.thedataschool.co.uk

I already knew that day 2 of Dashboard Week would be a stressful one because Power BI is not my favorite tool and I haven’t spent as much time with it compared to Tableau. One of my goals after completing the Data School training is to achieve cer...

Data,consulting,projects

Dashboard Week Day 2 Analyzing UK Street Crimes

Nov 27, 2024 Rory Moxom | www.thedataschool.co.uk

Day 2 of Dashboard Week brought the challenge of analyzing UK Street Crime data from September 2023 to September 2024. The task required building an interactive Alteryx app to explore the data and creating a Tableau dashboard to visualize key insi...

Data,consulting,projects

Dashboard Week - Day 2

Nov 27, 2024 Marcus Oberdiek | www.thedataschool.co.uk

The Superstore with PowerBI

Data,consulting,projects

Business KPI dashboard

Nov 27, 2024 Takhmina Pirmahmadova | www.thedataschool.co.uk

Task: create a best practice business KPI dashboard using the Superstore dataset and write a user story. One KPI must be Profit. Overall, the initial analysis ideas were:

Data,consulting,projects

My Favorite Project This Year Murphys Law

Nov 27, 2024 Mark Cordeiro | interworks.com

As we end the year by wrapping up projects, getting ready for the holidays and looking toward the future, we here at InterWorks wanted to take a quick step back and review some of the projects that stuck out to us over 2024. Be they…The post My Fa...

Data,consulting,projects

The Right Way to Present Dashboards Do Blueprints Exist

Nov 26, 2024 Takhmina Pirmahmadova | www.thedataschool.co.uk

Does it make sense to have a presenting structure?

Day Two of Dashboard Week UK Street Crime Data Dashboard

Nov 26, 2024 Thomas Duong | www.thedataschool.co.uk

The second day of Dashboard Week introduced us to a new set of challenges and rules to guide our work. While the rules are straightforward, the task itself required thoughtful planning and efficient execution.

Dashboard week day 2 Crime in the UK

Nov 26, 2024 Kealan Daly | www.thedataschool.co.uk

Today we built apps in Alteryx allowing a user to select parameters that would apply filters to a dataset containing records of crimes in the UK.

Dashboard Week Day 2 UK Street Crimes

Nov 26, 2024 Robbin Vernooij | www.thedataschool.co.uk

The point of Dashboard Week is to get the consultants working very, very quickly through a brand new data set each day. Some days require data prep, some don’t. Some days have complex data, some don’t. It’s a total surprise each morning.

WorkoutWednesday,WOW2024,FIXEDLOD,INDEX,ParameterActions,ReferenceLines,Sets,TableCalcs,TopN,Week47

Dashboard Week Day 2 - Creating an Alteryx App to update a Dashboard.

Nov 26, 2024 Joe O'Connor | www.thedataschool.co.uk

Day 2 of Dashboard Week

Perfect Labels For Rounded Bar Charts In Under 2 Minutes

Nov 25, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

Labeling a rounded bar has always been tricky. You might manually drag the labels, try to play around with the alignment and more, but still, you can’t get the labels perfect.No more! In this Tableau Tip, I’ll show you:1. Why standard labels don’t...

labels,roundedbars,tableau

Visualizing My Resume in a Compelling way

Nov 25, 2024 Takhmina Pirmahmadova | www.thedataschool.co.uk

The first dashboard challenge of the week was creating a visual CV using Tableau.

WorkoutWednesday,WOW2024,FIXEDLOD,INDEX,ParameterActions,ReferenceLines,Sets,TableCalcs,TopN,Week47

Redesigning a Dashboard to be Navigable by Keyboard

Nov 25, 2024 Eden Thiede-Palmer | www.thedataschool.co.uk

To begin dashboard week DS46 started off with a session on accessibility, and my task for the afternoon was to redesign an internally used dashboard to be navigable exclusively using a keyboard.

WorkoutWednesday,WOW2024,FIXEDLOD,INDEX,ParameterActions,ReferenceLines,Sets,TableCalcs,TopN,Week47

First day of Dashboard Week

Nov 25, 2024 Otaro Namakwa | www.thedataschool.co.uk

At the data school, there is this tradition that before a cohort graduates, they get an assignment to create a dashboard daily for a whole week. It is one of the most dreaded or well talked about to dos that frightens almost everyone, that it was ...

WorkoutWednesday,WOW2024,FIXEDLOD,INDEX,ParameterActions,ReferenceLines,Sets,TableCalcs,TopN,Week47

Dashboard Week Day One

Nov 25, 2024 Niklas Kubus | www.thedataschool.co.uk

With the very soon end of the training phase of my cohort DSDE8, we enter int0 the very last stage, which is the Dashboard Week.

WorkoutWednesday,WOW2024,FIXEDLOD,INDEX,ParameterActions,ReferenceLines,Sets,TableCalcs,TopN,Week47

Dashboard Week Day 1 - Lebenslauf

Nov 25, 2024 Davy Ly | www.thedataschool.co.uk

Jeden Tag ein neues Datenset, ein neues Dashboard, Start um 9 Uhr morgens, Präsentation um 16 Uhr und einen Blogpost bis 18 Uhr. Am ersten Tag bestand die Aufgabe darin, unsere Lebensläufe in Dashboards zu verwandeln. Hier ist, wie ich diese Chall...

WorkoutWednesday,WOW2024,FIXEDLOD,INDEX,ParameterActions,ReferenceLines,Sets,TableCalcs,TopN,Week47

Dashboard Week Day 1 Accessiblity

Nov 25, 2024 Thomas Duong | www.thedataschool.co.uk

Making Dashboards Accessible: Lessons from Dashboard Week

WorkoutWednesday,WOW2024,FIXEDLOD,INDEX,ParameterActions,ReferenceLines,Sets,TableCalcs,TopN,Week47

Dashboard Week Day 1 - Accessibility

Nov 25, 2024 Joe O'Connor | www.thedataschool.co.uk

Day 1 of dashboard week: Accessibility

WorkoutWednesday,WOW2024,FIXEDLOD,INDEX,ParameterActions,ReferenceLines,Sets,TableCalcs,TopN,Week47

Dashboard Week - Day 1

Nov 25, 2024 Marcus Oberdiek | www.thedataschool.co.uk

Create a CV in Tableau Desktop

WorkoutWednesday,WOW2024,FIXEDLOD,INDEX,ParameterActions,ReferenceLines,Sets,TableCalcs,TopN,Week47

Dashboard Week CV

Nov 25, 2024 Maria Maske | www.thedataschool.co.uk

Today was the first day of our Dashboard Week and our exciting task was to create our CV as a dashboard. I would like to share my thoughts and results with you in this post.

WorkoutWednesday,WOW2024,FIXEDLOD,INDEX,ParameterActions,ReferenceLines,Sets,TableCalcs,TopN,Week47

Dashboard Week Accessibility

Nov 25, 2024 Georgia Webb | www.thedataschool.co.uk

Dashboard Week Accessibility

WorkoutWednesday,WOW2024,FIXEDLOD,INDEX,ParameterActions,ReferenceLines,Sets,TableCalcs,TopN,Week47

Accessibility week Navigating through a dashboard using a keyboard

Nov 25, 2024 Kealan Daly | www.thedataschool.co.uk

Today marked the start of dashboard week for us and we built dashboards according to principles that improve its accessibility. I built a dashboard that adhered to Web Content Accessibility Guidelines (https://www.w3.org/WAI/WCAG22/quickref/?versi...

WorkoutWednesday,WOW2024,FIXEDLOD,INDEX,ParameterActions,ReferenceLines,Sets,TableCalcs,TopN,Week47

Accessibility Dashboarding

Nov 25, 2024 Rory Moxom | www.thedataschool.co.uk

Accessibility in Dashboard Design: Key Insights and Best Practices

WorkoutWednesday,WOW2024,FIXEDLOD,INDEX,ParameterActions,ReferenceLines,Sets,TableCalcs,TopN,Week47

Top 5 Product Sales vs Other Products

Nov 25, 2024 Donna Coles | donnacoles.home.blog

Erica set this week’s challenge and provided multiple levels specifically aimed a newer users of Tableau. My solution is for Level 3. Setting up the calculations First, create a parameter to capture the Sub-Category we care about pSelectedSubCat s...

WorkoutWednesday,WOW2024,FIXEDLOD,INDEX,ParameterActions,ReferenceLines,Sets,TableCalcs,TopN,Week47