SSIS and SSRS RRS feed

  • Question

  •  Hi,

       I am working as Dot Net Professional and need to switch in MS BI... i need guidance how to do that means what are the preliminary steps to achieve that...

    Currently working on ASP.NET,C#,VB.NET and SQL Server and Oracle SQL Developer.

    Please advice..

    Thanks & Regards,

    Chayan Upadhyay

    Thursday, August 15, 2013 6:44 PM


  • Hi,

    doing business intelligence on the Microsoft stack is a huge field. The next step depends on the field you would like to work. Generally said you have the choice between Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS) - There are other technologies which can further improve the business intelligence experience like SharePoint and Excel. They are all working together, but every single one needs some special knowledge. A good general starting point is to have a good knowledge of SQL and SQL Server (which I think you have, because of your current work).

    Could you give an insight where do you want to start? Do you want to start with transferring and transforming data from one place to another (SSIS), or building cubes for analysis or data mining (SSAS), or building reports for an end user (SSRS)?

    Best Regards. When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer. This helps us build a healthy and positive community.

    @Horizon_Net | Blog

    Saturday, August 17, 2013 2:25 AM