My First KPI Dashboard: IT Help Desk

Oct 19, 2022 Elaine Yuan | www.thedataschool.co.uk

Last Friday, I created my first KPI dashboard at the Data School. Our cohort of eight was divided into pairs and each pair was given the same dataset to individually design a KPI dashboard. The datasets were diverse; there was data for Customer Se...

TableauGeneralKnowledge

Intro to LODs

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

A brief introduction to Level of Detail Expressions.

Changing Column Headers the Easy Way

Oct 19, 2022 Tanya Fischer | www.thedataschool.co.uk

Creating tables can be a pain in Tableau but even though one of the main purposes of Tableau is to leave tables behind you will now and then still find yourself creating them at least as part of your dashboard.

TableauGeneralKnowledge

How to Tableau: Number Formatting

Oct 19, 2022 Eric Parker | onenumber.biz

Have you ever spent waaaaay too long trying to format a number in Tableau? Did you ever change a number format but see no change in your worksheet? These little things can be maddening!

TableauGeneralKnowledge

Understanding Tableau Accelerators

Oct 19, 2022 Ben Calder | interworks.com

Out of the many new features launched in the Tableau ecosystem this year, I am particularly interested in the efforts surrounding Tableau Accelerators. Earlier this year, I attended a talk on Tableau Accelerators led by Nicolas Oury and John Demby...

Data,Dashboard,Tableau,TableauAccelerators

OKC Thunder Reunites the OKC Tableau User Group

Oct 19, 2022 Garrett Sauls | interworks.com

About two weeks ago, the Oklahoma City Thunder hosted the first meeting of the Oklahoma City Tableau User Group in nearly three years! Like many other user groups, regular meetings were put on hold during the bulk of the COVID pandemic. The recent...

Data,OKC,Oklahoma,Tableau,TableauUserGroup,Thunder,TUG

tall and thin data - transposing in alteryx

Oct 18, 2022 Stephen Moyse | www.thedataschool.co.uk

What kind of dataset do we want?

Data,architectures,data,models,practices,processes,Repositories,terms

Week 3: Alteryx - Road to core certification

Oct 18, 2022 Shahbaz Khan | www.thedataschool.co.uk

Its week 3 of our data school and this week is focused on Alteryx with Friday booked out on the calendar as ‘Alteryx core cert’. As you can imagine the thought of the ‘exam’ looms large but I just wanted to write this blog documenting the week for...

Data,architectures,data,models,practices,processes,Repositories,terms

The one with Pivot

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

Click here and learn how to pivot your data using Transpose and Cross Tab tools on Alteryx.

Data,architectures,data,models,practices,processes,Repositories,terms

The difference between Transpose and Cross-Tab tools in Alteryx

Oct 18, 2022 Keren Aharon | www.thedataschool.co.uk

The transpose and cross-tab tools are two pivoting tools found in the transform menu in Alteryx. Pivoting data allows you to rearrange columns or rows in your dataset in order to view your data from a different perspective.

Data,architectures,data,models,practices,processes,Repositories,terms

The difference between Cross tab and Transpose

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

This blog will be focusing on the difference between Cross Tab and Transpose tool and to look at the practical applications in where and when these tools should be used. Cross Tab and Transpose are considered opposites.

Data,architectures,data,models,practices,processes,Repositories,terms

The Importance of Planning Your Data Prep

Oct 18, 2022 Eamonn Woodham | www.thedataschool.co.uk

Like most tasks, taking the time to plan out your goals and steps is extremely helpful when cleaning and working with data. Knowing exactly how you will achieve your goal before you start allows you to be much more prepared and prevents you from r...

Data,architectures,data,models,practices,processes,Repositories,terms

How to remove the highlighting action on Tableau Desktop

Oct 18, 2022 Ben Winsey | www.thedataschool.co.uk

How to remove the highlight action on your Tableau worksheet and dashboard.

Data,architectures,data,models,practices,processes,Repositories,terms

How to calculate a moving average in Alteryx.

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

In this blog we are going to be looking at calculating a moving average using the Multi-Row Formula.

Data,architectures,data,models,practices,processes,Repositories,terms

An Alteryx Challenge Walkthrough

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

In preparation for our Alteryx designer core test on Friday, DS35 have been working through Alteryx challenges. Here is a walkthrough of one of those challenges.

Data,architectures,data,models,practices,processes,Repositories,terms

Data What? Knowing Your Data Terms

Oct 18, 2022 Karl Young | interworks.com

It’s kind of hard keeping track of terms in the world of data. It seems like every time you turn around, there’s a new concept, idea, implementation, tool or even argument about data. To contribute to the confusion, each and every idea is given a…...

Data,architectures,data,models,practices,processes,Repositories,terms

#MakeoverMonday 2022 Week 42 - Food & Drug Administration Inspections in...

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

Having looked at the original visualization this week (here), it was pretty clear to me that the creators desired to create a KPI style dashboard. In a way it’s good that I picked up on it that way. However, it wasn’t designed particularly uclarly...

BAN,barchart,drilldown,FDA,filteraction,group,highlightaction,inspections,interactive,kpidashboard,livestream,MakeoverMonday,set,setaction,sparkline,tableau,timeseries,WatchMeViz

The differences between Tableau server and Tableau Cloud

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

Firstly lets define what tableau server and tableau cloud:

data-engineering,modern-data-stack,snowflake,dbt,snowpark

SQL: Tab Commands

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

Uploading a dashboard onto tableau server using tab commands.

data-engineering,modern-data-stack,snowflake,dbt,snowpark

Ingestions in DBT: How to Load Data from REST APIs with Snowpark

Oct 17, 2022 Tamas Foldi | medium.com

We all know the status quo in the modern data stack: Ingestion tools for ingestions and transformation tools for transformations. Use Fivetran, Airbyte or Meltano to get the data in, then run dbt models to transform them. But do we always need ing...

data-engineering,modern-data-stack,snowflake,dbt,snowpark

Using “Set Rankings” Instead of Table Calculations (Guest Post from Kasi...

Oct 17, 2022 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 This is a guest blog post is from our regular contributor, Kasia Gasiewska-Holc. Based in Poland, Kasia works remotely as a Senior Data Analyst and data visualization consultant at SageData, a data analytics company based in Berlin. S...

How-To,Tableau

How to Use Show/Hide Buttons in Tableau Dashboards

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

Show/Hide buttons in Tableau allow you to do just that, show or hide containers, worksheets, blanks, text, legends, even the title. You can now hide ANY object on a dashboard.One of my favorite use case is adding a show/hide buttons for a filters ...

augmented-analytics,machine-learning,ai,data-science,nlg

What I wish I knew a year ago…

Oct 14, 2022 Annie Casey | www.thedataschool.co.uk

The first two weeks at DSNY included a lot of content that made me say “damn, I wish I knew that a year ago…” most of which were small steps or shortcuts that vastly improved quality of life in Tableau. Ann made a great point: unless you were prop...

data-engineering,vscode,programming,python,extension

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

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

Skeptical, yet hopeful. Those were the emotions I’ve felt when I first attended the meet-and-greet back at March of this year. The moment I gazed upon the tall Manhattan building to attend the panel, my first thought was, how daunting it felt. Goi...

data-engineering,vscode,programming,python,extension

SQL

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

The basics of SQL

data-engineering,vscode,programming,python,extension

5 Underrated VS Code Extensions You’ll Love as a Data Engineer

Oct 14, 2022 Anjan Banerjee | medium.com

Photo by DerHexer on Wikimedia CommonsVS Code is one of my favorite tools, and with some well-chosen extensions, it becomes even more powerful. VS Code provides a lightweight, powerful and customizable work environment. This enables you to quickly...

data-engineering,vscode,programming,python,extension

Let’s Talk Design Principles

Oct 14, 2022 Baylee Field | interworks.com

There is a plethora of elements that go into a successful dashboard. Organizing these elements can be incredibly intimidating. So, how can we make the design process easy to understand and implement? What Are Design Principles? Why Are They Import...

Data,Dashboarding,design,Tableau,UX

what I would have done differently in my application dashboards

Oct 13, 2022 Stephen Moyse | www.thedataschool.co.uk

First and foremost, if it hasn’t been said already, do not make BANs just a raw text box - you should definitely link them to the data with actual values (I definitely didn’t do this).

augmented-analytics,machine-learning,ai,data-science,nlg

What is a Join? Which one do I use?

Oct 13, 2022 Juliet Craig | www.thedataschool.co.uk

In the data world, a join is when two or more separate tables are combined based on matching identifiers. This can be useful when you have data across multiple tables; that you want to visualize together. Today, we are going to use Tableau Prep Bu...

augmented-analytics,machine-learning,ai,data-science,nlg

What I would do differently in my application

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

Two things I would do differently for my data school application dashboard.

augmented-analytics,machine-learning,ai,data-science,nlg

Waffling About Squirrels 🐿️

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

Happy first two weeks of the Data School! For today’s blog, I’m going to go over a prominent part of my application: a waffle chart with squirrels.

augmented-analytics,machine-learning,ai,data-science,nlg

Two things I would change about my original application!

Oct 13, 2022 Keren Aharon | www.thedataschool.co.uk

Changing tooltip colours based on conditions. One thing I wish I knew during my initial application was how to manually change the colour within the tooltip for certain variables so if the number is above a certain value it shows green and if it d...

augmented-analytics,machine-learning,ai,data-science,nlg

Two things I would change about my First Application

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

This week we started doing Tableau. After two sessions I realized there was so much more I could do for my application. I learnt a lot more then I knew before. This article will be looking particularly at two things.

augmented-analytics,machine-learning,ai,data-science,nlg

I wish I knew these 2 things before applying to The Data School

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

Today we will learn how to create a Set and use colour-code in your worksheets.

augmented-analytics,machine-learning,ai,data-science,nlg

How to highlight the highest and lowest points of a line chart using LODs.

Oct 13, 2022 Sophie Higson | www.thedataschool.co.uk

Spark lines showing the minimum and maximum values highlighted.

augmented-analytics,machine-learning,ai,data-science,nlg

How to Make the Client Experience Feel Like a Walk in the Park

Oct 13, 2022 Mohammed Uddin | www.thedataschool.co.uk

It’s hard learning something new for the first time. Trust me, I’m trying to figure out how to navigate Tableau Prep without my head exploding. Your immediate confusion turns to anxiety; which turns to anger, and finally all that leads to abdicati...

augmented-analytics,machine-learning,ai,data-science,nlg

Filling in the gaps - what i wish i knew about Tableau

Oct 13, 2022 Shahbaz Khan | www.thedataschool.co.uk

So its been awhile since my last post and I wanted to update what I’ve been up to since then. We’re coming to the end of week 2 of the data school now and having completed 2 days of tableau training, I wanted to spend some time looking back at wha...

augmented-analytics,machine-learning,ai,data-science,nlg

Blogs.

Oct 13, 2022 Erlina Cahyadi | www.thedataschool.co.uk

What are they for? Are they resources for us to look back on? Resources for others to use? A space for individuals to talk about their day or experiences? How did they start? Who wrote the first blog? So many questions.

augmented-analytics,machine-learning,ai,data-science,nlg

Application v2.0

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

Here are a couple things I learnt that I wish I knew about Tableau before applying to The Data School.

augmented-analytics,machine-learning,ai,data-science,nlg

2 Things I Would Change on my Original Application Viz

Oct 13, 2022 Eamonn Woodham | www.thedataschool.co.uk

Using Sets: Looking back at my original Viz one of the glaring problems I see now is the colours, I used far too many for the whole viz and for this graph I chose to use very obscure colours for each individual console which lead to a confusing an...

augmented-analytics,machine-learning,ai,data-science,nlg

Learning to Stop Worrying and Augment Your Analytics

Oct 13, 2022 Zsolt Palmai | medium.com

I don’t think about memes a lot — or much of them — but lately this one has been on my mind:Some wording may have been changed to avoid having to label this post NSFW.We have billionaires taking joyrides to space, and yet we keep manually updating...

augmented-analytics,machine-learning,ai,data-science,nlg

Can you do YoY comparisons?

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

Community month for the #WOW2022 team continued this week, with Liam Huffman setting this challenge to build a year on year comparison chart with twist. Typically when building YoY charts you compare the month from last year with the same month th...

Ethics and Data

Oct 12, 2022 Lyon Abido | www.thedataschool.co.uk

Data ethics centers on how institutions interact with data that is sensitive and whether data is being used in service or in harm to individuals, groups or other institutions. The operations, decision making and implications of how data is generat...

TableauGeneralKnowledge

Before & After: Viz in Tooltip

Oct 12, 2022 Elaine Yuan | www.thedataschool.co.uk

My favorite feature of Tableau is undoubtedly the tooltip. My first understanding of the power of the tooltip was the ability to add a visualization in the tooltip. By hovering over a visualization, the user can examine the data with greater detail.

TableauGeneralKnowledge

How to Tableau: Measure Names & Measure Values

Oct 12, 2022 Ollie Linley | onenumber.biz

Measure Names and Measure Values - they seem to be everywhere! In your data pane, appearing magically when building certain graphs and views… But what exactly are they for?

TableauGeneralKnowledge