Week 1 - DS31: Excitement, anxiousness, learning, and tips

Apr 8, 2022 Algirdas Grajauskas | www.thedataschool.co.uk

The first week of data school just flew by. First day introductions can beawkward and cause nervousness but fret not as it all passes very fast and thefeeling of comfort takes over. Starting with your other cohort who are veryinviting and quick to...

Data,cloud,enterprise,hockey,KPIs,scorecards,Snowflake

So it begins

Apr 8, 2022 Tom Stinson | www.thedataschool.co.uk

Week 1 ended with DS31 remaking our original application dashboard using skillslearned during the first week. Returning to the original dashboard data was abit of a shock, and trying to decipher what I had done two months ago even more.Using Alter...

Data,cloud,enterprise,hockey,KPIs,scorecards,Snowflake

Joining tables in Alteryx and Tableau Prep

Apr 8, 2022 Dorinna Pentchev | www.thedataschool.co.uk

During DS31’s first week of training, we learnt how to join tables of datatogether in Alteryx and Tableau Prep, which is very useful if you would like toinclude additional information about records but the corresponding data is in adifferent data ...

Data,cloud,enterprise,hockey,KPIs,scorecards,Snowflake

HOW TO CHANGE SHAPES IN TABLEAU DESKTOP

Apr 8, 2022 Romina Wiechern | www.thedataschool.co.uk

Sometimes it is nice to show not just the labels and the values on a dashboardor in a chart, but to make it more visual for the viewer. For that you canchange shapes in Tableau.

Data,cloud,enterprise,hockey,KPIs,scorecards,Snowflake

First Week- Introduction to Everything

Apr 8, 2022 Edward Sinclair-Hughes | www.thedataschool.co.uk

Starting a new job is like a box of chocolates…

Data,cloud,enterprise,hockey,KPIs,scorecards,Snowflake

DS31 Training Blog: Week 1

Apr 8, 2022 Thanoshaan Thayalan | www.thedataschool.co.uk

The first week of any job can be quite a daunting prospect but the introductionto The Information Lab and the Data School was extremely pleasant. A lot ofinformation is passed down to you immediately but the attitude and environmentaround the comp...

Data,cloud,enterprise,hockey,KPIs,scorecards,Snowflake

Quick Insights with Enterprise Cloud Scorecards

Apr 8, 2022 Linus Tse | interworks.com

Why do some businesses fail while others succeed? What are the factors that determine their outcome? Answering questions like these is why I’ve chosen a career as an Analytics Consultant. I’ve always been fascinated to learn what drives business o...

Data,cloud,enterprise,hockey,KPIs,scorecards,Snowflake

Eine Einführung in die Zeitreihenanalyse mit Alteryx am Beispiel des S&P...

Apr 7, 2022 Robin von Malottki | www.thedataschool.co.uk

Was haben die Finanzwirtschaft, die Ökonomie, Meteorologie und die Polemologiegemeinsam? Börsenkurse, Arbeitslosenquoten, Temperaturentwicklungen undDyadische Konflikte lassen sich allesamt mithilfe von Zeitreihen analysieren.Ein Ziel der Zeitreih...

Data,2D,circleobject,geospatial,Snowflake

How to Validate Join Results in Tableau Desktop

Apr 7, 2022 Eric Parker | onenumber.biz

When joining two tables in Tableau, have you ever wondered any of the following questions?

Data

Create 2D Circle Objects on a Flat Plane in Snowflake

Apr 7, 2022 Chris Hastie | interworks.com

Ever wondered how to create a circle object on a two-dimensional plane in Snowflake? Among others, here are a few reasons that you may wish to do this: Depicting socially distanced locations on a floorplan Displaying the range or “trade area” from...

Data,2D,circleobject,geospatial,Snowflake

Can you track headcount?

Apr 7, 2022 Donna Coles | donnacoles.home.blog

Luke decided to set us a challenge this week based on Human Resources (HR) data, using a dataset provided as part of the #RWFD Real World Fake Data project managed by Mark Bradbourne. The challenge focussed on reporting monthly headcount, using a ...

IF statements

Apr 6, 2022 Skomantas Tamulaitis | www.thedataschool.co.uk

IF is the main logical function in Tableau and a complete IF function is oftencalled an IF statement. Within any IF statement there are usually at least 3other functions: THEN, ELSE, and END. These functions split up the IF statementin different p...

Data

SAP: what’s the difference between the merchandise category hierarchy an...

Apr 6, 2022 Gwilym | gwilymlockwood.com

I’ve been working with product classification in SAP recently, and something that comes up a lot is the difference between the merchandise category hierarchy and the article hierarchy. Both can be used for showing hierarchies and reporting, so wha...

Uncategorized,data

How to Always Sort a Dimension to the Bottom of a Chart

Apr 5, 2022 VizWiz (noreply@blogger.com) | www.vizwiz.com

In this tip, I show you how to use a calculated field to always sort a specific dimension to the bottom of a chart. You can also always have a dimension at the top, you simply change the sort from Descending to Ascending. This also works with colu...

ascending,barchart,calculatedfield,chart,comparison,context,descending,dimension,graph,group,highlight,howto,negative,sort,sorting,tableau,tip,tutorial

Using Alteryx Macros to cooperate more effectively at Data Preparation

Apr 5, 2022 Frederik Egervari | www.thedataschool.co.uk

Lately, we, in DSDE2 had our first projects where we had to work as a wholegroup of eight to analyze data. Thereby a major task is coordinating how to workwith each other, to distribute the work most effectively and achieve the bestresults.

Data,2022.1,newfeature,Tableau,ViewData

Tableau Basics: Creating a Bar-in-Bar Chart

Apr 5, 2022 Megan Coutts | www.thedataschool.co.uk

This blog post will provide a step-by-step tutorial on how to create abar-in-bar chart, so you can give it a go for yourself in Tableau! But first,let’s look at why this chart type is useful:

Data,answer,hierarchy,liveboards,search,SpotlightonThoughtSpot

Splitting strings in Alteryx: RegEx

Apr 5, 2022 Caitlin Walsh | www.thedataschool.co.uk

The RegEx tool in Alteryx can be used to parse different parts of a text string and create new columns for them.Here, I work through one such example.

Data,answer,hierarchy,liveboards,search,SpotlightonThoughtSpot

Data School Roundup - March 28 to April 3, 2022

Apr 5, 2022 Ann Jackson | www.thedataschool.co.uk

We had a TON of blog posts this week, due to DS28 and their continued work onDashboard Week.  You can find Day 1 in last week’s round up, and the other 4 arehere.  This signifies the completion of their time in training, so a hugecongratulations t...

Data,answer,hierarchy,liveboards,search,SpotlightonThoughtSpot

Comparing years: Bar + Gantt

Apr 5, 2022 Fergus Smith | www.thedataschool.co.uk

In this blog I will show you how to create a bar chart showing the current year of a measure (Sales) and then how to create Gantt lines overlaying the bar chart showing the figures from the year before.

Data,answer,hierarchy,liveboards,search,SpotlightonThoughtSpot

Spotlight on ThoughtSpot: Hierarchy of Process

Apr 5, 2022 Karl Riddett | interworks.com

Welcome to part two of our opening ThoughtSpot blog series at InterWorks! If you missed the first post, that’s the best place to start. Now that you’re all caught up, I’d like to take time today to review the ThoughtSpot “hierarchy of things” as I...

Data,answer,hierarchy,liveboards,search,SpotlightonThoughtSpot

Tableau 2022.1: Overview of our Top New Features

Apr 4, 2022 Sophie Sparkes | www.theinformationlab.co.uk

Tableau 2022.1 is here! While there are many great features in this version, our top three are: Workbook Optimiser, Customise View Data and New AcceleratorsThe post Tableau 2022.1: Overview of our Top New Features appeared first on The Information...

Blog,News,Tableau,TableauLaunch

Kennst du schon den eisernen Bestand?

Apr 4, 2022 Robin von Malottki | www.thedataschool.co.uk

Der eiserne Bestand ist eine Kennzahl aus dem Einkauf und gibt eineSicherheitsmenge an, die nicht unterschritten werden sollte. Reduziert sich dieverfügbare Menge auf den eisernen Bestand, sollte man spätestens eine Bestellungaufgeben (Wenn nicht ...

Data,2022.1,newfeature,Tableau,ViewData

Fuzzy Matching in Alteryx

Apr 4, 2022 Frederik Egervari | www.thedataschool.co.uk

The Fuzzy Match Tool in Alteryx can be a very powerful tool when you try tomatch two data streams but the matching condition is not always met hundredpercent and therefore a join doesn’t work. With Fuzzy Matching it is possible tofind matches that...

Data,2022.1,newfeature,Tableau,ViewData

Eine schrittweise Anleitung für eine explorative Datenanalyse mit Alteryx

Apr 4, 2022 Robin von Malottki | www.thedataschool.co.uk

In diesem Blog möchte ich schrittweise erklären, wie man eine explorativeDatenanalyse durchführen kann. Dafür benutze ich einerseits den bekanntenTitanic-Datensatz. Diesen kann man hier[https://public.tableau.com/en-us/s/resources?qt-overview_reso...

Data,2022.1,newfeature,Tableau,ViewData

DRILL-DOWN-ACTION

Apr 4, 2022 Romina Wiechern | www.thedataschool.co.uk

Seitdem ich die Funktion des Drill-Down-Charts beziehungsweise den Weg dahingelernt habe, benutze ich es in fast jeder Präsentation. Es ist meiner Meinungnach ein eleganter Weg viele und detailreiche Informationen auf ein Dashboard zubringen, ohne...

Data,2022.1,newfeature,Tableau,ViewData

Tableau 2022.1 Closer Look: View Data

Apr 4, 2022 Sebastian Deptalla | interworks.com

Behold! An old and rusty feature in Tableau shines in a new light and got a major upgrade! Tableau version 2022.1 has been released, and with it come a lot of things to make our lives as Tableau developers easier. My colleague Rowan shared an…The ...

Data,2022.1,newfeature,Tableau,ViewData

Is colour really THAT important?

Apr 3, 2022 Megan Coutts | www.thedataschool.co.uk

Now when you think about data analysis, I’m probably right in assuming thatcolour is not the first thing to pop into your head, with many other factorstending to take precedence over such a concept. However, within the realm ofdata visualisation, ...

InterWorks Blog Roundup – March 2022

Apr 2, 2022 Mark Cordeiro | interworks.com

One quarter down, three more to go! InterWorks has had a busy and exciting quarter, and we hope yours was just as productive. If you want to gain a bit more momentum, maybe one of our new resources will help. We’ve had posts go up…The post InterWo...

News,BlogRoundup,Dataiku,March,Neuron,Tableau

Using a dummy variable to highlight the worksheet/dashboard

Apr 1, 2022 Nhung Le | www.thedataschool.co.uk

Actions are often used when creating a worksheet or dashboard. But often it isthe case that when you have your action done and click on that, it highlightedonly what you click on and blended other values in the background. Today I willshow you a t...

data-visualization,data-science,augmented-analytics,dashboard,artificial-intelligence

USA Interstate Traffic - Dashboard Week Final Day

Apr 1, 2022 Jacob Kilroy | www.thedataschool.co.uk

Final day of dashboard week saw us visualizing US Interstate Traffic Data

data-visualization,data-science,augmented-analytics,dashboard,artificial-intelligence

Dashboard Week Day 5 - US Highway Traffic

Apr 1, 2022 Alfred Chan | www.thedataschool.co.uk

Last day of the dashboard week, we are looking at USA highway traffic data, and we had 3 hours to do all the stuff…

data-visualization,data-science,augmented-analytics,dashboard,artificial-intelligence

Dashboard Week Day 5 - Traffic Reports

Apr 1, 2022 James Driver | www.thedataschool.co.uk

For todays challenge we were tasked with creating a dashboard around the trafficdata collected in the US in November 2015. The data was a bit messy and requireda join, but the prep stage didn’t take too long.

data-visualization,data-science,augmented-analytics,dashboard,artificial-intelligence

As We May See: The World after Dashboards

Apr 1, 2022 Chris von Csefalvay | medium.com

In 1945, influential scientist and government advisor Vannevar Bush published As We May Think, an article of remarkable foresight. In less than a dozen pages, he outlined many futuristic technologies that have come to pass, including hypertext, th...

data-visualization,data-science,augmented-analytics,dashboard,artificial-intelligence

How to Ingest Excel Files with Dynamic Sheet Names Using Matillion

Apr 1, 2022 Chris Hastie | interworks.com

If you ever want to ingest data from an Excel file into Snowflake using Matillion, you can do so with the Excel Query component. If you know the name of the sheet you want to ingest, you can simply enter the name into the component and…The post Ho...

Data,Excel,ingest,Matillion,Snowflake

#B2VB 2022/W3 - Olympic Medal Tracker

Mar 31, 2022 VizWiz (noreply@blogger.com) | www.vizwiz.com

If you’re not participating in the Back to Viz Basics community project yet, you should be. It’s all about creating effective, simple charts, which is exactly what you need to be able to do before you build anything fancy. This will definitely hel...

b2vb,basics,color,containers,dashboard,datavisualization,filter,heatmap,howto,medals,Olympics,parameter,sort,table,tableau,text,tips,tutorial,WatchMeViz

Meet the Team: Benedetta Tagliaferri, Head of Consultant Support

Mar 31, 2022 Sophie Sparkes | www.theinformationlab.co.uk

Get to know a bit more about the team working at The Information Lab! Benedetta’s solid analytical background and flair for design mean that she is perfectly placed to help non-profits drive social change by making sense of their data. In her own ...

Blog,MeettheTeam

Webscraping London Marathon Results - Dashboard Week Day 4

Mar 31, 2022 Jacob Kilroy | www.thedataschool.co.uk

Day 4 of Dashboard week had us webscrape the London Marathon Results.

Data,2022.1,newfeatures,Tableau,ViewAccelerator,workbookoptimizer

Kennst du schon die Churn Rate?

Mar 31, 2022 Robin von Malottki | www.thedataschool.co.uk

Die Churn Rate (dt. Abwanderungsquote) oder auch Attrition Rate (dt.Fluktuationsrate) ist eine Kennzahl aus dem Vertrieb, die als Indikator für dieKundenzufriedenheit herangezogen wird. Sie misst, wie hoch der Anteil der Kundenist, die innerhalb e...

Data,2022.1,newfeatures,Tableau,ViewAccelerator,workbookoptimizer

Dashboard week Day 4 Web scraping

Mar 31, 2022 Tulsi Majithia | www.thedataschool.co.uk

Today’s Objective was we needed to visualize historical results[https://www.tcslondonmarathon.com/results/race-results] of the London Marathon[https://www.virginmoneylondonmarathon.com/].

Data,2022.1,newfeatures,Tableau,ViewAccelerator,workbookoptimizer

Dashboard week | Day 4 | London Marathon

Mar 31, 2022 Gabriela Mitache | www.thedataschool.co.uk

For the fourth day of dashboard week, DS28 had to visualize historical results(between 2014-2021) from the London Marathon.

Data,2022.1,newfeatures,Tableau,ViewAccelerator,workbookoptimizer

Dashboard Week Day London Marathon Data

Mar 31, 2022 James Driver | www.thedataschool.co.uk

For todays challenge we were given a link to the database of the LondonMarathon, with 8 years worth of data to download. This one was tricky as therewas no way of exporting this and it would require web scrapping to retrieve. Thescrapping part pro...

Data,2022.1,newfeatures,Tableau,ViewAccelerator,workbookoptimizer

Dashboard Week - Day 5 - London Marathon Runners

Mar 31, 2022 Katie Matkin | www.thedataschool.co.uk

Today’s task was to analyse London Marathon Runners from 2014-2021 - there’s ofcourse a lot of participants so we had to use the first two letters of oursurname to narrow down the results. You can find the data here https://www.tcslondonmarathon.c...

Data,2022.1,newfeatures,Tableau,ViewAccelerator,workbookoptimizer

Dashboard Week Day 4: London Marathon Historical Results

Mar 31, 2022 Andy Kriebel | www.thedataschool.co.uk

I missed out on the London Marathon ballot again. You can’t find me in the results, but DS28 will be looking for people like themselves. This won’t be easy!

TableauDashboards

Dashboard Week Day 4 - London Marathon

Mar 31, 2022 Alfred Chan | www.thedataschool.co.uk

Day 4 of the dashboard, biggest challenge I have ever had in my DS training.

Data,2022.1,newfeatures,Tableau,ViewAccelerator,workbookoptimizer

Pop a Filter On and Off a Tableau Dashboard

Mar 31, 2022 Eric Parker | onenumber.biz

Want to set up filters or parameters on your Tableau dashboard so they disappear or reappear based on a user selection? I ran into this scenario recently when working with a client. We had a handful of pre-set date ranges a user could select (e.g....

TableauDashboards