Data model reletaed question

[nafric]

Hello:

This is the dataset example i got from excel. To make a data modelwhich field i need consider as dim and fact table?

Sourc_file	user_email	system_time stamp	tool Name
\\abc	abc@xy.com	9:02:12 AM	Formula
\\abc	xyz@xy.com	10:02:12 AM	Developer
\\abc	tcx@xy.com	11:02:12 AM	Python
\\abc	lkj@xy.com	12:02:12 PM	R

Appreciate your help.

Thanks

[danextian]

Hi @nafric 

A fact table stores measurable, usually, numeric data (sales, revenue, transaction volume) which may have a varying degree of granularity (transaction or line item level). A dimension table stores descriptive attributes (customer - customer location, customer email or product - product category, model, color, size, sku). Yours is a user dimension table containing user creation time (possibly) and dev roles.

[srlabhe · Accepted solution]

As per standards the Dim table is the one where you have required dimensions for data analysis. While Fact table normally have corresponsing keys with Facts (measures in it).  This looks insufficient data to decide but you can use email to derive Users Name and put in Dim Table and any count of column which makes meaningful data should work here.

Hope it helps.