Data Visualization

 

  IF We have kept a column to accept NULL Values and have set a default constraint for that column and if we add a NULL value using INSERT INTO statement then NULL will be inserted instead of Default constraint.

  If we want to show sum for a particular segment, avg for another segment, Ratio for the other segment in a single calculation then we use the ATTR Function.    IF ATTR([Segment])='Consumer'  THEN SUM([Profit]) ELSEIF ATTR([Segment])='Corporate'   THEN avg({ INCLUDE [Category]:SUM([Sales])}) ELSEIF ATTR([Segment])='Home Office'  THEN [Profit Ratio]*100 END

   You can Import a custom map from an URL     

  select name1,course from student where course IN ("Art","Math","Eng") group by name1,course having min(marks)>75;

                 Types of Animations in Tableau 1.                            Simultaneous Animations : These are by default 2.                            Sequential Animations : These take more time but make complex changes clearer by presenting                step by step                  Animations are supported by all web browser except Internet explorer                Following Tableau features don’t animate ·         Maps, polygons and density marks in web browser ·         Pie and text marks ·    ...

  Action filter: If you want an action filter to be applied on two or multiple sheets on different dashboards then don’t go with dashboard actions. Instead do the following steps ·         Show the action filter on the existing dashboard ·         From drop down : Apply to worksheets ->Show all worksheets in Workbook ·         Select the worksheet and click on OK Here we have avoided the dashboard filter action which causes navigation to that dashbaord and used the filter.

  Tableau Aggregation Error : Count(IF ‘Last 3 months’=True then 1 end) Use Count outside to avoid tableau aggregation disaggreagation error

You can use a textbox as a title to Show parameter name

If you are facing aggregation issues at front end , directly pull the dimension on the row shelf. And then hide it....so that you will get appropriately values at front end

           Few things to keep in mind when you are delivering a dashboard.                 Things to check while you are delivering a dashboard. 1.  Font size, Font name :  Maintain consitency 2. Color code  : check whether appropriate business sense color coding is applied. 3. Grid Lines, Reference Lines : 4.  Relevant Filters, Data Source Filters, Action Filters:  Whenever you are repointing to a new data source , the data source filters get removed.            5. Numbers :  Most of the times clients are  more concerned with the data accuracy  and its format.Check whether you are formatting  PANE OR HEADER. PREFIX etc. 6.Filter heirarchy and context filters. 7. Grid readability  :   When  there are too many columns,  use Measure names and Measure values in order to fix those appropri...

 Tableau is self service Business Intelligence analytics tool