Sunday, August 15, 2021

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..

Monday, August 9, 2021

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.

Sunday, August 8, 2021

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?

! 

Saturday, August 7, 2021

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

    

Tuesday, August 3, 2021

How to changes the order of Filter value

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

How do I find only strings that contain precisely "ABC" (upper case), but not those that contain "abc" or other upper/lower case combinations?

  How do I find only strings that contain precisely "ABC" (upper case), but not those that contain "abc" or other upper/...