i have data in excel and i was hoping to design a star shema model but apparently there are no dimension codes to do that. Is there a way around it or i simply have to generate the codes myself in excel.
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.