April 19, 202610 min read
Creating Interactive Pie Charts with Show Me Features
Learn to create customized pie charts in Tableau using the Show Me feature, with options for labels, sizing, and color adjustments.
Garfield Stinvil
G
Garfield Stinvil
48 articles
Garfield is an experienced software trainer with over 16 years of real-world professional experience. He started as a data analyst with a Wall Street real estate investment company & continued working in the professional development department at New York Road Runners Organization before working at Noble Desktop. He enjoys bringing humor to whatever he teaches and loves conveying ideas in novel ways that help others learn more efficiently.
Since starting his professional training career in 2016, he has worked with several corporate clients including Adobe, HBO, Amazon, Yelp, Mitsubishi, WeWork, Michael Kors, Christian Dior, and Hermès.
Outside of work, his hobbies include rescuing & archiving at-risk artistic online media using his database management skills.
Articles
April 19, 202612 min read
Line Charts: Customization Techniques Explained
Create a better line chart by overlaying two synchronized charts—one a line, the other using circles or custom shapes placed via dual...
Garfield Stinvil
April 19, 20269 min read
Creating Advanced Butterfly Charts
Now, this is the final version. This is the advanced version. I would like a butterfly chart where the text is in the middle.
Garfield Stinvil
April 19, 20265 min read
MHierarchy Techniques in Tableau
Organizing the data on your sidebar. I have three basic topics to go over here, which is brand new information that I've not shown you. So...
Garfield Stinvil
April 19, 20266 min read
Alt Hotkeys in Excel: Keyboard Shortcuts
Hotkeys. You're able to use Excel on a Mac and on a PC.
Garfield Stinvil
April 19, 202612 min read
Excel Tables: Tips for Level One Students
Tables. In this section we're going to talk about tables.
Garfield Stinvil
April 19, 20266 min read
Data Visualization: Top 10 Countries by Life Expectancy
Explore how to create an area chart in Tableau that visualizes life expectancy data across the top ten countries, with filters and clear...
Garfield Stinvil
April 19, 202610 min read
Tableau Dashboards: Techniques for Dynamic Visuals
Learn how to build dynamic Tableau dashboards by combining charts, text, images, and navigation buttons into interactive visual layouts.
Garfield Stinvil
April 19, 20269 min read
Absolute Cell References in Excel Calculations
Absolute cell references. Absolute cell references are very important in Excel when you're working with calculations where you have...
Garfield Stinvil
April 19, 20264 min read
Visualizations in Tableau: Data Sources to Dashboards
Here is the Tableau workflow, the linear step-by-step process.
Garfield Stinvil
April 19, 20263 min read
Remove Duplicates in Excel Using Data Tools
Remove Duplicates. In this section, we'll use Remove Duplicates to eliminate duplicate data.
Garfield Stinvil
April 19, 20268 min read
Basic Excel Calculations and Order of Operations
Calculations. Let's take a look at how you can perform very simple calculations in Excel.
Garfield Stinvil
April 19, 20269 min read
Data Cleaning in Tableau with the Data Interpreter
So, the Data Interpreter is a feature that Tableau sort of like gives to users to help fix some very simple data issues. And so, it's not...
Garfield Stinvil
April 19, 20265 min read
Understanding Tableau's Pricing Tiers
Tableau has three general categories of users for the paid version. Creators. Creators can prepare and build content.
Garfield Stinvil
April 19, 20266 min read
Managing Excel Worksheets with Ease
Worksheets. In this section, we're going to talk about managing your worksheets in your Excel file.
Garfield Stinvil
April 19, 20265 min read
Windows Management: Keyboard Shortcuts for Excel
In this section, we're going to talk about how to work with windows inside of the Windows operating system. This particular topic is not...
Garfield Stinvil
April 19, 20266 min read
Regression Analysis with Excel's Analysis ToolPak
Simple linear regression. I want to estimate the relationship between variables.
Garfield Stinvil
April 19, 20264 min read
Growth Patterns: Linear vs. Exponential Forecasting in Excel
Series forecast. In this section, we're going to take a look at two different types of growth, linear and exponential growth.
Garfield Stinvil
April 19, 20265 min read
AND & OR Functions: Logic in Real-Life Scenarios
AND/OR logical functions. In this section, we'll take a look at how you can use the AND and OR functions to test if multiple criteria are...
Garfield Stinvil
April 19, 20264 min read
Creating Dynamic Visuals with Pivot Charts in Excel
Pivot Charts. Pivot Charts are dynamic graphical representations of Pivot Table data that work in tandem with pivot tables.
Garfield Stinvil
April 19, 20265 min read
Streamlining Daily Reports with Macros for Accuracy
In this section, we're going to create a macro that's going to format a report that we are going to imagine we need to create every single...
Garfield Stinvil
April 19, 202611 min read
Multi-Input Functions: From Text Extraction to Rounding
The main purpose of this section is to show you how to use functions that may take more than just one input. Earlier on in our Excel...
Garfield Stinvil
April 19, 20264 min read
Data Visualization: Mastering Labels and Tooltips
Labels. So again, my pictures are off, but these are the exercises that we did with paper clips for the subcategory group and also for...
Garfield Stinvil
April 19, 202612 min read
Data Organization: Sorting, Filtering, and Subtotals in Excel
Sort and Filter. We will use Sort and Filter to find and organize data in large databases.
Garfield Stinvil