Tableau Aggregator

Dashboard Week Day 5

Mar 29, 2024 Lorraine Ferrusi | www.thedataschool.co.uk

This is it. This is how it ends.

WorkoutWednesday,WOW2024,BarChart,DualAxis,fakeaxis,Fixedsize,PercentofTotal,RunningTotal,SIZE,TableCalculations,Week13

Relative point in time calculations in Power BI using Power Query parame...

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

In this blog in the explaining with series I’ll go over how to carry out point in time analysis using Power Query and Power BI on a support desk ticket data set.

Friends or Foes NYC Squirrels vs NYC Rats

Mar 28, 2024 Salome Grasland | www.thedataschool.co.uk

For our penultimate day of dashboard week we were provided with an adorable dataset about NYC squirrel sightings. It immediately reminded me of another dataset I had worked with– NYC rate sightings. A questions came to mind:

FINAL DASHBOARD DAY DAY 4

Mar 28, 2024 Tobias Colmer | www.thedataschool.co.uk

DASHBOARD WEEK FINAL DAY

Decoding the Data How to Read and Analyse Any Dataset

Mar 28, 2024 Jeffrey Brian Thompson | www.thedataschool.co.uk

Diving into a new dataset can feel like cracking a code. Each column and row can hold an abundance of information, but where do you start? This blog outlines a three-step approach to understanding and decoding any dataset, turning raw data into ac...

Dashboard week day 4

Mar 28, 2024 Alexandra Skelly | www.thedataschool.co.uk

Web scraping + APIs Challenge

Dashboard Week day 4 web scrapping

Mar 28, 2024 Saampave Sanmuhanathan | www.thedataschool.co.uk

Today was the day I found most difficult. We were tasked with web scrapping the cocktails database. This is a topic I found quite challenging as I struggle quite a bit with APIs.

Dashboard Week - NYC Squirrel Census

Mar 28, 2024 Daniel Bostrom | www.thedataschool.co.uk

On March 1st, 2020, the latest NYC Squirrel Census took place. 72 volunteer census takers flocked to parks throughout Manhattan and Brooklyn to observe and document squirrel appearance and behavior, taking important notes along the way, like “Pret...

Dashboard Week Day 4 Squirrel Data

Mar 28, 2024 Calvin Gao | www.thedataschool.co.uk

Today’s data was about squirrel sightings. This was actually a version of data similar to the final dashboard application for DSNY2. However, DSNY2 has a larger dataset where sightings were reported for several days in Central Park. The squirrel d...

Dashboard Week Day 4 - Squirrel Census

Mar 28, 2024 Cecily Santiago | www.thedataschool.co.uk

Today we were assigned to create an informative dashboard using the Squirrel Census data, a log of squirrel sightings in NYC parks from March 1, 2020.

Dashboard Week Day 4 - Alteryx Tableau Cocktails

Mar 28, 2024 Andrew Tobin | www.thedataschool.co.uk

The challenge for the last day of the dashboard week was a web-scraping task: scrape the list of cocktails from https://www.thecocktaildb.com/, and the information within the pages for each (ingredients, etc.). Afterwards, we needed to create a da...

Dashboard Week Day 4

Mar 28, 2024 Jessica Kirk | www.thedataschool.co.uk

Today marked the last day of training for DS43 and day 4 of dashboard week. We were challenged with webscraping data off the cocktail database website https://www.thecocktaildb.com/ before using the website API, all within alteryx, then exporting ...

DS43 Dashboard Week Day 4

Mar 28, 2024 Lorna Brown | www.thedataschool.co.uk

Shaken not Stirred

Can you build this segmented bar chart

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

My #WOW2024 challenge this week, was to recreate this bar chart which displayed the total value in conjunction with the values split by another dimension, in this instance year. It was inspired by Sam Parsons’ film franchises viz. The viz is built...

WorkoutWednesday,WOW2024,BarChart,DualAxis,fakeaxis,Fixedsize,PercentofTotal,RunningTotal,SIZE,TableCalculations,Week13

How to Migrate Tableau Custom SQL to Data Warehouses

Mar 28, 2024 | www.anyalitica.dev

Tableau, a powerful data visualization tool, has revolutionized the way organizations analyze and present data. Its user-friendly interface and ability to connect to various data sources have made it a popular choice among data analysts and busine...

tableau,sql,migration,select_star

What are joins

Mar 27, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

I bet you didn’t know how easy it is to understand the 4 types of joins. Let me show you…

analysis,dataanalysis,fulljoin,innerjoin,join,outerjoin,rightjoin

8 Reasons Power BI isnt FREE

Mar 27, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

Too many IT leaders are ignorant. They are blinded by the allure of Power BI being “free”. It’s not.

charts,collaboration,complexity,cost,dataanalysis,ecosystem,free,limitations,mac,performance,PowerBI,reporting,sharing,visualization

When and Where Should You Be a Taxi Driver

Mar 27, 2024 Salome Grasland | www.thedataschool.co.uk

Today we were provided with data about Yellow Taxi Rides from the NYC Taxi and Limousine Commision. As a child my dream job was to always be a taxi driver, but my mother wanted me to be a doctor so we compromised and I became a data consultant. As...

TableauPrep

Project Breakdown Analysing South Korean Cinema

Mar 27, 2024 Michał Mioduchowski | www.thedataschool.co.uk

This is a short blog describing a full process of a data analyst working with dataset containing information about all movies available at the IMDb website.

TableauPrep

Dashboard Week day 2 data movies part 1

Mar 27, 2024 Saampave Sanmuhanathan | www.thedataschool.co.uk

For day 2 of Dashboard week we started our two day task of the tableau data+ movies challenge. The dataset we originally started with had over 5 million rows. I started off by familiarising myself with the data dictionary. I uploaded the data onto...

TableauPrep

Dashboard Week- day 23

Mar 27, 2024 Alexandra Skelly | www.thedataschool.co.uk

Day 2 & 3 we were set with the task of creating a visualisation using IMDb dataset.

TableauPrep

Dashboard Week Days 23

Mar 27, 2024 Hewan Zewdu | www.thedataschool.co.uk

For days 2 and 3 of dashboard week we were tasked with taking part in Tableau’s Data + Movies challenge. This was a task to use their IMDb data to create a dashboard of your choosing, with the help of their starter kit.

TableauPrep

Dashboard Week - Day 3 - Yellow Taxi Rides

Mar 27, 2024 Alan Grunberg | www.thedataschool.co.uk

This week, we sourced our data from https://www.nyc.gov/site/tlc/about/tlc-trip-record-data.page. They have tables with information on all taxi rides in NYC going all the way back to 2009! For our project we focused just on yellow cabs in 2023. St...

TableauPrep

Dashboard Week Day 3 Yellow Taxi Parsing a Parquet File in Alteryx

Mar 27, 2024 Calvin Gao | www.thedataschool.co.uk

Today was a data prep heavy task. The dataset came from the TLC Trip Record Data, specifically the yellow taxi trip records where the files came in a file type of ‘parquet’.

TableauPrep

Dashboard Week Day 3 - Working with .parquet files in Alteryx - Yellow T...

Mar 27, 2024 Cecily Santiago | www.thedataschool.co.uk

Today we were assigned to create an informative dashboard using the 2023 Yellow Taxi data from https://www.nyc.gov/site/tlc/about/tlc-trip-record-data.page.

TableauPrep

Dashboard Week Day 3 - Taxi Rides and working with Parquet files in Alte...

Mar 27, 2024 Luke Bennett | www.thedataschool.co.uk

For the third day of Dashboard Week, we were given data from NYC Taxi and Limousine Commission on taxi rides in New York City. The data contains information such as the times and locations of pickups and drop offs, fares charged, and the Taxi line...

TableauPrep

Dashboard Week Day 3 Data Movies Part 2

Mar 27, 2024 Saampave Sanmuhanathan | www.thedataschool.co.uk

For day three of dashboard week, we continued on from yesterday:

TableauPrep

Dashboard Week Day 3

Mar 27, 2024 Lorraine Ferrusi | www.thedataschool.co.uk

Dashboard Week Day 3:

TableauPrep

Dashboard Week Day 23 - Tableau IMDb

Mar 27, 2024 Andrew Tobin | www.thedataschool.co.uk

The second challenge of dashboard week was to produce a dashboard using IMDb data, focusing on some specific topic in the world of cinema. In my case, I chose to focus on language: what languages are films in? How has this changed over time? How d...

TableauPrep

Dashboard Week Day 2 3 Movie Challenge

Mar 27, 2024 Holly Jones | www.thedataschool.co.uk

For days 2&3 of dashboard week, we were tasked with designing a dashboard for the Data+ Movies Challenge for Tableau. We received two days to complete this dashboard so the stakes were definitely high!

TableauPrep

Dashboard Week - Day 23

Mar 27, 2024 Jessica Kirk | www.thedataschool.co.uk

This Tuesday and Wednesday, DS43’s dashboard challenge involved the IMDB movies dataset. We all had to come up with an avenue to go down that didn’t overlap with other members of our cohort.

TableauPrep

DASHBOARD WEEK DAY 2.B

Mar 27, 2024 Tobias Colmer | www.thedataschool.co.uk

DASHBOARD WEEK DAY 2 PART 2

TableauPrep

How Tableau Prep Decides Default Group Names

Mar 27, 2024 Eric Parker | onenumber.biz

A fundamental component of Tableau Prep is the ability to clean messy data. One of the best ways to do that is by creating groups! However, creating groups can be confusing. How does Tableau Prep decide what to name a group? For example, if you gr...

TableauPrep

Sorting stacked bar charts

Mar 26, 2024 Saampave Sanmuhanathan | www.thedataschool.co.uk

One of the limitations of using a stacked bar chart to visualise data is the difficulty to explore individual components due to categories being stacked on top of each other. By using set and parameter actions we can add an action so that by selec...