How to Combine Date and Time Fields into a Single DateTime Field in Tabl...

Sep 2, 2021 Eric Parker | onenumber.biz

This might be a record short post for the OneNumber blog! I hope I can save you the five minutes I wasted writing custom string calculations trying to combine Date and Time fields in Tableau.

TableauDates,TableauCalculations

InterWorks Blog Roundup – August 2021

Sep 2, 2021 Andrea Avey | interworks.com

Another month, another roundup! In August, we published 14 new pieces of content and featured 20 contributors to the blog, including a couple first-time bloggers! Our team shares all kinds of data tidbits and new knowledge, from a mini-series on t...

News,AWS,datavisualization,Dataiku,monthlyblogroundup,Snowflake,Tableau

How much change has occurred?

Sep 2, 2021 Donna Coles | donnacoles.home.blog

A relatively straightforward challenge was set by Luke this week, to visualise the difference in Sales between 2020 and 2021 in a slightly different format than what you might usually think of. Start by filtering the data to just the years 2020 an...

Live Stream – The Core Components to Successful Digital Transformation

Sep 1, 2021 Analytics Events | www.tessellationtech.io

Learn about the seven key components organizations need to focus on to be effective at digital transformations. … Read MoreThe post Live Stream – The Core Components to Successful Digital Transformation appeared first on Tessellation.

UpcomingLiveStream,Webinar,dataassets,datacompetencies,datagovernance,dataliteracy,digitaltransformation

How to Optimize Your Jupyter Notebooks with Embedded Power BI Reports

Sep 1, 2021 Zac Zinda | www.tessellationtech.io

How to Optimize Your Jupyter Notebooks with Embedded Power BI Reports As a Python user, one of the most time-consuming parts of any data science project I complete is producing clean, aesthetically pleasing visualizations throughout the explorator...

PowerBI,BIReporting,PowerBIforBeginners

#MakeoverMonday | 2021w35 | Male circumcision

Sep 1, 2021 Sean Miller | www.hipstervizninja.com

How prevalent is male circumcision across the globe? Check out this week’s #MakeoverMonday to explore more.The post #MakeoverMonday | 2021w35 | Male circumcision appeared first on HipsterVizNinja.

*New Viz* The Cost of Data: One sheet, two chart

Aug 31, 2021 Lindsay Betzendahl | vizzendata.com

Using a 2021 MakeoverMonday data set from week 19, I created a simple viz that utilized three useful techniques: aContinue reading

DataVisualization,Design,Tableau,Tutorial,FigmaDesign,MakeoverMonday,Onesheettwocharts,Parameteractions

How to Compare to the Average with a Bar Chart

Aug 31, 2021 VizWiz (noreply@blogger.com) | www.vizwiz.com

Context is important in data visualization. For every chart you create, consider asking yourself “compared to what?” In this tip, I show you how to add context to a simple bar chart by showing whether a value is above or below the average. ...

above,analysis,average,barchart,below,boolean,chart,color,comparison,context,datavisualization,graph,highlight,tablecalc,tablecalculation,tableau,tip,tutorial,window,window_avg

Alteryx core certification

Aug 31, 2021 Jonatan Raphael-Amanrich | www.thedataschool.co.uk

My personal experience with the Alteryx certification and a few tips to help out future data schoolers

Data,Alteryx,Assist,dataprep,Dataiku,Tableau,WebinarReplay

Alteryx - One-hot Encoding

Aug 31, 2021 Liu Zhang | www.thedataschool.co.uk

One hot encoding is a common process used to transform categorical variable into numerical variables.

Data,Alteryx,Assist,dataprep,Dataiku,Tableau,WebinarReplay

Webinar Replay: The Data Prep Landscape

Aug 31, 2021 Rachel Kurtz | interworks.com

Recently, we hosted a webinar that focused on the anchoring question of, What is data prep and what tools can help me with it? “The goal is to turn data into information and information into insight” – Carly Fiorina, CEO of Hewlett Packard We feel...

Data,Alteryx,Assist,dataprep,Dataiku,Tableau,WebinarReplay

How many consecutive starts?

Aug 31, 2021 Donna Coles | donnacoles.home.blog

Another table calculation related challenge this week, set by Luke, visualising cumulative starts for NFL Quarterbacks per team from 2006. Luke provided the data within a Tableau workbook template on Tableau Public, so I started by downloading the...

#MakeoverMonday 2021 Week 35 - Male Circumcision Around the World

Aug 30, 2021 VizWiz (noreply@blogger.com) | www.vizwiz.com

In this week’s Watch Me Viz, I started by showing the original visualization, demonstrated how to make a non-geographical field geographical, and then I spent lots of time working through set action drill down.I showed how to do drill down to two ...

action,BAN,barchart,circumcision,dashboard,dashboardaction,filteraction,gender,health,howto,MakeoverMonday,male,region,setaction,tableau

3 Fun Tips for Containers in Tableau

Aug 30, 2021 Spencer Baucke | www.tessellationtech.io

3 Fun Tips for Containers in Tableau! During an internal data visualization learning session at Tessellation I presented on a couple of fun ways that I use containers in my Tableau dashboards. Although many of the folks on the call … Read MoreThe ...

Dashboards,Tableau,Technical,containers,main,tableau

How I Went from Hospitality and Tourism Student to InterWorks Account Ex...

Aug 30, 2021 Nico Gerbrecht | interworks.com

For years, I had joked that hospitality was one of the best career fields to go into. The opportunity to live and find work in nearly any country in the world is an attractive thought. My reasoning was that people will always want to eat,…The post...

Culture,culture,hospitality,HowIWentFrom,OklahomaState,sales

How to create a stacked area chart showing the % of total

Aug 29, 2021 Edoardo Aversa | www.thedataschool.co.uk

Line charts are a useful way to visualise the individual values of data over time, but what if we need to visualise the distribution of data as part of a whole over time? In this post we are going to look at a simple and effective possible solutio...

Can you create a moving average chart with a focus on selected subcatego...

Aug 29, 2021 Donna Coles | donnacoles.home.blog

Following the #WOW survey where practice in table calculations was the most requested feature, Lorna continues with the theme in this challenge, where the focus is on the moving average table calculation, plus a couple of extra features thrown in....

Tableau Charts - Line Related Charts Part1 #Tableau

Aug 27, 2021 Jesus Esquivel Roman | www.thedataschool.co.uk

This blog covers the following line-related chart types: Cumulative curve, Moving Average with Parameters, and Cycle Plots

DS24 Training Blog - Week 12

Aug 27, 2021 Liu Zhang | www.thedataschool.co.uk

Photo by Marvin Meyer[https://unsplash.com/@marvelous?utm_source=ghost&utm_medium=referral&utm_campaign=api-credit] / Unsplash[https://unsplash.com/?utm_source=ghost&utm_medium=referral&utm_campaign=api-credit]Day 1:Monday client p...

Upgrade Tableau Server

Aug 27, 2021 markwu2000@gmail.com | enterprisetableau.com

Often we heard enterprise Tableau customers had all kinds of challenges to upgrade their Tableau servers. This webinar invited the super experienced Tableau server admin talking about our own experiences of upgrading very large Tableau servers. Re...

TableauEnterprise

What did it take to get into DS25?

Aug 26, 2021 Andy Kriebel | www.thedataschool.co.uk

There were so many amazing applications for DS25. Who made it into DS25? What did they create?

Alteryx,Business,Careers,journey,careeradvice,CareerInsights,JourneytoTessellation

Jake Miknuk’s Journey to Tessellation: There is a Beginning and End to E...

Aug 26, 2021 Jake Miknuk | www.tessellationtech.io

“There is a beginning and end to everything.” My dad has imparted this little bit of wisdom to me during almost every major transition in my life. Coming from a United States combat veteran who served for a year in … Read MoreThe post Jake Miknuk’...

Alteryx,Business,Careers,journey,careeradvice,CareerInsights,JourneytoTessellation

How To Unpivot (Transpose) in Tableau Prep - Using the New Rank Feature

Aug 26, 2021 Eric Parker | onenumber.biz

No! This post is not a mistake. It really is our third blog post in the last three years detailing how to transpose values in Tableau Prep. The tool is rapidly evolving, and the good new is that the process of transposing values is becoming more s...

TableauPrep,Data

Snowflake - How to pivot columns in database

Aug 25, 2021 Liu Zhang | www.thedataschool.co.uk

Pivot a table from long to wide format is common transformation step to be done to a table. Snowflake can use pivot function directly within the query environment.

TableauPrep,Data

Snowflake - How to flatten JSON file

Aug 25, 2021 Liu Zhang | www.thedataschool.co.uk

This is experience gained from the Data School’s Snowflake project, where we learned how to parse JSON file and flatten it within Snowflake environment instead of Alteryx.

TableauPrep,Data

Travel Planner & Emissions Calculator

Aug 25, 2021 datavis.blog | datavis.blog

This post highlights some of the techniques used in this travel planner dashboard that allows you to draw out two routes on a map, select the methods of transport and then compare them by distance and carbon emissions.

IronQuest,ParameterActions,Tips,Maps,parameterasdatasource,Tableau

Advance with Assist: Adding Field Names Above Bars on a Bar Chart

Aug 25, 2021 Carol Prins | interworks.com

Question: I would like my users to see the product names above the bars in my bar chart instead of having them on the left of the bar to make it more presentable. How do I achieve this? By having the field name sitting above…The post Advance with ...

Data,AdvancewithAssist,barchart,dualaxis,Tableau

MakeoverMonday 2021 Week 34 - Entry-Level Jobs on LinkedIn Requiring 3+ ...

Aug 24, 2021 VizWiz (noreply@blogger.com) | www.vizwiz.com

Eva sent me an interesting, and ironic data set for this week. It’s based on a studying done on LinkedIn of jobs that advertise as “entry-level” yet require 3+ years of experience. I’m still having trouble wrapping my head around that.In this week...

percoftotal,barchart,chart,color,dashboard,employment,experience,font,howto,jobs,MakeoverMonday,PowerBI,stackedbarchart,tableau,WatchMeViz

How to Automatically Exclude a Partial Week

Aug 24, 2021 VizWiz (noreply@blogger.com) | www.vizwiz.com

In this video, I show you how to use level of detail expressions to only return sales through the latest completed week. This method will work as weeks complete; you will not need to edit any of the calculations to ensure weeks that close in the f...

analysis,calculatedfield,calculation,chart,contextfilter,datavisualization,dynamictitles,exclude,filter,graph,howto,latest,levelofdetail,LOD,tableau,tip,trick,tutorial,week

PostgreSQL & Tableau Server

Aug 24, 2021 Garth Turner | www.thedataschool.co.uk

Learn how to use PostgreSQL to find out more about your server, and explore the data.

PowerBI,AnalyticsAutomation,PowerBIforBeginners

Modulo: How to increment a number every n rows (Alteryx)

Aug 24, 2021 Henry Mak | www.thedataschool.co.uk

In this blog post, Henry shows you how to increase the value of a variable every n rows using the modulo operation, in Alteryx.

PowerBI,AnalyticsAutomation,PowerBIforBeginners

Live Stream – How to Drive Value with Tableau Server: A Guide for Tablea...

Aug 24, 2021 Analytics Events | www.tessellationtech.io

Join this one-hour webinar for data developers to learn how to best leverage Tableau Server for publishing, refreshing, and managing access to your workbooks and data sources. … Read MoreThe post Live Stream – How to Drive Value with Tableau Serve...

Tableau,TableauServer,UpcomingLiveStream,Webinar,tableau,Tableaututorial

Create Automated Workflows with Power Automate

Aug 24, 2021 Taguma Nicholas | www.tessellationtech.io

Create Automated workflows with Power Automate Automation is a hot topic right now. It’s up there on the list of tech buzzwords right next to Big Data, Machine Learning, and Blockchain. On a more basic level, have you ever thought … Read MoreThe p...

PowerBI,AnalyticsAutomation,PowerBIforBeginners

Five Ways to Create a Well-Documented Tableau Dashboard

Aug 23, 2021 Alice McKnight | www.tessellationtech.io

Five Ways to Create a Well-Documented Tableau Dashboard Ever been asked to update a dashboard you didn’t create? Are you handing off a completed dashboard to a client who will now maintain the dashboard? Ever have a dashboard break months … Read M...

Dashboards,Tableau,Technical,dashboard,tableau,TableauPrep

Setting up Your dbt Environment

Aug 23, 2021 Derek Hecksher | interworks.com

In our last post, we talked about the differences between dbt Cloud and dbt Core. Once you’ve decided which environment works best for your team, it’s time to start development. In this post, we’ll walk through some of the basic setup of dbt and b...

Data,dbt,Jinja,projects,sql

Create a Tiled Container "Selector"

Aug 23, 2021 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

  The new version of Tableau (2021.2) brought us an awesome new feature, the ability to add a show/hide button to not only a floating container, but also a tiled container.  When you close a tiled container, the other tiled containers ...

DataViz,How-To,Tableau

DS24 Training Blog - Week 11

Aug 22, 2021 Liu Zhang | www.thedataschool.co.uk

First time experience on Snowflake which is also the topic of this week’s project. Plenty practice with database, API, Alteryx server as well.

Alteryx Core Certification Exam Tips

Aug 20, 2021 Jyoti Gupta | www.thedataschool.co.uk

You have an upcoming Alteryx Design Core certification exam and are looking for some tips. I have got you sorted!! Check out list of thing I did to pass my exam.

Dashboards,PowerBI,Technical,main

5 things to do before creating your dashboard in Tableau

Aug 20, 2021 Rahul Lalwani | www.thedataschool.co.uk

When it comes to data visualisation, the majority of the attention is focused onthe tools themselves. What chart type, for example, is appropriate for the data?What is the most effective technique to visualise survey results? These are allimportan...

Dashboards,PowerBI,Technical,main

Understanding the Basics of Power BI Service

Aug 20, 2021 Spencer Baucke | www.tessellationtech.io

Understanding the Basics of Power BI Service Once you’ve created an awesome Power BI report with an efficient and properly constructed data model, easy to understand visuals, and meaningful metrics using DAX, you need to be able to get that … Read...

Dashboards,PowerBI,Technical,main

#MakeoverMonday 2021 Week 33 - UCAS Daily Placements

Aug 19, 2021 VizWiz (noreply@blogger.com) | www.vizwiz.com

UCAS is a service that helps people find open placements universities in the UK (and hopefully place them). I found this particular data set quite confusing until I looked at this viz from UCAS. I then understood that we were basically looking at ...

applications,college,containers,education,filters,MakeoverMonday,trellischart,UCAS,UK,unitedkingdom,university

From Teaching to Tessellation: Jennifer Hunter’s Journey to Consulting

Aug 19, 2021 Jennifer Hunter | www.tessellationtech.io

From Teaching to Tessellation: Jennifer Hunter’s Journey to Consulting From a young age, I’ve loved all kinds of puzzles, strategy games, brainteasers, and anything that involved problem-solving. In school, I quickly became the “go-to” for my frie...

Careers,journey,careeradvice,CareerInsights,JourneytoTessellation

How do Tableau Groups Work?

Aug 19, 2021 Eric Parker | onenumber.biz

Did you know there are at least 3 different types of groups you can create? Which of the types is a best fit for you depends largely on your situation and data.

TableauGeneralKnowledge,TableauHow-Tos

Analytics in Digital Transformation with AWS

Aug 19, 2021 Holt Calder | interworks.com

The year 2020 produced a mass migration of business processes, enterprise software and internal workloads to AWS in a way that was previously unseen. In the world of data, organizations relied on the flexibility of the cloud to run infrastructure,...

Data,AWS,cloud,Fivetran,Matillion,Snowflake,Tableau

Compare Latest Month with Previous Months Average in Tableau (LOD)

Aug 18, 2021 Liu Zhang | www.thedataschool.co.uk

Rather than compare between individual month value, we can also do comparison across different range of date. Aggregation is needed when the view is broken down by a dimension measure. This blog post shows how to do it.

TableauGeneralKnowledge,TableauHow-Tos