I have been assigned to convert some of the report from microsoft excel to SSRS using SSAS. I have never used the BI Site of SQL Server before and therefore i am stuck.
I am quite clear about the data sources and i think i have figured out the dimension tables and the fact table (i am sure i will have to make lots of changes later). I am not sure where to start with now?
In BIDS will i create a new SSAS project and start defining my dimension and fact tables (would be helpful if i could find tutorial on it) and then use SSIS to import the data from SQL Server database?
or is there any other way of doing this?
Sorry if this seems a silly question but i need your help.