I'm fairly new to dimension modelling and looking for some advise on the approach to take in modelling this scenario. I'm struggling to identify the Fact where as everything feels like a Dimension.
I have Project which has various attributes (value, location, start and end dates etc)
A Project can have many characteristics (a mixture of boolean flags, dropdown and numeric values)
A Project can have many Awards (type, score)
A Project can have many References (type, who, reference)
None of this data changes frequently, most is fairly static. The source system contains many tables incorporating key values pairs and various relationships.
The ultimate goal is to simplify the model for use in self service reporting along with creating a view of each project containing characteristics, awards, references etc.
The types of questions end users may ask are:
"Show me projects with these characteristics where the project location is x"
"Show me projects with more than 5 awards"
"Show me projects where value is greater than X with these characteristics"
Any advise on the approach I should take to modelling this would be much appreciated.