Tableau Aggregator

Mastering Conditional Formatting for Enhanced Tables and Matrices in Pow...

Apr 11, 2024 Troy Schuh | interworks.com

The following table, which employs URL links, bars, background colors and icons to visually depict data, was created in Power BI. To achieve a similar result in Tableau would necessitate at least three applications of the “forklift” technique or, ...

Data,data,PowerBI,URLs

Creating Navigation Buttons in Power BI Using Page Navigator

Apr 11, 2024 Zack Cordeiro | interworks.com

One of the most unique and helpful features of Power BI as a visualization tool is its built in page navigator. Traditionally, you would build a navigation button or some other action button in order to switch pages or add a hierarchy to your cont...

Data,buttons,Navigation,PowerBI

Celebrating Student Employee Appreciation Week

Apr 11, 2024 Sara Pineda | interworks.com

InterWorks is celebrating remarkable milestones achieved by our dedicated team members who are either completing their undergraduate studies or venturing into higher education pursuits. We’ve taken the opportunity to gather some reflections from o...

Culture,employeeexperience,Students

Tableau Conference 2024 Presentation

Apr 11, 2024 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

We are thrilled to onceagain be speaking at Tableau Conference April 29 - May 1, 2024 in San Diego!! We’ll be backwith a fresh new 2024 version of How to Do Cool Stuff in Tableau,complete with brand new tips, tricks, and techniques that we hopewi...

Tableau,TableauConference

How to make sense of ANY data set

Apr 10, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

Demystify ANY data set by answering 5 simple questions:When?Where?Which?Who?Why?———-P.S. Newsletter subscribers get a deeper dive into each of these for FREE when they sign up. Go to andykriebel.com to get yours.

analysis,dataanalytics,dataexploration,datavisualization,understandingdata

11 Ways to Compare Two Measures

Apr 10, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

I don’t believe in complexity in data visualization. I stick with simple charts when you needs to compare measures to add context.Tableau workbook here.

barinbar,barbell,comet,comparison,datavisualization,divergingchart,floatingchart,linechart,pairedchart,scatterplot,slopegraph,tableau

12 Essential Skills for Every Excel User

Apr 10, 2024 Ollie Linley | onenumber.biz

Where do you begin with Excel? It’s a tool so widely used that everyone assumes you know how to work your way around it! But for those of us just starting out, it can be really intimidating to work out where to begin.

Excel

PYD125 Tableau Conference 2024 with Ken McBride Evan Pierce and Alberto...

Apr 10, 2024 InterWorks | interworks.com

This special edition of Podcast Your Data comes from behind the scenes of our “Road to TC24″ series, which is dropping periodically on our social media. Here, Content Manager Garrett Sauls and InterWorks Channel Strategy Director for the Americas ...

Data,PodcastYourData,PYD,TableauConference

The Ultimate Tableau Date Calcs Cheat Sheet

Apr 9, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

This date calcs cheat sheet by Luke Stanke is all you’ll ever need to master date calculations in Tableau. Includes visual examples that highlight exactly how each calc works. Simply click the calc you need, copy the calculation, paste into your c...

datecalculations,tableau

How to Create a Floating Bar Chart in Tableau

Apr 9, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

A floating bar chart is similar to a Gantt chart, except it shows the range of two data points instead of two dates.

barchart,calculatedfield,color,difference,diverging,floatingchart,gantt,lookup,size,tablecalc,tablecalculation,tableau

Run R Script in Tableau - Part 2

Apr 9, 2024 Le Luu | www.thedataschool.co.uk

In the previous blog, I shared how to install, and load R packages in the R Console. To run the R script in Tableau Prep Builder and Tableau Desktop, we need to install Rserve and connect Rserve with the local host and port number on our local mac...

Fundamentals,Innovation,Storytelling,Strategy

Quick Tip clustered bar charts with Measure Values

Apr 9, 2024 Caitlin Walsh | www.thedataschool.co.uk

If users want to see a side-by-side bar chart with ‘grouped’ spacing, Tableau developers can sometimes be limited by the hierarchy of dimensions and measures. If you are working with Measure Values, however, this quick tip offers an alternative.

Fundamentals,Innovation,Storytelling,Strategy

Domain Ownership Data Products within Business Functions

Apr 9, 2024 Mike Oldroyd | interworks.com

A few years ago, the dominant architecture for data and analytics was based around an enterprise data warehouse (EDW). The intention was to replace separate departmental data silos with a central hub that would allow data to be shared much more ea...

Data,dataproducts,domains

How to Create an Enclosed Dot Plot in Tableau

Apr 8, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

An enclosed dot plot is similar to a barbell charts except the line connecting the dots surrounds the dots.

barbellchart,dotplot,dualaxis,enclosed,encloseddotplot,howto,linechart,tableau

Exploring the History of Data Visualization

Apr 8, 2024 Alyssa Huff | playfairdata.com

If you’re reading this post, it’s highly likely that you either have some familiarity with or are interested in data…The post Exploring the History of Data Visualization appeared first on Playfair Data.

Fundamentals,Innovation,Storytelling,Strategy

How to Create a Barbell Chart in Tableau

Apr 7, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

A barbell chart is a dot plot that shows two or more points and also connects those points to display the range.

barbell,barbellchart,dotplot,dualaxis,howto,linechart,tableau

How to Create a Histogram in Tableau

Apr 6, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

A histogram visualizes the distribution of data over a continuous interval. Each bar represents the frequency at each bin.

barchart,bins,datavisualization,distribution,histogram,howto,normaldistribution,tableau

How to Create a Heatmap in Tableau

Apr 6, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

A heat map is a good way of showing the patterns between 2 categories of data. They use color to encode the intensity of the relationships in the matrix.

color,colums,heatmap,heatmap,howto,rows,tableau

18 Ways to Visualize Bar Charts in Tableau

Apr 6, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

The SECRET to never choosing the wrong chart…the Bar Chart! Here are 18 options for your next bar chart.Tableau tutorial and workbook here.

barchart,barinbar,columnchart,datavisualization,howto,stackedchart,stackedcolumnchart,tableau

Building a Hex Map

Apr 5, 2024 Samantha Fitzsimmons | www.thedataschool.co.uk

Awhile back I built a hex map for a Makeover Monday about interstate moving. Using a hex map lets you show geographic information differently. It doesn’t emphasize area or where things are as much, making sure each part on the map gets equal space...

Data,data,Fields,PowerBI

InterWorks Blog Roundup March 2024

Apr 5, 2024 Mark Cordeiro | interworks.com

Welcome back, welcome back, readers! This is, as you can tell from the title, the InterWorks Blog Roundup for March of 2024. Yes, I just read the title back to you for word count purposes. No, I will not apologize. Anywho, we’re listing out here…T...

Data,AI,Roundup,sql,Tableau

Using the ISBNdb API with Python

Apr 4, 2024 Salome Grasland | www.thedataschool.co.uk

One of the great things about Python is that is can call APIs. I recently found this extremely helpful after scraping ISBN numbers from old bookstore newsletter. I was hoping to create a sort of bibliography of all books mentioned in the newslette...

Data,data,Fields,PowerBI

How-To Remove Unwanted Highlighting on BANs KPI Cards Text Sheets in Ta...

Apr 4, 2024 Cecily Santiago | www.thedataschool.co.uk

Have you ever used the Tableau hack to remove unwanted highlighting on a dashboard, but found that your BANs, KPI Cards, or other Text Sheets didn’t respond as you expected?

Data,data,Fields,PowerBI

Recreating Level of Detail Calculations in Power BI

Apr 4, 2024 Roger Garcia | interworks.com

While visualizations provide a valuable snapshot of data, they often fall short in accommodating the diverse analytical needs of decision-makers. For example, imagine a visualisation shows total sales by year. This is useful. But what if we want t...

Data,levelofdetail,LOD,PowerBI

Power BI Logic and Calculation Foundations

Apr 4, 2024 Darinka Markovic | interworks.com

For anyone interested in learning multiple BI tools, it’s always a rough start in the beginning: we’re sure we know the basics, but we also need to understand how some concepts translate or don’t even compare. Like a Mac user trying to use a PC,…T...

Data,data,Fields,PowerBI

Power BI Case Statements

Apr 4, 2024 Zack Cordeiro | interworks.com

In this blog we will show how to write case statements in Power BI, and how they differ from writing case statements in Tableau. How do you write a CASE statement in Tableau? Since the syntax in Tableau (VizQL) is very similar to SQL syntax…The po...

Data,CaseStatements,PowerBI

Can you build a trellis of Profit Ratio Gauges

Apr 4, 2024 Donna Coles | donnacoles.home.blog

It’s Community Month at #WOW2024 HQ, and for the first challenge, Jack Hineman (a long time participant of WOW) asked us to create gauge charts using map layers. Not only that, he wanted them displayed in a trellis format, with a specific requirem...

WorkoutWednesday,WOW2024,DynamicFontSize,DynamicTrellis,FIXEDLOD,Gauge,MAKEPOINT,MapLayers,TableCalculations,TrellisChart,Week14

How to Create a Butterfly Chart

Apr 3, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

A butterfly chart is a type of bar chart where two sets of data series are displayed side-by-side each going a different direction.Follow a video tutorial here and here.

butterfly,divergingbarchart,dualaxis,howto,table,tutorial

How do I add DONUT CHARTS over a FILLED MAP in Tableau

Apr 3, 2024 Cecily Santiago | www.thedataschool.co.uk

Have you ever wanted to show donut charts hovering over locations in a map in Tableau but didn’t know how without floating the donut charts? Maybe you were able to achieve pie charts over the map but couldn’t get the center to cut out?

60 Ways to Visualize Time Series Data

Apr 2, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

I don’t believe in creating fancy visualization to get attention. I prefer easy to understand. Here’s my complete list of 60 unique ways to visualize time series data.Learn to build them here. View the workbook here. Download it on Gumroad here (f...

areachart,bar,datavisualization,line,stacked,tableau,timeseries

Using Python and RegEx to Parse ISBNs from Text

Apr 2, 2024 Salome Grasland | www.thedataschool.co.uk

Find the repo here

Data,AWS,EC2,Matillion

How do I dynamically switch elements on a Tableau dashboard Dynamic Zone...

Apr 2, 2024 Cecily Santiago | www.thedataschool.co.uk

Have you ever wanted to give your dashboard the ability to switch between several charts or change out text boxes? If so, you should learn about Dynamic Zone Visibility (commonly referred to as DZV).

Data,AWS,EC2,Matillion

Its a Wrap Power BI and Fabric Summit 2024

Apr 2, 2024 Robby White | interworks.com

With more than 150 virtual sessions, talks and live Q&A events, the Power BI and Fabric Summit 2024 conference had something for everyone. The keynote session kicked off with an overview of the Microsoft Fabric ecosystem. Getting a chance to h...

Data,Conferences,Fabric,PowerBI

Automating EC2 Instance Management with AWS EventBridge and Lambda

Apr 2, 2024 Guilherme Rampani | interworks.com

Welcome to our journey into the world of AWS automation! In this blog post, we’ll be exploring how to automate the start and stop times of Amazon EC2 instances using a combination of AWS services: Lambda, EventBridge and Simple Notification Servic...

Data,AWS,EC2,Matillion

WatchMeViz Can viral infections be cured with antibiotics

Apr 1, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

I’m really surprised, though maybe I shouldn’t be, about the results from a poll of 1206 Americans by KFF. They asked a simple question: ”Can viral infections usually be cured by antibiotcs, or not? Or do you not know enough to say?”According to t...

Americans,antibiotics,dotplot,dualaxis,formatting,header,howto,KFF,MakeoverMonday,stackedbarchart,survey,tableau,UnitedStates,USA,viralinfections,WatchMeViz

Extracting Text from PDFs with Python

Apr 1, 2024 Salome Grasland | www.thedataschool.co.uk

Full notebook found here.

tableau,datadev

Do I Sort on Field or Nested

Apr 1, 2024 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

In our recent Tableau Bootcamp, Ken was showing some sorting options when a client, who had a good bit of Tableau experience, asked, “when sorting, I always chose ‘Nested’, but you chose to sort on a ‘Field’ - what’s the difference...

Tableau

The Beginners Guide to Tableau Level of Detail LOD Calculations

Mar 31, 2024 Ethan Lang | playfairdata.com

In the ever-evolving landscape of visual analytics, you can often find yourself working with complex datasets, multiple data sources, and…The post The Beginner’s Guide to Tableau Level of Detail (LOD) Calculations appeared first on Playfair Data.

Engineering,Intermediate,TableauDesktop,TechnicalFeatures

Playfair Data Among Ingrams Best Companies to Work For

Mar 31, 2024 Amy Leonard | playfairdata.com

Playfair Data, a leading visual analytics consulting and training firm, is excited to announce its inclusion in Ingram’s list of…The post Playfair Data Among Ingram’s Best Companies to Work For appeared first on Playfair Data.

Announcements

Run R Script in Tableau with Rserve - Part 1

Mar 29, 2024 Le Luu | www.thedataschool.co.uk

R is a programming language that was developed at Bell Laboratories by John Chambers and colleagues (according to the page r-project.org). R is really helpful if you are working with statistical data or forecasting data. R is a free software, you ...