How-to guide on Alteryx Download tool

Jun 10, 2022 Ozlem Sigbeku | www.thedataschool.co.uk

A step by step guide to downloading text from a URL address for word sleuthing. Copy along using URL provided.

crypto,data-engineering,blockchain,web3,cloud-computing

HOW TO USE A SHOW/HIDE BUTTON

Jun 10, 2022 Romina Wiechern | www.thedataschool.co.uk

Of course, there are different ways to use a Show/Hide Button on your dashboard.I want to show you one of them.

crypto,data-engineering,blockchain,web3,cloud-computing

First week project

Jun 10, 2022 Longyan Chen | www.thedataschool.co.uk

Time flies, the first week is done now.

crypto,data-engineering,blockchain,web3,cloud-computing

DS32 Week 1 - What to expect during the first week at the Data School

Jun 10, 2022 Imogen Emmett | www.thedataschool.co.uk

An overview of the first week at the Data SchoolIncluding key tips and takeaways

Data,datastack,datawarehousing,ETL,WhatMakesGoodAnalytics

Common Calculated Field Errors in Tableau

Jun 10, 2022 Kristine Wiesner | www.thedataschool.co.uk

Here are some common calculated field errors one can encounter while starting tolearn Tableau.

crypto,data-engineering,blockchain,web3,cloud-computing

Web3 is Lemons — Go Make Lemonade

Jun 10, 2022 Anjan Banerjee | medium.com

Web3 is Lemons — Go Make LemonadePhoto by Auguste A on UnsplashIt would be a mistake to write off web3 as merely a ploy to sell companies and the public on crypto and NFTs. While digital currencies and (wannabe) art market disruptors have kept muc...

crypto,data-engineering,blockchain,web3,cloud-computing

Reconnecting with Community: Back with a Vengeance

Jun 10, 2022 Jackson Stein | interworks.com

Above all, these COVID years have reinforced the value of in-person engagements. Not only do you have high-value, high-impact conversations, but it is fantastic to see other people and spend time with them. I’m thrilled to have had the opportunity...

Culture,Beyond,culture,recruiting,ThoughtSpot

Prep that and build this!

Jun 10, 2022 Donna Coles | donnacoles.home.blog

It’s a double whammy this week – a #PreppinData & #WOW2022 combo! And I’m going to attempt to blog a solution guide to both! Wish me luck… it may take some time! The #PreppinData & #WOW2022 crew combined with the requirement to prep some S...

Tableau Prep - Correcting Spelling Errors

Jun 9, 2022 Maha Hussari | www.thedataschool.co.uk

The data below has lots of spelling errors:

Data,joins,relationships,sql,Tableau

SQL What is it?

Jun 9, 2022 Algirdas Grajauskas | www.thedataschool.co.uk

SQL is a type of language which is used to manage databases. What does that meanthough?

Data,joins,relationships,sql,Tableau

SQL Scalar Function

Jun 9, 2022 Algirdas Grajauskas | www.thedataschool.co.uk

Continuing from the previous post

Data,joins,relationships,sql,Tableau

Row level security : How to gatekeep the right way

Jun 9, 2022 Charalambos Pavlou | www.thedataschool.co.uk

How to set up row level security on tableau desktop connected to tableau server.

Data,joins,relationships,sql,Tableau

Key features of Tableau Prep

Jun 9, 2022 Reuben Clayman | www.thedataschool.co.uk

My fourth day at the Data School introduced us to Tableau Prep where we learntsome of the key functions, and started getting to grips with this new system.

Data,joins,relationships,sql,Tableau

It's all in the Details

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

Level of Detail calculations (LODs) can be very useful when trying to find and highlight key info in our data. In this example, we can highlight the Latest Month, Prior Month, the Month one year before the Latest, and the First Month in Superstore.

Data,joins,relationships,sql,Tableau

How to add custom colors in Tableau

Jun 9, 2022 John Power | www.thedataschool.co.uk

First off, navigate to your Tableau Repository, right click on ‘Preferences’ andselect ‘Open with’, ‘Notepad’:

Data,joins,relationships,sql,Tableau

Hot 4 Hotkeys

Jun 9, 2022 Marcelo Ramos | www.thedataschool.co.uk

A small-ish list of my favoured hotkeys most people can benefit from, if they don’t utilise them already!

Data,joins,relationships,sql,Tableau

Dashboard Week Project 4: "Global Internet Shutdowns 2021"

Jun 9, 2022 Kristine Wiesner | www.thedataschool.co.uk

Our last dataset for the dashboard week is from #KeepItOn[https://www.accessnow.org/keepiton/#problem] coalition which tracks downinternet shutdowns worldwide.  I have read their report and they have veryinteresting KPIs which I want to emulate in...

Data,joins,relationships,sql,Tableau

Alteryx Weekly Challenge 182 Ultimate Guide

Jun 9, 2022 Ozlem Sigbeku | www.thedataschool.co.uk

How to do Alteryx Weekly Challenge 182. Warning: spoilers.

Data,joins,relationships,sql,Tableau

How to Create Dynamic Labels for Tableau Highlight Tables

Jun 9, 2022 Eric Parker | onenumber.biz

Highlight tables are one of my all-time favorite Tableau visuals. You can pack so much information into a limited space. One of the only weaknesses of highlight tables is that they usually display every label (too cluttered) or no labels (too bare...

Design,TableauCalculations

An In-Depth Look at Using Joins in Analytics

Jun 9, 2022 Sebastian Deptalla | interworks.com

Joins—they are happening everywhere. That’s actually a cool tagline! And it’s definitely true. I haven’t encountered a data warehouse, a data lake or a BI tool that didn’t include some sort of join somewhere.   But I also know there are a lot of e...

Data,joins,relationships,sql,Tableau

What's your type? Is your data type the right one?

Jun 8, 2022 Reuben Clayman | www.thedataschool.co.uk

My first insight into data types using Alteryx and how to make sure you’ve got the right one.

Design,TableauCalculations

The journey to The Data School

Jun 8, 2022 Longyan Chen | www.thedataschool.co.uk

Some resources that I used to get into The Data School.

Design,TableauCalculations

Regex in Tableau Prep

Jun 8, 2022 Kristine Wiesner | www.thedataschool.co.uk

During our dashboard week last week, I was faced with a situation in datacleaning with Tableau Prep, where I have to separate a field of number codesindividually so  I can match these codes to another file.

Design,TableauCalculations

Don't Overthink It!

Jun 8, 2022 Maha Hussari | www.thedataschool.co.uk

Starting something new is always scary but as long as you don’t overthink it, you’ll be fine. Read my top 3 points about starting DS!

Design,TableauCalculations

Committing to The Data School Journey

Jun 8, 2022 Tristan Kelly | www.thedataschool.co.uk

We at The Data School New York are three days into our journey, and although thecontract may be for 2 ½ years, I have a good feeling it will be over before weknow it.

Design,TableauCalculations

What Makes Good Analytics: Approachable Language vs. Jargon

Jun 8, 2022 Jim Horbury | interworks.com

Acronyms and impenetrable language: we all know these tendencies aren’t helpful, so why can’t we stop acting on them? It’s a problem for us; it’s a problem for you. No matter what industry you work in, the likelihood is high that industry-specific...

Data,acronyms,communication,jargon,WhatMakesGoodAnalytics

How to Compare to a Selected Value with a Parameter Action

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

In this tip, I show you how to use a parameter action to compare values within a chart. This example uses a bar chart; it works with other chart types as well. var divElement = document.getElementById(‘viz1654...

action,calculatedfield,click,compare,comparison,context,highlightaction,howto,levelofdetail,LOD,parameteraction,tableau,tip,tutorial

Thank you

Jun 7, 2022 Tram Nguyen | www.thedataschool.co.uk

4-months of intensive training officially wrapped up with joy. It’s difficult tosummarize my feeling throughout this whole period by a few concrete wordsbecause it’s a combination of everything:“excited”, “nervous”, “stressed”, “thrilled”, “satisf...

News,BlogRoundup,Matillion,May,TableauConference,TC22

Sets, Groups and Parameters

Jun 7, 2022 Juhie Radia | www.thedataschool.co.uk

Giving a quick summary of these 3 features then comparing and contrasting them at the end

News,BlogRoundup,Matillion,May,TableauConference,TC22

Make finance less dry in Tableau!

Jun 7, 2022 Tram Nguyen | www.thedataschool.co.uk

Two weeks ago I created one of the main financial statements, Profit & LossStatement in Tableau. Thought that this topic might be of high demand, today I’mwriting this blog to tell you the process to do it.

News,BlogRoundup,Matillion,May,TableauConference,TC22

How to hide the Sort Controls from view

Jun 7, 2022 Zdravka Bratuhtcheva | www.thedataschool.co.uk

This is going to be my shortest blog for something I find very valuable - hidingthe sort control toggle from the view. I learned about this option form Convoand I when I needed it I had to go back and scroll through a very long feed tofind it. I t...

News,BlogRoundup,Matillion,May,TableauConference,TC22

How to change your graph type using Measure Names

Jun 7, 2022 John Power | www.thedataschool.co.uk

(A video version of this explanation can be found on Andy Kriebel’s YouTubeChannel - https://www.youtube.com/watch?v=nxCEfvu4D-w)

News,BlogRoundup,Matillion,May,TableauConference,TC22

Fake it 'til you make it: dummy data in Mockaroo

Jun 7, 2022 Caitlin Walsh | www.thedataschool.co.uk

Dummy data can be a lifesaver when you’re trying to create demo or sample dashboards. In this example, I’ve used Mockaroo to create a dummy dataset.

News,BlogRoundup,Matillion,May,TableauConference,TC22

Data School Roundup - May 23-June 5, 2022

Jun 7, 2022 Andy Kriebel | www.thedataschool.co.uk

This week’s roundup includes 33 Tableau tips, 10 Alteryx tips, plus impressions from the Tableau Conference and tips for taking the Tableau exam.

News,BlogRoundup,Matillion,May,TableauConference,TC22

Dashboard Woche Tag 4 – Digitale Shutdowns

Jun 7, 2022 Tanya Fischer | www.thedataschool.co.uk

Aufgrund einer kleinen Covid-Situation erfolgt dieser Post etwas verspätet undauch mal wieder auf Deutsch, was aber nichts mit Covid zu tun hat.

Data,datavisualization,goldpartner,Tableau

CP (current period) vs PP (previous period) KPI’s

Jun 7, 2022 Zdravka Bratuhtcheva | www.thedataschool.co.uk

How to calculate current period compared to the one before.

News,BlogRoundup,Matillion,May,TableauConference,TC22

Alteryx Fun-damentals

Jun 7, 2022 Ozlem Sigbeku | www.thedataschool.co.uk

A few tools I enjoyed in day one of Alteryx Fundamentals, with videos and screenshots to demonstrate.

News,BlogRoundup,Matillion,May,TableauConference,TC22

Why I’m Excited for Snowflake Summit 2022

Jun 7, 2022 Chris Hastie | interworks.com

I thought I would step away from my usual style of blogs today. The vast majority of my blog posts in the past have been written to achieve a specific technical goal, and you can think of them as guides or how-to’s. Today, I’d like…The post Why I’...

Data,Event,Matillion,Snowflake,SnowflakeSummit

InterWorks Blog Roundup – May 2022

Jun 7, 2022 Mark Cordeiro | interworks.com

Wow, this year sure is flying by. It seems like just yesterday that we were accidentally writing “2021” on the date line. For some of us, that was literally yesterday. No, I will not be naming any names. I will, however, look into the mirror…The p...

News,BlogRoundup,Matillion,May,TableauConference,TC22

What to know about the first day at the Data School

Jun 6, 2022 Ozlem Sigbeku | www.thedataschool.co.uk

10 (possibly helpful) tips on the first day of The Data School.

News,BlogRoundup,Matillion,May,TableauConference,TC22

What to expect in your first day at the data school

Jun 6, 2022 Joel Akaje-Macauley | www.thedataschool.co.uk

This is what to expect within your first day at the data school with my own insights and takeaways.

News,BlogRoundup,Matillion,May,TableauConference,TC22

Including Different Decision Making Scenarios in a Dashboard

Jun 6, 2022 Dorinna Pentchev | www.thedataschool.co.uk

An example of how to present potential outcomes of different decisions.

Data,datavisualization,goldpartner,Tableau

Reflecting on 10 Years as a Tableau Gold Partner

Jun 6, 2022 Behfar Jahanshahi | interworks.com

Every journey is filled with pivotal moments. This is just as true for organizations as it is for individuals. In the case of InterWorks, we often talk about our origins, as well as the development of our overarching company culture. Much of that ...

Data,datavisualization,goldpartner,Tableau

Guest Blog Post: Percentage Trend Calculations - An Easier Way! by Kasia...

Jun 6, 2022 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

This is a guest blog post from 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. She is also a Tableau Public A...

DataViz,How-To,Tableau

Can you maintain rank?

Jun 6, 2022 Donna Coles | donnacoles.home.blog

Building the WAR chart Build a basic bar chart by adding Name to Rows and WAR to Columns Whilst we could sort the data at this point, we’re going to leave for now, as we want the ‘ranking’ field to define the sort. Now rather than use the RANK tab...