AAPI Heritage Month Vizzes 22

Jun 2, 2023 Elaine Yuan | www.thedataschool.co.uk

At the end of May, I created two additional Tableau visualizations for Asian American and Pacific Islander (AAPI) Heritage Month; one is on the topic of children’s literature and the other is about Drag Race. Without further ado, let me introduce ...

Data,baseball,Dashboard,Highlight,InterWorkers,MVP

The Cody Ehlers Baseball Project

Jun 2, 2023 Wesley Cannatti | interworks.com

One amazing thing about InterWorks’ people is that we all come from very diverse backgrounds. Though we all ended up here working with data, some of us have taken an interesting path to get here. Cody Ehlers is not just a talented Strategic Client...

Data,baseball,Dashboard,Highlight,InterWorkers,MVP

Say Less How To Ensure Your Tooltips Add Value

Jun 2, 2023 Beth Kairys | interworks.com

We’ve all done it. We’ve completely ignored the warning label. You know, the one we probably see everyday: CAUTION: Contents Hot We ignore it because it’s understood. We just ordered hot coffee or tea, and we expect it to be hot. We see the steam…...

Data,Dashboarding,design,Tooltips,UI,UX

Building a Tableau Dashboard for National Donut Day

Jun 2, 2023 Zack Cordeiro | interworks.com

I heard a week or so ago that National Donut Day was coming up, and it sparked my curiosity about donut day, leading to many long study sessions about everyone’s favorite ring-shaped pastry. I figured the best way to disperse my newly acquired yet...

Data,dashboards,Donuts,holidays

Exploring NASAs API

Jun 1, 2023 Zoe Reed | www.thedataschool.co.uk

As part of dashboard week, our task for today was to pull data from one of NASA’s many APIs, then visualise this data in any tool we wished.

Data,Curator,Tableau,TheBICantos,ThoughtSpot

Day 3 working with NASA API

Jun 1, 2023 Adrien Sourdille | www.thedataschool.co.uk

Today’s challenge was to pick one (or multiple) API’s of your choice to pull your data from and use to build a Tableau, Power BI workbook or Alteryx App that outputs interactive charts & reports.

Data,Curator,Tableau,TheBICantos,ThoughtSpot

Dashboard Week Day 3 Quiz Goal

Jun 1, 2023 Vivian Ng | www.thedataschool.co.uk

For the third day of Dashboard Week, we needed to scrape the Bundesliga website for 20 (or more) seasons’ worth of data. We also had to create an exploratory dashboard after cleaning up the data.

Data,Curator,Tableau,TheBICantos,ThoughtSpot

Dashboard Week Day 3 Nasa API Day

Jun 1, 2023 Tanbir Jalil | www.thedataschool.co.uk

In the penultimate day of dashboard week, we had the pleasure of working with NASA’s publicly available APIs. Plenty of interesting data to look at, and a good hour was spent perusing the different APIs finding which specific API piqued my interes...

Data,Curator,Tableau,TheBICantos,ThoughtSpot

Dashboard Week Day 3 - NASA Iceberg Data

Jun 1, 2023 Ross Killington | www.thedataschool.co.uk

Day 3 we were set an interesting task where we were given a choice of NASA API’s and instructed to pull data from an API of our choice and create an interactive dashboard with the data.

Data,Curator,Tableau,TheBICantos,ThoughtSpot

Dashboard Week Day 3 NASA API

Jun 1, 2023 Edward Hayter | www.thedataschool.co.uk

Day 3 of Dashboard Week was relatively broad in options. We could select a NASA API of our choice and make a Dashboard from the data in either Tableau, PowerBI or Alteryx with app configurations that returned rendered reports and interactive charts.

Data,Curator,Tableau,TheBICantos,ThoughtSpot

Dashboard Week Day 3 NASA

Jun 1, 2023 Karina Chan | www.thedataschool.co.uk

Today’s task is to use any NASA API to pull in data, and then make a dashboard out of it. The full instruction can be found here: https://www.thedataschool.co.uk/robbin-vernooij/ds38-dashboard-week-day-3-nasa/.

Data,Curator,Tableau,TheBICantos,ThoughtSpot

Dashboard Week Day 3 - Football Webscraping

Jun 1, 2023 Hang Chen | www.thedataschool.co.uk

June 1st, 2023, marks the 3rd day of Dashboard Week. Today, our task is to web scrape a German football website. Our goal by the end of the day is to create an exploratory dashboard with a good amount of user interactivity.

Data,Curator,Tableau,TheBICantos,ThoughtSpot

Dashboard Week Day 3 - Bundesliga

Jun 1, 2023 Nayeli Jaime | www.thedataschool.co.uk

For the third day of dashboard week we were tasked with web scraping the Bundesliga website and creating an exploratory dashboard that would allow users to learn more about Bundesliga teams and seasons (using at least 20 seasons).

Data,Curator,Tableau,TheBICantos,ThoughtSpot

Dashboard Week Day 3 - APIs

Jun 1, 2023 Andreea Scintei | www.thedataschool.co.uk

I was excited when I found out today was an API day. Not just any API, but NASAs APIs. I was picturing space visuals, stars, planets, asteroid trajectories and all of that good stuff. Since NASA has around 17 available APIs I started the day by re...

Data,Curator,Tableau,TheBICantos,ThoughtSpot

Dashboard Week Day 2 Power BI

Jun 1, 2023 Habeeb Gayle | www.thedataschool.co.uk

The second day of dashboard week was a Power BI task. I was tasked with recreating Carl Allchin’s ‘The Warriors and Curry’ Tableau dashboard on Power BI.

Data,Curator,Tableau,TheBICantos,ThoughtSpot

Dashboard Week Day 2

Jun 1, 2023 Jose De La Rosa | www.thedataschool.co.uk

For this week, we were tasked with Web scraping a website, and with that information, we had to create an exploratory dashboard. Most of the morning was spent on obtaining the data, and to scrape the data, I used alteryx. Since one of the requirem...

Data,Curator,Tableau,TheBICantos,ThoughtSpot

DSNY3 Dashboard Week Day 2 Bundesliga

Jun 1, 2023 Valerija Kirjackaja | www.thedataschool.co.uk

For Day 2 of Dashboard Week, we are asking you to scrape the German Bundesliga website to get information about the teams’ performance over time. You are welcome to go as far back as you like but you are required to get the data for at least the l...

Data,Curator,Tableau,TheBICantos,ThoughtSpot

DS38 Dashboard Week Day 3 NASA

Jun 1, 2023 Robbin Vernooij | www.thedataschool.co.uk

Today’s challenge is to pick one (or multiple) API’s of your choice to pull your data from and use to build a Tableau, Power BI workbook or Alteryx App that outputs interactive charts & reports.

TableCalculations,TableauCalculations,Design

Customise the appearance of a Macro in Alteryx Alteryx Tip 2

Jun 1, 2023 Shreya Arya | www.thedataschool.co.uk

The default appearance of a macro in Alteryx is a blue circle, but there are many other icon options you can choose from within Alteryx Designer. You can even customise Macro’s with your own custom pictures & icons. Read on to learn more…

Data,Curator,Tableau,TheBICantos,ThoughtSpot

InterWorks Blog Roundup May 2023

Jun 1, 2023 Mark Cordeiro | interworks.com

If you’re reading this, that means you survived Conference Season. Congratulations! If you joined ThoughtSpot online or Tableau in Las Vegas, you probably saw us either hanging around our booth or speaking at a session, so hopefully you said hello...

Data,Curator,Tableau,TheBICantos,ThoughtSpot

Data Analysts of the Future The Skills Desperately Needed in an Ever-Cha...

Jun 1, 2023 Mark Cordeiro | interworks.com

As the professional equivalent of a monkey with a typewriter, I have been watching the news about AI chatbots with both wonder and an ever-present, underlying fear that I will soon be replaced by our machine overlords. The future, it seems, is a m...

Data,AI,consulting,data,ML

Filtering and Highlighting

Jun 1, 2023 Donna Coles | donnacoles.home.blog

It was Sean’s turn to set the challenge this week which included a lots of little details to provide a wealth of different ‘views’ on the same data within a single chart, specifically the change of measure and the change of date granularity. Build...

WorkoutWednesday,WOW2023,CustomDateFormat,CustomShapes,DateGranularity,deselectmarks,DualAxis,DynamicAxisTitles,DynamicZoneVisibility,ParameterActions,SetControl,transparentshape,week22

What did it take to get into DSDE4

May 31, 2023 Peter Gamble-Beresford | www.thedataschool.co.uk

As we now look to recruit our next cohort of trainee consultants here in Germany, it’s the perfect time to take a quick look back at what it took to join our 4th cohort here.

TableCalculations,TableauCalculations,Design

Recreating a tableau viz in PowerBI

May 31, 2023 Adrien Sourdille | www.thedataschool.co.uk

Today, we were tasked with rebuilding an iconic viz in Power BI. This challenge was interesting as it pushed us out of our Tableau comfort zone and made us think more deeply about how the different dashboarding tool at our disposal really work.

TableCalculations,TableauCalculations,Design

Recreating a Tableau Viz in Power BI

May 31, 2023 Zoe Reed | www.thedataschool.co.uk

For day 2 of dashboard week, we were tasked with recreating a Tableau viz in Power BI. Having only spent a day learning Power BI prior to today, I anticipated a challenge. I recreated a viz by Carl Allchin after being inspired by the copious image...

TableCalculations,TableauCalculations,Design

Output as Google Sheet in Alteryx

May 31, 2023 Karina Chan | www.thedataschool.co.uk

In order to output data as a google sheet,  you will need the Google Drive tool, which can be downloaded in this link: https://community.alteryx.com/t5/Community-Gallery/Google-Drive-Tools/ta-p/898151.

TableCalculations,TableauCalculations,Design

How To Make A Radar Chart In Power BI

May 31, 2023 Karina Chan | www.thedataschool.co.uk

Radar chart is not one of the build in visuals in Power BI, so the first thing we need to do is to download a radar visual. Click the three dots in the Visualizatrions pane and select “Get more visuals”, then it will bring you to what I call the v...

TableCalculations,TableauCalculations,Design

HowTo - Circular Calendar Chart - Part 2 Building in Tableau

May 31, 2023 Trea McElhone | www.thedataschool.co.uk

Welcome to Part 2 of my #HowTo on how to build a circular calendar chart in Tableau - before following this blog, please make sure you are up to date with Part 1.

TableCalculations,TableauCalculations,Design

Fixing The Error With Map Tool In Alteryx

May 31, 2023 Karina Chan | www.thedataschool.co.uk

Map tool has been a known bug in the latest two versions of Alteryx. It crushes the app every time you try to add it to the canvas. However, there is actual a simple way to solve this issue. All it takes is to rename a file in your computer.

TableCalculations,TableauCalculations,Design

Drop Down App Filter in Alteryx

May 31, 2023 Edward Hayter | www.thedataschool.co.uk

Dashboard week kicked off with the need to create an app that filtered data on a selected date and area along with filtering to a specific type of crime. This blog focuses on the last requirement as without noticing you can leave a flaw in your ap...

Dashboard Week Day 2 - Power BI Recreation

May 31, 2023 Trea McElhone | www.thedataschool.co.uk

For our second day of Dashboard week we were tasked with recreating a chosen dashboard from the list on this post - with one particular catch, we had to recreate it in PowerBI.

TableCalculations,TableauCalculations,Design

Dashboard Week Day 2 PowerBI

May 31, 2023 Edward Hayter | www.thedataschool.co.uk

The task for today was to recreate a Tableau Dashboard in PowerBI. I opted for Robbin Vernooij’s Alteryx Community Contribution Tracker. It consists of a landing page and a profile deep dive which can be accessed by selecting a person on the landi...

TableCalculations,TableauCalculations,Design

Dashboard Week Day 2 - National Survey of College Grads 2021

May 31, 2023 Hang Chen | www.thedataschool.co.uk

Dashboard Week Day 2: The data set we were given today is about the National Survey of College Graduates: 2021. One thing to note is that there is a lot of data available for selection within this topic. The data I chose to work with is ‘Median an...

TableCalculations,TableauCalculations,Design

Dashboard Week Day 2 Land of Owe-ppurtunity

May 31, 2023 Vivian Ng | www.thedataschool.co.uk

Today’s the second day of Dashboard Week, and we analyzed National Survey of College Graduates 2021 data. I sought to learn more about college graduates and the median amount they borrowed to finance their undergraduate degrees, in relation to the...

TableCalculations,TableauCalculations,Design

Dashboard Week Day 2 DS38

May 31, 2023 Tanbir Jalil | www.thedataschool.co.uk

Today’s dashboard week was a PowerBI Centric day where we recreated some of the dashboards created in Tableau by the coaches. We were given a choice of which dashboard to recreate on a first come first served basis and I was slightly t...

TableCalculations,TableauCalculations,Design

Dashboard Week Day 2 - College Graduates

May 31, 2023 Nayeli Jaime | www.thedataschool.co.uk

For the second day of dashboard week, we were tasked with analyzing the data from the National Survey of College Graduates 2021, with the free reign to tackle this in any way we wanted. As soon as I saw the topic for the day, I knew exactly how I ...

TableCalculations,TableauCalculations,Design

Dashboard Week Day 2

May 31, 2023 Andreea Scintei | www.thedataschool.co.uk

Today we took on a Power BI challenge. We were provided with a list of Tableau dashboards and asked to choose which one we would like to recreate in PBI. I picked the one I thought was more interesting, you can find it here.

TableCalculations,TableauCalculations,Design

Dashboard Week Day 1 - Accessibility Using Data from Fix My Street Glasg...

May 31, 2023 Jessica Kwan | www.thedataschool.co.uk

Since this is our first dashboard week challenge, I thought I would keep it simple and focus mainly on what we covered this morning – accessibility.

TableCalculations,TableauCalculations,Design

Dashboard Week Day 1

May 31, 2023 Jose De La Rosa | www.thedataschool.co.uk

For Dashboard week day 1, we are working with the National Survey Of College Graduates dataset. For the first part of the day, we received the data at 8:45, and at 9:00 AM, I began data exploration. There are several tables, in different categorie...

TableCalculations,TableauCalculations,Design

DSNY3 Dashboard Week Day 1 College Graduates

May 31, 2023 Valerija Kirjackaja | www.thedataschool.co.uk

Dashboard Week is arguably one of the most intense weeks in the Data School training programme. Each day, consultants need to produce a dashboard on a completely new dataset - some days, the data might require cleaning and preparation, other days ...

TableCalculations,TableauCalculations,Design

DS38 Dashboard Week Day 2 Power BI

May 31, 2023 Robbin Vernooij | www.thedataschool.co.uk

Simple instructions today; pick one of the below Tableau dashboards and recreate it in Power BI. If time allows, improve on the existing dashboards!

Display a Single Dimension Across Multiple Columns in Tableau

May 31, 2023 Eric Parker | onenumber.biz

Sometimes, you have too many values in a dimension on the rows shelf in your Tableau worksheet and end up with a scroll bar. Annoying, right? Scroll bars mean your users are less likely to see the data at the bottom of your worksheet because it it...

TableCalculations,TableauCalculations,Design

Dashed and Dotted Line Patterns

May 31, 2023 Marc Reid | datavis.blog

This post takes a quick look at this new formatting feature shipping in version 2023.2 enabling the use of dotted and dashed lines.

Formatting,Tableau

PYD120 The Journey to ThoughtSpot with Solutions Engineer Hadley Reuter...

May 31, 2023 InterWorks | interworks.com

In this episode of Podcast Your Data, InterWorks’ Content Manager, Garrett Sauls, sits down with ThoughtSpot Solutions Engineer Hadley Vaca to chat about all things data, her time at InterWorks as an intern and her new role at ThoughtSpot.  The po...

Data,internship,Podcast,PYD,ThoughtSpot

How to Create a Radial Bubble Chart in Tableau

May 30, 2023 VizWiz (noreply@blogger.com) | www.vizwiz.com

If you’re looking for something beyond the basic line chart in Tableau, this radial bubble chart might be exactly what you’re looking for. And the best part, it only takes 6 calculations and 8 steps. But be careful, this isn’t the easiest chart to...

bubblechart,circle,circulartimeline,cosine,geometry,howto,index,levelofdetail,radialchart,radians,sine,tablecalculation,tableau