Forum Discussion
Data model reletaed question
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 | [email protected] | 9:02:12 AM | Formula |
| \\abc | [email protected] | 10:02:12 AM | Developer |
| \\abc | [email protected] | 11:02:12 AM | Python |
| \\abc | [email protected] | 12:02:12 PM | R |
Appreciate your help.
Thanks
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.
2 Replies
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.
Hi Anonymous
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.
