Why Quantifying your Work is Essential How to do it

Oct 2, 2023 Emma Whyte | www.theinformationlab.co.uk

It’s the part of the data engineering or dashboard building process that often gets forgotten: writing up your latest project and attributing a value to it to your organisation. The process of reflecting on and quantifying your work is where the r...

Blog,bestpractice

Dashboard Week Day 5- NYC School Cafeteria Violations

Oct 2, 2023 Sabrina Vazquez | www.thedataschool.co.uk

This last Dashboard Week blog marks the end of my training here at DSNY. This last day was difficult physically, but thankfully not mentally like other days in the week. New York City went into a state of emergency after I arrived in the office (l...

machine-learning,large-language-models,ai,data-science

Brief Overview of SQL Data Types

Oct 2, 2023 Afnan Foyez | www.thedataschool.co.uk

Data types determine how information is stored, managed, and retrieved. They play a vital role in ensuring data accuracy, integrity, and efficiency. Whether you’re just beginning your journey with SQL (Structured Query Language) or you’re a season...

The Knowledge Dividend of LLMs a pragmatic perspective

Oct 2, 2023 Chris von Csefalvay | medium.com

As I’m writing this, the sun hasn’t risen over the Denver skyline in earnest. There’s still pink in the sky over the Front Range, and most of the world is still blissfully asleep. And so far, a small, moderately fine-tuned Large Language Model (LL...

machine-learning,large-language-models,ai,data-science

Tableau Hacks Advanced Apply Reset and De-Highlight

Oct 2, 2023 Robin Schouten | interworks.com

In the previous Tableau Hacks blog, we discussed adding Apply and Reset buttons to our dashboard filters, as well as the trick to de-highlight these buttons for a better user experience. In today’s blog, we will look into some more advanced option...

Data,Tableau,TableauHacks,TableauTips

Tableau Cloud System SCIM Unifying the Dimensions

Oct 2, 2023 John Saunders | interworks.com

Get ready to embark on an epic quest as we unravel the complexities of user provisioning and management across multiple systems and domains. Brace yourself for the introduction of Tableau Cloud System for Cross-Domain Identity Management (SCIM). P...

Data,Tableau,TableauCloud

The Gain Loss Chart

Oct 2, 2023 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

  Recently, a client asked me to build them a visual to show their top 20 most profitable accounts. I created a simple bar chart showing profit and filtered that down to the top 20. However, as I looked at the chart, I wondered to myse...

How-To,Tableau

Common String Functions

Oct 1, 2023 Samantha Fitzsimmons | www.thedataschool.co.uk

There are common string functions are the useful in Tableau, many of which would be most useful during the data cleaning process.

Calculating the Basics of Table Calculations - Part 1

Oct 1, 2023 Sid Saythongphet | www.thedataschool.co.uk

In Tableau, did you know we are able to transform the values within our visualization directly? We can do this by implementing a special type of calculation, called table calculations. Whereas basic calculations work at the data source level of de...

Put on the Dot

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

To wrap up the first section (other than making the buttons) of my HIPAA breaches dashboard remake, we’re going to talk about how you can select a point on a line with a parameter action, like so:

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

Nesting Nesting 1-2-3

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

Nested IF statements are when you have an IF statement inside an IF statement. I personally still find them a little difficult to understand, but they’re useful for when you only want to use one calculation. On the other hand, however, sometimes t...

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

NYC Cafeteria Inspections Dashboard Week Day 5

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

The final day of Dashboard Week has arrived, marking the end of an enriching training journey for us at DSNY4. It was a day tinted with somberness, beginning with a relentless downpour that brought public transportation in NYC to a halt. As a resu...

Using .PARQUET files

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

No, I’d not heard of them either

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

The Ten Commandments of Scope Heaven Part 1

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

As a collaboration with my esteemed colleague Sakif Chowdhury, and after each of our recent victories (mine, Sakif’s) with scoping during Dashboard Week, we have decided to compile the Ten Commandments of Scope Heaven in two parts.

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

Survey Data

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

Survey data can be really difficult to work with and require a ton of cleaning if good Survey practices aren’t kept.

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

Linear Regression Skeleton Scoping and Fast Stats Dashboard Week 5

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

It’s Dashboard Week here at the Data School, where in our final week of training we soon-to-be-graduates are given a topic or dataset and tasked with putting together a whole dashboard - every day.

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

Dashboard week - Day 5

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

On the final day of Dashboard Week, we embarked on a unique journey, beginning by examining the impact on mobility. However, at the stroke of 10:00, a surprising twist altered our course, presenting us with a new challenge involving a dataset. Thi...

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

Dashboard Week Day 5 - School Violations

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

The final day of dashboard week is finally here. It has been quite a long week and we ended it in the middle of a storm, there were floods and delays all over New York City. This meant that getting into the office took longer than normal, and we a...

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

Dashboard Week Day 5 - New York Taxis

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

So this morning our brief was to analyse Uber data in a country of our choice and see how mobility had been affected by COVID. Great, off I go to click the big download data button and I’ll be straight on my way to building the best dashboard ever...

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

Dashboard Week Day 5 - New York Cafeteria Inspections 2020-2023

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

On the last day of Dashboard Week, we were given the task of creating a Tableau Dashboard using inspection data from NYC Open Data for cafeterias permitted in public, private, and parochial schools in NYC.

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

Dashboard Week Day 5 NYC School Cafeteria Inspections

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

Finally, it is Day 5 of the dashboard week and I am excited that we will be graduating today. It’s a big day and we will be presenting our dashboard to the entire DSNY team today. So planning to make this one of the best among the five dashboards.

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

Dashboard Week Day 5 - Lyft Performance In NYC

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

Dashboard Week Day5 - Lyft Performance

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

Dashboard Week Day 5 How has mobility changed because of Covid

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

How did Covid impact Uber? DS40’s task for their last day is to focus solely on answering that question.

Data,Tableau,TableauHacks,TableauTips

Dashboard Week Day 5 - DSNY5 Application

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

For day 5 of Dashboard week the task was to create a dashboard with the data DSNY 5 was given for their final application.

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

Dashboard Week - Day 5

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

And just like that … it’s a wrap! For the final day of dashboard week, we were challenged to create a dashboard from the dataset DSNY 5 used for their application viz. Normally, what would be a fun challenge became even more stressful due to torre...

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

Dashboard Week - Day 4 SpotifyYoutube

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

Dashboard week is quickly coming to a close and for day 4, we got to work with data that contained information from Spotify and Youtube on the top 10 songs by various artists.

Data,Tableau,TableauHacks,TableauTips

Dashboard Day 5 - New York Taxis

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

Today began with a brief instructing us to download data from Uber and present a dashboard on the difference in demand due to Covid. The process of accessing the data was quite difficult for me to understand so I went to one of our coaches (Robbin...

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

DSNY4 Training Recap Next Steps

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

Training for DSNY 4 is over. Those 4 months flew by.

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

Creating an OnOff switch in Tableau

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

During the fourth day of dashboard week, I created a dashboard that showed what songs a person might like based on their preferences. The user had the ability to choose which preferences they wanted to include in the calculation for the song recom...

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

Alteryx Core Exam Preparations

Sep 29, 2023 Myles Stevenson | www.thedataschool.co.uk

When preparing for the Alteryx Core exam it’s important to be aware of every tool in the favorite’s Tab

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

Web-scraping London Marathon Data

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

Today, I was tasked with scaping finish times from the London Marathon website and creating a dashboard in Tableau with my findings.

Data,Tableau,TableauHacks,TableauTips

Web Scraping in Alteryx

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

A batch macro in a batch macro ?!?!?!?

Data,Tableau,TableauHacks,TableauTips

Table Calculations - 8th Week at DSDE

Sep 28, 2023 Ali Fawwaz | www.thedataschool.co.uk

The 8th week at the Data School was an important week. We learned a lot of new things in different subjects. We learned about spatial data in Alteryx and we also were introduced to  Macros in Alteryx too. I would write many pages about what we lea...

Espaol,CustomHeaders,Differentcalculationsbylevelofaggregation,Parameter,Target

Scraping Data with Alteryx ChatGPT

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

Today’s Challenge: Scrape and Visualise

Data,Tableau,TableauHacks,TableauTips

Scope Success API Calls and More https://www.thedataschool.co.uk/lex-dev...

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

Did you know that there is an entire API for Rick and Morty data? Yup, there is, and we analyzed it today. Axel Fuhrmann and Talita put it together for no other reason than their love of the show and ability to do so.

Data,Tableau,TableauHacks,TableauTips

Music Genres LODs and Algorithmic Scoring Dashboard Week 4

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

Music genres are fascinatingly multiplicitous. As a musician myself I love finding out about new ones and where they “fit into” the wide-ranging scheme of all genres. One genre can break down into ten others, which may each break down further into...

Data,Tableau,TableauHacks,TableauTips

London Marathon

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

Dashboard week day 4 , one to go…..

Data,Tableau,TableauHacks,TableauTips

Help I Cant Place This Sheet Inside This Container in Tableau

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

Greetings ye adventurous analyst. Have you encountered a snag in your dashboard production process? Are you trying, mercilessly, to force a sheet into a container which is just not having it?

Data,Tableau,TableauHacks,TableauTips

Dashboard week - day 3

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

We embarked on an exploration of historical London Marathon data, with a unique twist. Our task required us to narrow down the dataset to marathon runners whose names began with the first two letters of my name, ‘Ri.’

Data,Tableau,TableauHacks,TableauTips

Dashboard Week Day 4 - Webscraping

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

Dashboard Week Day 4 - Webscraping

Data,Tableau,TableauHacks,TableauTips

Dashboard Week Day 4 - Web Scraping and Marathons

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

As usual, this morning kicked off with a blog post from Andy instructing us to scrape Marathon data from this website: https://results.tcslondonmarathon.com/2022/?page=2&event=MAS&pid=search&search[name]=DA

Data,Tableau,TableauHacks,TableauTips

Dashboard Week Day 4 - Web Scraping

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

Today’s mission should we choose to accept it (reluctantly we kind of had to) was to web scrape data from the London Marathon website. In particular we had to web scrape data from runners who’s surnames began with the first two letters of our surn...

Data,Tableau,TableauHacks,TableauTips

Dashboard Week Day 4 Spotify and YouTube

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

Here comes Day 4 for the dashboard week and today we are working with some music data. This is the dataset of songs of various artists in the world. Interestingly, each record is a song and has some interesting information about Spotify and YouTub...

Data,Tableau,TableauHacks,TableauTips

Dashboard Week Day 4 - SpotifyYoutube

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

Today we actually received a data set that was clean. It contained information about approximately 20,000 songs, their qualities, the number of views they have, and the artist that created it. From this data, I wanted to create a dashboard that wo...

Data,Tableau,TableauHacks,TableauTips

Dashboard Week Day 4- Spotify Data

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

Today we worked on a dataset about Spotify and YouTube. From Kaggle, the data included the top 10 songs from various artists and information about the song and its YouTube video. Although comparing Spotify popularity to YouTube popularity could ha...

Data,Tableau,TableauHacks,TableauTips