Overall Satisfaction with Microsoft BI
Northcraft Analytics use Microsoft BI for IT Performance Management analysis, along with other visualization and analysis technologies such as Tableau, Microstrategy and Qlikview (to a limited extent). Northcraft Analytics is a provider of BI platform independent applications, so we support our customers across a wide range of verticals leveraging Microsoft Analysis Services/XML/A as the core of our Hybrid Olap (HOLAP) architecture, along with the data warehouse. Some key use cases for analysis would include:
- Incident Assignment Bottleneck Analysis
- Service Level Agreement Breach Identification and Probabilistic Prediction
- Configuration Management Analysis - Aging, Mean Time Between Incident and Adoption Analysis
Northcraft Analytics helps our customer base leverage their existing technology investments to analyze and improve IT performance.
- Connecting andJoining Multiple Data Sources Together - Multi-Dimensional SSAS
- Usability in Report Creation for Business Analysts (Excel via Analysis Services specifically), Executives (Performance Point and Power BI) and Power Users (Report Builder)
- Collaboration (via SharePoint only, before the release of Power BI Designer)
- Speed of Analysis - Specifically when leveraging SSAS on databases up to 5 TB
- Speed of ETL processing - Multiple Parallel Sequential Jobs with SSIS/DTS
- Parallel Sequential job Processing within the SSIS GUI, not using DTS
- More Options for non-SharePoint portal Integration
- Reporting Services performance browser rendering time for reports
- SAP Business Objects,Tableau Server,MicroStrategy Analytics,Oracle BI Foundation Suite
We chose Microsoft BI due to performance, functionality, TCO and openness (yes, I know, this sounds strange for Microsoft).
- SAP Business Objects has a less attractive GUI for end users, inferior Excel integration, inferior SharePoint integration, requires more labor to enhance performance and has higher licensing costs than Microsoft BI.
- Tableau Server has no real ETL capabilities... and thus requires an underlying BI stack. So, while Tableau rules the visualization world with Tableau Desktop, Tableau Server doesn't give us all of the capability we need for a full BI solution for our clients. Tableau Desktop makes an excellent complementary product to Microsoft BI. We typically recommend using both to customers in certain situations.
- Microstrategy - Comprehensive Multidimensional/HOLAP platform, expensive, visualizations are better than SAP BO, but not as strong as Microsoft, especially Microsoft SSAS + Tableau (which can be acquired at a lower price point). Excel integration isn't as seamless as SSAS to Excel either.
- Oracle - Expensive, patchwork of acquired BI tools rather than a platform, inferior visualizations. This platform is meant for customers who are already trapped in Oracle licensing.