Inspiring Ingenuity

Alteryx, Bicycles and Teaching Kids Programming.


4 Comments

Alteryx: Amazon S3 & the Gallery

AmazonS3DownloadA variety of questions have come up from Alteryx users that all have the same answer:

  • The Alteryx Gallery will only allow me to upload about 100MB of data, how do I upload more?
  • I need to change my data daily/hourly/monthly for my Gallery module, how do I do that without re-uploading my entire app every time?
  • How do I persist data from run to run in a Gallery module?
  • How do I share data in Alteryx Desktop with coworkers/clients/partners without sending huge files around?

The answer to all of these questions is to use the Amazon S3 tools. What is S3?  Amazon says it is:

Amazon S3 is storage for the Internet. It is designed to make web-scale computing easier for developers.

Amazon S3 provides a simple web-services interface that can be used to store and retrieve any amount of data, at any time, from anywhere on the web. Continue reading


2 Comments

Alteryx: Interactive HTML Visualizations

image

In the last 2 weeks, I have introduced (as a prototype) the idea of embedding HTML visualizations into Alteryx.  If you have not read them you can read Part 1: JSON Data Output and Part 2: HTML5 Visualizations.  In last week’s post, I explored a generic HTML 5 output tool and a sample visualization based on NVD3.  Although I was able to return a very nice visual from NVd3, all interactivity was lost.  This week I want to show a prototype with the interactivity working the way it should in NVD3.

Looking at the screenshot on the left, you can see an App running in the Gallery with a NVD3 chart.  In that particular screenshot, my mouse is over the US in 1995 so NVd3 displays a popup with the relevant information at that point.  You can also click on the modes (Stacked, Stream & Expanded) to show different views and you can click on the countries at the top, or in the graph itself to only show a subset of the data.  This is how NVD3 is designed to run. Continue reading


3 Comments

Alteryx: Connecting to Cloud Services

Output

…or consuming the Google Directions API…

There are many functions available as cloud services that can be used within Alteryx.  For instance, the Alteryx geocoder is fairly good, but sometimes people want more, or just want to try other options.  Instead of asking Alteryx to do something about it (and waiting for a future release), many of the APIs can be utilized from directly inside of Alteryx.  A quick search will find a variety of options, many of which could easily be wrapped by an App or Macro. Continue reading