Using Shapes in Tableau If you’re like me, nothing excites me like bringing a dashboard to life using proper shapes and colors. In this blog post I will show you three different techniques on how to implement shapes into your … Read More
Articles
Our Thoughts
Looking for formal Tableau or Alteryx Training?
Skip the workshop and learn online over 8 weeks with the support of a coach and a cohort with our Data Coach Platform.
or check out Data Coach on YouTube
Ultimate Guide to Tables in Tableau, Part 4: Filtering
Ultimate Guide to Tables in Tableau: Filtering with Tables Part 4: Filters with Tables So you’ve built a table. That probably means you need a bunch of filters to go with the table. These filters can be cumbersome, steal valuable … Read More
Top Five : Things I’ve Learned About Tableau Recently
Things I’ve Learned About Tableau Recently I like to think I know a lot about Tableau but when I read a post by Ken Flerlage, or see a #WorkoutWednesday by Luke Stanke, I realize there is so much more to … Read More
TEXT INPUT | ALTERYX 2-MINUTE TOOLS
TEXT INPUT | ALTERYX 2-MINUTE TOOLS This week, we are going to learn how to use the Text Input tool to bring in simple, usually one-time, data sets into your workflow. Yep. I am excited too. The Text Input Tool … Read More
Ultimate Guide to Tables in Tableau, Part 3: Row Density
Ultimate Guide to Tables in Tableau: Row Density Part 3: Row Density In this post we continue our ultimate guide to tables in Tableau by discussing how to change the number of rows displayed in a table using Tableau. As … Read More
Ultimate Guide to Tables in Tableau, Part 2: Pagination
Ultimate Guide to Tables in Tableau: Pagination Part 1: Pagination In this post we continue our ultimate guide to tables in Tableau by discussing how to create pagination in Tableau. Sometimes our tables are too long in Tableau–and sometimes we … Read More
AGGREGATE CONSUMER PURCHASES | WEEKLY CHALLENGE #8 | I CAN ALTERYX THAT
AGGREGATE CONSUMER PURCHASES | WEEKLY CHALLENGE #8 | I CAN ALTERYX THAT In this week’s challenge, our goal is to take a large table of consumer orders and aggregate them to evaluate the feasibility of creating a new “meal deal.” … Read More
Alteryx’s Output Data Tool
Alteryx’s Output Data Tool You’ve spent most of your time so far automating your data wrangling, so where do you go from here? The Output Data tool! The Output Data Tool Check Out the 2-Minute Tool Playlist!
HISTOGRAM | ALTERYX 2-MINUTE TOOLS
SCATTERPLOT | ALTERYX 2-MINUTE TOOLS This week, we are going to continue with the data investigation and visualization theme. Like the scatter plot last week, we can use the Histogram tool in Alteryx to look at our data. Specifically, this … Read More
Alteryx’s Record ID Tool
Alteryx’s Record ID Tool “Chicka Chicka Yeah, RecordID RecordID” – McLovin'[Data] Not having an ID on your Record getting you down? Just use the Record ID tool! The Record ID Tool Check Out the 2-Minute Tool Playlist!
Alteryx’s Tool Container Tool
Alteryx’s Tool Container Tool The tools in your workflow getting away from ya a bit? Put ’em in a box, using the Tool Container tool! The Tool Container Tool https://youtu.be/QAfOYyPLpSI Check Out the 2-Minute Tool Playlist!
SCATTERPLOT | ALTERYX 2-MINUTE TOOLS
SCATTERPLOT | ALTERYX 2-MINUTE TOOLS One of the best things about Alteryx is the ability to easily investigate your data. We are going to talk about one of my favorites, the Scatterplot tool. As you can image, you use the … Read More
How to Grow Your Analytics Career
Five Steps to Finding Your Next Role There is no doubt that COVID-19 has affected everyone and every area of business. The analytics community has had a unique spotlight cast upon it from many people who, maybe for the first … Read More
PARSING VIDEO GAME DATA | WEEKLY CHALLENGE #207 | I CAN ALTERYX THAT
PARSING VIDEO GAME DATA | WEEKLY CHALLENGE #207 | I CAN ALTERYX THAT In this challenge, we’ve been provided with a list of video game data. Unfortunately, the data is all in one column, so we must use Text To Columns … Read More
HOTEL RESERVATIONS | WEEKLY CHALLENGE #206 | I CAN ALTERYX THAT
HOTEL RESERVATIONS | WEEKLY CHALLENGE #206 | I CAN ALTERYX THAT Given a list of hotel bookings, the goal for this challenge is to calculate the average length of each stay and count the number of reservations per month. In … Read More
ANALYTICS RANKING | WEEKLY CHALLENGE #9 | I CAN ALTERYX THAT
Analytics Ranking | WEEKLY CHALLENGE #9 | I CAN ALTERYX THAT In this weekly challenge, the goal is to create a ranking field that accounts for ties. The most challenging part of this problem is using the Multi-Row Formula tool to … Read More
Tableau Prep vs. Alteryx: Basic Data Prep | Extras, Governance, Price
Tableau Prep vs. Alteryx Designer: Basic Data Preparation Part 4: Pricing, Governance, and other features If you missed the rest of the series, start here! Though Tableau Prep and Alteryx have some differences in breadth and depth of product functionality, … Read More
How to build a sales funnel in Tableau: #WOW2019 – Week 14 Solution
How to build a sales funnel in Tableau: Workout Wednesday – Week 14 Solution We’re in the middle of a lockdown and my audio driver is broken on my laptop so this week’s video solution is just a blog post. … Read More
SPATIAL ROUTE | WEEKLY CHALLENGE #6 | I CAN ALTERYX THAT
SPATIAL ROUTE | WEEKLY CHALLENGE #6 | I CAN ALTERYX THAT You’ve been handed a data set containing locations that different sales reps visits. Your goal is to map the route that each rep takes and calculate the distance traveled … Read More
Alteryx’s Multi-Row Formula Tool
Alteryx’s Multi-Row Formula Tool How can you talk with your data that’s not in the same row? The Multi-Row Formula tool! Your walk-talkie to communicate (and change!) data that’s up and down in your fields. The Multi-Row Formula Tool Check … Read More
SPATIAL INFO | ALTERYX 2-MINUTE TOOLS
SPATIAL INFO | ALTERYX 2-MINUTE TOOLS Knowledge is power! But finding out additional information about your points, lines, and polygons on your maps can be difficult. It often involves some complicated calculations. Luckily, Alteryx has consolidated a number of common … Read More
How to Create a Range Parameter in Tableau
Improving Parameter Design: Part 9 Rethinking Slider Parameter Formatting in Tableau Welcome to the 9th post on improving parameter design in Tableau. So far we have discussed: how parameter formatting hasn’t improved over time and gave one possible design solution … Read More
Tableau Prep vs. Alteryx: Basic Data Prep | Joining, Transformation, and Output (Part 3)
Tableau Prep vs. Alteryx Designer: Basic Data Preparation Part 3: Joining, Transformation, and Output This is Part 3, consider starting at Part 1! Though Tableau Prep and Alteryx have some differences in breadth and depth of product functionality, many look … Read More
Alteryx’s Summarize Tool
Alteryx’s Summarize Tool Slice and dice to your heart’s content! Just like a Pivot Table in Excel, the Summarize tool lets us aggregate our data into a more concise level of detail. The Summarize Tool Check Out the 2-Minute Tool … Read More
Ultimate Guide to Tables in Tableau (Part 1)
Ultimate Guide to Tables in Tableau Part 1: The Introduction Quick without thinking too much about it answer the following questions: What chart type is used the most when displaying data? What chart type is the hardest to design? What … Read More
POLY-BUILD | ALTERYX 2-MINUTE TOOLS
POLY-BUILD | ALTERYX 2-MINUTE TOOLS This month ended about being spatial themed, which wasn’t the plan, but I am going to roll with it. To continue that trend, we are going to learn how to create lines and shapes on … Read More
HR POSITION FINDER APPLICATION | ALTERYX WEEKLY CHALLENGE #5 | I CAN ALTERYX THAT
HR POSITION FINDER APPLICATION | ALTERYX WEEKLY CHALLENGE #5 | I CAN ALTERYX THAT Your company has an HR hierarchy full of employee numbers. Your goal is to build an analytic app so that a user can select an employee … Read More
Tableau Prep vs. Alteryx: Basic Data Prep | Data Cleansing (Part 2)
Tableau Prep vs. Alteryx Designer: Basic Data Preparation Part 2: Data Cleansing If you missed Part 1, start here! Though Tableau Prep and Alteryx have some differences in breadth and depth of product functionality, many look to the two products … Read More
Alteryx’s Union Tool
Alteryx’s Union Tool The Union tool — it’s in your Alteryx workflow’s DNA! Enjoy this video which talks about stacking that data into one unified stream, using the Union tool! The UnionTool Check Out the 2-Minute Tool Playlist!
Five Ways to Communicate Data When the Stakes Are High
Creating clear visualizations when time is scarce. The keys are to move quickly, add context, don’t get fancy, avoid baseless information and get feedback. … Read More
DISTANCE | ALTERYX 2-MINUTE TOOLS
DISTANCE | ALTERYX 2-MINUTE TOOLS We have covered a lot of the basics in 2-Minute tools at this point. Now its time to do something a little more complicated in Alteryx. See? Catherine O’Hara believes in you. That means you … Read More
Understanding Dice Probability
Understanding Dice Probability I love playing board games and I definitely love winning. Beating your friends at Settlers of Catan is one of the sweetest victories you can experience in your life. One of the key components is to understand … Read More
How to build Interactive Legends in Tableau
Improving Parameter Design: Part 8 How to create an interactive legend in Tableau Welcome to the 8th post on improving parameter design in Tableau. So far we have discussed: how parameter formatting hasn’t improved over time and gave one possible … Read More
Alteryx’s Sort Tool
Alteryx’s Sort Tool When it comes to sorting in Alteryx, this tool can lead to delight or despair. Take a look at this week’s video all about the Sort tool! The Sort Tool Check Out the 2-Minute Tool Playlist!
Tableau vs. Alteryx: Basic Data Prep | Input and Data Investigation (Part 1)
Tableau Prep vs. Alteryx Designer: Basic Data Preparation Part 1: Input and Data Investigation Tableau Prep and Alteryx Designer are key players on the data prep market. Tableau Prep is a more recent release that is now packaged with the … Read More
CREATE POINTS | ALTERYX 2-MINUTE TOOLS
CREATE POINTS | ALTERYX 2-MINUTE TOOLS If you are an aspiring cartophile like myself, you want to fit maps into your analysis. But guess what? Not every tool has mapping capabilities. The solution, run it through Alteryx! I know. I … Read More
How to calculate percent of total in Tableau: Four ways
Tableau 360 How to calculate percent-of-total in Tableau: Four Ways In this episode of Tableau 360 we’ll look at four ways to calculate percent-of-total. There are two table calculations and two level-of-detail calculations. Here are the four ways: Table Calculation … Read More
Alteryx’s Data Cleansing Tool
Alteryx’s Data Cleansing Tool If you’re like me, you get stressed when receiving dirty data and find yourself spending precious analysis time cleaning it up! Enter, the Data Cleansing tool. This is one of the most commonly used tools in … Read More
DOWNLOAD DATA AND PARSE JSON | WEEKLY CHALLENGE #7 | I CAN ALTERYX THAT
DOWNLOAD DATA & PARSE JSON | WEEKLY CHALLENGE #7 | I CAN ALTERYX THAT In this challenge, you’ve been given a URL that returns a set of data in the JSON format. Your goal is to download that data, parse … Read More
What Are Your Thoughts On The Gartner Magic Quadrant?
What Are Your Thoughts on the Gartner Magic Quadrant Results? Welcome to the Tessellation team chat. Inspired by one of our favorite segments at FiveThirtyEight, we are giving you a peek into the Tessellation Slack channel. This month we’re focusing … Read More
FIND REPLACE | ALTERYX 2-MINUTE TOOLS
FIND REPLACE | ALTERYX 2-MINUTE TOOLS On cold November nights, do you ever look up at the stars and wonder… is there a better way of replacing values in a primary data source with those from a secondary data set … Read More
How to Build a Horizontal List of Parameters with Rounded Corners
Improving Parameter Design: Part 7 of 5 (Encore #2) Creating a Horizontal Parameter Selector with Rounded Borders Welcome to the 7th of five posts on improving parameter design in Tableau. So far we have discussed: how parameter formatting hasn’t improved … Read More
In My Opinion: 2020.1 Release
In My Opinion: Tableau 2020.1 Release The first Tableau major release of 2020 is out and we have a lot to be excited about! Which new features are favorites of the Tessellation team? We’re all chiming in on our favorites … Read More
Alteryx’s Join Tool
Alteryx’s Join Tool Ever want to combine two good data sets to create an amazing one!? You’re in luck! All it takes is one common field to start enriching you data using the Join tool. Check out this week’s video … Read More
Tableau Animations: Scrolling Bar Chart
Tableau Animations: Scrolling Bar Chart Animation is now available with the release of Tableau 2020.1. With the release brings new possibilities for what can be done with animations. This brings the opportunity to add a missing preattentative attribute to the … Read More
Parameters in Tableau vs. Looker
Parameters in Tableau vs. Looker Parameters allow users to interact with the back-end logic in a dashboard. I’m grateful any time a data visualization tool has some kind of parameter functionality, as many currently lack it. For example, while trying … Read More
Alteryx’s Filter Tool
Alteryx’s Filter Tool It’s easy to split your data into some very *colorful* data streams using Alteryx! Check out this week’s video below to learn how you can use simple (or complex!) True/False statements to handle certain data, differently. The … Read More
So You Want to Build Alteryx Macros (Part 3)
So You Want to Build Alteryx Macros (Part 3) This is Part 3 of a four-part series covering macros in Alteryx. In this post, I will walk you through how to build a batch macro in Alteryx. A batch macro … Read More
Top Five: Ways to Mislead with Data Visualizations
Five Ways to Mislead with Data Visualizations Presenting data as some sort of visual — a bar or line chart, scatter plot, a map, etc. — is a powerful storytelling technique. Instead of sifting through hundreds or thousands of individual … Read More
