Studying Power Query, does this Data Model and relationships make sense?

jstar40
Posts: 3
Joined: Thu Feb 11, 2021 4:08 pm

Studying Power Query, does this Data Model and relationships make sense?

Postby jstar40 » Mon Feb 22, 2021 12:03 am

Hi Folks,

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.
https://1drv.ms/u/s!AjBFR0k-0IKjjAh6q8eHsDfJo4vt?e=EMFalb

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.

Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 3 guests