Dashboard Week Day 4 How fast do marathoners run

Sep 28, 2023 Andy Kriebel | www.thedataschool.co.uk

How faster are marathoners over time at the London marathon? DS40 will let us know.

Espaol,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

Dashboard Week - Day 3 Rick and Morty

Sep 28, 2023 Tabitha Diaz | www.thedataschool.co.uk

It’s day 3 of dashboard week and I am here to report that things have gotten easier but also more challenging!  

Data,Tableau,TableauHacks,TableauTips

Bundesliga Web Scraping Dashboard Week Day 1

Sep 28, 2023 Afnan Foyez | www.thedataschool.co.uk

And so, Day One of Dashboard Week began, a journey into the unknown. We were aware of the daunting task at hand - to produce both a dashboard and a blog post every day. However, what we didn’t know was the nature of the datasets we’d be working wi...

Data,Tableau,TableauHacks,TableauTips

Target Achievement Report

Sep 28, 2023 Rosario Gauna | rosariogaunag.wordpress.com

In this blog, we will provide you with a detailed, step-by-step guide to tackle the Week 39 challenge of #WOW2023, presented by Valerija Kirjackaja and Erica Hughes. Within the context of this challenge, we are faced with the need to create a dyna...

English,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

Informe de Logro de Objetivos

Sep 28, 2023 Rosario Gauna | rosariogaunag.wordpress.com

En este blog, te ofreceremos una guía detallada y paso a paso para abordar el desafío de la semana 39 de #WOW2023, presentado por Valerija Kirjackaja y Erica Hughes. Dentro del contexto de este desafío, nos planteamos la necesidad de crear una tab...

Espaol,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

Target Achievement Report

Sep 28, 2023 Donna Coles | donnacoles.home.blog

The #WOW2023 challenge this week was set by guest challenger Valerija Kirjackaja, who asked us to recreate a tabular view of data. Model the data The requirement involved both the use of the Superstore data set and a custom Target data set, so the...

WorkoutWednesday,WOW2023,CustomNumberFormat,DataModelling,fakeaxis,MIN0,Relationships,SIZE,Subtotals,TableCalcs,Week39

Using Running sum to Pivot in Alteryx

Sep 27, 2023 Sakif Chowdhury | www.thedataschool.co.uk

When pulling data from an API or web-scraping, it is quite common to need to pivot the data at some point. Here’s what the data from the Rick and Morty API looked like when I tried to use it today:

Espaol,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

Using ChatGPT and Python to Make Data

Sep 27, 2023 Lydia Wren | www.thedataschool.co.uk

You don’t even need to know Python!!!

Espaol,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

Tips to pass your Alteryx Core Certification

Sep 27, 2023 Jules Claeys | www.thedataschool.co.uk

Yesterday we passed our Alteryx Core Certification!

Espaol,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

This IS a Drill-down Part 2 Parameter Action

Sep 27, 2023 Vivian Ng | www.thedataschool.co.uk

Continuing where we left off from having created a parameter that allowed us to drill down to breach type, let’s go into the parameter action today!

Espaol,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

Rick and Morty Dashboard Week Day 3

Sep 27, 2023 Afnan Foyez | www.thedataschool.co.uk

Today we were given the task to use the Rick and Morty API in order to retrieve data and create a dashboard.The API seems to be well documented, once I noticed this I went straight to Postman and started make calls to the API to see what kind of d...

Espaol,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

Harnessing ChatGPTs Python Skills to Generate Fake Datasets

Sep 27, 2023 Sanjeev Dosanjh | www.thedataschool.co.uk

Today’s task presented an intriguing challenge: to create an entire company from scratch and harness the remarkable abilities of ChatGPT to generate a Python script capable of producing a dataset comprising a minimum of 25,000 records. The envisio...

Espaol,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

Dashboard Week Day 3 - Rick and Morty API

Sep 27, 2023 Sakif Chowdhury | www.thedataschool.co.uk

Today we had to access the Rick and Morty API and create a dashboard about anything we wanted from that. I chose to show where different characters reside. The idea was to be able to look into the different universes/dimensions that exist in the s...

Espaol,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

Dashboard Week Day 3 - Rick Morty vs. Pop Culture APIs

Sep 27, 2023 Michael Bellamy | www.thedataschool.co.uk

On the third day of Dashboard Week, the task laid out for us involved using an API to retrieve information on the infamous TV show Rick and Morty.

Espaol,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

Dashboard Week Day 3 Rick Morty

Sep 27, 2023 Nitesh Shrestha | www.thedataschool.co.uk

Today is the third day of the dashboard week and we are working with APIs. We are instructed to access information from Rick and Morty API and build a dashboard. Rick and Morty is one of the popular animated science fiction TV episodes. The API co...

Espaol,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

Dashboard Week Day 3 Create Your Own Company

Sep 27, 2023 Andy Kriebel | www.thedataschool.co.uk

Surely DS40 would love to own their own businesses. What type of company would it be? What data would be important to them? How would they monitor it?

Data,datapipeline,DynamicTables,Snowflake

Dashboard Week Day 3 APIs

Sep 27, 2023 Terrence Miller | www.thedataschool.co.uk

Day 3’s topic is APIs.  Originally we were assigned Breaking Bad but turns out that api isn’t working atm and is a very sketchy site atm…

Espaol,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

Dashboard Week Day 3- API

Sep 27, 2023 Sabrina Vazquez | www.thedataschool.co.uk

Today we worked with a Rick and Morty API!

Espaol,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

Dashboard Week Day 2 - Survey Data

Sep 27, 2023 Terrence Miller | www.thedataschool.co.uk

Dashboard week day 2 for DSNY4 is Survey Data…There was definitely a groan from all of us after seeing the topic but the data was actually pretty clean.

Espaol,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

Dashboard Design Best Practices Color

Sep 27, 2023 Tobias Fitschen | www.thedataschool.co.uk

Hello everyone! Welcome to part four of the dashboard design series. So far we already discussed the advantages of applying whitespace, proper text use and chart choice in your dashboards. Moving on, this blog post will be about colors in your das...

Espaol,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

Creating datasets with ChatGPT and visualising in Power BI

Sep 27, 2023 Toby Horne | www.thedataschool.co.uk

Today, we were tasked with creating a fictional company and using ChatGPT to build a dataset of at least 25,000 rows so that we could produce a KPI dashboard in Power BI.

Espaol,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

Creating a Dynamic TOP N using a Dimension Parameter

Sep 27, 2023 Kinley Ly | www.thedataschool.co.uk

Creating a Dynamic TOP N using a Dimension Parameter is a relatively simple process since the Field Parameter feature we are using is quite similar to how parameters work in Tableau. However, the calculations on the other hand, is a whole differen...

Espaol,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

Bins and Histograms

Sep 27, 2023 Terrence Miller | www.thedataschool.co.uk

A histogram is a graph used to represent the frequency distribution of a few data points of one variable.

Espaol,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

Alumni Spotlight Nick Bowskill

Sep 27, 2023 Mel Niere | www.thedataschool.co.uk

Learn more about Nick’s experience, from the time he applied to The Data School, to his career as a Business Manager. Nick was part of Cohort 11 of The Data School London, which took place from October 2018 to February 2021.

Espaol,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

Alteryx Analytical Apps

Sep 27, 2023 Numa Begum | www.thedataschool.co.uk

An analytical app within Alteryx is a workflow that has a user interface, this allows the end-user to control aspects of the workflow such as changing parameters so they can execute a workflow without building it, automating the process.

Espaol,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

Organize the Tableau Data Pane with Folders

Sep 27, 2023 Ollie Linley | onenumber.biz

A messy Tableau data pane is totally overwhelming. It makes finding a particular field a gargantuan task. In fact, you might not even remember what you called the field in the first place! When you finally find the field you want, you realize that...

TableauGeneralKnowledge

Tableau Hacks Basic Apply Reset and De-Highlight

Sep 27, 2023 Robin Schouten | interworks.com

If you build any dashboard with more than a handful of filters, and your dataset is fairly large, changing and applying multiple filters can be painfully slow since you are waiting after every filter change for the data to load. In these cases, yo...

Data,Tableau,TableauHacks,TableauTips

Dynamic Drill-Down from Monthly to Daily Data Using Set Actions

Sep 26, 2023 VizWiz (noreply@blogger.com) | www.vizwiz.com

Unlock the power of Tableau’s Set Actions to enhance your data visualizations! In this in-depth tutorial, I’ll walk you through a step-by-step guide on how to create an interactive chart that allows users to drill down from monthly to daily data b...

datavisualization,day,drilldown,howto,interactive,month,set,setaction,tableau,timeseries,tip,tutorial

This IS a Drill-down Part 1 Parameter

Sep 26, 2023 Vivian Ng | www.thedataschool.co.uk

As previously mentioned, I remade my HIPAA breaches dashboard as a way to practice implementing interactivity and to also get more comfortable with parameters and parameter actions, so the next few posts will cover how I used parameters and parame...

Data,datapipeline,DynamicTables,Snowflake

Super Super Dash

Sep 26, 2023 Lydia Wren | www.thedataschool.co.uk

DASHBOARD WEEK DAY 2: Lollipop charts as a timeline, dynamic zone visibility and URL objects

Data,datapipeline,DynamicTables,Snowflake

Nothing At All

Sep 26, 2023 Lex Devlin | www.thedataschool.co.uk

What exactly is nothing? Is nothing an absence of something? Or is it where there never was anything at all? Is it an indicator of no value, like zero? Or is it the total absence of any information whatsoever?

Data,datapipeline,DynamicTables,Snowflake

How to build a timeline chart Dashboard Week Infographic

Sep 26, 2023 Nadia Holloway | www.thedataschool.co.uk

Today was day 2 of dashboard week which focused on design (BIG FAN). Our brief required us to create a Marvel infographic (again, big fan).

Data,datapipeline,DynamicTables,Snowflake

Dynamic Standard Deviation Band in Tableau

Sep 26, 2023 Tabitha Diaz | www.thedataschool.co.uk

A few weeks ago, for a client project, I was interested in allowing the client to adjust the standard deviation of a chart. Before this project, I would create the standard deviation through the analytics pane. This can be done by selecting the di...

AuthorExperience,Dashboards,TipsTricks,UserExperience

Dashboard day 2

Sep 26, 2023 Olivier Newman | www.thedataschool.co.uk

The task for dashboard day two was to build an infographic using marvel data from https://data.world/fivethirtyeight/avengers?ref=thedataschool.co.uk.

Data,datapipeline,DynamicTables,Snowflake

Dashboard Week - Infographics in Tableau

Sep 26, 2023 Asha Daniels | www.thedataschool.co.uk

I explain from the POV of a data-schooler building an infographic for dashboard week and what I created.

Data,datapipeline,DynamicTables,Snowflake

Dashboard Week - Infographics

Sep 26, 2023 Francisco Rei | www.thedataschool.co.uk

Dashboard week 2 - Infographics

Data,datapipeline,DynamicTables,Snowflake

Dashboard Week Day 2 - Youth Entertainment Preferences Survey Data

Sep 26, 2023 Michael Bellamy | www.thedataschool.co.uk

For day 2 of dashboard week, we were asked to explore some survey data looking at the preferences, interests, habits, opinions, and fears of young people… fun fun!

Data,datapipeline,DynamicTables,Snowflake

Dashboard Week Day 2 Survey Data

Sep 26, 2023 Nitesh Shrestha | www.thedataschool.co.uk

This is the second day of the dashboard week and today we are working on survey data. This survey was conducted in 2013 among the Slovakian young people exploring their preferences, interests, habits, opinions, and fears. The details and the data ...

Data,datapipeline,DynamicTables,Snowflake

Dashboard Week Day 2 Design an Infographic

Sep 26, 2023 Andy Kriebel | www.thedataschool.co.uk

Coach Lorna wants DS40 to practice their design skills. One of the best ways to do that is by creating an infographic.

AuthorExperience,Dashboards,TipsTricks,UserExperience

Dashboard Week Day 2

Sep 26, 2023 Otto Richardson | www.thedataschool.co.uk

Today, we started an exciting project: creating an infographic about Marvel comicbook characters and their mortality. I decided to focus on characters who, even after they ‘died’ in the comics, came back to life, like a form of ‘resurrection.’

Data,datapipeline,DynamicTables,Snowflake

Dashboard Design Best Practices Chart Choice

Sep 26, 2023 Tobias Fitschen | www.thedataschool.co.uk

Hello everyone! Welcome to part three of the dashboard design series. So far we already discussed the advantages of applying whitespace and proper text use in your dashboards. Moving on, this blog post will be about the right chart choice , which ...

AuthorExperience,Dashboards,TipsTricks,UserExperience

Creating a Button to Reset Parameters in Tableau

Sep 26, 2023 Sakif Chowdhury | www.thedataschool.co.uk

While building interactive dashboards, we sometimes want to be able to use several filters and then allow the user to reset the dashboard to its original quickly. To do this we can use a ‘button’ that resets all of the parameters we use for filter...

Data,datapipeline,DynamicTables,Snowflake

Snowflake Dynamic Tables Automatic Declarative Data Transformation Pipel...

Sep 26, 2023 Tinju Abraham | interworks.com

Imperative vs. Declarative Programming There are essentially two primary approaches to coding: imperative and declarative. To put it simply, these approaches determine whether you instruct the compute engine on how to perform the program’s tasks (...

Data,datapipeline,DynamicTables,Snowflake

Webscraping https://www.thedataschool.co.uk/lex-devlin/webscraping-api-c...

Sep 25, 2023 Lex Devlin | www.thedataschool.co.uk

Are you a sports fan? I’m not. I understand however the binding, inspiring force that sport represents. Some people meet spouses at sporting events, for others its a primary pastime, even a reason to live. For Germany, the Bundesliga has now been ...

AuthorExperience,Dashboards,TipsTricks,UserExperience

Tips for Building Dashboards that Reduce Conative load

Sep 25, 2023 Otto Richardson | www.thedataschool.co.uk

Day 1 of Dashboard week, and the focus is on integrating accessibility into our dashboard design process. To effectively communicate data, it’s vital to consider the diverse spectrum of users, including those with neurodiverse conditions like dysc...

AuthorExperience,Dashboards,TipsTricks,UserExperience