top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is Dimensions and Facts in context of Tableau?

0 votes
408 views
What is Dimensions and Facts in context of Tableau?
posted Jul 21, 2016 by Mahie Shah

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

1 Answer

0 votes

Facts are the numeric metrics or measurable quantities of the data, which can be analyzed by dimension table. Facts are stores in Fact table that contain foreign keys referring uniquely to the associated dimension tables. The fact table supports data storage at atomic level and thus, allows more number of records to be inserted at one time. For instance, a Sales Fact table can have product key, customer key, promotion key, items sold, referring to a specific event.

—>Dimensions are the descriptive attribute values for multiple dimensions of each attribute, defining multiple characteristics. A dimension table ,having reference of a product key form the fact table, can consist of product name, product type, size, color, description, etc.

answer Sep 19, 2016 by Manikandan J
...