top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How do you normalize data for use in Tableau?

+2 votes
268 views
How do you normalize data for use in Tableau?
posted Jul 14, 2016 by Abhimanyu Singh

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

When an Excel data source (other than a cube) is already formatted as a cross-tabulation or is otherwise aggregated, options for viewing, aggregating, and grouping in Tableau are limited. Tableau cannot see underlying data points that have already been summarized into a higher-level group or order. To take advantage of Tableau’s full functionality, you need to normalize the data before connecting to it from Tableau.

You can normalize a table manually

answer Sep 1, 2016 by Manikandan J
...