For this assignment, you will use the Excel file provided for the course project

Question

For this assignment, you will use the Excel file provided for the course project to create a fact table. It is important that you understand what a fact table is and how it may differ from say a dimension table. Fact tables simple store facts about your dataset. You should create a sample fact table using at least four columns of data from the Excel file. At a minimum the student submission should include the following content:

• Explanation of what a fact table is.

• Description of how a fact table differs from a dimension table.

• A sample fact table containing at least four columns taken from the sample

Excel file. Dataset: https://community.tableau.com/docs/DOC-1236

Explanation / Answer

Q1) Explanation of what a fact table is.

A fact table works with dimension tables. A fact table holds the data to be analyzed, and a dimension table stores data about the ways in which the data in the fact table can be analyzed. Thus, the fact table consists of two types of columns. The foreign keys column allows joins with dimension tables, and the measures columns contain the data that is being analyzed.

Suppose that a company sells products to customers. Every sale is a fact that happens, and the fact table is used to record these facts. For example:

Now we can add a dimension table about customers:

Customer ID

Name

Gender

Income

Education

Region

In this example, the customer ID column in the fact table is the foreign key that joins with the dimension table. By following the links, you can see that row 2 of the fact table records the fact that customer 3, Sally Jones, bought two items on day 8. The company would also have a product table and a time table to determine what Sally bought and exactly when.

Q2) Description of how a fact table differs from a dimension table

Q3) A sample fact table containing at least four columns taken from the sample

Please find the link to download the excel that contains "Facts_Table" tab below:-

https://drive.google.com/file/d/151_br4F0YwqeiT0uJeeravgkm6eceoKZ/view

Please let me know in case of any clarifications required. Thanks!

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.