Many of them are not aware of MS Datawarehousing(DWH) tools and technique. How is the market for Microsoft DWH in general? are there a demand and need of skilled personals in these areas?
Thanks,
Rajiv.
It is a fast growing market.
Have a look here for information about market shares for OLAP: http://www.olapreport.com/market.htm
These figures say nothing about SSIS, SSRS and they are from 2005.
HTH
Thomas Ivarsson
Hi:
I have been working at client work station with BI Intelligence Studio but i want deploy the project in server machine, but my windows credential don't have sufficient privilege for do it. However i know the server credential for do it but i can't find the project settings for do that.
The account you connect to the AS server as will need permisions to deploy the database. In the Windows Start menu, you can right-click on the BI Studio item and select Run As... and this will give you the option to run the UI under a different windows use account.
This account does not necessarily need permissions to access the source relational data as you can specify in a data source to use the service account or impersonate a specific account. Additionally, many data sources will let you save a user name and password in the connection string. (For security reasons, Analysis Services will remove the password form the connection string, but will prompt you for it later as necessary and will store encrypted under the current user credentials to avoid excessive prompting.)
