Microsoft BI - a complete BI offer at last!
December 15, 2016
Microsoft BI - a complete BI offer at last!
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Microsoft BI
We build BI solutions on our source systems through Microsoft BI. We use most of SQL Server Enterprise tools, more specifically SSRS, SSIS, SSAS; our end-users mostly work with SS Management Studio, Reporting Services and Excel. Our BI department is for external clients only, we have no internal BI infrastructure.
- Relative ease of use of SSAS cubes for end-users
- Versatility of SSRS for creating reports and automating their executions
- Integration with Office 365
- SSRS Report Builder requires more IT skills than other reporting tools
- No SSAS actions available in Report Builder
- Integrated security tools are not readily available; Management Studio works well for SSAS, but no way to keep track of global security attributions unless you build a report on the DB
- At the moment, the lack of use of Power BI has indered our market progression IMO
- A large majority of customers keeps the solution once implemented, very few have switched platform
- Once organizations implement Office 365, the potential for added business with Microsoft BI will really manifest. At this time, the slow adoption of Office 2013 or more recent is limiting the analysis and visualizations capabilities of our average client.
For analysis and visualization, Power BI is aiming to take a large chunk of Tableau's market share. The rhythm of iterations at this time has in my opinion given the momentum to Power BI. The added functionalities in Excel also make it possible for intermediate users to get familiar with data modeling.