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
Articles
Blog
Data analytics & business intelligence articles written by renowned data experts.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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