How We Do Our Trainings

Feb 2, 2024 Sebastian Deptalla | interworks.com

Step 1: Scoping You talk with us about what you actually need. This is what we call an enablement scoping. We check what you are after, ask a lot of questions and see if our trainings can fit that somehow. Usually they can, but sometimes…The post ...

Data,InterWorks,Trainings

How Do We Actually Learn

Feb 2, 2024 Sebastian Deptalla | interworks.com

Breaks – Or How Our Brains Work We have a few rules about breaks among us trainers: 10 minutes break for every full hour. No reading or answering emails during a break. Not more than four hours of training per day, ideally in the morning….The post...

Data,InterWorks,Learning,Training

The Census And You Querying the Census API With Alteryx

Feb 1, 2024 Aaron Potts | www.thedataschool.co.uk

Learn how to build a query for the US Census API, implement it in an Alteryx workflow, and transform the output into usable data.

Preppin for the Alteryx Designer Core Exam Part 2

Feb 1, 2024 Marc-Anthony Tucker | www.thedataschool.co.uk

Here is where I will get to the main things that can help you pass the exam. I will suggest some strategies that you can utilize to better prepare and take the exam along with additional resources to check out. I also urge others who are Core Cert...

My Experience with LWTDSL

Feb 1, 2024 Michael Imbriale | www.thedataschool.co.uk

As of today, DSNY7 is taking their turn presenting “Learn What the Data School Learns,” a session where data school trainees each give a 45-minute presentation on a subject they have learned since joining the data school. I wanted to reminisce abo...

Lessons Learned from Teaching Consultancy Tableau

Feb 1, 2024 Lisa Hitch | www.thedataschool.co.uk

I had the incredible opportunity to teach consultancy and Tableau (advanced business charts, including Marginal Histograms, Parallel Coordinates Charts, and Burndown Charts) and I will share my lessons learned here

Dealing with French Characters in Tableau

Feb 1, 2024 Adrien Sourdille | www.thedataschool.co.uk

If you import French characters (or other special characters) in Tableau, you might be in for a bad surprise. Indeed, depending on the settings of your workbook, Tableau might not be able to process the special characters in your string and will m...

Excel at Tableau Interactivity with Dynamic Zone Visibility

Feb 1, 2024 Donna Coles | donnacoles.home.blog

Erica set the #WOW2024 challenge this week, asking us to recreate this ‘drillable’ functionality within a single dashboard. To achieve this, I used 4 sheets along with parameter actions to drive the interactivity, and dynamic zone visibility to co...

WorkoutWednesday,WOW2024,DrillDown,DrillThrough,DynamicZoneVisibility,MapLayers,Navigation,ParameterActions,Week5

Preppin for the Alteryx Designer Core Exam Part 1

Jan 31, 2024 Marc-Anthony Tucker | www.thedataschool.co.uk

A few weeks ago, I took the both the Alteryx Foundation Micro-Credential Exam and the Alteryx Designer Core Exam. Thankfully, after one week of training with my coaches from The Data School, I passed with high marks and received my certification f...

TableauPublic

Lessons Learned from a Short-Term Consultancy Project

Jan 31, 2024 Lisa Hitch | www.thedataschool.co.uk

A few weeks ago, I had the incredible opportunity to work on a short-term consultancy project (~2 weeks) as the sole data consultant. Here are some of my takeaways, experiences, and lessons-learned.

TableauPublic

How to Make an Alteryx App with the Filter Tool

Jan 31, 2024 Michael Imbriale | www.thedataschool.co.uk

When making Alteryx App, one of the most useful features is being able to choose what you want to filter on in your data set. Let’s say that you are looking at a bunch of Lego sets, and you want to look at a particular set. You could put in a filt...

TableauPublic

Exporting Images from Tableau Workbook

Jan 31, 2024 Michał Mioduchowski | www.thedataschool.co.uk

Tableau Desktop allows us to copy Dashboard elements, such as images and text objects (Ctrl+C or ▼ -> “Copy Dashboard Item”) and paste them to other dashboards (Ctrl+V), either in the same or different Workbook. It doesn’t provide an option how...

TableauPublic

Alumni Spotlight Priya Padham

Jan 31, 2024 Mel Niere | www.thedataschool.co.uk

Learn more about Priya’s experience, from the time she applied to The Data School, to her career as a Data Visualization Engineer II at Expedia Group. Priya was part of Cohort 21 of The Data School London, which took place from October 2020 to Feb...

TableauPublic

How to Password Protect a Tableau Public Dashboard

Jan 31, 2024 Ollie Linley | onenumber.biz

Do you want to incorporate password protection for your Tableau Public Dashboards?

TableauPublic

Custom Join in ThoughtSpots SQL Editor

Jan 31, 2024 Gavin Holzworth | interworks.com

To best use ThoughtSpot, we need to have a good understanding of the data structure being used. The best way to work with that data is in ThoughtSpot’s data pane. In the data pane, we need to connect to a data source (in our case…The post Custom J...

Data,joins,sql,ThoughtSpot

Spatial Data 101 Alteryx Spatial Tools for Beginners Part 2

Jan 30, 2024 Aaron Potts | www.thedataschool.co.uk

In the last entry in this series, you learned how to input spatial data of various types and create a basic trade area around individual points. Now we’ll build on those skills by helping you smooth out and reduce the complexity of spatial files, ...

Data,row-levelsecurity,security,Snowflake

Kurz erklrt Rang-Funktionen in Tableau

Jan 30, 2024 Franziska Schwade | www.thedataschool.co.uk

Heute gebe ich euch einen kleinen Überblick darüber, welche Ränge ihr den Werten in euren Dashboards zuweisen könnt.

Data,row-levelsecurity,security,Snowflake

Fortgeschrittene SQL-Funktionen

Jan 30, 2024 Volha Fiadotava | www.thedataschool.co.uk

Structured Query Language (SQL) ist eine beliebte Abfragesprache, die häufig in allen Arten von Anwendungen verwendet wird. Hier möchte ich einen kurzen Blick auf einige fortgeschrittene Funktionen werfen, die SQL noch beeindruckender machen. Dies...

Data,row-levelsecurity,security,Snowflake

Being Project Manager Week In Review Part 2

Jan 30, 2024 Michael Imbriale | www.thedataschool.co.uk

Day Three: After a horrible first half of the week, I knew I needed to pick it up in the second half. Wednesday morning, I had my final meeting with the stakeholder before our presentation on Friday. My plan for this meeting was to give the stakeh...

Data,row-levelsecurity,security,Snowflake

Snowflake Row Access Policies Demystified

Jan 30, 2024 Barbara Hartmann | interworks.com

Row Access Policies are a convenient way to apply row-level security to multiple tables or views in one go. You simply create one policy and can apply that to as many objects as you like. Best of all, if you need to make adjustments, you…The post ...

Data,row-levelsecurity,security,Snowflake

SQL and Snowflake 7 lateral split-to-rows CTEs filters

Jan 29, 2024 Harvey Joyce | www.thedataschool.co.uk

In this blog, I take on Preppin’ Data Challenge 2023 Week 7 in Snowflake using SQL!

Advanced,Engineering,TableauDesktop,TipsTricks

Dashboard Week Day 4-5 - DataMovies

Jan 29, 2024 Yoan Caboste | www.thedataschool.co.uk

For the last two days of dashboard week, we were tasked with joining the #dataplusmovies challenge which provides partakers with IMDB’s extensive dataset, to see what they come up with.

Advanced,Engineering,TableauDesktop,TipsTricks

2024-01-28PART and 2024-01-28TRUNC

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

One of the slightly confusing concepts in Tableau would be the 2024-01-28PART and 2024-01-28TRUNC functions. The two functions appear to provide similar functions, however, there are still important distinguishing features between the two.

How to Account for Leap Year in Tableau

Jan 28, 2024 Felicia Styer | playfairdata.com

Brace yourselves – 2024 is a leap year! Here are a few strategies to keep your Tableau workbooks accurate this…The post How to Account for Leap Year in Tableau appeared first on Playfair Data.

Advanced,Engineering,TableauDesktop,TipsTricks

Taking Tableau Certifications at a Pearson VUE Test Center

Jan 26, 2024 Franziska Schwade | www.thedataschool.co.uk

Today, I took my first Tableau certification to become a Tableau Certified Data Analyst!

Tableau Data Analyst Certification Exam

Jan 26, 2024 Volha Fiadotava | www.thedataschool.co.uk

I recently took the Tableau Data Analyst certification exam and would like to share my thoughts on my experience, preparation and I will give you some tips for passing the exam.

Set Actions to Highlight Values in Table

Jan 26, 2024 Finn Kappus | www.thedataschool.co.uk

Especially in exploratory Dashboard, including tables can be useful. However, in some cases, the table on the dashboard only shows a sample of the data. Here, you can use a scroll to find the relevant data. There is also the option to use set acti...

Psychology in Data Visualization Gestalt Psychology

Jan 26, 2024 Calvin Gao | www.thedataschool.co.uk

The Gestalt Principles or the Gestalt Psychology explains that the human brain tends to perceive objects or visual elements as a whole when certain principles are applied. This happens such that the human brain will fill in details on visual eleme...

Design,Intermediate,Storytelling

Operatoren in SQL

Jan 26, 2024 Finn Kappus | www.thedataschool.co.uk

Wenn Sie neu in SQL sind und zuvor andere Programmiersprachen wie Python oder Tools wie Tableau verwendet haben, werden Sie einige kleine Unterschiede bemerkt haben. Um in Zukunft Verwirrung zu vermeiden, finden Sie hier einen Überblick über die O...

Day 45 The Finale

Jan 26, 2024 Hannah Bartholomew | www.thedataschool.co.uk

The name’s bond. James Bond. #DataPlusMovies

Data School - Alteryx 101

Jan 26, 2024 Calvin Gao | www.thedataschool.co.uk

On week three, the cohort tackled Alteryx and prepared for the Designer Core Certification. This certification tests an individual’s knowledge on the core toolset of Alteryx Desktop Designer and utilises this toolset to analyse real life problems.

Design,Intermediate,Storytelling

Data Movies Challenge - Dashboard Week Day 45

Jan 26, 2024 Dan Wade | www.thedataschool.co.uk

5 topics, 5 dashboards, 5 days.

Dashboard Week Days 45 - Data Movies

Jan 26, 2024 Faith Rotich | www.thedataschool.co.uk

For the last challenge of dashboard week, our task was to submit a viz for the Data + Movies challenge by Tableau, which meant a sweet reward: a cool free t-shirt from Tableau!

Dashboard Week Day 4 5 Movies

Jan 26, 2024 Aurora Malinauskaite | www.thedataschool.co.uk

Day 4 & 5: did someone say movies!?

Dashboard Week- Day 4 5 A Trip to the Movies

Jan 26, 2024 Harvey Joyce | www.thedataschool.co.uk

The Final two days of Dashboard Week! We had to plan, design and create a visualisation focused on Movies!

Dashboard Week Day 4 5

Jan 26, 2024 Beza Taye | www.thedataschool.co.uk

On Day 4, we were set the 2-day challenge of completing the #DataPlusMovies Challenge using IMDB Data, I was excited for this one as I thoroughly enjoy all kinds of films. However this made narrowing down my scope a little harder!

Alumni Spotlight Harry Osborne

Jan 26, 2024 Mel Niere | www.thedataschool.co.uk

Learn more about Harry’s experience, from the time he applied to The Data School, to his career as a Data Visualization Analyst at Close Brothers. Harry was part of Cohort 23 of The Data School London, which took place from April 2021 to August 2023.

Can you create donut charts exceeding 100

Jan 26, 2024 Donna Coles | donnacoles.home.blog

In 2024 the #WOW coaching crew has extended to include Yusuke Nakanishi (@YusukeNakanish3) and Yoshitaka Arakawa (@yoshi_dataviz) from the Japanese #datafam. This week Yusuke set this challenge asking us to build donut charts that represented whe...

WorkoutWednesday,WOW2024,CombinedSets,ContextFilters,DonutChart,DualAxis,INDEX,MeasureNames,MeasureValues,PieChart,Sets,TableCalculations,Trellis,week4

How to Alias Dimensions in Tableau

Jan 25, 2024 George Ledger | www.thedataschool.co.uk

You may have noticed that when using calculations as headers in Tableau, they are not always appropriately named for the end-user to understand what it actually is. Not only this, but dimensions are unable to be aliased like measures. So, what do ...

Design,Intermediate,Storytelling

Dashboard Week Day 3 - The Database Disaster

Jan 25, 2024 Thomas Smith | www.thedataschool.co.uk

In today’s installment of dashboard Week, we were set the challenge of utilising Snowflake and Tableau to unravel insights from a realisticly sized fake business’s database. The task at hand demanded not only querying the database to build out dif...

Design,Intermediate,Storytelling

DS42 Dashboard Week Day 45

Jan 25, 2024 Robbin Vernooij | www.thedataschool.co.uk

As I’m feeling generous, you’re getting two days to wrap up this weeks dashboard week.

Design,Intermediate,Storytelling

DBW D3

Jan 25, 2024 Yoan Caboste | www.thedataschool.co.uk

On the third day of dashboard week we were tasked with having a look at a fake clients database in snowflake, which consisted of a total of 500 billion rows all together. We had to use SQL to create data extracts to answer specific business questi...

Design,Intermediate,Storytelling

Making a Lot Out of a Little A Data Visualization Story

Jan 25, 2024 Wesley Cannatti | interworks.com

Have you ever been asked to create a dashboard with some sub-standard data? Maybe you don’t have the amount of data columns you would want, or maybe you are trying to perform some data analysis to support a data-driven decision. You might even be ...

Data,CleaningData,Dashboarding,data,Netflix

Templates - Dashboard Week Day 2

Jan 24, 2024 Dan Wade | www.thedataschool.co.uk

DS42: Dashboard Week - Day 2: Todays challenge was all about building templates. We had two dashboards to build in half a day to see how far we get. A sales dashboard in Tableau and a HR dashboard in Power BI.

TableauDashboards,TableauDates

SQL - Dashboard Week Day 3

Jan 24, 2024 Dan Wade | www.thedataschool.co.uk

DS42: Dashboard Week - Day 3: Todays challenge was all about MySQL. We had a giant data source we needed to extract data from, for a user story of choice.

TableauDashboards,TableauDates