-
Alteryx: Exploring Joins
The above snapshot shows a simple join in Alteryx along with a description provided by the Alteryx Designer. Joining both datasets (colored in green) shows you that we are going to join both datasets by a certain ‘ON’ criteria of dimensions. Going to the example I discuss in the video, I joined both csv files…
-
MLB Run Differential
Using Alteryx Designer, we take a look at our MLB database to build the same run differential measure that was visualized in Tableau. We look at how a simple workflow can be constructed in Alteryx. We also build some simple charts in the designer using the Interactive Chart Tool. Below are the following tools I…
-
Creating a Dashboard with Call Center Data
Today we create a simple dashboard using call center data. Before we dig into the data; let’s discuss call center data conceptually. Call center data creates various opportunities for data developers to visualize. There are many ways to examine data generated by the normal operations of a contact center. As someone who has worked with…
-
Getting To Know Alteryx
I just downloaded Alteryx (the trial version)! Let’s snoop around. Above is the layout I get when Alteryx loads. I placed some box call-outs in the screenshot above to discuss. Initial Thoughts I like that when navigating around the tool palate; Alteryx gives you examples of each tool in use. For those that learn more…
-
Create Pareto Chart and Box Plot Chart in Tableau
This week I took a stab at creating both a Pareto chart and Box Plot chart. A Pareto chart is a dual chart with bars and a line graph; individual values are represented by bars and the building cumulative total is represented by a line graph. Named after Italian engineer Vilfredo Pareto who made the…
-
Strengthen Your Dashboards with Parameters
What are parameters? Parameters are a workbook variable that is defined as a number, date or string. It can act as a filter, reference or replace a value in your data source. With parameters you can also create ‘parameter actions’ that let’s the user dynamically change set parameters when interacting with the viz. I like…
-
Creating a Waterfall Chart in Tableau
A waterfall chart is a type of bar chart that can explain net change of a measure from across all its contributing cohorts. This is a bar chart that is mostly used in the financial services industry. Analyzing change over time can show attribution of change to specific groups to the overall change of said…
-
Resume Writing with Tableau
How many of you have been caught in that never ending cycle of submitting resumes during your job search? You find yourself in stuck in a numbers game; working hard to send so many resumes to only get a fraction of those submissions returned with a call for an interview. However, you don’t stop there…,…
-
Resurrecting An Old Visualization
This week I take a look at a prior dashboard I made in the past (in my Tableau Public profile) and using the same data give the dashboard a tableau makeover. Dashboard: I take a look at average Fahrenheit temperatures in my hometown of El Paso, TX. It is located in West Texas and is…
-
Breakdown: Level of Detail (LOD) Calculations
Foundation of a LOD calculation Just like a SQL query, there are specific ‘keywords’ to a LOD calculation. In SQL, you have a select statement, from statement and may also have a variation of other keywords to query specific cohorts of data. Let’s look the keywords needed to create a LOD calc: Example of a…