Thursday 3 December 2015

Want to analyze the data like Sales Variance Percentages from previous year to current Year.

1) Create a Calculated field to get the "2014 Sales" as the following screen shot.

t4.PNG
2) Create a Calculated field to get the "2015 Sales" as the following screen shot.
t5.PNG

3) Create a Calculated field to get the "2014  - 2015 Sales Variance" as the following screen shot.
t6.PNG

4) Right click on "2014  - 2015 Sales Variance" ,  then click on "Default Properties", then click on "Number Format".
t8.PNG
6) Then select "Percentage" as the Data format.
t9.PNG

7) now add all the Calculated fields.
t7.PNG


Wednesday 2 December 2015

Calculating Ranks in Tableau

Create a parameter like below.
43.png
create a calculation, drop it on "Text Labels"
56.png

Right click on parameter, then click on "Show Parameter Control".

Drag "Measure Selection" field twice onto Columns shelf, State on to rows shelf.
47.png
Then Right click on first Measure Selection Column (Rank) then click on "Discrete", Change ir from Column shelf to Row shelf.
48.png


Then applying the Sorting
49.png

Then Copy the Rank Column into "Filter Shelf". ( I am using laptop so how i am doing here is CTRL+ALT+Right click on Mouse + dragging into Filters shelf.)50.png

Then Apply the Filter on Ranking51.png

If you want to hide the Ranks, right click on rank field, click on "Show Header".
52.png

=====

I have added normal report, top 5 City report to the Dashboard to come to know how our calculation will work.
Measure

53.png

54.png



55.png

Tuesday 1 December 2015

How to Filter the Multiple Values.


As of now Tableau does not have "IN" operator to use in the Calculation but there is an alternative that is "OR"

Case [Region]
when "Central" then "Territory - 1"
when "East" then "Territory - 1"
else "Territory - 2" end

Or

If  [Region] = "Central" or   [Region] ="East" then "Territory - 1"
else "Territory - 2" end

Wednesday 18 November 2015

TDE fies - Extracts

Extracts are saved subsets of a data source that you can use to improve performance, upgrade your data to allow for more advanced capabilities, and analyze offline. You can create an extract by defining filters and limits that include the data you want in the extract. After you create an extract you can refresh it with data from the original data source. You can either fully refresh the data, replacing all of the extract contents; or you can increment the extract; which only adds rows that are new since the last refresh.
Extracts can:
  • Improve performance. For file based data sources such as Excel or Access, a full extract takes advantage of the Tableau data engine. For large data sources, a filtered extract can limit the load on the server when you only need a subset of data.
  • Add functionality to file based data sources, such as the ability to compute Count Distinct.
  • It provides work offline facility to the developers.
  • Extracts are saved with .tde extension.


Limitations:

Defining Relationships among the Tables

Defining relationships among the tables and applying filter.


a. Open the Tableau Software by double click on Tableau Software Icon.
b. Connect to the Data Base,
c. Drag required tables in to right panel like the below figure. In this Example Orders, People, Return tables are selected for reporting.
d. Tableau Engine defines the Relationships automatically. Although we can also define our own relationships.(IT IS EQUALENT TO V-LOOKUP INEXCEL)






e. And we can apply the filter before we connect to the work area.
Click on Filters which is located on top right side.
 f. Click on add, in the following example We are applying filter on field “ Market” & select “Central” & “West”.
Central” & “West” markets only available to the report since we applied Data source filters.
g. After apply the filter, click on go to work sheet.
h. Drag Market, Product fields onto row shelf, sales onto column shelf.


Modifying Data source filters:
1) Right click on Data source.

2) Now we can modify filter here as we want. In this example we are adding one more filter on “Product Line” column.

How to get the Latest Transaction date for each customer?


Here I'm creating 2 reports , one report is to show Normal Report, another one is to show Calculated Report. Hence adding those 2 reports to Dashboard, which will show Latest Order customer wise.

1st Report (Calculated Report)
1) Create a Calculation 
Name: Max Date
Syntax: window_max(Max([Order_Date]))




2) Add fields [Customer_Name], [Order_ID]  to Row Shelf, drag Calculated field into Text Label

2nd Report (Normal Report)

1) Create a Report using  [Customer_Name], [Order_ID], [Order_Date].


Create a dashboard by dragging the above reports onto Dashboard.




Difference between Parameter & Quickfilter


Definitions:

Quick Filters:
We use the Quick Filters to include or exclude the members from the report.

Parameters:
Parameters are dynamic variables that can be used as placeholders in formulas.
And we can replace constant value by dynamic value

Differences:

1) We can implement Quick Filters on "Rows" only, it means implement on "Records".
where
Parameters can be used on Rows or Columns.

2) We can select More than 1 value at a time
where
Parameter allow us to pass max 1 Value at a time.

3) Parameter values not get updates automatically
where
Quick filter will get update as database updates.

4) We can call Parameters into Calculations, where we can't call Quick Filters into calculations.

 

Tuesday 17 November 2015

Quick Filters:

Quick Filters:

-> We use the Quick Filters to include or exclude the members from the report.
-> It offers more interaction with report, It means End user can select required data instantly.
If user don't want to see the data on the report, then they can deselect that specific member from Quick Filter.

EX:
1) Drag [Region], [Order Date], [Customer Name] fields into Rows shelf.
2) Drag the one of Measure fields from Measures window into Column Shelf.
3) Right click on  [Region] in the work area then click on Show "Quick Filter".



Changing the UI:

1) Single Value (List):  This option offers select only 1 member at a time or select all members by selecting "All" radio button.
It does not allow selecting multiple members from the selection criteria.
2) Single Value Drop Down List:
 This option also offers select only 1 member at a time or select all members by selecting "All" radio button.
It does not allow selecting multiple members from the selection criteria.
3) Single Value Slide Bar:
This option also offers select only 1 member at a time or select all members by selecting "All" radio button.
It does not allow selecting multiple members from the selection criteria.
4) Drop Down Multiple Values:
This option also offers select either at 1 or multiple members a time or select all members by selecting "All" check box.
5) Drop Down Multiple Values:
This option also offers select either at 1 or multiple members a time or select all members by selecting "All" check box.
Here List of the values shown in the drop down list.

6) Drop Down Multiple Values:
This option also offers select either at 1 or multiple members a time or select all members by selecting "All" check box.
Here List of the values shown in the drop down list.
7) Custom Value List:
This option also offers select either at 1 or multiple members a time or select all members by typing the characters.
It will search the members which are related to your typed word.
If type ST, it will show the data EAST, WEST then select which ever members want to show on the report.
It is quite similar to Contains filter.

What is show Relevant values in Tableau? (CASCADING FILTERS)


We use the show Relevant values to view associated values in quick filter, we can say it is CASCADING FILTER.

It means, State Quick Filter is showing Values as per values selected in "Region" quick filter.






How to build Dashboards in Tableau

Dashboard: General Definition:
A dashboard is a visual display of the most important information needed to achieve one or more objectives; consolidated and arranged on a single screen so the information can be monitored.

In Tableau, We use Tableau to place multiple Reports at single place as well as to the define relationship from report to others.
Creating Simple Dashboard:

1) Create a Report with Region, Sales fields and Name it as "Region Sales"
2) Create another Report with State, Sales Fields and Name it as "State Sales"
3) Create a Dashboard by click on Dashboard menu, then click on "Create New Dashboard"
4) Then Drag the "Region Sales", "State Sales" report into Dashboard.
5) Now Dashboard have 2 Reports.

Objects in Dashboard:
1)  Horizontal: it is used to place the organize the reports horizontally.
2) Verticalit is used to place the organize the reports Vertically.
3) Image: We can add Image to the Dashboard.
EX: Drag the Image object to the work Area, then provide the path of the Image.
4) Webpage: It is used to add the Webpage to Dashboard.
EX: Drag the Webpage object to the work Area, then provide the URL.
5) Blank: It is used to  keep space between two Reports on the Dashboard.
6) Text: It is used to add the textual data to the Dashboard.


Action :
Actions,  which are used to define the interaction between reports.
Actions are used to define the Drill down in Dashboards.

Action Types:
 
 
1) Filter: Action Filters are used to define the Filter from 1 report to another, it means which ever we use in one report that related data will only show in other report.

EX: 
1) Create a Report with Region, Sales fields and Name it as "Region Sales"
2) Create another Report with State, Sales Fields and Name it as "State Sales"
3) Create a Dashboard by click on Dashboard menu, then click on "Create New Dashboard"
4) Then Drag the "Region Sales", "State Sales" report into Dashboard.
5) Now Dashboard have 2 Reports.
6) Click on "Dashboard" file menu then click on "Action" , then on "Filter"
7) Select "Region Sales" as Source Sheet, "State Sales" as Target Sheet.
8) Select Run on as "Select"
9) Click on "OK".
10) Click on any of the Region in   "Region Sales"  report, then we can see selected Region related Data in the 
"State Sales".

3) Highlight:
Highlight option is used to highlight the selected data related on other report.
EX: 1) Create a Report with Region, Sales fields and Name it as "Region Sales"
2) Create another Report with State, Sales Fields and Name it as "State Sales"
3) Create a Dashboard by click on Dashboard menu, then click on "Create New Dashboard"
4) Then Drag the "Region Sales", "State Sales" report into Dashboard.
5) Now Dashboard have 2 Reports.
6) Click on "Dashboard" file menu then click on "Action"  then click on "Highlight"
7) Select "Region Sales" as Source Sheet, "State Sales" as Target Sheet.
8) Select Run on as "Select".
9) Click on "OK".
10) Click on any of the Region in   "Region Sales"  report, then we can see selected Region related Data in the 

"State Sales" will be highlighted.

3) URL:

We use this kind of Actions to navigate from Report to any specific webpage.

1) Create a Report with Region, Sales fields and Name it as "Region Sales".
2) Click on "Dashboard" file menu then click on "Action"  then click on "URL".
3) Then Define "https://www.google.co.in/" in the URL, click on "OK".
4) click on any of the region in the report, it will take to the google page.
========================
Run Action On: 
We use "Run Action On" to define the User interaction with report. After define the Action type, we define Run Action On.

Run Action Types: 
1) Hover: We use this type to define the interaction from 1 report to another, in this approach action will be applied by keeping mouse hover on the Source Report.

2) SelectWe use this type to define the interaction from 1 report to another, in this approach action will be applied when select (Click) any data in the Source Report.

3) Menu: We use this type to define the interaction from 1 report to another, in this approach action will be applied when click on data then click on menu bar in the Source Report. 

Creating Dashboards:

Navigating with in the Same Dashboard

1) Create a Report with Region, Sales fields and Name it as "Region Sales"
2) Create another Report with State, Sales Fields and Name it as "State Sales"
3) Create a Dashboard by click on Dashboard on menu bar, then click on "Create New Dashboard", Right click on Dashboard at footer level then Rename as " Region, State Sales Dashboard".
4) Then Drag the "Region Sales", "State Sales" report into Dashboard.
5) Now Dashboard have 2 Reports.
6) Click on "Dashboard" menu bar  then click on "Action" , then on "Filter"
7) Select "Region Sales" as Source Sheet, "State Sales" as Target Sheet.
8) Select Run on as "Select"
9) Click on "OK".
10) Click on any of the Region in   "Region Sales"  report, then we can see selected Region related Data in the 
"State Sales".


Navigating from one Dashboard to another.

1) Create a Report with Region, Sales fields and Name it as "Region Sales"
2) Create another Report with State, Sales Fields and Name it as "State Sales"
3) Create a Dashboard by click on Dashboard on menu bar, then click on "Create New Dashboard", Right click on Dashboard at footer level then Rename as " Region Sales Dashboard". Then Drag "Region Sales" report into work area.
4) Create a Dashboard by click on Dashboard on menu bar, then click on "Create New Dashboard", Right click on Dashboard at footer level then Rename as " State Sales Dashboard". Then Drag "State Sales" report into work area.
5) Now there are 2 Dashboards .
6) Go to  "Region Sales Dashboard" menu bar  then click on "Action" , then on "Filter"
7) Select "Region Sales" as Source Sheet from Region Sales Dashboard, "State Sales" as Target Sheet from .State Sales Dashboard.
8) Select Run on as "Select"
9) Click on "OK".
10) Click on any of the Region in   "Region Sales"  report, then we can see selected Region related Data in the 
"State Sales".

Note:
1) We can define the Size of the view in the Dashboard by selecting the Sizes which are located in Left bottom side.
2) When we drag the Reports into Dashboard, it occupies total space of the Dashboard, if you want to define the size then select "Float" option then we can define the Size of the Report in the Dashboard.
Float: it is used move report from 1 place to another place within the Dashboard and can define the custom size.
Tiled: It is fixed size, occupies maximum size in the Dashboard, If we place 2 reports in Dashboard, that 2 reports occupies total space of the Dashboard.
3) Text Object: We use if only for add the comments or to show any textual data along with Report in the Dashboard.