Legal Notice
MicroStrategy does not guarantee the accuracy of any information presented in this document, and there is no commitment, express or implied, on the part of MicroStrategy to update or otherwise amend this document. The furnishing of this document does not provide any license to patents, trademarks, copyrights or other intellectual property rights owned or held by MicroStrategy.
Copyright Information
All Contents Copyright © 2010 MicroStrategy Incorporated.
All Rights Reserved.
Please click the link to agree to the above terms and continue with the QuickTour. AGREE »
Flexible Technology for Departmental to Enterprise BI
Seamless Migration from Departmental to Enterprise BI
MicroStrategy 9
- Metadata and Data Layer De-coupled: MicroStrategy’s metadata abstraction layer allows companies to “re-point” the metadata to automatically access new data locations without disrupting reports or requiring redesign.
- Consolidate Disparate Departmental BI Applications: MicroStrategy’s metadata compatibility enables departments to incrementally migrate their business logic into a consolidated BI environment. MicroStrategy Object Manager helps consolidate disparate departmental BI applications by reconciling overlaps and conflicts.
Microsoft
- Inefficient Change Management: Microsoft lacks a single, enterprise business metadata layer that could be consolidated across all of Microsoft’s BI platform components. Microsoft has not released any plans to create a common metadata in its future plans including Project Madison and Gemini.
- Lack of Tools to Consolidate Disparate Departmental BI Applications: Microsoft does not have a tool equivalent to MicroStrategy Object Manager that manages metadata deployments and consolidates and reconciles disparate departmental BI applications.
MicroStrategy Technology Provides a Seamless Migration Path from Departmental BI to Enterprise BI
High Performance Multi-Source Data Access
MicroStrategy 9
- Seamless Navigation across Multiple Data Sources: MicroStrategy’s unified multi-dimensional business model allows companies to create a single logical view spanning multiple data sources, making it easy to add any new data sources. Users are able to seamlessly drill across multiple data sources.
- Smart Push-Down Architecture: MicroStrategy performs joins at the database layer, thereby minimizing network traffic and leveraging the power of modern database engines. MicroStrategy further minimizes network traffic by moving the least amount of data to the most optimal database to query.
Microsoft
- Limited Data Source Support: As one might expect, Microsoft optimizes its BI for Microsoft SQL Server and Analysis Services data sources.
- Inefficient Multi-Source Data Access: Microsoft remains unable to choose the most efficient data source or perform push-down joins in the most optimal database, which often requires moving some data from one database to another in order to efficiently perform the data join.
MicroStrategy 9 Multi-source ROLAP Allows Data Environments to be Optimized for Performance and Cost
Rapid Departmental BI Application Development
MicroStrategy 9
- No Need of an ETL Tool or Data Warehouse: MicroStrategy 9 provides easy access to multiple data sources without requiring a data warehouse. MicroStrategy can instantiate In-memory ROLAP cubes by pulling information from multiple sources, obviating the need of an ETL tool or a data warehouse.
- Graphical Architect and Automatic Data Detection: MicroStrategy’s graphical design interface makes it fast and easy to add new data sources and define business logic. MicroStrategy speeds development by automatically detecting data types from data sources and creating the entire business logic layer.
Microsoft
- Requires ETL for Departmental BI: Microsoft does not provide In-memory ROLAP cubes capability that would obviate the need of an ETL tool by accessing multiple sources of data and creating In-memory cubes for departmental application access.
- Inefficient Administration Across Departmental BI: Microsoft does not provide a comprehensive command line administrative tool for high volume tasks, making administration across several departmental BI applications more time-consuming.
Centralized and De-Centralized Administration
MicroStrategy 9
- Flexible De-Centralized Administration: MicroStrategy allows user and application administration responsibilities to be distributed to business people within individual departments using a Web interface. This offloads administrative tasks from centralized IT personnel and gives departments the ability to have their own databases, metadata and BI applications within the same infrastructure as the enterprise BI environment.
- Synchronized BI Departmental Applications: MicroStrategy 9 Update Packages can automatically consolidate disparate development teams’ updates and changes.
Microsoft
- 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.
- Inefficient Consolidation of BI Departmental Applications: Microsoft does not offer the ability to automatically consolidate updates to packages from disparate development teams.
MicroStrategy Supports Distributed Governance Operational Models
