Context
|
Microsoft BI Stack
|
MicroStrategy BI Stack
|
Remarks
|
Data Access
|
- Any ODBC Data source
|
- Any ODBC Data Source
|
- Microsoft BI has some limitations when compared to MicroStrategy BI for certain data sources.
|
- Small Data sizes when accessing a SSAS cube
|
- No data size limits
|
- Limted access to SAP BW.
|
- Connects to most common data analysis cubes
|
Security
|
- De-centralized Security: Microsoft requires IT professionals to manually configure security in many places, increasing the chances of human error.
|
- Unified Single Sign-On Integration: MicroStrategy provides an automatic single-point of integration for the whole platform with existing security authentication infrastructure such as LDAP, NT, Windows Active Directory, IBM Tivoli, SiteMinder, and database security.
|
-Limited Flexibility in Setting User Privileges: Microsoft offers administrators very limited granularity for setting group and user privileges. This limits administrators' control.
|
- Does not support all types of security.
|
- Supports multiple types of security such as Windows Active Directory or LDAP etc.
|
- SSRS does not support LDAP
|
Data Access
|
- Any ODBC Data source
|
- Any ODBC Data Source
|
- Microsoft BI has some limitations when compared to MicroStrategy BI for certain data sources.
|
- Small Data sizes when accessing a SSAS cube
|
- No data size limits
|
- Limted access to SAP BW.
|
- Connects to most common data analysis cubes
|
Security
|
- De-centralized Security: Microsoft requires IT professionals to manually configure security in many places, increasing the chances of human error.
|
- Unified Single Sign-On Integration: MicroStrategy provides an automatic single-point of integration for the whole platform with existing security authentication infrastructure such as LDAP, NT, Windows Active Directory, IBM Tivoli, SiteMinder, and database security.
|
-Limited Flexibility in Setting User Privileges: Microsoft offers administrators very limited granularity for setting group and user privileges. This limits administrators' control.
|
- Does not support all types of security.
|
- Supports multiple types of security such as Windows Active Directory or LDAP etc.
|
- SSRS does not support LDAP
|
Metadata Layer
|
- Limited metadata layer in PPS
|
- Robust reusable metadata layer: MicroStrategy’s object-oriented metadata defines your enterprise’s business layer in a single repository. Metadata objects can be nested as building blocks to create more complex objects. If a metadata object changes, every other metadata object dependent on it automatically changes.
|
Lack of Unified Semantic Business Layer Across Data / Lack of Integrated Architecture: - Microsoft lacks a common metadata layer. Lack of a common metadata across the platform shows Microsoft BI is still evolving and increases IT efforts, therefore increasing Total Cost of Ownership. - Need for understanding SQL and underlying datasource structure to build reports: Since within Microsoft Reporting Services there is no business layer that can translate the business question into underlying SQL, report developers need prior knowledge of underlying data structures and specialized skills like SQL for developing reports.
|
- Ability to create reusable report objects like Attributes, metrics, filters, prompts, templates, etc.
|
- Lack of Single version of Truth: Since a common library of reporting building blocks e.g. attributes, metrics, filters is not used by the reports, each report has potentially its own definition of entities which would be unrelated to a similar entity in another report.
|
|
- Lack of Abstraction Layer leads to Inefficiencies and Overheads: Since the distinction between various architecture layers is missing e.g. report definition vs. presentation layer, several inefficiencies are created at various level. As an example certain functions such as sorting must be done in the query, requiring SQL changes. Changes to the report layout normally prompt to query the database again.
|
Ad hoc /Self-Service reporting
|
- Self-service is supported using Power pivot and power view of Excel.
|
- MicroStrategy provides most robust and user-friendly report objects to build self-services BI.
|
-Microsoft BI requires end users to know data modeling and relationships knowledge to build self-service BI.
|
- No extra cost required, comes with Office professional plus version of Excel
|
- Microsoft self-service BI caches all report data in client system which limits to work on big data sets.
|
|
- MicroStrategy provides centralized definitions of all report objects which promote one version of the data in an Enterprise.
|
User Interface & SharePoint Integration
|
- Limited web interface which supports to view/run reports, choose parameters, navigate within reports, create folders and subscriptions.
|
- Fully Interactive Web Interface: A wide range of controls gives business users the ability to manipulate, format and analyze any report without IT support. Individual columns can be selected quickly, and drill, pivot and perform tasks can be done on-the-fly. Provides ability to create, edit, save, update and view/run reports; choose parameters, navigate across reports, drill anywhere, create folders and subscriptions.
|
- Microsoft lacks a user-friendly web authoring environment. Most report design tasks must be performed by IT using desktop programming environments.
|
- Seamless SharePoint integration.
|
- WYSIWYG Design and Edit of Any Report at Runtime: Business users create and edit highly formatted reports using a zero-footprint WYSIWYG design paradigm that drastically shortens report development time.
|
- MicroStrategy integration with SharePoint needs some extra effort whereas Microsoft BI is seamlessly integrated in SharePoint.
|
|
- Need to deploy MicroStrategy WSP solution to for SharePoint integration / Use URL API integration with some limitations.
|
|
Alerts / Notifications / Distribution
|
- SSRS allows report subscriptions in various formats to a network shared folder or a SharePoint document library.
|
- Supports most of the types of alerts and subscriptions.
|
MicroStrategy provides most robust Alerting /Subscription options.
|
- No direct email alert or report delivery is supported
|
- Users can subscribe themselves or co-workers to receive all reports available in the MicroStrategy environment on a wide range of output devices.
|
Development efforts / Reusability
|
- Building the first report may take less time when compared to MicroStrategy as it does not require to build metadata layer.
|
- Single Development Environment: MicroStrategy’s single Web interface, single server and single code base provide a unified development environment for the whole platform. No need to learn multiple SDKs.
|
- Multiple development environments: Microsoft BI requires multiple development environments and multiple IT skills resources as Microsoft BI spanned across multiple products
|
- KPIs or objects built in PPS cannot be shared to SSRS as they work independently. Microsoft dashboards require IT to create most of the dashboards logic from scratch, increasing design time.
|
- MicroStrategy technology requires far fewer IT personnel for a given amount of BI users because its metadata is easier to maintain and end users have more self-service capabilities, offloading work from IT staff.
|
- Microsoft technology requires far more IT personnel then MicroStrategy for a given amount of BI object and users because Microsoft report developers cannot reuse the metadata across reports.
|
- Microsoft does not allow users to easily author reports at run time, mainly because Microsoft lacks dynamic prompting. Lack of user self-service requires IT to create and maintain an unnecessary number of reports.
|
- MicroStrategy object prompts allow users to choose from all reporting, analysis, and business logic objects to author their own reports at run time. This reduces user dependency on IT and the number of reports for IT to maintain.
|
-MicroStrategy requires some initial time to build its metadata layer and later saves lot of time to create a self-service BI using the same metadata layer.
|
|
- Dashboards are created using all reports and objects from MicroStrategy’s single metadata. MicroStrategy Intelligence Server provides its sophisticated processing, security, caching, and analytical capabilities.
|
|
Maintenance & Administration
|
- Multiple Servers: Microsoft requires several administration points for its BI platform components including: SQL Server, SharePoint Server, PerformancePoint Services. These multiple servers dramatically increase complexity of administration and prevent Microsoft from allowing centralized distribution of all administrative tasks. Microsoft requires administrators to install and administer several different servers. Multiple, overlapping products contain overlapping functionality, which increases administrative complexity.
|
- Single Server and Centralized Administration: MicroStrategy’s single BI server provides efficient, centralized administration for the IT administrator. A single server with fewer moving parts and processes translates into less downtime.
|
-Microsoft BI platform's Maintenance and Administration require more IT effort and skills span in multiple technologies.
|
- Limited Monitoring and Administration: Microsoft provides very limited out-of-the-box dashboards, reports and KPIs to perform impact analysis, auditing and tuning of the BI application.
|
- Single Point of Monitoring and Administration: MicroStrategy provides a single centralized console for real-time user and system management and an out-of-the box BI environment monitoring application.
|
-Lack of Object Reusability and High Administrative Maintenance: Since the subcomponents cannot be shared across reports, maintenance of the reporting application becomes intensive. As an example, if a “Revenue” metric definition changes from Sum(Amt1) to Sum(Amt2), within MicroStrategy only the definition of one metric object needs to be changed; the changes are automatically committed across all the dependent reports that use the metric. Within Microsoft Reporting Services, each report using the Revenue calculation would need to be modified. Lack of Object Reusability limits the ability for the application to scale in terms of number of reports leading to slower development turn around, especially important when the reporting needs grow at an enterprise level.
|
Cost
|
- Varies by requirement and tool set needed
|
- Relatively very expensive than Microsoft BI
|
|