Articles

Blog

Data analytics & business intelligence articles written by renowned data experts.

Tableau Parameter Buttons

How to Create Custom Buttons in Tableau

Buttons are ubiquitous and self-explanatory to use, and yet it feels like our options for creating and implementing them in Tableau can be quite limited. Not anymore! This guide will walk you through the steps needed to create beautiful and functional buttons in Tableau for a variety of needs. … Read More

Featured Post

The CALCULATE() Function in Power BI

The CALCULATE() Function in Power BI For readers familiar with Power BI, you already know that the CALCULATE function is one of the most important DAX functions in the platform. This function is commonly used, extremely useful, and opens up … Read More

Featured Post

How to Create YTD Calculations in Power BI​

How to Create YTD Calculations in Power BI Recently, Tessellation put out a blog covering how to create Year to Date (YTD) calculations in Tableau, which you can find here. Regardless of what industry or company you work in, comparing … Read More

Featured Post

From Cocktail Shaking to Analytics Enablement: My Journey to Tessellation

From Cocktail Shaking to Analytics Enablement: My Career Journey to Tessellation Welcome to our “Journey to Tessellation” series, in which we’re sharing the exciting, unconventional, and innovative career paths behind our entire team of consultants. Read on to discover how … Read More

Featured Post

Alteryx 2-Minute Tools: How to Use The Input Data Tool

Welcome to our latest data analytics video series in collaboration with Data Coach: Alteryx 2-Minute Tools. Every Tuesday, we’ll share a brief Alteryx tutorial video that will teach you step-by-step how to use one of the 200+ most powerful, essentials … Read More

Featured Post

Career Insights: One of the Most Important Skills You Need to Succeed in Data and Analytics Consulting

“Ambiguity brings out the best and worst in people.” – Luke Stanke, co-founder of Tessellation What I Look For in When I’m Hiring a Data Analytics Consultant What makes a good employee? What makes an outstanding data and analytics consultant? … Read More

Featured Post
Jacob Blizzard Tessellation Data Analytics

Mastering Business Analytics Across Industries: A Journey to Tesselation

Mastering Business Analytics Across Industries: A Journey to Tessellation Welcome to our “Journey to Tessellation” series, in which we are sharing the exciting, unconventional, and innovative career paths behind our entire team of consultants. Read on to discover how Jacob … Read More

Featured Post

Letter #2: Analytic PenPals featuring Alteryx and Tableau Developers. What’s the hype with Tableau?

Join Autumn Battani, Tableau Expert, and Jacob Kahn, Alteryx Expert, on their pen pal adventure exploring the tools of the others expertise. Autumn and Jacob are ready to share their letters with the public in hopes that the exploration of data processing and data visualization inspires readers to take the next step in their data game. … Read More

Featured Post

MLOps Explained: What Is Machine Learning Operations?

Uncover the power and potentials of Machine Learning Operations (MLOps) and its importance in the creation of sustainable, scalable data science products. … Read More

Featured Post
Meet Zac Zinda, a Data Science Consultant at Tessellation

A Data Scientist’s Journey: From Evening Hobby to Full-Time Career

Welcome to our “Journey to Tessellation” series, in which we’re sharing the exciting, unconventional, and innovative career paths behind our entire team of consultants. Read on to discover how Zac Zinda, one of our newest consultants, switched career paths from teaching and the mortgage industry into data analytics. … Read More

Featured Post

How to Create YTD Calculations in Tableau

How to Create YTD Calculations in Tableau One of the most commonly requested items in Tableau dashboarding is to show your metrics as Year to Date (YTD), Prior Year to Date (PYTD), and Year over Year change (YoY). Although seemingly … Read More

Featured Post

OAuth with Snowflake and Alteryx

Using OAuth with Snowflake in Alteryx Snowflake and Alteryx are two of my favorite tools. Many organizations choose to authenticate to their roles with Snowflake using OAuth, which isn’t always immediately straightforward when connecting via Alteryx and some other tools. … Read More

Featured Post
Meet Jacob Kahn - Tessellation Team

From Worksheets to Workflows: My Career Change into Data Analytics

From Worksheets to Workflows: My Career Change into Data Analytics Welcome to our “Journey to Tessellation” series, in which we’re sharing the exciting, unconventional, and innovative career paths behind our entire team of consultants. Read on to discover how Jacob … Read More

Featured Post

Letter #1: Analytic PenPals featuring Alteryx and Tableau developers. Why do people use Alteryx?

Join Autumn Battani, Tableau Expert, and Jacob Kahn, Alteryx Expert, on their pen pal adventure exploring the tools of the others expertise. Autumn and Jacob are ready to share their letters with the public in hopes that the exploration of data processing and data visualization inspires readers to take the next step in their data game. … Read More

Featured Post
ts forecast output

Mastering Time Series Analysis & Forecasting in Alteryx

Mastering Time Series Analysis and Forecasting in Alteryx For those of you that missed my free webinar last week, “How to Create a Time Series Forecast in Alteryx,” (which you can watch the recording of here) I’ve written up a … Read More

Featured Post

A Comparison of Clustering Text vs Non-Text data

A Comparison of Clustering Text vs Non-Text Data Over the last few months I have been focused on doing various flavors of unsupervised learning on text data. I’m eager to share with you some of the fundamental differences that exist … Read More

Featured Post
Time Series Analysis and Forecasting Tessellation Data Analytics Webinar

3 Advantages to Time Series Analysis and Forecasting

3 Advantages to Time Series Analysis and Forecasting A time series is a collection of observations in chronological order. These could be daily stock closing prices, weekly inventory figures, annual sales, or countless other things. Time series analysis, then, is … Read More

Featured Post

3 Reasons Why You Should Change Careers into Data Analytics in 2021

At this point in your career, I’m guessing you are probably curious about the world of data analytics. Perhaps you feel stuck in your current job during the pandemic and want to know how feasible a career switch into data analytics is. … Read More

Featured Post

Tessellation Achieves Alteryx Premier Partner Status

Tessellation Achieves Premier Partnership Status We are very excited to announce that Tessellation has been named an Alteryx Premier Partner for 2021! What is a Premier Partner? Premier Status is the highest achievement level for Alteryx partners. Premier Partners add … Read More

Featured Post

Dynamic Rows and Columns in Tableau

Dynamic Rows & Columns in Tableau Recently Luke Stanke and myself held a webinar discussing some cool ways to enhance P&L statements and other financial reporting. This blog post contains detailed instructions on how to use some of the techniques … Read More

Featured Post

Beyond Dual Axis: Using Multiple Map Layers to create next-level visualizations in Tableau

Beyond Dual Axis: How to Use Map Layers in Tableau 2020.4 to Build Next-Level Visualizations Tableau’s 2020.4 will be its boldest release yet. And while many people are sleeping on the release, a few people have already started to realize … Read More

Featured Post

Toggling Views with Bookmarks in Power BI

Toggling Views with Bookmarks in Power BI Bookmarks are one of my favorite features in Power BI because they allow for a lot of great customization options for user experience. In this blog, I am going to show you how … Read More

Featured Post

Alteryx 2020.4

Alteryx 2020.4 What’s New? In the following, we’ll examine some of our favorite features that in the newest release of Alteryx – let’s get into it!  Alteryx Designer We’re at the last main release for Alteryx in 2020, and while … Read More

Featured Post

Switching Metrics in Power BI

Switching Metrics in Power BI To avoid having multiple tabs with the same charts, but different metrics, you have to get a little creative in Power BI. This blog will walk you through how to enable this toggle functionality in … Read More

Featured Post

Building an Executive Dashboard in Tableau

Building an Executive Dashboard in Tableau Over the course of 2020, I’ve put out more than 25 blog posts. If you had taken the time to read and learn from each blog you would be able to create a one-of-a-kind … Read More

Featured Post

KPI Design Ideas for Tableau

KPI Design Ideas Here are 15 ideas and sources of inspiration for designing your KPIs for Tableau For a very long while I’ve been collecting KPI design ideas. Specifically, I wanted to include. For all the examples I am using … Read More

Featured Post

What-if Analysis in Power BI

https://tessellationio.wpengine.com/wp-content/uploads/2020/09/2020-09-29-17-48-11_Trim.mp4 What-if Analysis in Power BI Leveraging parameters in Power BI can take your scenario planning to the next level. In the example below, we are using mock model output of a linear regression model to perform a what-if analysis … Read More

Featured Post

Custom Sorting in Power BI

Custom Sorting in Power BI Building charts in Power BI is really easy, but implementing specific features within that chart can be difficult. One of the most common requirements that I’ve had to work on being a Power BI consultant … Read More

Featured Post

Tableau Regression Models

Regression Models in Tableau Tableau recently released the MODEL_QUANTILE() and MODEL_PERCENTILE() functions in Tableau Desktop 2020.3. These are game-changing for Tableau. They finally put regression output directly in the hands of Tableau developers. Specifically, MODEL_QUANTILE() allows any creator to calculate … Read More

Featured Post

Creating Power BI Dashboard with Custom Images & Icons

Creating Power BI Dashboard with Custom Images & Icons A great way to tie all of your Power BI reports together in your Power BI Service workspace is to create a great looking dashboard that can serve as a landing … Read More

Featured Post

26 Ways to Enhance your Tables in Tableau

26 Ways to Enhance Tables in Tableau If you develop dashboards and work with data visualizations regularly, then you probably find yourself loathing the moment you are asked for a table of data. You probably think to yourself: “why do … Read More

Featured Post

Alteryx 2020.3

Alteryx 2020.3 What’s New? In the following, we’ll examine some of our favorite features that are in the newest release of Alteryx – let’s get into it!  Alteryx Designer To me, it appears that the last few releases really indicate … Read More

Featured Post

Tableau 2020.1 – Dynamic Parameters

Tableau 2020.1 – Dynamic Parameters There have been a ton of game changing features released by Tableau in 2020, so this post will be the first in a series of blog posts dedicated to exploring some of the newly released … Read More

Featured Post

GOTTA CATCH ‘EM ALL! | WEEKLY CHALLENGE #215 | I CAN ALTERYX THAT

GOTTA CATCH ‘EM ALL | WEEKLY CHALLENGE #215 | I CAN ALTERYX THAT Everyone knows and loves Pokemon. From the adorable Pikachu to the also adorable Cubone, they’re all just so cute. In this week’s challenge, your goal is to … Read More

Featured Post

Understanding Tableau’s IN Function

Understanding Tableau’s IN Function On 8/12/2020, Tableau released Tableau Desktop version 2020.3 that included some fun new features, including Write to Database in Tableau Prep, Export to Crosstab Button, and the IN function. There are lots of great new features … Read More

Featured Post

Trellis Chart in Tableau

Trellis Chart in Tableau Consider the following line chart that shows total sales by quarter over four years and is broken down by the 17 sub-categories. Pretend you are someone in your audience for this plot. Their response will be: … Read More

Featured Post

U.S. MILITARY & HIGH POINTS | WEEKLY CHALLENGE #214 | I CAN ALTERYX THAT

U.S. MILITARY & HIGH POINTS | WEEKLY CHALLENGE #214 | I CAN ALTERYX THAT In this week’s challenge, we have two data sets and three goals. One of the data sets, MIRTA Sites, is ready for analysis. The other data … Read More

Featured Post

Adding Up and Down Arrows to KPIs in Power BI

Adding Up and Down Arrows to KPIs in Power BI A common way to show time period changes in your KPI dashboards is to show metric indicators in the form of up and down triangles colored by the direction (+/-) of … Read More

Featured Post

How to Build a Click to Drill-down Pivot Table in Tableau

How to Build a Click to Drill-down Table in Tableau The following post is a part of a series looking at different options for mimicking Pivot Tables in Tableau: Building Pivot Tables in Tableau Series This option uses Parameter Actions … Read More

Featured Post

How to Build a Dynamic Drill-down Table in Tableau

How to Build a Dynamic Drill-down Table in Tableau The following post is a part of a series looking at different options for mimicking Pivot Tables in Tableau: Building Pivot Tables in Tableau Series. This option is great for situations … Read More

Featured Post

How to Build a Pivot Table in Tableau

How to Build a Pivot Table in Tableau Microsoft Excel will always hold a special place in my heart. Learning how to automate excel through VBA is what made me interested in coding and eventually lead me to Tableau.  A … Read More

Featured Post

Tableau Sales Funnel Template

Tableau Sales Funnel Template The Template Here’s the TL;DR version: Making a funnel chart takes time. Making a beautiful chart takes even more time. Here’s a template for you to automate everything. And here’s the original data. How to use … Read More

Featured Post

Getting COVID-19 Data from the Web with Tableau Prep

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

Featured Post

Ultimate Guide to Tables in Tableau, Part 5: Headers

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

Featured Post

Using Custom Shapes in Tableau

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

Featured Post

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

Featured Post

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

Featured Post

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!

Featured Post

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

Featured Post

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

Featured Post