Alteryx Designer Desktop Ideas

I always get a chuckle out of seeing PowerPoint presentations which, through numerous tables and illustrations show the "health" of "x" - where "x" is a customer, a market, business division, etc. - where the author spent hours creating graphical indicators such as arrows to render trends.

Recalling being provided such a deck from a senior leader who was touting how precisely the deck drew attention to areas of needed action.  The deck, in this case, was a 6 figure investment from a consulting firm. My unwelcomed response was, "Pretty pictures, nice illustrations.  What happens when business shifts tomorrow and we need to see this updated?"  There was no response.

In a different past life, I had the opportunity to create a similar deck, but utilized PowerPoint's ability to link to Excel, and VBA that made the tables graphs - and trending arrows all dynamic based on the data.  

This feature request, however, is not about me.  The dynamic slide deck solution was a windfall.  Alteryx workflows can certainly push dynamic data into .xlsm files to lighten the burden on the .xslm by eliminating the data pull.

BUT - not many organizations care for having production .xlsm files in use, and they're difficult to governance control.

Would be GREAT if one of Alteryx's output options was:  A PowerPoint

Give the developer the same ability to render "pages" as one would to populate Worksheets in a Workbook.

Have to believe would be a game changer for the product.

Hello,

  could you improve the sample tool to able it using a variable ?

  For exemple : the user could use a variable instead for "N".

  Thank you

  Kévin V.

The Explorer tool looks glitchy when you initially drop it on the canvas and I think its because it is trying to access the internet.  We already have temp folders in the Alteryx programs folder and it would be cool if the initial file reference is local- so its FAST.  

It may be user-friendly to display the DSN description. It's usually stored in the windows registry under "description" :

This should display in the log and when you configure a connexion.

Currently I am running two version of Alteryx and some of the macros were created/updated in the newer version of Alteryx. I would like to see only one error message displayed for all of the macros created in a newer version rather than having a dialog box pop up a dozen plus times (one for each macro) every time I open an instance.

Macro Error Message

As Alteryx becomes more focussed on the Enterprise - it is important that we build capabilities that support the needs of large-scale BI.

One of these critical needs is dealing with heterogeneous data from different systems that use different IDs for every critical entity / concept (e.g. client; product)

Here's the example:

Problem:

- In any large enterprise - there are several thousand different line-of business systems

- Each of these was probably built at a different time, and uses a different key for specific concepts - like Client & Product

- Most large enterprises that I've worked at do not have a pre-built way of transforming these codes so...

- This means that any downstream analytics finds it almost impossible to give single-view-of-customer or single-view-of-product.

Solution option A:

Reengineer all upstream systems.   Not feasible

Solution option B: 

Expect some reference-data team to fix this by building translations.   More feasible but not fast

Remaining Solution Option:

Just as Kimball talked about - the only real way is to define a set of enterprise dimensions, which are the defined master-list of critical concepts that you need to slice-and-dice by (client; product; currency; shipping method; etc) in a way which is source-system agnostic

Then you need a method in the middle to transform incoming data to use these codes.   This process is called "Conforming"

What would this look like in Alteryx?

Setup

• We would use the connect product to define a new dimension - say "Product".
• Give this a unique ID which is source-system independant; and then add on the attributes that are important for analytics (product type; category; manufacturer; etc)
• Then decide how to handle change (slowly changing dimension or SCD type 0,1,2, etc).   Alteryx should take full responsibility for managing this SCD history; as do many of the competitors
• We then create a list of possible synonym types (within Connect).   For example - a product may have a synonym ID from your supplier; from your ERP system; from your point of sale system.  that's 3 different IDs for any product.
• We then load up the master data - this is painful but necessary

In Use:

• I read in data into alteryx via any input tool
• I bring in a "Conforming" tool off the toolbox (new tool which is needed)
• It asks me which column or columns I wish to conform
• For each - it asks me which synonym type to use
• It then adds a translated column for me to use which ties back to the enterprise dimension - and spits out the errors where the synonym is necessary.

Impact:

In BI in smaller contexts, or quick rapid-fire BI - you don't have to worry about this.   But as soon as you go past a few hundred line-of-business systems and are trying to do enterprise reporting, you really have to take this serious.   This is a HUGE part of every BI persons's role in a large enterprise - and it is painful; slow and not very rewarding.   If we could create this idea of a simple-to-use and high-velocity conforming process - this would absolutely tear the doors off enterprise BI - and no-one else is doing this yet!

+ @AshleyK @BenG @NickJ @ARich @patrick_digan @JoshKushner @samN @Ari_Fuller @Arianna_Fuller 

http://community.alteryx.com/t5/Data-Sources/Connecet-to-an-Orcale-Database/m-p/12575#M956

When use Sql-Server build Stored Procedure where list in the Input Data Tool. So able to work with SPs.

When I use Oracle build Stored Procedure where not list in the Input Data Tool. So not  able to work with SPs.

Oracle, Sql-Server and MySql you can build Stored Procedure.

It would be great if when Alteryx for this Databases have implemented the same functionality.

So it can not be made dependent on the using Database to decide for Alteryx. 

Mathias

It would be useful if the Tile Tool had an option to tile based on Natural Breaks in the data. See: https://en.wikipedia.org/wiki/Jenks_natural_breaks_optimization

For example:

Hi,

It would be great if the Intellisense features of the Formula tool could also be put into the Advanced Filter and Multi-Row tools. 

Thanks

All the items in the 'View' menu have useful shortcuts. For instance, I'm always using Ctrl+Alt+D for the interface designer.

It would be nice to be able to quickly check workflow dependencies; at the moment there are far too many clicks to get there given the amount they are accessed (by myself and my colleagues at least...)

Quite often the window is only required briefly to check whether absolute/relative paths are used and to see inputs/outputs. It would really improve speed and ease of use if the window could be brought up with a couple of key strokes.

What are your thoughts?

For the purposes of troubleshooting/optimization, it might come in handy to have a timestamp column in the Results Pane. Especially with processes time-consuming enough that I let them run in the background, I would like to know which steps are particularly time consuming, and seeing when the messages were generated would at least be a start.

MemSQL is a very popular high-velocity; high scalability database which is often used for analytics: https://portal.memsql.com/

However, when attempting to make a connection to MemSQL, Alteryx throws the error "Get Table List Error: Error opening "SHOW VARIABLES LIKE 'aurora_version'": No Columns Returned."

From discussions with the support team at Alteryx - it appears that this is due to Alteryx presuming that the database is a MySQL database (because MemSQL also uses the MariaDB ODBC driver) and then sending a followup query to identify system version before making a connection - however MemSQL does not support this value so the connection fails.

Request:

- Please can we add the ability to connect to MemSQL without this error (i.e. trap this error and identify the DB version)

- Please can we give an advanced view to Alteryx users so that they can see this additional traffic and change this where needed?

          NOTE: By providing an advanced view - users can understand and diagnose / fix behaviours that Alteryx assumes by default, but which are not always relevant or useful.   An example of this is that on MS SQL Alteryx tries to open a cursor on columnstore tables by default and you have to use a workaround - please can you give us the ability to see and change these under-the-covers behaviours that are presumed by default.

- It may be useful to the Alteryx corporation to reach out to MemSQL and add Alteryx to the list of applications that can be used with MemSQL:  

https://docs.memsql.com/v6.8/guides/client-and-application/third-party-integrations/introduction/

To replicate:

- Fire up a MemSQL cluster (easiest is to get a trial cluster using the link above, or use an internal DB)

- Connect to this DB using the MariaDB ODBC connector (as recommended by MemSQL)

- Test this connection works with an ODBC compliant app like Tableau; Excel; etc

- Then attempt to connect using Alteryx  - see screenshot below.

I would like to be able to email attachments to fileshare sites.  I can't because the email that Alteryx sends out is missing the required header data that tells the fileshare there is an attachment.  

This is what the email should have but it does not.  

X-MS-Has-Attach: yes

I worked this issue with Alteryx support probably a year ago and had hoped to see this as an improvement, but it's not there.

There are other ways to get data to fileshare sites, and every single one of them has failed for various reasons. Email would by far be the simplest way if the right header data were included.

Many times; ideas for new ways to use Alteryx come to me while I'm not at work.

Most of the time that happens, I can use RDP via VPN to get to my work desktop.

But sometimes it isn't easy to do that.  Like when I'm driving, outside for a run, in the shower.. you get the idea.

My point is that there should be a mobile app for Designer (iPads and Android tablets).  The mobile app wouldn't necessarily need to be connected to the actual sources live (maybe require a template used for input for ODBC; but allow connections to HTTP/FTP/local sources). 

The user would design the workflow, and then have the option to email the schema to themselves (or others) so that once back at work, one could pick up where they left off.

Although I would prefer to use it on an iPad, it could technically be used on an iPhone as well.

For an example of how that could look, see the iOS app "Workflow".  That, in combination with the now defunct "Schemes" was a great way to do visual programming similar to what we do in Alteryx.

It would be great to have an outbound connector on output tools for 2 reasons:

a) if this outbound connector can carry key results of the output process, this can be saved in an audit log.  For example - rowcounts; success/failure.   This kind of capabiltiy (to generate a log, or to be able to check the rowcount of rows committed to a database) is important for any large BI ETL process

b) this woudl also allow the process to continue after the output process and also act as a flow of control.   For example:

- First output the product dimension

- once done - then connect (using the outbound connector) to the next macro which then updates the Sales fact table using this product dimension (foreign key dependancy)

The ability to create Interface tools would be helpful. I would to edit multiple actions at the same time on a single tool, but it needs to be done dynamically. All of these tools exist within the standard tool set, but the standard action tool only allows for one action to be done per tool.  

Other Examples:

-Radio Button Groupings (only 1 scenario can be selected within a group instead of one radio button per designer interface)

-Replace textual selection with a graphic selection:

                       Please select a Park to run the report for:

                      Islands of Adventure     Universal Studios      Both        vs                IOA          Universal Studios         UPR

-Toggle List Box Options where: 

Survey Import

Hello all,

A whole field of performance improvement have not been explored by Alteryx : the hardware acceleration by using something else than a CPU for calculation.

Here some good readings about that :
https://blog.esciencecenter.nl/why-use-an-fpga-instead-of-a-cpu-or-gpu-b234cd4f309c

https://en.wikipedia.org/wiki/Application-specific_integrated_circuit

The kind of acceleration we can dream !

In Render tool you can use a field to group by and use that field to alter the output file name somewhat similar to the output tool.  Unfortunately it is not exactly like the output tool.  Usually you have a table tool and or layout or visual layout tool before the Render.  In my most recent scenario I have several outputs I use the Table tool for to format, the text tool to generate headings and the visual layout tool to organize these headings and tables into coherent sections on a final output used as a dashboard. 

Fine and dandy except a new requirement now divides these data based on client so I tried to find a way to pass the Client code through to the Render tool so it could dynamically alter the output file so each client gets their version without manually creating multiple replicated streams to format.  But the Render tool requires a field and if I am passing a table it can't reference columns (fields) within the table and if I build a client code field to pass outside the table I can't seem to find a way to tag it to the table  and text going into the layout or in some way pass it into the layout tool in a meaningful way to reach the Render tool for use in dynamic rename of output file.

I wish there was a way to pass a field into the Render tool to modify output file name whether feeding it tables or other data or mixed elements.  Maybe a pass through element or something?

Similar to how there is a functionality to use pip through the ayxinstallPackages, there needs to be a way to upgrade python itself. There are important packages such as keras that have errors in Python 3.6 that are not present when used with 3.7 so it should really be up to the user as to which python package to use. Another solution could also be to allow the user to point to their own local installation of Python so that the user can maintain consistency between their own local site-packages and the one that Alteryx has.