Posts

Create a Donut chart by Sales & Profit over Category --Tableau Intreview Question

  --Tableau Interview Question  A**ion L**s India Private Limited Tableau Interview Question  --Create a Donut chart by Sales & Profit over Category  Follow my Tableau Public Profile Donurt Chart by Sles & Profit Over category | Tableau Public

When the user will select subcategory , that particular subcategory will colored & level up with sales - Tableau Interview Question

 --Question:- When the user will select subcategory , that particular subcategory will colored & level up with sales  --Asked by Big 4 Tableau Interview Question  Follow my Tableau Public Profile Blog:  Sub category hover | Tableau Public

Choose the Dimension & Top N by Drop down --Tableau Interview Question

--Choose the Dimension & Top N by Drop down  --Tableau Interview Question --Asked by Klou** Interview question Follow my Tableau Public: Choose Dimension BY Parameter & Top N | Tableau Public

User can select the moving average day by parameter-Tableau Intreview Question

  Question-User can select the moving average day by parameter --Tableau Intreview Question --Asked by Ti**r A**l***cs Follow my Tableau Public to get the details. Tableau Public: https://public.tableau.com/app/profile/arabinda.mohapatra/viz/MovingavergaebysalesInputbyUser/Movingavergaebysales?publish=yes

Drop down list of YOY, MOM,QOQ Growth --Tableau intreview Question

--Question   A**ion L**s India Private Limited Tableau interview Question  -- Drop down list of YOY, MOM,QOQ Growth  -- Vist my Tableau public to get the details https://public.tableau.com/app/profile/arabinda.mohapatra/viz/DropdownofYOY_MOM_QOQGrowth/GROWTHKPI?publish=yes

How to change the default properties of aggregation from sum to average -Tableau Intreview Question

 --How to change the default properties of aggregation from the sum to average  Answer-Default properties > Aggregation> SUM (By default) .Can change to maximum, minimum & aggregation 

Dealing with 20M records in Tableau (CTe,Temptable & Empty extract)

--Tableau Handling Large dataset.  Dealing with 20M records in Tableau  Create a Temp table to hold the data and to store the intermediate result in INITIAL SQL & load the data to TEMP Table. doo the calculation on the top of that temp table in the Tableau Custom SQL. Create an Empty extract on top of it  Publish the Data source  & refresh on the tableau server level only. Empty extract Create a Boolean paramter  Create the workbook  Make a calculated field on the top of that parameter Show the parameter and select True Create a extract by adding that calcualted field as exculding the True  You can check the no of records in the workbook is ZERO AND Now you have zero extract ready  Now make the parameter to False so that the the condition will True (True exculde in the Extract filter & Parameter will select False) Now publish the data source on the tableau server. Refersh over the tableau server. We can connect that datasource to get a...