Thursday, 7 April 2016

Alteryx Service Controller

  • The Alteryx Service Controller acts as an orchestrator of workflow executions and is responsible for the management of the service settings and the delegation of work to the Alteryx Service Workers.
  • The Controller receives jobs from the Scheduler, looks at themwithin the persistence layer where it maintains all of the queued jobs, and delegate jobs to the Workers.
  •  If Alteryx is deployed across multiple servers, only one machine may be enabled as a Controller.



Thanks Guru's,
Prazval.ks

Alteryx Scheduler

  • The Alteryx Scheduler is the component that provides the ability for a user to schedule the execution of workflows developed within the Designer, either on a recurring basis or at a specific time in the future.
  • The Scheduler interface component, which is written in C#,is accessed via the Designer and is used to specify the date, time, and frequency for running a workflow.
  • The Scheduler then communicates with the Alteryx Service Controller, which manages the job queue.
  • In an Alteryx Server deployment, the Scheduler interface can be set up to communicate with the Controller on the same machine, or it can be configured to connect to a remote Controller so that workflows are processed on a different machine.
Thanks Guru's,
Prazval.ks

Alteryx Service

The Alteryx Service allows the Alteryx Engine to be deployed across multiple servers,providing a highly scalable architecture for the scheduling, management, and execution of analytic workflows.
The Alteryx Service, which is written in C++ with some C# wrappers, can be deployed across multiple servers by using a Controller-Worker architecture.

 This means one server acts as the Controller and manages the job queue, and the others act as the Workers and perform the work. 


Thanks Guru's,
Prazval.ks

Wednesday, 6 April 2016

Dashboard Creation using Alteryx

In Alteryx lets design a following workflow that  will create a dashboard of sales data(Click to download DataSource) with a table, a chart and a heading with the company logo.

Solution:-

Tools Used:
1.Input
2.Table
3.Chart
4.Text
5.Image
6.Join
7.Join Multiple
8.Layout
9.Render

Steps:-


Step11:-
Finally Run the Workflow,it should display the following output.
Note:-
Logo and Heading in the dashboard output depends on what we are passing in Step6 and Step9 respectively.

For reference download the dashboard workflow here

Thanks Guru's,
Prazval.ks




Monday, 4 April 2016

SQL in Alteryx

Some of the Tools in Alteryx   offer  similar functionality  of SQL Commands,which are listing below:-


Alteryx Tool             SQL Clause                        Description


SELECT


Alteryx by default will show all available columns,  using a Select tool, located in the Favorites Toolbox,we can select required columns,change column names and data formats,for example V_String to Int
                  

WHERE
  Using the Filter tool,in the Favorites Toolbox 'Where' conditions can be checked.’T’ side of filter gives conditional matching data and ‘F’ side gives us unmatched data
                                       
                                                         
GROUP BY
 Using a Summarize Tool, located in the Favorites Toolbox ,  Group By functionality can be accomplished         

JOIN
Using Joins tool,Joins can be implemented.By default it gives output in Inner Join fashion.        

CARTESIAN JOIN
Cartesion Join is the Cross Product of 2 Tables.
Using an Append FieldsTool, Cartesian join functionality can be easily accomplished 

LEFT JOIN
(Also known as LEFT OUTER JOIN)
To achieve Left Join in Alteryx, the data that is output from the center of the Join Tool can be union with the data that is output from the left side of the Join Tool.
          

RIGHT JOIN
(Also known as RIGHT OUTER JOIN)
 To achieve Right Join in Alteryx, the data that is output from the center of the Join Tool can be union with the data that is output from the right side of the Join Tool

FULL OUTER JOIN
To achieve Full Join in Alteryx, the data that is output from the center of the Join Tool can be union with the data that is output from the right side,left side of the Join Tool       

 

ORDER BY
Order by functionality can be accomplished using a Sort Tool. Any field can be selected and sorted using this tool, in either ascending or descending order.  

AGGREGATIONS
(SUM,MIN,MAX etc)
Using Summarize Tool, any column can be aggregated by choosing the required aggregate option from the Numeric drop-down menu.           

DISTINCT
 In Alteryx by using a Unique Tool, return an output with unique values,which is equivalent to  SQL DISTINCT


Thanks Guru's,
Prazval.ks

Sunday, 3 April 2016

Tableau R Functions Communication&Interaction


If we use any Tableau R Function,internal Communication Order will be as following:


SCRIPT functions in Tableau are Table Calculations and that once you place them in the view, you will need to right-click on their pills and change their “Compute Using” option.

No of times it communicate with "R",Depends on "Compute Using" option.
For Example



Thanks Guru's,
Prazval.ks

Tableau R Functions

Tableau has the following four functions to communicate with R:
SCRIPT_REAL()
SCRIPT_BOOL()
SCRIPT_STR ()
SCRIPT_INT()

These functions require that R returns a specific value of type REAL/INT/BOOL/STR, which Tableau will then display.

Note:-
SCRIPT functions in Tableau are Table Calculations and that once you place them in the view, you will need to right-click on their pills and change their “Compute Using” option

Thanks Guru's,
Prazval.ks


Tableau + R Integration

1)Open up R Studio
2) Type the following script (keep in mind that R is case sensitive):
     install.packages("Rserve") //when prompted, choose a mirror to install this library from
     library(Rserve)
     Rserve()  //to run Rserve()

window should look similar to this:


3) Open Tableau

4) Select Help>Settings and Performance>Manage R Connection…
  

5) Specify the following and select OK 

6)Test Connection and Check whether it is successful(or) not.

Thanks Guru's,
Prazval.ks




What is R


  • R is a powerful object-based programming language (like C++, java, python, and many other modern programming languages). It is considered to be one of the leading tools to conduct advanced statistical analyses.
  • R is free,any one can contribute and verifiable.
  • R is having Over 7000 official packages and we can perform Textual Sentiment Analysis,Color Analysis,Mine Sweeper etc.
  • With Tableau’s connection to R, we can leverage Tableau’s rich data discovery, visualization and dashboard capabilities in conjunction with R’s advanced statistical computations.

Thanks Guru's,
Prazval.ks

Formatting Tips

Hello Gurus, One of the common things in Tableau after building any visualization is performing formatting. The Structured way of doing i...