A personal exprience with Microsoft BI
Updated March 08, 2016
A personal exprience with Microsoft BI
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Microsoft BI
Microsoft BI was used to implement a data warehouse and a reporting solution for our department and it provides data downstream to multiple lines of business. We currently use SQL Server, SSRS and SSIS 2012 and are currently deploying SSAS while some of the reports are using IBM Cognos.
- Microsoft provided us with an easy and flexible platform to build our data warehouse with very good performance for our medium size databases.
- We used SSIS to seamlessly orchestrate a daily ETL load of around 5Gb in less than two hour.
- Visual Studio was used as our main development tool and allowed us to integrate our solution for deployment into TFS as well as track defects and meet milestones within our project.
- I would like to have a simpler, better integrated solution for reporting in which we can easily integrate all SSRS, Performance Point, Powerview and Porwerpivot forms into Sharepoint or any other custom reporting portal
- Also I would like MS BI to have better integration with other products for example SSIS with Cloudera Hadoop or SSRS with Cognos cubes.