Wednesday 19 August 2015

Parts of the Dataview

  • The parts of a view can be categorized as either table components, which are part of every view, or optional components, which can be turned on or off.
  • Data views are displayed in a table on every worksheet. A table is a collection of rows and columns, and consists of the following components: 
           Headers, Axes, Panes, Cells, and Marks.
           In addition to these, you can optionally show Titles, Captions, Field Labels, and                                                  Legends.
          They are shown as below.


Thanks Guru's,
Prazval.ks





Friday 14 August 2015

Tableau Server Architecture

Tableau has a highly scalable, n-tier client-server architecture that serves mobile clients, web clients and desktop-installed software.Tableau Server architecture supports fast and flexible deployments.

The following diagram shows Tableau Server’s architecture:



Tableau Server is internally managed by the multiple server processes.They are

1)Gateway/Load Balancer:-
It acts as an Entrygate to the Tableu Server and also balances the load to the Server if multiple Processes are configured.



2)Application Server:-

Application Server processes (wgserver.exe) handle browsing and permissions for the Tableau Server web and mobile interfaces. When a user opens a view in a client device, that user starts a session on Tableau Server. This means that an Application Server thread starts and checks the permissions for that user and that view.



3)Repository:-
Tableau Server Repository is a PostgreSQLdatabase that stores server data. This data includesinformation about Tableau Server users, groups and group assignments, permissions,projects,datasources, and extract metadata and refresh information.


4)VIZQL Server:-
Once a view is opened, the client sends a request to the VizQL process (vizqlserver.exe). The VizQL process then sends queries directly to the data source, returning a result set that is rendered as images and presented to the user. Each VizQL Server has its own cache that can be shared across multiple users

5)Data Engine:-
It Stores data  extracts and answers queries


6)Backgrounder:-
The backgrounder Executes server tasks which includes refreshes scheduled extracts,tasks initiated from tabcmd and manages other background tasks.


7)DataServer:-
DataServer Manages connections to Tableau Server data sources
It also maintains metadata from Tableau Desktop, such as calculations, definitions, and groups.



Thanks Guru's,
Prazval.ks




Sunday 9 August 2015

Tableau Version History



TABLEAU Version History


        
·       

Tableau 7

Tableau 6

Tableau 5

Tableau 4

             
Thanks Guru's,
Prazval.ks


DAX Time Intelligence Functions

   Thanks Guru's, Prazval.Ks