Saturday, 19 August 2017

Count of A's in Each Customer’s Name

How many A's does each Customer have in their name(On Superstore Data)?

Step 1:

Create  3 calculated fields “Cust Name WithOut A's”, “Name length”, and “Name Length WithOut A's”  by below formulas.



Step 2:
Create “Number of A’s” calculated field to find no of A’s in each and every player.










Step 3:
Drag and drop “Name” dimension field into rows shelf and “Number of A’s” measure field into columns shelf.

Thanks Guru's,
Prazval.ks

Saturday, 12 August 2017

Zipping the Tableau Server LogFiles

Tableau Server LogFiles can be backed up by  using TAB ADMIN.
It Creates an archive (.zip) containing Tableau Server log files.
If we have Clustered Environment,then log files from worker servers are included in the archive that's created.

Syntax:-

tabadmin ziplogs  <File-location>

Dynamic Date Axis Display in Tableau

Design a dynamic Date Axis Display(On Superstore Data) if the user selects a date range that is larger than 365 days show a yearly Axis, if they select a date range larger than 30 days show a monthly Axis, otherwise show the view at a daily Axis Level.

Step1:-
Create  3 Calculated Fields Duration, “Date Granularity, and Date Axis  by below formulas.



Step 2:
Drag and drop Date Axis Cal. field into columns shelf, right click on Date Axis field and select Exact Date, Continuos. 

Step 3:
Drag and drop Date Cal.field into filter shelf and select Range of dates “click on next, click on apply, ok .

Step 4:
Right click on "Date" field in filter shelf and select add to context, Select Show filter.

Step 5:
Drag and drop "Sales" measure field into rows shelf and change aggregation as avg.

Step 6:
Perform any selection on Date Filter and check whether the
Date Axis is changing dynamically (or) not.

Thanks Gurus,
Prazval.ks

Sunday, 11 June 2017

Finding Student Best Subject

Lets achieve this using LOD's. 
For this, We need to create 3 calculations, to find out the best scoring subject of each student .

Step1:

Create a Calculated Field with the following Formula.


 Step2:


Step3:



Thursday, 1 June 2017

Deploying Tableau Server on AWS

Hello Gurus, 

 Today lets see how to deploy the Tableau Server on AWS.


Pre-requisites:-


First we need to Configure AWS with the following steps:








To run Tableau Server on AWS,next we need to install Tableau Server on EC2 instance (or) instances that we just configured in the above Steps.
Its just like the normal installation on our local hardware.




Finally we need to access dashboard on Server,so first we need to publish the required workbook from desktop to Server.














Finally access your dashboard in AWS











Thanks&Regards,
Prazval.ks

Friday, 28 April 2017

Gap between 1st and 2nd Highest in Tableau


Hello Gurus,
One of the frequently performed business analysis is identifying the Gap between Highest Sales and 2nd Highest Sales/Revenue/Orders etc.By taking the sample data set above lets perform the Gap analysis in the simplified way using LOD's.

We need to create 2 calculations,to findout 1st Maximum,2nd Maximum and then we need findout the difference between those two.



Step1:
Create a calculated Field with the name 1st_Max_Score with the following Formula




Step2:
Create another calculated Field with the name 2nd_Max_Score with the following Formula




Step3:
Create a calculated Field with the name "Gap" with the following Formula:-

Gap=2nd_Max_Score - 1st_Max_Score



Thanks Guru's,
Prazval.ks







Thursday, 2 February 2017

Toggling/Popping Dashboard

Description: -

          Toggling Dashboard will display the sheets in the Dashboard  on Demand Dynamically Depnding on the Selection of the User by hiding the remaining sheets .

Procedure: -
STEP1: -
To connect to Datasource File, click on “More” option in the “Connect”. Connect to “Superstore Sales.tde” datasource file which is available in “Archive” folder of “Datasources Folder” in “My Tableau Repository Folder”.
STEP2: -
Create a Sheet with name “Category_OQ”. Drag the Category from Dimension Tab and drop it into “Rows Shelf”
STEP3: -
Drag the Order Quantity field from “Measures Tab” and Drop it into Columns Shelf and colour the visualization with Category by dragging and dropping it into color marks card 

STEP4: -
Create second New sheet with name “Year_Total.Sales”. Drag the “Order Date” field from “Dimension Tab” and drop it into Columns shelf and Drag “Sales from “Measure Tab” and drop it into Rows Shelf 

STEP5: -
Create third new sheet with name “Country_Profit”. Double Click on the “country” field in the Dimension tab and Drag “Profit” field from measure tab and drop it into color marks card. Drag and drop “Sales” and “country” fields and drop into the “Text” of the marks card.
STEP6: -
Create a Parameter with name “Sheet Selector” of type “String” with allowable value as list. In the list take “Bar, Line, Map, All” and click “ok” 


STEP7: -
Go to Analysis Tab in the menu bar and click on “Create Calculated Field” with name “Sheet”. Drag the Sheet Selector Parameter and drop it into the Calculated field.
STEP8: -
Drag the Sheet Calculated field and drop it into the filter shelf of the Category_OQ worksheet and in the Filter options, select “Custom Value List” and enter “Bar, All” and click “ok” 


STEP 9: -
Similarly, for Year_Total.Sales sheet and Country_Profit sheet add the “sheet” calculated field into the filter shelf with “Custom list” containing “Line, All” and “Map, All” respectively.
Right click on the Sheet Selector Parameter and click on show “parameter control”. 
                                                                                            Custom Value list for 2nd and 3rd sheets.

STEP 10: -
Create a New Dashboard. In the Menu bar, select “Dashboard” and then click on “New Dashboard”. Drag the vertical container in the titled mode. Drag the Category_OQ sheet and drop it into the container 
                                                                                                              Creating Dashboard.

STEP 11: -
In the Fig.10, we can observe “Line space” at the bottom of the Category_OQ chart. Drag the “Year_Total.Sales” and drop it into that cross line space of the container as shown in fig 11. Similarly Drag “Country_Profit” and drag it into the empty line of the container.


                                                           Dragging the Other sheets into Cross lined Empty area as above.
STEP 12: -
Show the parameter, select "all" Value,Tableau will displays all the sheets.


Select any one value in the parameter (Bar,Line etc),Tableau will display only that sheet by hiding the remaining sheets as below which is known as TOGGLING technique.


Thanks Guru's,
Prazval.ks

Count of A's in Each Customer’s Name

How many A's does each Customer have in their name(On Superstore Data)? Step 1: Create  3  calculated fields  “Cust Name Wi...