I need to create a dashboard using 3 dimension tables and 2 fact tables.All 5 tables are in sqlserver.So how do i connect to these tables and i see that facttable contains some dimensions to .So i have to use all the tables i need to use data from all 5 tables.So how do i start ?
When connecting to SQL server you can create joins between different tables in you database. You can also extract by using SQL Queries. My advise would be to take your facttable and then join the different dimensions. Obviously you need to have keys and indexes in your different tables.