Forum Discussion
tracking real estate data
Hello! It sounds like your financial table should serve as the fact table and the property table would be the dimension table that can be used to filter. You would connect the Property Dim table to the Financial Fact table usining a key for the property and a Date table would also connect to Financial table.
Hello, I'm running into a similar scenario. I have different property types (Multifamily, retail, office etc). With some of their own unique property information. Should all of these property types be in one dimension sheet? Or would it be more efficient to have one sheet for multifamily, one for retail, etc. The idea would be then to link them to a financial sheet that includes sales data (A property sold on xyz date for $abc). I'm leaning towards 1 dimension sheet with a column specifiying which property type it is. There will be some "blanks" for certain property types (Multifamily has 'units' but retail only has 'total square footage' for the size of the property). Any thoughts? Happy to send screen shots/discuss further for clarity.
Hi,
Based on the limited informatin that you hve shared, there should be 1 Dim table for all property types.