Articles

Blog

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

Best practices for optimizing snowflake for tableau performance

Best Practices for Optimizing Snowflake for Tableau: Performance

Best Practices for Optimizing Snowflake for Tableau: Performance Why this Series? Katrina and I were chatting a couple of weeks ago. Though she is a skilled Tableau Developer and Snowflake user, she mentioned that she couldn’t find many details on … Read More

Featured Post

Creating Custom Gauge & Needle Charts in Tableau

Creating Custom Gauge & Needle Charts in Tableau We’ll start off by saying that gauges generally aren’t the best data visualization approach. This is because gauges involve two violations of best practices: 1) the gauge is effectively a curved bar … Read More

Featured Post
A Journey into Data and Analytics: How to Succeed in Your First Analytics Role

Live Stream – A Journey into Data and Analytics: How to Succeed in Your First Analytics Role

Learn how to find success in the data analytics industry from four champion analysts at Tessellation. … Read More

Featured Post

Best Practices for Optimizing Snowflake for Tableau: Extract Versus Live Connection

Best Practices for Optimizing Snowflake for Tableau: Extract Versus Live Connection Why this Series? Katrina and I were chatting a couple of weeks ago. Though she is a skilled Tableau Developer and Snowflake user, she mentioned that she couldn’t find … Read More

Featured Post

Consulting 101: What to Do With No Data

Consulting 101: What To Do With No Data If you’re a data visualization consultant, I know that you’ve faced this dilemma: you have your requirements, you understand your use cases and deliverables, but the proper data pipelines are not set … Read More

Featured Post

Changing Spatial Projections in Alteryx & Tableau

Changing Spatial Projections in Alteryx & Tableau I think it is safe to say that most people are familiar with maps. Today, with a smart phone in nearly everybody’s pocket, the use of GPS tools like Google Maps or Apple … Read More

Featured Post

How to Calculate a Dynamic Selected and Prior Fiscal Year Tooltip in Tableau

How to Calculate a Dynamic Selected and Prior Fiscal Year Tooltip in Tableau I recently encountered a problem using a string value of the fiscal year and how to show both a selected year and the prior year based on … Read More

Featured Post
Integrate Your Data Warehouse Into Salesforce With Tableau CRM

Integrate Your Data Warehouse Into Salesforce With Tableau CRM

Integrate Your Data Warehouse Into Salesforce With Tableau CRM Bringing external data into Salesforce is easy with Tableau CRM. In fact, Tableau CRM’s input connectors can access and replicate data from data warehouses, databases, and external applications. In this post, … Read More

Featured Post

Live Stream – The Core Components to Successful Digital Transformation

Learn about the seven key components organizations need to focus on to be effective at digital transformations. … Read More

Featured Post
How to Optimize Your Jupyter Notebooks with Embedded Power BI Reports

How to Optimize Your Jupyter Notebooks with Embedded Power BI Reports

How to Optimize Your Jupyter Notebooks with Embedded Power BI Reports As a Python user, one of the most time-consuming parts of any data science project I complete is producing clean, aesthetically pleasing visualizations throughout the exploratory data analysis process. … Read More

Featured Post

3 Fun Tips for Containers in Tableau

3 Fun Tips for Containers in Tableau! During an internal data visualization learning session at Tessellation I presented on a couple of fun ways that I use containers in my Tableau dashboards. Although many of the folks on the call … Read More

Featured Post

Jake Miknuk’s Journey to Tessellation: There is a Beginning and End to Everything

“There is a beginning and end to everything.” My dad has imparted this little bit of wisdom to me during almost every major transition in my life. Coming from a United States combat veteran who served for a year in … Read More

Featured Post

Live Stream – How to Drive Value with Tableau Server: A Guide for Tableau Developers

Join this one-hour webinar for data developers to learn how to best leverage Tableau Server for publishing, refreshing, and managing access to your workbooks and data sources. … Read More

Featured Post

Create Automated Workflows with Power Automate

Create Automated workflows with Power Automate Automation is a hot topic right now. It’s up there on the list of tech buzzwords right next to Big Data, Machine Learning, and Blockchain. On a more basic level, have you ever thought … Read More

Featured Post

Five Ways to Create a Well-Documented Tableau Dashboard

Five Ways to Create a Well-Documented Tableau Dashboard Ever been asked to update a dashboard you didn’t create? Are you handing off a completed dashboard to a client who will now maintain the dashboard? Ever have a dashboard break months … Read More

Featured Post

Understanding the Basics of Power BI Service

Understanding the Basics of Power BI Service Once you’ve created an awesome Power BI report with an efficient and properly constructed data model, easy to understand visuals, and meaningful metrics using DAX, you need to be able to get that … Read More

Featured Post

From Teaching to Tessellation: Jennifer Hunter’s Journey to Consulting

From Teaching to Tessellation: Jennifer Hunter’s Journey to Consulting From a young age, I’ve loved all kinds of puzzles, strategy games, brainteasers, and anything that involved problem-solving. In school, I quickly became the “go-to” for my friends who needed help … Read More

Featured Post

Live Stream – Data Career Tips with Alex Christensen and Michael Green

Join this webinar hosted by Alex Christensen and Michael Green to ask all your burning questions about building your data analytics career! … Read More

Featured Post

What is Tableau CRM?

This post kicks off our series about Tableau CRM. We’ll start with the basics, then dive deeper into the platform as the series progresses. What is Tableau CRM? Tableau CRM is an end-to-end analytics solution with powerful data management, data … Read More

Featured Post

Well, Here I Am: The Phil Perrin Journey into Data Visualization & Analytics

Well, Here I Am: The Phil Perrin Journey into Data Visualization & Analytics Education I was always good at math. In high school, I skipped our pre-calculus course and went straight into Calculus. I then received our school’s Calculus award! … Read More

Featured Post

How to Calculate Dynamic Point-In-Time Metrics in Tableau

How to Calculate Dynamic Point-In-Time Metrics in Tableau What is a Point-in-Time Metric? Here are several examples: Temperature and weather measurements Pending support tickets Open claims Active devices in IOT data Customer accounts in a specific status Number of employees … Read More

Featured Post
Tessellation Webinar Aug 18 Become an Alteryx Wizard: Discover the time-saving magic of analytic apps

Live Stream – Become an Alteryx Wizard: Discover the Time-Saving Magic of Analytic Apps

Join award-winning Alteryx Expert, Jacob Kahn, to learn how to save time by building intuitive, creative, and customizable user interface applications in Alteryx. … Read More

Featured Post

How to Use Tableau Marimekko Chart Templates

How to Use Tableau Marimekko Chart Templates Marimekko charts–also known as a Mosaic Plot–use two dimensions to visualize a quantitive measure. There are many great tutorials on marimekko charts, but I was recently asked to create a marimekko chart with … Read More

Featured Post

From Urban Planner to Data Analyst: Lynda Chao’s Journey to Tessellation

From Urban Planner to Data Analyst: Lynda Chao’s Journey to Tessellation The Early Signs Growing up, I have always enjoyed creative activities; from doodling to ceramics or graphic design, this part of me persisted well into college. I knew I … Read More

Featured Post

Growing Data Analytics Technologies: Getting Started with Snowflake

Growing Data Analytics Technologies: Getting Started with Snowflake If you’ve been around the data or database world for a minute, you’ve probably heard of Snowflake before. It is one of the fastest growing technologies disrupting and improving the way we … Read More

Featured Post

Power BI Beginner Basics: How to Create Toggle Switches and When to Use Them

Power BI Beginner Basics: How to Create Toggle Switches and When to Use Them From the airplane mode switch in phone settings to the switch on your blender, both physically and digitally we use toggle switches everywhere. We interact with … Read More

Featured Post

Forecasting Inventory in Tableau Using Relationships

Forecasting Inventory in Tableau Using Relationships One of my favorite features introduced to Tableau in the past couple of years has the ability to use relationships in data models. If you aren’t familiar with data modeling using relationships, you can … Read More

Featured Post

Live Stream – How Kraft Heinz Saved 5,500 Hours with Analytics Automation

What to Consider When Selecting Your Business Intelligence Platform Join this one-hour webinar hosted by Alteryx in partnership with Tessellation and the Kraft Heinz Company. We’ll discuss how analytics automation can save thousands of hours in supply chain management. Date: … Read More

Featured Post

How to Create a Power BI App

How to Create a Power BI App We all know that Microsoft Power BI is a robust tool. But did you know that you can create your own Power BI App either for your own use or your end-users? And … Read More

Featured Post

Facebook Prophet Tutorial: How to Use Time Series Forecasting

Facebook Prophet Tutorial: How to Use Time Series Forecasting Dealing with uncertainty is difficult. If we knew exactly what would happen, planning for events and outcomes would be a lot easier. In the case of a business, knowing what is … Read More

Featured Post
How to Use Data Science for Marketing Analytics

Live Stream – How to Use Data Science for Marketing Analytics

Learn how to use data science for marketing analytics to optimize your future marketing spend and promotions, all using Python. … Read More

Featured Post

Dashboard Design Best Practices: The Secrets to Good Prototyping

Dashboard Design Best Practices: The Secrets to Good Prototyping This blog is the third in a series on prototyping. In this series, our first post walked you through why prototyping will benefit your development process. Our second post lists out … Read More

Featured Post

How to Use Spatial Analysis Tools: Making Custom Shapefiles in Alteryx

Making Custom Shapefiles in Alteryx Last night I received a message from my colleague here at Tessellation, Alteryx ACE Nick Haylund. The message was a screenshot from a tweet that displayed an interesting map of the United States. Disregarding the … Read More

Featured Post
network visualization of harry potter characters screen time

How to Create Network Visualizations in Tableau

How to Create Network Visualizations in Tableau Network visualizations display relationships between elements by linking nodes with common characteristics. This allows the user to visualize clusters quickly and determine relationships. Unfortunately, the development process in Tableau isn’t as straightforward. To … Read More

Featured Post

Choosing the BI Tool that is Right For You

Choosing the BI Tool That is Right for You Choosing a BI tool for your organization can be tedious. Get the decision right, and you’re a hero. Choose a tool that ends up not meeting people’s needs and being too … Read More

Featured Post
A colorful banner image with text "Restructuring Data in alteryx files with multiple column headers"

How to Restructure Data in Alteryx: Files With Two Column Headers

How to Restructure Data in Alteryx: Files With Two Column Headers As analysts and developers, we don’t always have control over the data we receive and how it is formatted. We still need to do our best to deliver what … Read More

Featured Post

Customer Retention Analysis: How Data Science Can Predict Customer Churn

Customer Retention Analysis: How Data Science Can Predict Customer Churn As an analytics consultant, I talk to a lot of managers that wonder what data science can actually do for their business. Oftentime I hear: … it’s just an overrated … Read More

Featured Post

How to Use Multiple Collapsible Containers in Tableau

How to Use Multiple Collapsible Containers in Tableau Tableau 2021.2 presented a new feature that allowed for collapsible containers on dashboards. This tutorial shows you how to use multiple collapsible containers on a dashboard. For background, you will be embedding … Read More

Featured Post

Dashboard Design Best Practices: How To Prototype

Dashboard Design Best Practices: How To Prototype This blog is the second in a series on prototyping. In this series, Autumn Battani and I will walk you through why prototyping can help benefit your development process, options that you have … Read More

Featured Post
Photo of Taguma Nicholas

Taking Apart Toys to Tessellation: Taguma Nicholas’ Journey to Analytics Consulting

Taking Apart Toys to Tessellation: Taguma Nicholas’ Journey to Analytics Consulting Curiosity Turned to Passion The most distinguishing attribute I inherited from my Father is a sense of curiosity, his interest in Computer Programs and Design, and mine in whatever … Read More

Featured Post
Photo of a Sudoku puzzle

How I Used Alteryx to Solve Sudoku Puzzles 4,000 Times Faster

How I Used Alteryx to Solve Sudoku Puzzles 4,000 Times Faster Anyone who knows me well knows that I love board games and puzzles. I also love to develop algorithms that play board games or solve puzzles for me. In … Read More

Featured Post
Why Your Data Analysts NEED to Know SQL

Live Stream – Why Your Data Analysts NEED to know SQL

Join this one-hour webinar with Data Coach Co-Founder & SQL expert, Alex Christensen, to learn why SQL is important for data analysts, which SQL you should learn, and how to master SQL quickly. … Read More

Featured Post
Dashboard Design Best Practices-Prototyping

Dashboard Design Best Practices: Why You Should Prototype

Dashboard Design Best Practices: Why You Should Prototype When building dashboards, there’s a large part of the job that happens outside of Tableau. In a previous blog, I talked about the importance of managing user feedback and how I go … Read More

Featured Post
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

Mastering the Network Analysis Tool in Alteryx

Mastering the Network Analysis Tool in Alteryx Alteryx comes packaged with lots of tools. Although there are over 200 tools to choose from, most users will never need to wander far from the standards: Select, Formula, Join, Summarize, and friends. … Read More

Featured Post
Give Tips for Managing a Successful Data Analytics Project

5 Tips for Managing a Successful Analytics Project

5 Tips for Managing a Successful Analytics Project Like a lot of people in analytics, I have had a winding career journey that led me to Tessellation. I was an academic research scientist performing in vivo experiments on models of … Read More

Featured Post

Live Stream – How to Become a Data Analytics Consultant in 2021

During this webinar, learn the essential non-technical skills that data analytics consulting firms require when hiring new analytics consultants from Tessellation partner, Alex Christensen. … 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

Live Stream – How to Become a Data Analytics Consultant in 2021

During this webinar, learn the essential non-technical skills that data analytics consulting firms require when hiring new analytics consultants from Tessellation partner, Alex Christensen. … Read More

Featured Post