Being PM: Let's Chat

Sep 11, 2022 Gerda Staurylaite | www.thedataschool.co.uk

Let’s talk about being a project manager.

(Why) building a chord chart (is probably not a good idea)

Sep 9, 2022 Heinrich Preuß | www.thedataschool.co.uk

After successfully working with the Sankey diagram template in a previous customer project, I wanted to try the next template because I thought the chord diagram looks very nice and fits very well with my use case of showing transit passengers at ...

Data,Alteryx,cloud,data,Review,Trifacta

Penguins Mapbox

Sep 9, 2022 Lauren Halliwell | www.thedataschool.co.uk

I built a heatmap with data on penguins and seals in Antarctica.

Data,Alteryx,cloud,data,Review,Trifacta

My first mapbox

Sep 9, 2022 Angelica Obi | www.thedataschool.co.uk

Mapbox lets you add a layer of detail to your maps. Here’s a before and after of my first mapbox map.

Data,Alteryx,cloud,data,Review,Trifacta

My First Mapbox Map

Sep 9, 2022 Ben Winsey | www.thedataschool.co.uk

A preview of my first Mapbox Map

Data,Alteryx,cloud,data,Review,Trifacta

Mapbox-ing

Sep 9, 2022 Hannah Laughton | www.thedataschool.co.uk

This is my first attempt at using Mapbox!

Data,Alteryx,cloud,data,Review,Trifacta

Jazz Up Maps with Mapbox

Sep 9, 2022 Carol Mhlanga | www.thedataschool.co.uk

Create unique maps using mapbox.

Data,Alteryx,cloud,data,Review,Trifacta

Funnel Chart

Sep 9, 2022 Tram Nguyen | www.thedataschool.co.uk

When I was doing the sales pipeline funnel report, it’s desirable to create a funnel chart to encapsulate the sales pipeline process. This kind of chart also applies to streamlined process such as HR interview process where the number of observati...

Data,Alteryx,cloud,data,Review,Trifacta

Dynamic Sorting: parameters for a customisable view

Sep 9, 2022 Caitlin Walsh | www.thedataschool.co.uk

We can narrow down and sort a view using some parameters and the INDEX() table calculation, instead of using a Top N filter.

Data,Alteryx,cloud,data,Review,Trifacta

Introducing the Tableau Upgrade Feature Tool Dashboard

Sep 9, 2022 Ryan Alexander | interworks.com

Comparing Upgrades for Different Versions of Tableau I’ve built a Tableau dashboard here to help see the new features between your existing Tableau version and potential planned upgrades. It also includes options for Tableau Server, Desktop, Mobil...

Data,Dashboard,Tableau,upgrade,Viz

Alteryx Up in the Clouds

Sep 9, 2022 Robin Schouten | interworks.com

A first look at Alteryx Designer Cloud powered by Trifacta. As an Alteryx (Designer) user like me, you have probably heard of Alteryx Designer Cloud powered by Trifacta. If you want to know more about Alteryx Designer Cloud and how it compares to ...

Data,Alteryx,cloud,data,Review,Trifacta

Let’s build a Marrimeko Chart!

Sep 9, 2022 Donna Coles | donnacoles.home.blog

Sean set the challenge this week and went retro, revisiting a challenge from 2017 originally set by Emma Whyte to build a Marrimeko chart. Hang on… a what chart? Marrimeko…??? A good place to understand what a Marrimeko chart actually is, is this ...

Why aren't I seeing all my data in Tableau Prep?

Sep 8, 2022 Eric Parker | onenumber.biz

Tableau Prep is a powerful tool for cleaning and shaping data. One of its weaknesses is that it can be slow on a desktop computer. There are a number of reasons for that (computer memory limitations, size of data source, complexity of steps, etc.)...

TableauPrep

Tableau Relationships: Performance – Breaking the Cardinality

Sep 8, 2022 Sebastian Deptalla | interworks.com

Let’s go deeper and see what happens when we break the cardinality, or in other words, use it in a way it’s not designed for. Also, it helps to understand everything a bit better. For those looking for more of an introduction to performance, you…T...

Data,cardinality,relationships,Tableau,Tableaurelationships

Alteryx Up in the Clouds

Sep 8, 2022 Robin Schouten | interworks.com

A first look at Alteryx Designer Cloud powered by Trifacta. As an Alteryx (Designer) user like me, you have probably heard of Alteryx Designer Cloud powered by Trifacta. If you want to know more about Alteryx Designer Cloud and how it compares to ...

Data,Alteryx,AlteryxCloud,AlteryxDesigner,cloud,Trifacta

The Fundamentals of Logical Functions - IF THEN vs. Case

Sep 7, 2022 VizWiz (noreply@blogger.com) | www.vizwiz.com

In this video, I got through several examples of when to use an IIF, IF THEN, or CASE statement in Tableau. I also cover their best use cases, when you have to use one vs. another, and general rules of thumb.While this is demonstrated in Tableau, ...

calculatedfield,calculation,case,formula,howto,ifthen,IIF,logic,logicalfunctions,tableau,tip

Fill NULL values with the value one row above in Tableau Prep

Sep 7, 2022 Ben Mangel | www.thedataschool.co.uk

NO CODING SOLUTION

Data,AI,Dataiku,Event,machinelearning,ML

AI and ML for All: A Look at InterWorks’ Go! Dataiku Webinars

Sep 7, 2022 Carol Prins | interworks.com

Have you wondered how you can venture into the land of data science without being a data scientist? Most of us get intimidated with this idea of writing thousands of lines of code to build a machine learning algorithm. Well, that was true maybe a…...

Data,AI,Dataiku,Event,machinelearning

How To Nail A Data School Final Interview

Sep 6, 2022 joe.stokes | www.theinformationlab.co.uk

Going to interview can be a daunting experience, here Joe Stokes gives us his top tips for a successful Data School interview day.The post How To Nail A Data School Final Interview appeared first on The Information Lab.

Blog,ApplicationProcess,Data,FinalInterview,TableauDesktop

A Definitive Guide to Creating Python UDFs in Snowflake using Snowpark

Sep 6, 2022 Chris Hastie | interworks.com

Snowpark for Python is the name for the new Python functionality integration that Snowflake has recently developed. At the Snowflake Summit in June 2022, Snowpark for Python was officially released into Public Preview, which means anybody is able ...

Data

How to Create a Gradient Area Chart in Tableau (Kizley Benedict)

Sep 6, 2022 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 This week, I’m excited to welcome Kizley Benedict as a guest author. If you’re not already following Kizley on Tableau Public, stop right now and go follow him—I promise you won’t regret it. He has a rare talent for creating well-designed and ins...

How-To,Tableau

#MakeoverMonday 2022 Week 36 - Median Age at First Marriage in America

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

This was a relatively simple data set and I was able to build quite a few vizzes during Watch Me Viz. I ended up with something more complex that it needed to be, but it was fun figuring out how to create the calculations.Here’s how it works:Compa...

age,barchart,color,connectedscatterplot,hexmap,levelofdetail,LOD,MakeoverMonday,marriage,referenceline,scatterplot,tablecalculation,tableau,tadpolechart,USA

Tableau: How to have a different calculation for the Totals

Sep 5, 2022 ali.agah | www.theinformationlab.co.uk

Intro I initially assumed the Total rows in can only show the sum of the values above but turns out they’re a lot more versatile than that! Firstly, you use Total using to change the calculation used for the field (change the header value to refle...

Blog,Advanced,Calculations,TableauDesktop

Mockaroo: How to use it in your advantage

Sep 5, 2022 Ana-Casiana Tarita | www.thedataschool.co.uk

Last week we had the task to create fake data to use in our analysis. Our task was to pick a field ( Real Estate, Healthcare, Marketing etc.), and to create an executive and normal dashboard with our created data from Mockaroo.

Data,data,python,Snowflake,SnowPark

1st Day of the 1st Client project

Sep 5, 2022 Angelica Obi | www.thedataschool.co.uk

And so it begins……

Data,data,python,Snowflake,SnowPark

A Definitive Guide to Snowflake Sessions with Snowpark for Python

Sep 5, 2022 Chris Hastie | interworks.com

Snowpark for Python is the name for the new Python functionality integration that Snowflake has recently developed. At the Snowflake Summit in June 2022, Snowpark for Python was officially released into Public Preview, which means anybody is able ...

Data,python,Snowflake,SnowPark

Mockaroo Basics

Sep 4, 2022 Gerda Staurylaite | www.thedataschool.co.uk

An insight on how to create fake data using Mockaroo.

How to create: Month to Day Drilldown

Sep 4, 2022 Nermine Obeng | www.thedataschool.co.uk

How to create a Month-to-Day drilldown chart.

How To: Drill Down Using Parameter Actions

Sep 4, 2022 Gerda Staurylaite | www.thedataschool.co.uk

A step-by-step guide in how to create a drill down chart using parameter actions.

How To: Comparison Selected with Set Actions

Sep 4, 2022 Gerda Staurylaite | www.thedataschool.co.uk

A step-by-step on how to create a comparison chart!

Comparing Join Types

Sep 4, 2022 Jessica Haire | www.thedataschool.co.uk

We’ve come across joins in Tableau, for example, but when we switch tools, it’s important to know that the join types are not always the same. This post will show you the different types of joins you can expect to see across Tableau, Tableau Prep,...

Alteryx Spatial: Create Points & Poly-Build

Sep 4, 2022 Gerda Staurylaite | www.thedataschool.co.uk

Intro to some of the spatial tools in Alteryx.

Alteryx micro credential worth it?

Sep 3, 2022 Eric Williams | www.thedataschool.co.uk

Joining the data school you are required to get two certifications. The Alteryx Designer core certification and Tableau Data analyst certification.

5 Most Common Date Functions in Tableau

Sep 2, 2022 VizWiz (noreply@blogger.com) | www.vizwiz.com

In this tip, I take you through the 5 most common date functions in Tableau:2022-09-02PART2022-09-02NAME2022-09-02TRUNC2022-09-02ADD2022-09-02DIFFBy the end of this video you will understand when to use them to meet your use case. Click here for t...

add,calculatedfield,compare,datefunctions,dateadd,datediff,datename,datepart,dates,datetrunc,difference,tableau,tip

Learn SQL the Effective Way with Data School New York

Sep 2, 2022 will.sutton | www.theinformationlab.co.uk

By way of introduction, I am Will, this year’s Tableau Iron Viz Champion and a recent addition to the core consultancy team at The Information Lab. I’m a firm believer that good data preparation is key to creating effective data visualisations (so...

Blog,dataprep,DataSchool,Database,DSNY,learnsql,NewYork,SQL

Tableau vs. Power BI

Sep 2, 2022 Heinrich Preuß | www.thedataschool.co.uk

Nun sind wir in unserem Training also in “Vollkontakt” mit dem großen Konkurrenten “unseres” Tableaus gekommen - mit Microsofts Power BI. Es wäre natürlich sehr überraschend, würde dieser Blogeintrag eine Ode an Power BI, die das Tool zum Sieger e...

Data,Curator,Matillion,Snowflake,Tableau,TechnicalTuesday,webinar

Webinar Replay: Redesign the Analytics Experience with Curator

Sep 2, 2022 Ben Bausili | interworks.com

A video replay for this webinar is available at the bottom of the blog. A lot of analytics tools are fantastic at visualizing data, but they don’t really have a good solution for presenting that data in a clean and effective way. That’s where Cura...

Data,Curator,webinar,WebinarReplay

InterWorks Blog Roundup — August 2022

Sep 2, 2022 Mark Cordeiro | interworks.com

Fun trivia fact about August you probably learned at school: the month was named after the Roman Emperor Augustus by, well, himself! Actually, all of the English language month names are carried over from Roman naming conventions. I’m a sucker for...

Data,Curator,Matillion,Snowflake,Tableau,TechnicalTuesday,webinar

Are You Younger Than 50? Then Invest.

Sep 2, 2022 Gavin Holzworth | interworks.com

The Introduction I picked this topic to blog about for two reasons. The most important reason is because it’s one of my biggest hobbies. I love to invest, research companies and explore the data associated with them. These things have always inter...

Data,Dashboard,finance,Investing,Tableau,tableauviz

Part 1 - LODs reimagined Table Calculations

Sep 1, 2022 Ozlem Sigbeku | www.thedataschool.co.uk

Are LODs slowing you down? Here is one example of a LOD reimagined as a table calculation. Ozlem is my name, efficiency is my game.

LODs reimagined Table as Calculations - Part 1

Sep 1, 2022 Ozlem Sigbeku | www.thedataschool.co.uk

Are LODs slowing you down? Here is one example of a LOD reimagined as a table calculation. Ozlem is my name, efficiency is my game.

Data,Curator,Matillion,Snowflake,Tableau,TechnicalTuesday,webinar

How to color table columns distinctly

Sep 1, 2022 John Power | www.thedataschool.co.uk

For this example we will be using the Superstore dataset. Here we have a simple table showing the ‘# of Orders’, ‘Discount’, ‘Profit’, and ‘Sales’ for each month of 2018:

Dynamically displaying a measure value in your Tooltip

Sep 1, 2022 John Power | www.thedataschool.co.uk

So to explain what I mean by this - if you have created a chart that uses a parameter to switch between the measure being displayed, it is important to include a Tooltip that will also update accordingly based on the Parameter.

How to Add Total Labels to Stacked Bar Charts in Tableau

Sep 1, 2022 Eric Parker | onenumber.biz

Have you ever tried to add a label to the end of a stacked bar chart in Tableau? I’m guessing it didn’t work the way you wanted!

Design,TableauGeneralKnowledge

I Have ADHD – Part I: Breaking 5 Myths

Aug 31, 2022 Lindsay Betzendahl | vizzendata.com

Prologue It has taken me 20 years to share this story with such openness and to a potentially large audience.Continue reading

Community,Reflections,ADHD,Healthcare,MentalHealth,Personal