Dashboard Design Essentials: Dashboard Layout & Formatting If you’re reading this post I guess you made it through Part I of the Dashboard Design Essentials series! If you haven’t already read that post, make sure to check it out as … Read More
Dashboard Design Essentials: Basics of Design This post is the first in a series of posts aimed at providing resources to organizations and dashboard developers to help bring their dashboards to life regardless of what BI tool they use. Basic … Read More
Using M to Create a Custom Function for Web Scraping Last month I posted a blog to my website titled Web Scraping in Power BI that showed users how to connect to web data in Power BI using a report that I … Read More
Six Uses for Transparent Shapes in Tableau Sometimes you need to include custom shapes for your visualizations. One useful trick in Tableau is including a completely transparent, single-pixel image as a shape on dashboards and worksheets. This shape is extremely … Read More
First (Hopefully Annual) Snowflake / Tableau Hackathon This past Wednesday, Tessellation / Data Coach partnered with the Carlson School of Management at the University of Minnesota to host a hackathon event, using Snowflake and Tableau as the core tools. Around … Read More
Tableau’s New Relationships and What They Mean The release of Tableau 2020.2 has a lot of cool new features, but perhaps none are more game changing than the implementation of relationships into the data model. There have been many conversations … Read More
How to webscrape COVID-19 using Tableau Prep This blogpost is upcoming but I wanted to provide those from the GovTUG access to it early! Tableau Prep Workflow Get JHU Data – R Script Calculate Daily values – R Script Calculate … Read More
Top Five Power BI Features That Will (Tab) Blow Your Mind There are a ton of cool features in Power BI that you may not be familiar with, even if you have been using the tool for a long time. … Read More
Analytic Process Automation (APA) Here to stay, and why this matters to you Warning: hyperlinks and references to space travel await you… Since you’re reading this, it’s very likely you saw Alteryx’s huge announcement last week of their launch of … Read More
Ultimate Guide to Tables in Tableau: Headers Part 5: Custom Headers When you think about tables in general, we often don’t think about the importance that the header provides. The header can be more than a title. It can provide … Read More
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
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
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: 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 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 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!
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 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!
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 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 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 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: 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 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
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
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 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
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 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 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!
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
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 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 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