-
Airport On-Time Performance Dashboard
Using DFW data we look at key measures that are important to the efficiency of airport operations. For those that travel by air, you know that there are many pieces that move behind the scenes to ensure your flight leaves on time. There are many factors that may lead to a delay or worst a…
-
Creating a ‘Long-Form’ Dashboard
Using 2023 Tour de France Data So I am not sure if ‘long-form’ is the official term for these types of dashboards but for the sake of this conversation let’s pretend it is. I saw these types of dashboards for the first time years ago at a Tableau Conference when many Tableau Public dashboards were…
-
Using Images in your Dashboard Background
Below is a screenshot of a zoomed out dashboard with 4 images acting as the background for eventual views to be floated over the images: Here are some steps in producing the dashboard template above: Join me below as I walk through a quick construction of the dashboard screenshot above:
-
Alteryx: Data manipulation with spatial data
I received some Tour de France data from an online cycling website today. The data was in GPX format and it was a list of coordinates by stage. During the 2023 event, there was twenty-one stages starting in Spain and ending in France. Each GPX file is a sequential list of coordinates (latitude, longitude); each…
-
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…
Ralph's Data World 