Dashboard Week Day 2: Dashboard Harder

Oct 26, 2022 Zachary Ryan | www.thedataschool.co.uk

Dashboard Week Day 2 just happened and I am very happy it is over. Here’s why.

TableauCalculations,TableauDates

Dashboard Week: Day 2

Oct 26, 2022 Sundus Jamaal | www.thedataschool.co.uk

The task at hand today was to choose some tables from a wine dataset, clean it and get as much insight from it as possible and if there was time left at the end, to build a dashboard.

TableauCalculations,TableauDates

Creating a drilldown chart using parameter actions

Oct 26, 2022 Nermine Obeng | www.thedataschool.co.uk

Want to learn how to build a drilldown bar chart using parameter actions (as opposed to set actions)? Continue reading ahead!

Data,dataengineering,datatransformation,Deduplication,Snowflake

Can you combine files in Tableau Desktop?

Oct 26, 2022 Flavio Matos | www.thedataschool.co.uk

How to Join two files in Tableau Desktop

TableauCalculations,TableauDates

Adelaide Wine Data - Analysis - Dashboard Week

Oct 26, 2022 Beau Foletti | www.thedataschool.co.uk

Today’s task was different to yesterday’s task of accessibility. There were no requirements on design, not even a requirement for a dashboard. Today was purely about analysis.

TableauCalculations,TableauDates

Fiscal Year to Date vs. Prior Fiscal Year to Date in Tableau

Oct 26, 2022 Eric Parker | onenumber.biz

Many organizations report against a fiscal calendar which doesn’t align with the standard calendar year. If your organization’s fiscal year starts in October or July, you know what I’m talking about.

TableauCalculations,TableauDates

The InterWorks Italian Takeover

Oct 26, 2022 Vicky Lockett | interworks.com

The EMEA InterWorks team recently finished a long awaited, and most welcome, meet-up of InterWorkers from all across Europe! Planning for this trip with Andrea Thum and Sam Riley started back in July 2022, and as an events planner, it’s always mor...

Culture,CompanyRetreat,ItalianTakeover,Italy,Vacation

How to Create a 3 Level Drill Down in Tableau

Oct 25, 2022 VizWiz (noreply@blogger.com) | www.vizwiz.com

I’ve showed you in several videos and WatchMeViz live streams how to create a 2 level drill down. And naturally the follow up question is always, how can I go one level deeper? This tip has exactly what you’re looking for. I show you how to create...

3leveldrilldown,analysis,calculatedfield,color,comparison,context,drilldown,drillup,drilldown,formatting,howto,howtodown,setaction,shading,tableau,tip

The Journey From Being an Applicant to a Consultant-in-Training (Second ...

Oct 25, 2022 Kinley Ly | www.thedataschool.co.uk

The Journey From Being an Applicant to a Consultant-in-Training (Second Chapter) (First Chapter)

Data,dataengineering,datatransformation,Deduplication,Snowflake

Tackling Alteryx Exams

Oct 25, 2022 Zachary Ryan | www.thedataschool.co.uk

Here’s some key tips I learnt after taking both Alteryx exams and how I passed them.

Data,dataengineering,datatransformation,Deduplication,Snowflake

Tableau Certified Data Analyst Exam

Oct 25, 2022 Peter Hajnal | www.thedataschool.co.uk

You find a lot of useful information on convo about the exam here

Data,dataengineering,datatransformation,Deduplication,Snowflake

TDA-C01 exam. How was it?

Oct 25, 2022 Ana-Casiana Tarita | www.thedataschool.co.uk

Last week I had the opportunity to take the Tableau Certified Data Analyst exam with Pearson.

Data,dataengineering,datatransformation,Deduplication,Snowflake

ROW_NUMBER() AND RANK() from SQL in Alteryx

Oct 25, 2022 Bianca Ng | www.thedataschool.co.uk

DSNY2 just finished week 3 by taking the Alteryx Designer Core Certification Exam, so it’s a good time to review one of the challenges I enjoyed.

Data,dataengineering,datatransformation,Deduplication,Snowflake

Parameters 101

Oct 25, 2022 Tara Robinson | www.thedataschool.co.uk

This blog looks at what a parameter is, what the steps are to using a parameter and finally where it might be used. My next blog will walk through an example on Tableau.

Data,dataengineering,datatransformation,Deduplication,Snowflake

How to create a Dynamic Reference Line?

Oct 25, 2022 Flavio Matos | www.thedataschool.co.uk

Today we will see how to create a dynamic Reference Line using Parameter in Tableau Desktop.

Data,dataengineering,datatransformation,Deduplication,Snowflake

How to PM

Oct 25, 2022 Peter Hajnal | www.thedataschool.co.uk

At some point in your Client Project you will be asked to be the Project Manager. While I’m pretty sure you heard the term before, in case it’s not quite clear for you what is about when it comes to The Data School, here’s a little intro.

Data,dataengineering,datatransformation,Deduplication,Snowflake

How to Fail Gracefully

Oct 25, 2022 Diaraye Barry | www.thedataschool.co.uk

How to fail successfully on your Alteryx certification exam.

Data,dataengineering,datatransformation,Deduplication,Snowflake

Glasgow City Council - Accessibility - Dashboard Week

Oct 25, 2022 Beau Foletti | www.thedataschool.co.uk

The first day of our dashboard week was looking at accessibility. We were tasked to choose a specific type of design to accommodate for people who struggle to use dashboards. This could be universal or inclusive design…

Data,dataengineering,datatransformation,Deduplication,Snowflake

Dashboard week: day 1

Oct 25, 2022 Peter Hajnal | www.thedataschool.co.uk

Day one is over for our dashboard week. We’ve been tasked to make accessible dashboards for people with disabilities. We had the choice to decide what kind of disability are we focusing on.

Data,dataengineering,datatransformation,Deduplication,Snowflake

Dashboard Week Day 1: How to make a dashboard more accessible...

Oct 25, 2022 Bridget Ama Boateng | www.thedataschool.co.uk

What are some reasons why someone might have difficulty interpreting  a tableau dashboard?

Data,dataengineering,datatransformation,Deduplication,Snowflake

Dashboard Week Day 1: Accessibility

Oct 25, 2022 Nermine Obeng | www.thedataschool.co.uk

For the first day of dashboard week, we had to make a dashboard that meets accessibility requirements. I aimed to create a dashboard focused on universal design so that it would be accessible to as many people as possible. However, I did want to e...

Data,dataengineering,datatransformation,Deduplication,Snowflake

Dashboard Week- Accessibility

Oct 25, 2022 Ana-Casiana Tarita | www.thedataschool.co.uk

Today our task was to create an accessibility dashboard with data related to Road Constructions in Glasgow.

Data,dataengineering,datatransformation,Deduplication,Snowflake

Circle Time Line Chart

Oct 25, 2022 Sundus Jamaal | www.thedataschool.co.uk

Step 1: create a 0 min line to get your time line

Data,dataengineering,datatransformation,Deduplication,Snowflake

An Introduction of Snowflake Semantics

Oct 25, 2022 Zachary Ryan | www.thedataschool.co.uk

With Snowflake being one of the services you’ll look at in the DS beside Alteryx and Tableau, I thought it’d be worthwhile to inform the people of some of the more basic prompts used on the service. Take a look!

Data,dataengineering,datatransformation,Deduplication,Snowflake

Alteryx Core exam tips

Oct 25, 2022 Sundus Jamaal | www.thedataschool.co.uk

What does it take to pass the Alteryx exam?

Data,dataengineering,datatransformation,Deduplication,Snowflake

Data Deduplication Methods in Snowflake

Oct 25, 2022 Chris Hastie | interworks.com

We’ve all seen situations where, for whatever reason, we have more data than we need in a table and we want to deduplicate. There are plenty of reasons for this, from dodgy ingestion processes to deliberate intent. Without diving into the “why” of...

Data,dataengineering,datatransformation,Deduplication,Snowflake

#MakeoverMonday Week 43 - How have Major League Baseball Pitch Types Cha...

Oct 24, 2022 VizWiz (noreply@blogger.com) | www.vizwiz.com

This week’s data set was pretty simple. We had 21 baseball seasons and a column for each pitch type. Pivoting the metrics made it much easier to work with for me as I could then split the view by pitch type.During #WatchMeViz (below), I create a t...

baseball,change,color,comparison,customnumberformat,group,levelofdetail,LOD,MakeoverMonday,MLB,pitching,pivot,setaction,sets,sparklines,tableau,trellischart,WatchMeViz

What did it take to get into DS35?

Oct 24, 2022 Robbin Vernooij | www.thedataschool.co.uk

DS35 are only 2 weeks into in their 4 month training period, so it’s a great time to look at what it took for them to get into The Data School.

Data,DynamicZones,parameters,Tableau,TipsandTricks

The most important information might not be in your dataset

Oct 24, 2022 Flavio Matos | www.thedataschool.co.uk

Have you heard about the Survivorship bias? The most important information might not be in your dataset.

Data,DynamicZones,parameters,Tableau,TipsandTricks

Measure Values and Measure Names

Oct 24, 2022 Tara Robinson | www.thedataschool.co.uk

Measure Values and Measure Names what they are. This blog shows an example where they might be used.

Data,DynamicZones,parameters,Tableau,TipsandTricks

Advanced Table Calculations: Top 3 States within each Region

Oct 24, 2022 Gerda Staurylaite | www.thedataschool.co.uk

Here’s how to calculate top 3 states by sales within each region. However, this can be used in any calculation you might want to create! So, here’s how to!

Data,DynamicZones,parameters,Tableau,TipsandTricks

Dynamic Zones in Tableau (or Hide and Show via Parameter)

Oct 24, 2022 Sebastian Deptalla | interworks.com

When Tableau version 2022.3 was released, expectations for new features were quite low in the Tableau community. There were a lot of improvements for server and data related issues; but for the visual side of everything, the system enhancements ap...

Data,DynamicZones,parameters,Tableau,TipsandTricks

Can you use Tableau to estimate Aaron Judge’s home run trajectories?

Oct 23, 2022 Donna Coles | donnacoles.home.blog

It’s community month still for #WOW2022, and this week saw Samuel Epley set this challenge to visualise the home run trajectories of Aaron Judge. I had a little mini-break to Rome this week, so was hoping I was going to be able to get this week’s ...

My first time as Project Manager

Oct 22, 2022 Angelica Obi | www.thedataschool.co.uk

My first time as Project Manager

Quick LOD

Oct 21, 2022 Yana Arkhipenka | www.thedataschool.co.uk

During TTT LOD training preparation I’ve learned about quick way to create Fixed LOD. There is a great way to start with Fixed LODs as it gives  a clear picture on what are you doing or going to do.

LODs in a shellnut

Oct 21, 2022 Zachary Ryan | www.thedataschool.co.uk

Here’s how I’ve broken down LODs to a point that I understand them more (I think?) when using them in calculations on Tableau.

How To: Find Second Value in a Date Range

Oct 20, 2022 Gerda Staurylaite | www.thedataschool.co.uk

Find out here on how to find a second value in a date range.

Flattening a JSON file in Snowflake

Oct 20, 2022 Gerda Staurylaite | www.thedataschool.co.uk

Here’s how you can learn how to flatten a json file in Snowflake!

Filled shape chart in Tableau

Oct 20, 2022 Nhung Le | www.thedataschool.co.uk

In a visualization, I played around with filled shape charts. I want to explain inflation in a simple way: with the impact of inflation, you can buy less through time, paying the same amount of money.

Easy Sunburst Donut Chat in Tableau using Map Layer

Oct 20, 2022 Nhung Le | www.thedataschool.co.uk

Today’s blog show you how to create an advanced pie chart – sunburst donut chart using Map Layer. This way you do not need to work with floating element on your dashboard and you need only one worksheet.

Cohort Analysis with a Common Baseline

Oct 20, 2022 Gerda Staurylaite | www.thedataschool.co.uk

Let’s have a look as to why cohort analysis is useful when making analysis

Alteryx Core Exam: What to Expect!

Oct 20, 2022 Gerda Staurylaite | www.thedataschool.co.uk

Introduction about what to expect in Alteryx Core exam

The Joy of Select

Oct 19, 2022 Diaraye Barry | www.thedataschool.co.uk

In this blog I am going to be covering all the amazing things you can achieve using the Select tool in Alteryx.

TableauGeneralKnowledge

Plan your approach

Oct 19, 2022 Tara Robinson | www.thedataschool.co.uk

The last few days I have been working with Alteryx. This is a new software for me and the problem I have found is that I tried to dive into the task before actually knowing what I was actually being asked to do. This goes through a challenge and h...

TableauGeneralKnowledge

Pivoting in Alteryx

Oct 19, 2022 Edward Gay | www.thedataschool.co.uk

Alteryx has two pivoting tools: transpose and cross tab. Here is a quick guide on how to use them.

TableauGeneralKnowledge