Articles

Blog

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

Creating a Measures Table in Power BI

Creating a Measures Table in Power BI When navigating through your data model in Power BI Desktop, it’s easy to get lost, especially if you have a data model with several tables and a multitude of measures. In order to … 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

Live Stream: How to Switch Careers into Data Analytics in 2021

Live Stream: How to Switch Careers into Data Analytics in 2021 February 23rd, 2021, 8AM PST | 10AM CST | 11AM EST Learn career path advice to switch careers to data science or data analytics in 2021. Feeling stuck in … Read More

Featured Post

Live Stream: Thought Leader Masterclass Preview: Tableau Advanced Calculations​

Live Stream: Thought Leader Masterclass Preview: Tableau Advanced Calculations March 3rd, 2021, 12:30PM PST | 1:30PM CST | 3:30PM EST Throughout 2021, Data Coach will release six exclusive masterclasses instructed by renowned thought leaders in Tableau, Alteryx, Power BI, and … Read More

Featured Post
Alteryx2021.1

Alteryx 2021.1

Alteryx 2021.1 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!  Power to the Process in 2021.1 We have our first NEW release of … Read More

Featured Post

Import v Direct Query: Here’s What You Need to Know

Import v Direct Query: Here’s What You Need to Know One of the first things any Power BI developer needs to know is whether to check that Import or Direct Query box while connecting to data in Power BI Desktop. … Read More

Featured Post

Using the Optimization Tool in Alteryx

Using the Optimization Tool in Alteryx As any user can attest, Alteryx is a fantastic and powerful tool. With well over 100 pre-built tools you can quickly and easily clean messy data, perform calculations, or analyze spatial information. Because Alteryx … Read More

Featured Post

Circular Bar Charts: Why You Should Make Them But Never Share Them

Circular Bar Charts: Why You Should Make Them But Never Share Them It’s time to deep dive into a data visualization foundation: Bar charts! In this article, we will deep dive into the allure of Circular Bar Charts and help … Read More

Featured Post

Managing User Feedback

Managing User Feedback Performing technically is only part of the battle of professional dashboard building; another important piece is managing user feedback. The goal is to have the dashboards be as efficient and useful as possible and gathering input can … Read More

Featured Post

Live Stream: Taking the Guesswork out of Sales Forecasting

Live Stream: Taking The Guesswork Out of Sales Forecasting February 16th, 2020, 12PM PST | 2PM CST | 3PM EST In this webinar, you will learn how to leverage cutting-edge data science techniques to create a powerful and accurate forecast … Read More

Featured Post

A Beginners Tableau Tutorial: How to Get Started

A Beginners Tableau Tutorial: How to Get Started Are you thinking of getting started with Tableau? Maybe people at your organization have already been using Tableau and you’ve recently been encouraged to get on board. Or perhaps you are looking … Read More

Featured Post

How to Build a Ranked Small Multiple Bar Chart in Tableau

How to Build a Ranked Small Multiple Bar Chart in Tableau I like big bar charts…and I can not lie.  Thank you to all three of you who laughed at my corny joke. But for real, I think bar charts … Read More

Featured Post

How to Publish to Tableau Online with Alteryx

How to Publish to Tableau Online from Alteryx Designer In my several years of supporting Alteryx Server and Tableau Server, one of the most frequent questions I get from Alteryx users is: “How do I publish to Tableau Server?” The … 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

Underrated Tableau Features

Underrated Tableau Features There are a lot of resources available to read about the shining stars of Tableau, the showstoppers. This is not that blog. This is the blog for the underdogs, the little things that people often overlook that … Read More

Featured Post
Sentiment Analysis word cloud

Code-free Sentiment Analysis for Business

What is Sentiment Analysis? “This is the worst!” cried Reginald. Cynthia, his long-time business partner, hurried into the room. “Is everything alright?” she asked. Reginald, usually an exuberant man, sighed and said “we lost the Smithfield account. I don’t know … Read More

Featured Post

YTD Flags in Power Query

YTD Flags in Power Query Dates tables are an integral part of any comprehensive data model. Dates tables allow you to normalize a variety of different date fields and perform calculations and filtering on all of those different fields at … 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

Mapping Lines with Endpoints in Tableau

Mapping Lines with Endpoints in Tableau Tableau offers its users a vast array of geospatial tools for mapping and other geospatial analysis including buffer calcs, distance calculations, and the ability to drill down into different levels of geospatial granularity with a click of the … 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

Connecting Jira to Snowflake using Fivetran

Connecting Jira to Snowflake with Fivetran This post is a continuation of the series that examines the simplification of data integration leveraging Fivetran and Snowflake. Fivetran nearly eliminates the development time required to ingest data from a vast number of … Read More

Featured Post

Alteryx Server 101: Organizing Content in the Alteryx Gallery

Alteryx Server 101: Organizing Content in the Alteryx Gallery Just got Alteryx Server at your organization? Get ready for some serious time saving when you automate your work! Server is a fantastic product, but the Gallery has a whole language … 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://www.tessellationtech.io/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

Alteryx Server: Workflow Credentials

Alteryx Gallery Workflow Credentials Picture this: your company just got Alteryx Server. You are dazzled by the idea of scheduling your workflows and sharing your analytic apps. You publish your perfectly-working workflow, which utilizes an excel file hosted on a … Read More

Featured Post

Fact of Fact Analysis Using Power Query

Fact of Fact Analysis in Power Query Building a data model in Power BI can be extremely easy. When primary keys match foreign keys one to one and when tables are built with a star schema in mind, things go … Read More

Featured Post

Optimizing Power BI Reports

Optimizing Power BI Reports Building performant reports is important in gaining trust with stakeholders and ensuring user adoption. Here are some practical and easy tips on how to optimize your Power BI reports! These tips will be broken down into … 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 Isotype Plots

Isotype Plots in Tableau What are Isotype Plots? Isotype plots are a blend of visual language that emphasizes quantitative data with symbolism that is often associated with descriptive imagery. If you wanted to simplify it its very similar to a … 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

Analytics 101: Descriptive, Predictive and Prescriptive Analytics

Analytics 101: Descriptive, Predictive, and Prescriptive Analytics One thing I’ve learned in my time as a data scientist has been that the term “analytics” means something different to just about anyone you talk to. Answers I’ve gotten ranged from basic … 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

Tableau 2020.3 – Write to Database in Tableau Prep

Tableau 2020.3 – Write to Database in Tableau Prep This post is the fifth in a series of posts examining a whole host of game changing Tableau features that have been released in 2020. In the previous edition of this … 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.2 – Relationships

Tableau 2020.2 – Relationships This post is the fourth in a series of posts examining a whole host of game-changing Tableau Desktop features that have been released in 2020. In the last post we discussed the nuances of Set Controls. In … Read More

Featured Post

Tableau 2020.2 – Set Controls

Tableau 2020.2 – Set Controls This post is the third post in a series examining a whole host of game-changing Tableau Desktop features that have been released in 2020. In the previous post in this series, we covered Viz Animations from the … Read More

Featured Post

Tableau 2020.1 – Viz Animations

Tableau 2020.1 – Viz Animations This post is the second in a series examining a whole host of game changing Tableau Desktop features that have been released in 2020. In the last edition of this series we covered Dynamic Parameters. In … 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

The Easiest Way to Webscrape Tweets with Python

UPDATE: Since this blog post was published, it seems that the key package used, GetOldTweets3, has been degraded and is no longer able to be imported or installed. I am looking into this issue. For now, I recommend looking into … 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

Top 5 Power BI Features That Saved Me This Week

Top 5 New Power BI Features That Saved Me This Week Power BI is such a powerful tool, but every week that goes by makes me realize that I haven’t come close to realizing it’s full potential! Every week I … 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

Pop Out Side Bars in Tableau

Pop Out Container Side Bars in Tableau This blog will show you how to use containers to create pop-out side bars in your Tableau dashboards. Side bars allow you to display extra information or context around a data point, but … Read More

Featured Post

Report Page Tooltips in Power BI

Report Page Tooltips in Power BI It can be a struggle to fit all the details you want displayed about a certain data point in your report. Often, it’s getting to that next level of your data’s granularity that can … Read More

Featured Post