March 5, 2010 at 8:58 pm
hello m currently working on a project of business intelligence.Its my final year project. i m having a company database n i have 2 analyze it n generate queries by finding patterns and create a report.how should i start the project???? i have database in the form of excel sheets.i have integrated d database in sql server 2008. i want 2 use business intelligence studio(visual studio 2008) as a front end and sql server 2008 as backend. is it possible??? where shud i write queries??? how do i connect sql 2008 wid visual studio??? should i use d analysis project in visual studio??? plzz help...!!!1 thanx....
sql2008
March 6, 2010 at 4:18 am
Hi,
You can use Visual studio(VS) for different reasons. Firstly you can use a SSIS project within VS to import data from within the excel spreadsheet. then you can further build on this by creating an analysis services project and developing a cube. Whats the projects objective
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply