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.