I work for a distributor and biannually we send out a survey to our employees to gauge how well our vendors are doing. After the employees take the survey we compile a report and share it with the vendor. Right now it is an access database and a crystal report. I am looking to get it into SSRS but am having difficulties determining how to model the data. This is what I have so far:
Dim_Question (survey questions have set values and comments)
Dim_Date (start-end date of survey)
Do I have two fact tables one for the comments and the other for the set values? The Dim_Question table seems a bit light. All I can think of putting in it is the question, category of question and comment y/n.
Another part of this vendor process is that we give them a report on total sales we have for their product lines. Any help is appreciated. Thanks.