Just load your table in using the wizard from script editor.
Then you should be fine using such dimensions like Loan_Type, Officer, Branch with some aggregations like e.g. sum(Balance). What else do you want to use as dimensions? Maybe your dates, so have a look at Henrics recent blog post on how to add calendar tables to your data model.
Hope this helps,
It's pretty easy to do with if you create a key on the detail table. it's as easy as doing
Rowno() as Key,
and then you can do code like this
month([Applied Date]) as [Applied Month],
//this removes it from the fact table and leaves it in the dimension table above
Drop Field [Applied Date] from Detail;