Sunday 5 July 2015

Important notes in Tableau Desktop

Important notes in Tableau Desktop

  • Multidimensional data sources do not support aggregations and binned data.
  • Multidimensional data sources supports only in windows.
  • You can use tableau to aggregate measures only with relational data sources, multidimensional data sources contain aggregated data only.
  • Null values are ignored in median, count, sum, avg and countD.
  • Median does not work on live connection.
  • Median was not there before 8.2 version.
  • Percentile required extract data. Percentile works with only extracts.
  • When all measures are disaggregated you see a mark for each row in the view, you can't select marks to keep only, exclude or create a set when all measures are disaggregated.
  • A dimension can be aggregated as a measure using minimum, maximum, count and count (distinct)
  • Count (Distinct) is not support for Microsoft Access, Microsoft Excel and text files data sources. These data sources requires extract to work with CountD
  • Dis-aggregating the data can result in a performance degradation.
  • When you are writing formulas, any part that displays in bold indicates that it will be computed locally with in tableau on the aggregated results. Any normal weight text will be computed at the database level.
  • Functions are displayed in Blue color while creating calculation field.
  • Data window fields are displayed in Orange color while creating calculation field.
  • Operators are displayed as Blank color while creating calculation field.
  • Parameters are displayed as Purple color while creating calculation field.
  • Comments are colored as Green color while creating calculation field.
  • Grand Totals cannot be applied to continuous dimensions.
  • The view must have at least one header to apply Grand Totals.
  • If row headers are displayed you can calculate Grand Total for row, If column headers are displayed you can calculate Grand Total for column.
  • Forecasting is not supported for multidimensional data sources.
  • Forecasting doesn’t work if the view contains:
    (a) Table calculations
    (b) Disaggregated measures
    (c) Percent calculations
    (d) Grand Totals or Sub Totals
    (e) Date values with aggregation set to exact date
    (f) A time series contains null values also imposes constraints.
  • The smaller the p-value, the more significant the model.
  • If your data contains negative values tableau cannot plot them on a logarithmic scale. All values with a negative value will be displayed at 1 on the axis.
  • The pattern match is not case sensitive in filters wild card match.
  • If we are using multidimensional data source wild card match option is only available when filtering single level hierarchies and attributes.
  • Filters cannot be applied across multiple data sources.
  • In previous versions of tableau desktop, the All using this data source option was called make global and the only this worksheet option was make local.
  • Sorted fields are identified by a sort icon on the right side of the field.
  • You cannot nest inner joins within left or right joins. These joins will cause a "join expression not supported" error.
Source : Suresh Reddy NallapaReddy

15 comments:

  1. That is very interesting; you are a very skilled blogger. I have shared your website in my social networks! A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article.
    Tableau Online Training|
    SAS Online Training |
    R Programming Online Training|

    ReplyDelete
    Replies
    1. Tableau A2Z - Fb Group Brain Child....:): Important Notes In Tableau Desktop >>>>> Download Now

      >>>>> Download Full

      Tableau A2Z - Fb Group Brain Child....:): Important Notes In Tableau Desktop >>>>> Download LINK

      >>>>> Download Now

      Tableau A2Z - Fb Group Brain Child....:): Important Notes In Tableau Desktop >>>>> Download Full

      >>>>> Download LINK Z5

      Delete
  2. Thank You for sharing very useful information
    i like this blog , keep updating
    Best Tableau Training Institute in Hyderabad

    ReplyDelete
  3. such a wonderful article...very interesting to read ....thanks for sharining .............
    Tableau online training in Hyderabad

    ReplyDelete
  4. Thank u for posting such kind information.keep sharing like these.

    http://www.rstrainings.com/adv-java-online-training.html

    http://www.rstrainings.com/core-java-online-training.html

    ReplyDelete
  5. This is most informative and also this post most user friendly and super navigation to all posts.
    Best Tableau Training Institute

    ReplyDelete
  6. I feel Tableau is used to create some very important and useful aspect to solve many complicated problems and create the best dashboards and reports for end users.

    Tableau Rest Api Connection


    ReplyDelete
  7. Thank you for your valuable post. It is really helpful. Keep posting.
    Visit us: Core Java Online Course
    Visit us: Best Online Java Course

    ReplyDelete
  8. Very Nice Blog and the best explanation of uses tableau, This blog will help students a lot. I am glad to announce that ducat is offering best expert training for Tableau and guaranteed placement assistance for students to help the grow in your career

    ReplyDelete
  9. This site have particular software articles which emits an impression of being a significant and significant for you individual, able software installation.This is the spot you can get helps for any software installation, usage and cracked.
    sduplicate-cleaner-pro-crack
    tableau-desktop-crack
    franzis-cutout-pro-free-crack
    efofex-fx-draw-tools-crack
    antivirus-zap-pro-crack

    ReplyDelete
  10. Tableau A2Z - Fb Group Brain Child....:): Important Notes In Tableau Desktop >>>>> Download Now

    >>>>> Download Full

    Tableau A2Z - Fb Group Brain Child....:): Important Notes In Tableau Desktop >>>>> Download LINK

    >>>>> Download Now

    Tableau A2Z - Fb Group Brain Child....:): Important Notes In Tableau Desktop >>>>> Download Full

    >>>>> Download LINK r8

    ReplyDelete