Tableau: The Total Gym of Data Visualization

Oct 12, 2022 Robby White | interworks.com

We’ve all seen an infomercial, and if you haven’t, you might as well take this as a cue to jump onto YouTube and ask for some of the best Infomercials ever made. For some inspiration, you can try looking up OxiClean, George Foreman Grills, The…The...

Data,Tableau,totalgym,Training

Installing dbt with Mac M1 Chips

Oct 12, 2022 Austin Schwinn | interworks.com

Have you encountered errors trying to install older versions of dbt on your fancy, new MacBook? This could be related to compatibility issues with the new M1 CPU. Dependency packages written for Intel CPUs can cause issues preventing proper instal...

Data,Apple,dbt,M1,Mac

#MakeoverMonday 2022 Week 41 - UNDP Human Development Index

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

From UNDP:The Human Development Index (HDI) is a summary measure of average achievement in key dimensions of human development: a long and healthy life, being knowledgeable and have a decent standard of living. The HDI is the geometric mean of nor...

action,country,development,hover,howto,human,index,interactivity,MakeoverMonday,select,tableintooltip,tableau,tips,tooltip,UNDP,UnitedNations,viztooltip,WatchMeViz

Backwards is the New Forwards

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

This blog is called backwards is the new forward because to understand what we need to do we need to work backwards to work out what is needed to get to the final solution. There is a small step by step to how to get here.

Tableau Set Control Part 1: The Basics

Oct 10, 2022 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

A Sets Timeline Sets have been part of Tableau for a long time (well before I started using it back in 2016), but historically, their uses have been somewhat limited because there was no way for your users to add or remove items from t...

How-To,Tableau

Applying accessibility principals to data visualisation

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

It’s Community month for #WOW2022, and so guest poster Collin Smith set this challenge to get us all thinking about how to make an accessible dashboard. There were 3 tiers of requirements, so lets start with Tier 1. Building the charts I used 5 sh...

mode functions have limitations - my first Alteryx community challenge

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

The aim: To find which artists had the most top 100 hits in each decade from the Billboard top 100 ranking.

Data,Alteryx,books,Curator,Dataiku,ProfessionalDevelopment,Snowflake,Tableau,webinar

Solving my first Alteryx Challenge

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

When asked to complete a core Alteryx Challenge I selected number 58 and was tasked with converting strings of numbers into dates, I quickly discovered the DateTime Tool and identified that I would be needing it. But before I could use the tool I ...

Data,Alteryx,books,Curator,Dataiku,ProfessionalDevelopment,Snowflake,Tableau,webinar

Google is your best friend

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

So Day 2 of covering the Alteryx fundamentals has come and gone. We spent the majority of today finishing off our analysis into some sales data trying to find the top 20% SKU’s for revenue. Took me back to my auditing days somewhat analyzing vario...

Data,Alteryx,books,Curator,Dataiku,ProfessionalDevelopment,Snowflake,Tableau,webinar

InterWorks Blog Roundup — September 2022

Oct 6, 2022 Mark Cordeiro | interworks.com

Well, we survived the heat of the summer! With autumn on our doorstep and the summer heat finally breaking here in the northern hemisphere, our US and EMEA teams are looking forward to dusting off our boots, jackets and pants again. For me, person...

Data,Alteryx,books,Curator,Dataiku,ProfessionalDevelopment,Snowflake,Tableau,webinar

How to Create a Starburst Chart

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

Starburst charts, sometimes called sunburst charts or circular timelines, are one method of displaying data over time. They may look cool, but they aren’t exactly easy to understand. If you are going to use them, I’d advise you to check with your ...

circletimeline,circulartimeline,dataprep,date,howto,parameter,starburstchart,sunburstchart,tableau,timeseries,timeline,tip,union

SQL Querying

Oct 5, 2022 Lauren Halliwell | www.thedataschool.co.uk

SQL is a universal language, used to query data bases. In this blog, you will learn how t0 use SQL in order to get whatever information you require. There are 6 main operations you need to learn.

airbyte,dagster,dbt,data-engineering

SQL Basics

Oct 5, 2022 Arnold Quarcoo | www.thedataschool.co.uk

Learning the basic syntax for SQL and in which order is best to do it in, as SQL is sensitive to the order.

airbyte,dagster,dbt,data-engineering

SQL 101

Oct 5, 2022 Cammy Phillips | www.thedataschool.co.uk

Some key thought about how to get what you want out of your SQL query search!

airbyte,dagster,dbt,data-engineering

Regular Expressions (RegEx)

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

Regex 101 (or a little easier than that 😉)

airbyte,dagster,dbt,data-engineering

OMG SQL...

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

SQL basics

airbyte,dagster,dbt,data-engineering

How I ended up at The Data School

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

My parents thought it would be a good idea to enroll me in swimming classes when I was a kid. Because of it, I ended up at The Data School.

Design,TableauHow-Tos

Dagster + Airbyte + dbt: How Software-Defigned Assets Change the Way We ...

Oct 5, 2022 Tamas Foldi | medium.com

A few weeks ago, I heard an interview with Dagster founder Nick Schrock on the Data Engineering Podcast. Although I tried Dagster way back in its early stage, listening to Nick’s approach to Software-Defined Assets (SDA) in the data orchestration ...

airbyte,dagster,dbt,data-engineering

10 Tableau Charts in 10-ish Minutes

Oct 5, 2022 Eric Parker | onenumber.biz

Tableau is a fantastic data visualization tool, but memorizing some of the initial data visualization rules is hard. It might only take a few clicks to create a scatter plot or a highlight table, but you need to know exactly which clicks to make i...

Design,TableauHow-Tos

New Considerations for Migrating from Tableau Server to Tableau Online

Oct 5, 2022 Tony Kau | interworks.com

It’s been a minute since we looked at the process to migrate from your own Tableau Server onto the Tableau-hosted SaaS offering Tableau Cloud. If you’re considering the move, below is an updated list of considerations that could impact your decisi...

Data,contentmigration,ServerCare,tabcmd,Tableau,TableauCloud,TableauOnline,TableauServer

why the selector tool is the most essential tool in Alteryx data prep (s...

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

A basic explanation of the selector tool in Alteryx.

Design,TableauHow-Tos

What did it take to get into DSNY2?

Oct 4, 2022 Ann Jackson | www.thedataschool.co.uk

I’m pleased to introduce you to Cohort 2 of The Data School New York!  This eclectic group of bright individuals wowed us with their approach to Central Park Squirrel data (and some McDonald’s menu!).

Design,TableauHow-Tos

Using custom shapes for your dashboard

Oct 4, 2022 Viktoria Von Laer | www.thedataschool.co.uk

At the last day of the Dashboard week, we got a dataset about boybands- a good topic, to create a little bit more playful dashboard and try something new. The data included information about the boybands accessories, so I thought of presenting the...

Design,TableauHow-Tos

Union Vs Join

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

Union and Join are both functions used within Alteryx this is an understanding of the difference between the two. They were used within the DS35 first session of Alteryx and this was how I understood the difference between the two.

Design,TableauHow-Tos

Two Ways To Handle [NULL] Values

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

This post will be covering how to treat null values. Option 1: Fill the Null value using the previous value.Option 2: Using a Filter

Design,TableauHow-Tos

Tableau Prep flow and documentation conventions

Oct 4, 2022 Ozlem Sigbeku | www.thedataschool.co.uk

I went to jail for crimes of peak nerdiness just to get this message to you. Why is documentation important and an example of how to document a Tableau Prep flow.

Design,TableauHow-Tos

How to in import multiple sheets from an excel file into Alteryx using d...

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

Importing multiple sheets into Alteryx in just 2 steps.

Design,TableauHow-Tos

How to filter duplicates in Alteryx

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

A quick guide on filtering duplicates in your data.

Design,TableauHow-Tos

Day 1 of Alteryx - Looking at the bigger picture

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

So today was DS35’s first run at using Alteryx. What can I say the day started with the apprehension and expectation of being thrown in the deep end and being expected to swim or inevitably sink into the vast depths of unorganized data. However, I...

Design,TableauHow-Tos

Dashboard Week Day 4: Working with backgroundimages, floating containers...

Oct 4, 2022 Viktoria Von Laer | www.thedataschool.co.uk

Using an image as a background for the whole dashboard and placing the charts on it, looks always very stylish for me, but I never tried it until now- although it’s really  easy to do.

Data,Azure,SCIM,Snowflake,SSO

Browsing your data in Alteryx

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

Today we got our first experience with Alteryx, naturally we were introduced to several tools but one that we kept using throughout was the Browse tool.

Design,TableauHow-Tos

Leveraging Snowflake’s ODBC Driver on Modern MacOS

Oct 4, 2022 Ryan Alexander | interworks.com

If you’re a macOS user and use Tableau Desktop, you may be familiar with the continued problems with Snowflake drivers. The move from Intel-based processors to the new Apple Silicon chips has brought changes in potential drivers and issues configu...

Data

#MakeoverMonday 2022 Week 40 - Income Inequality Around the World

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

Of course, as soon as I posted the data set this week, the UK PM decided to backtrack on the tax cuts she has promised before. In my opinion, this is a good. But it kinda made that part of the analysis irrelevant.Still, though, I was curious to se...

color,comparison,context,economy,G7,income,inequality,levelofdetail,liztruss,LOD,tableau,unitedkingdom,vizintooltip,WatchMeViz

¿Puedes construir un mapa con valores representados por “Pirámides”?

Oct 3, 2022 Rosario Gauna | rosariogaunag.wordpress.com

Para la semana 39 de #WOW2022, Luke Stanke nos comparte el desafío de construir un mapa para visualizar los casos de COVID-19 por condado, dentro de Estados Unidos Continentales. En el mapa, cada condado será representado a través de “pirámides” c...

Español,#Map

Can you Build a Map with values represented by “Pyramids”?

Oct 3, 2022 Rosario Gauna | rosariogaunag.wordpress.com

For week 39 of #WOW2022, Luke Stanke shares with us the challenge of building a map to visualize COVID-19 cases by county, within the Continental United States. On the map, each county will be represented through “pyramids” with the following char...

English

SCIM and User Management for Snowflake with Azure AD

Oct 3, 2022 Danny Tishenko | interworks.com

This is the second part of the three-part series on SSO and user provisioning. This one is a follow up on my previous post, which went over the core concepts of how SSO (and SCIM) work. Now we are going to delve deeper into actually…The post SCIM ...

Data,Azure,SCIM,Snowflake,SSO

How to Set Up a Published Data Source in Tableau

Oct 3, 2022 Nico Gerbrecht | interworks.com

Congratulations! You’ve just rolled out Tableau and are beginning to onboard users. Everyone is excited and ready to get started using Tableau. People are off building dashboards and reports, but then the inevitable happens. “Wait a minute, these ...

Data,datasources,Tableau,TableauDesktop,TableauOnline,TableauServer,TableauTips

5 Hacks using Blank Characters in Tableau

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

 I love transparent shapes, but did you know that there is a transparent text character - a blank character?  And that this blank character has a pile of cool use cases in Tableau.  I use them ALL THE TIME!  Check out this video for so...

How-To,Tableau

Training? Did it.

Oct 2, 2022 Ozlem Sigbeku | www.thedataschool.co.uk

My final thoughts of the Data School

Español,#Map

E is for Empty

Oct 2, 2022 Karen D. Hamilton | www.thedataschool.co.uk

Dashboard Week

Day 5 Dashboard Week: Boy Bands

Oct 1, 2022 Islande Derazin | www.thedataschool.co.uk

Day 5 dashboard week is about Boy Bands. The data is available on GitHub. We can use Power Bi or Tableau, I use Tableau.

How to do a https://www.thedataschool.co.uk/maha-hussari/how-to-do-a-url...

Sep 30, 2022 Maha Hussari | www.thedataschool.co.uk

If you are looking to be able to click on an image in Tableau and it will redirect you to a URL - this is the right blog for you.

D is for Drama

Sep 30, 2022 Karen D. Hamilton | www.thedataschool.co.uk

Dashboard Week

Different API, different problems

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

I tried to make a dashboard Walter White would be proud of. Read how it went.

Dashboard week day 5

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

we were tasked with downloading boy band data from github. link here https://github.com/the-pudding/data/blob/master/boybands/bands.csv and here https://github.com/thepudding/data/blob/master/boybands/boys.csv