Alteryx Designer Desktop Ideas

Hello!

I have a very regional problem, when we use reporting tools, they seem to be encoded in ansi, but in France, we use a lot of accents, and when we want to use the mail tool, we have to "write wrong" with e instead of é for instance, would it be possible to make it possible for us to use accents, I saw a solution in this post (https://community.alteryx.com/t5/Alteryx-Designer-Discussions/French-Characters-in-an-Email-using-Re...) but if it would be possible to have the option directly in the reporting tools it would be a lot easier for us to use them in an automated way!

Other applications I work in reguarly utilize right-click menus.  Sometimes those menus seem annoying, but in working with Alteryx, I realize it’s actually quite smart because it eliminates unnecessary wrist movement.  In the screenshot below, I have highlighted a bunch of fields.  The boxes were previously unchecked and I wanted to check them to bring them into my workflow.  I highlight them, and if I were in a different application, I would just right click and get access to everything that is in the options menu, but in Alteryx, I have to actually move the mouse to the options menu.  This might seem super nitpicky, but as someone who is currently suffering from overuse injuries in my wrists and hands, I really appreciate minimal wrist movement.

When you add a tool in the canvas, the annotation is automatically set (for example the formula, or connection configuration etc). You can then customize the annotation text in the "Annotation" tool's tab. But sometimes it can be useful to revert to the "automatic" annotation, and it doesn't seem possible once you set it to something different.

Apparently there is currently no way to reset a tool's annotation text to the automatic value.

I've found a way to do it by editing the xml content of the file : as far as I know you just have to delete the <AnnotationText>[...]</AnnotationText> tag and reload the file, and the annotation gets back to the default "automatic" value, which is still present in the <DefaultAnnotationText> tag.

I think a simple button in the tool's annotation tab to reset it would be nice.

Thank you!

As with Output Data tool, it would be very helpful to have this option within the Calgary Loader tool.  I have a series of ordered analytic apps and if I could name the Calgary database using the "Take File/Table Name from Field" option I would be able to chain the apps and be much more efficient.

Thanks.

Idea:

Let's add the universal PMML predictive markup language to rapidly deploy our predictive models. 

Rationale:

Most of the predictive models created are essentially built to be deployed into well known enterprise level decisioning tools.

These decisioning tools are working at banks, non bank financial institutions, credit card issuers, insurers on a daily basis.

If Alteryx want's to replace SAS, SPSS and similar competitor this PMML addition seems to be a must.

They all have a common markup language and even with the newer version we can deploy almost all data pre-processing steps too...

Current status in Alteryx as I'm aware of:

Only case where Alteryx and PMML comes close is the following link; http://www.alteryx.com/topic/pmml promising including PMML in the upcoming releases in 2012. And then no word of it. The writer is retired already and no word since 2012 (3 yrs is a long time span). 

What to do:

On easy way is already done for R, this is a Java library for converting R models to PMML https://github.com/jpmml/jpmml-converter

Clients:

FICO is one of the well known credit bureaus worldwide and also the vendor of decisioning software. They also have an Analytics Modeler Suite. All FICO systems are PMML compliant. Chek it out: http://www.decisionmanagementsolutions.com/2014/10/17/first-look-fico-analytic-modeler-suite-jtonedm...

Also Experian is one of the other big software vendors in the Analytics space with decision management tools and they are actually a partner of Alteryx too... Their well known widely implemented Powercurve tool has PMML language import too... Check it out: http://jtonedm.com/2014/05/13/first-look-experian-powercurve-update/

IBM ODM is a nother vendor for decisioning tools in the enterprise level. They also have PMML integration, look; http://www.prolifics.com/blog/odm-integration-spss-predictive-analysis-suite-part-1-pmml-import

Competitor status:

SAS supports PMML export from SAS Enterprise Miner

IBM SPSS products (Modeler and Statistics) offer a great deal of support for PMML

KNIME is one of the leaders in processing PMML documents 

RapidMiner has a PMML extension

MicroStrategy strongly supports the standard

I would like the ability to take custom geographies and write them to a table in Exasol. We visualize our data with Tableau and rely on live connections to Exasol tables rather than Tableau extracts. One shortcoming with spatial is that we have to output our custom geographies as a .shp file then make a Tableau Extract.  This would save us a few steps in sharing this data with our users. 

Thanks!

Wild card read option (Sales_*.csv ) works for reading files of the same structure available on a standard windows network/local fileshare. It would be good to have the same feature for reading from HDFS via the HDFS connection option using the input tool.

Regards,

Sandeep.

Modify the taskbar icon while according to workflow status to provide a visual queue when workflows are running/completed, like the SAS running man or the Teradata sunglasses... The Alteryx A could be going places.

Session connection to Google Sheet exists for 60 minutes. If someone wanted to keep this for more time then "User Login" option requires re-entering credentials every 60 minutes.

However, we can use the Developer Login0 to bypass this limitation. This method requires sign-in using Google API credentials. This option requires obtaining a Client ID, Client Secret, and Refresh Token and does not require re-entering credentials to run a workflow.

My question - can you address this issue in next release of Alteryx?

Spark ODBC is really faster than Hive, at least for GUI.

However, two things are missing :
1/ Append existing for the write date (exists his way on Hive)

2/ability to put "overwrite" even if the table does not exist (it works this way on Hive)

These two drawbacks limit severly th

Data profiling feature in the Browse tool is a great feature, however, when your working with an extremely large data set, it can a large amount of time to fully render.

My idea is if Alteryx can make a pre-determination whether the data is so large that it'll take a substantial amount of time to profile the data. If it does, to not profile immediately, rather, display a message where the profile info would be letting the user know that it may take a while to generate with a "Generate Profile" button if the user needs to see it.

Another option would be to only profile a sample of the data and present the user an option to profile everything.

Thanks,

Jimmy

I was with my friends at Limited Brands yesterday and they pointed out to me a way to improve Alteryx.  While designing a workflow, each time you add an input tool to the canvas you literally have to start from scratch to add additional tables from either a db datasource or file source (e.g. access).  With other tools, you can drag multiple tables to the canvas at once and come back later and add more inputs without having to select your source, see a list of tables etcetera.

On their behalf (they may post another suggestion), I am posting this idea.

Thanks,

Mark

The idea is specific for streaming analytics;

Alteryx seems it can be scheduled frequently to see if there is an update to a file in question.

It would be awesome to enable a listener which will be auto triggered when;

• ay new line is added to a data set (probably a log file) or
• an update to an existing row in a database (then the relevant score will be recalculated for ex.)

It will be straight forward to provide reactive responses to a log file and voila!

Alteryx automation and alteryx server will become a "complex event processor"...

complex event processing with Alteryx?

Here is a link to wiki page for CEP: https://en.wikipedia.org/wiki/Complex_event_processing

@GeorgeM would you think this will put Alteryx to another gartner MQ* as well?

*https://www.gartner.com/doc/3165532/add-event-stream-processing-business

"Enable Performance Profiling" a great feature for investigating which tools within the workflow are taking up most of the time.This is ok to use during the development time.

It would be ideal to have this feature extended for the following use cases as well:

• Workflows scheduled via the scheduler on the server
• Macros & apps performance profiling when executed from both workstation as well as the scheduler/gallery

Regards,

Sandeep.

It would be great if you could link a comment box to an object.  This would be great because if the objects moves for what ever reason the comment would stay with it.   

When a tool container is disabled, I'd like the lines that are going into it to be different from "enabled" lines. 

They could be grey or dotted for example.

When working on a workflow and disabling containers, I find that the lines entering disabled containers become confusing or cluttering. It would be much simpler to focus my attention efficiently if lines that remain enabled could be distinguished quickly.

Designer should support statistical testing tools that ignore data distribution and support Statistical Learning methods.

Alteryx already supports resampling for predictive modeling with Cross-Validation.

Resampling tools for bootstrap and permutation tests (supporting with or without replacement) should be tools for analysts and data scientists alike that assess random variability in a statistic without needing to worry about the restrictions of the data's distribution, as is the case with many parametric tests, most commonly supported by the t-test Tool in Alteryx. With modern computing power the need for hundred-year-old statistical sampling testing is fading: the power to sample a data set thousands of times to compare results to random chance is much easier today.

The tool's results could include, like R, outputs of not only the results histogram but the associated Q-Q plot that visualizes the distribution of the data for the analyst. This would duplicate the Distribution Analysis tool somewhat, but the Q-Q plot is, to me, a major missing element in the simplest visualization of data. This tool could be very valuable in terms of feeding the A/B Test tools.

As a security enhancement, the default passwords setting should be encrypt for user. Although this is critical for security my users have overlooked this even with training. They truly aren't culpable if they forgot. If it is the default then they must consciously change the it to an insecure setting.

From a security perspective the current default setting is backwards.

Grant Hansen

Hi All,

With Integration of various platform in Alteryx, connector seems to be an ease of use.

One is, yammer connectors. It would-

1. Help to extract insights of organisation pages.

2. Understand the productivity/Ideas of an organisation overall and help in enterprise content management.

Currently, the process to extract such data is through REST API/Bulk API and a connector would solve the issues.

Thanks

Harsh