These are articles that focus on the usage of Alteryx, the data prep, blending, and computational software.
Introduction Flat-files have been used around the world of the past few decades to store a lot of data. Flat-files were originally designed to save space, although they do have an intrinsic inefficiency because spaces are used as placeholders instead of using a delimiter, like a comma.
Introduction This post is NOT really intended to be a super-clean and comprehensive, step-by-step instruction set for how to draw Alteryx-generated polygons in Tableau. However, if you are willing to do a little work, you will be able to reproduce the results in this article.
Introduction One of the most popular topics I have written about in this blog is a method I call “Tableau buckets”. I have been very surprised by the number of people that have found this concept to be useful. For this reason, I am going to extend this “bucket” concept to Alteryx workflows.
Introduction Sorting data is fundamental technique and is a skill that anyone that frequently works with data needs to possess. I have sorted a lot of data through the years, for many different reasons. Sometimes the only way to get a job done when working with a wide variety of data sources that might include periodic data…
Introduction This is blog post number 101, and I now have a clarity about 3danim8’s blog that I did not have before I started writing it a year and a half ago. It took me writing the previous 100 blog posts to gain this clear vision and to develop my mission statement. It only took me 536 days,…
Introduction I have been thinking a lot about how Alteryx and Tableau work together to help me innovate when solving business and science problems. In this article, I’m going to explain what I mean by the term innovation and how I use Alteryx and Tableau to achieve this term.
A New Vision This was a difficult article for me to write for a lot of reasons, but I am glad that I wrote it. In this two-part article, which will be my 99th and my 100th blog posts, I revisit my past and present a revised vision for my future as a technical blogger.
This article includes a lot of tips for working with dates in Alteryx. The dates can be read from flat files but I also include some tips for reading dates from *.csv files.
Introduction I started using Alteryx in May, 2014, or less than six months ago. I have written a few blog posts for beginners and a recent post about a very impressive result I achieved using Alteryx. Now all of a sudden, the light has shined for me. I get it and I see the brilliance…
Introduction I previously wrote a blog post about strategies for reading flat-files (fixed-format, un-delimited ASCII files) to get the flat-file data ready for Tableau analysis. That post was written before I became an Alteryx user.
Introduction I started using Tableau with Version 3.6 way back in February, 2008. Since that time, I have continued to use Tableau about every day, with several thousand data files investigated over this time from a wide range of businesses.
Introduction In Part 4 of this new Alteryx-user series, I utilize the Alteryx/Tableau techniques shown in Parts 1 – 3 in a comprehensive example using data from the National Football League (NFL). I chose the NFL because the regular season begins in about a week and Americans love this sport (myself, included). Once I crunched the…
Introduction In Parts 1 and 2 of this series, I showed how I use Tableau to help me understand Experian and Dunn and Bradstreet (D&B) data that can be strategically accessed via Alteryx. This extracted data can then be used in quantitative business studies or for personal usage. This post provides an example of personal usage…
Introduction This is the second of a six part series of using Tableau to help with Alteryx applications, especially for new Alteryx users. In this post, I discuss the usage of the business database that is maintained by Dunn and Bradstreet and is accessible via Alteryx. This database allows Alteryx users to access information on…
Introduction If you are an experienced Alteryx user that has the privilege to use the “complete package of Alteryx”, which includes mapping, demographic and business data, you may already have techniques to handle the issues that I discuss in this blog post series. This series will be focused on using Tableau to help with Alteryx usage, especially…