Tableau Challenges

 1. Cannnot select multiple values in Parameter

2. We're publishing dashboards to Tableau Server to be used by many different users. Each user has it's own dataset and some of the filters displayed on the dashboard are not applicable for all users.Some users have an empty column for 100% of their data in the filter's dimension. Tableau still shows the filter with just 1 (empty) optionIs there a way to conditionally show/hide filters? In this case: when the filtered dimension is empty / there are no filter options, hide the filter for the user. Since there are a couple of filters which can have this, all those useless filters clutter the UI and add unnecessary complexity to the dashboard.

Tableau interview basic

 1. Difference between dimensions and measures . 2. what is granularity ..

3 .difference between heat map and tree map . 

4. Difference between calculated field and table calculations. 5. What is pivoting in tableau. 6. Difference Between fact and dimensions. 7. Action filters, context filters , datasource filters and dimension filters and it's process as well. 8. Set and parameters. 9. Bin and groups. 10. What is data visualization.. if interviews is going dive-dive then go and prepare for other questions also. Focused on scenario based questions as well..

Tableau Products

 

The products are

• Tableau Server
• Tableau Online
• Tableau Public server
• Tableau Desktop
• Tableau Public Desktop
• Tableau Reader
• Tableau Mobile
• Tableau Prep Builder

Server Part

Tableau Server

Tableau Server is a paid Server application which needs to be installed on a Windows or Linux server. This is used widely in the enterprise world. Usually there would be a dedicated admin team/person to take care of the memory, user management, data source management , folder management and other server related things.

Tableau Online

Tableau online is a paid server application too but it is already hosted by Tableau software and so no need to install on any windows server. It is better when you need the Tableau dashboards to be accessed from anywhere. It has almost all features of Tableau server but on the internet.

Tableau Public Server

Tableau Public server is a free server in the internet. This is the YouTube or Blogspot in Tableau Data Visualization world. It is free and people post their ideas and visualization here. We call it the Visual blog. It has no user management or folder management options. You can hide your work though. It cannot have live data source but only Extract. So many people publish their ideas and custom visualizations here. We could find the inspiration from here.

Developer Part

Tableau Desktop

Tableau Desktop is a paid desktop application. It is also called as Tableau Desktop Professional edition. This is where the developers create charts, formula, dashboards, actions and everything. It has 14 days trial too. The dashboards we create here can be published to any Server listed above. It can be opened in Tableau reader. Read Tableau reader for more information.

Tableau Public Desktop

Tableau Public Desktop is a free desktop application. It is the developer place for Tableau Public server.  It is free and has some limitations like cloud Save only, no live or database connection. They are widely use by learners, bloggers, public information related institution like media and etc.

Viewer Part

Tableau Reader

Tableau Reader is the free desktop application which can help us to view the Tableau dashbords created by Tableau Desktop. It supports only extract connection files. It can help new people to try Tableau by getting one license for Tableau Desktop and installing this free software on their end user’s machine. It can open the dashboards, interact with them like filtering, tooltip and parameters. We cannot edit the formula or charts here.

Tableau Mobile

Tableau mobile is a mobile application. It is available in iOS and Android. It can connect to Tableau server or Tableau online. It is just like Tableau Reader buy for mobile. It can help to interact and view dashboards which are published to Tableau server or Tableau online.

Data Preparation Part

Tableau Prep builder

Tableau Prep builder is a new product of Tableau. It helps developers to cleanse, blend and wrangle  the raw data. It is a mini ETL ( Extraction, Transformation and Loading ) tool which can connect to different database, join the data, transformation over the data and save the file as output. It can be automated and help developers to avoid redundant manual data manipulation.

How to rotate axis labels to 45 degree inclination? ------------- Not Possible

How to hide filter value without excluding the data from the view?

I have a problem with Filters.

I have a dimension with the values (0, 1, 2, 3, 4, 5). I want to use this dimension as a filter, but not to let the user the option to filter out the value "0". I don't want to exclude the values 0, the opposite - I want these values to ALWAYS be in the view, and let the user the chance to filter only between (1, 2, 3, 4, 5).

Is that an option? To remove a value from the filter, but not from the data?

! 

Tableau 2020.4 New Features

 1. Data Preparation :

            Tableau Prep builder in the browswer on Tableau Server and Tableau online

              Spaial support in Tableau Prep

2. Server Monitoring

            Resource monitoring tool for Tableau server on Linux

3.  Connecting to Data

            Salesforce connector API update

            Datorama connector

            Snowflake OAuth improvements

    

How to changes the order of Filter value

 > If we have date columne , if we want to show month-year in descending order ....

> 

Learning

 
1. We can pass the filter to hover sheet.
2. We can give download button that will download only Data tab data not crossdatatab. Data format would be different in it.
3. Using parameter : we can show some values as  float and some as number 
(left(str([Average Application FICO]),(find(str([Average Application FICO]),'.')+2)))
4. string func : Contains , endswith ,startswith, find ,left (start position is 1 will include last as well) 
, len (start with1 ), lower, ltrim,replace, rteim,right,upper
5. We can show multiple sheet swaping in tableau
6. Javascript API in tableau
7. We can give the index number horizonl and vertical.
8. We can run multiple if by using plus
if() then .. end
+
if() then ... end
9. For Swaping use first horizontal and then inlucde one vertical(only)... not multiple vertical.
 In one vertical include sheets one by one after selecting parameter.

10. How to convert string to date.
11. continuous axis cannot be rotate only dimension/discreate can rotate : Wrong, we can do it  format-->scale
12. Edit date continuous axis
13. if i have c
14. for swapping sheet thers should be one dimension avaialble (on row.column shelf) in each sheet.
15. We can show measure header by using measure name pill
16. How to Build a Monthly Date Slider in Tableau : https://www.theinformationlab.ie/2020/03/09/monthly-date-slider-in-tableau/



**************************
Quarter last date :  DATEADD('month',3,DATETRUNC('quarter', [As Of Dt]))-1
momth last date :  DATEADD('month',1,DATETRUNC('month', [As Of Dt]))-1

*************************************************************************
Issue list
1. Parameter multi select
2. 
************************************
Have to do
1. Column based conditional formatting

Filter/ Parameter hide based on Paramter selectoion

Steps:

1. Create 2 Param1  and Param2. Param1 will be visible all the time the other will appear based on  selection on Param1.

2.Create blank sheet having avg(0) on rows and columns

3. Add Param1 in blank sheet and add values based on which the Param2 will be hide.

4. Add Paramters1 and add blank sheets and then add PArameter2 and add floating object on Parameter2

Please check below link.

https://public.tableau.com/profile/peeyush.jain#!/vizhome/HideFilterParameterbasedonParameterseelction/Dashboard1

This approach will work good in Fixed layout where as for Autoimatic layout there is a chance the floatig object will distorted.

Date Slider in Tableau

 How to  shoe slider where user can select from -to date using slider.

Tableau Known Issue

 1. Latest 5 month selection in filter or Current month , Last year same month slected and other months are unselect in drop-down.

2. Filter hide based on Filter. By Parameter we can hide Filter.

3. Measure name and Measure values cannot used in Calculation

4. When having scroll in dashboard - sheet. Now when we download from server to PDF. it won't download complete data. 

Cell Background Color ( Conditional formatting)

 as

How to replace no value to zero. If there is no record in backend

How to replace no value to zero. If there is no record in  backend

Group        Name        Profit

A                Dave            10

A               Julie              20

A                Peter            30

B                Dave            40

B                Peter            22

C                Julie            11

Here, in this Group B name Julie data  not avaialble and for group C name Peter and Dave data not avaiale.If we want to show all name and group combination of data then missing data will come blank.

Ifnull and ZN function wont work as in data its not NULL.

Solution:

if  not ISNULL(LOOKUP(SUM([field]),0)) then 0 ELSE

sum([field])END