I'm studying Power Query and decided to try and build my own financial Data Model froma number of bank statements. That said, i'm not sure if my model and relationships make sense.
FYI - this link gives a fairly clean picture of the data model I believe.
For background, I live in Thailand, but my income comes from the Usa.
I can only guess that the "SF_BanK_Transactions"(USA) is my best fact table.
Ultimately I'm tring to figure out how many wire transfers I've made from the fact table to "BKB_John"(Thailand) as well as how many atm withdraws I've made in Thailand from the USA banks, which would be located in the "SF_Bank_Transactions".
The only relationhips I can make between tables is through the index table. I've ran into a few relationship errors already.
Thank you ahead of time, I Hope I've described this well enough.
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 3 guests