2.2 Base teórica o fundamento teórico
2.2.3 Variables de estudio
and project prioritization. On the other hand, CFOs and CIOs want enterprise BI systems because they offer a
single “version of the truth” and the lowest cost of ownership. With MicroStrategy 9, companies can have both.
MicroStrategy’s flexible BI platform provides multi-source data access, rapid application development, and seamless
migration from departmental to enterprise BI.
Microstrategy 9 supports a gradual and Incremental Migration from Islands of BI into a Consolidated
enterprise BI system
Enterprise DW
HR Dept Sales Dept
HR Sales
Enterprise
Finance Dept Fin
HR Dept Sales Dept Enterprise HR Sales
Finance Dept HR Dept Sales Dept
Enterprise DW Enterprise DW
HR Dept Sales Dept Finance Dept Fin Finance Dept Finance Dept Fin Finance Dept Enterprise Stage 1 Disparate Islands of BI
All Running on MicroStrategy BI
Stage 2 Merging Islands of BI
Using MicroStrategy Multi-source
Stage 3 Consolidating Data
Re-pointing Metadata to the EDW
HR Sales
Figure 10: MicroStrategy Technology Provides a Seamless Migration Path from Departmental BI to Enterprise BI
“
Organizations need to gradually and incrementally consolidate their departmental and workgroup islands of
BI into a cohesive enterprise framework that ensures a single “version of the truth” and low cost of operation.
MicroStrategy is directly addressing this challenge with MicroStrategy 9, which contains an In-memory BI and
Multi-source BI capability that will make MicroStrategy’s enterprise-caliber technology equally suitable for
workgroup BI and departmental BI. MicroStrategy’s new platform includes capabilities that allow consolidation
and transformation of departmental and workgroup islands of BI without having to redo reports or dashboards
as consolidation takes place.
”
– Chief Executive Officer and Executive Vice President Research, Ventana
Research
KEY BI REQUIREMENTS MICROSTRATEGY 9 MICROSOFT
seamless Migration from Departmental to enterprise BI • Metadata compatibility enables
consolidation of islands of information
• Metadata abstraction layer enables seamless re-pointing of the data source without affecting the business model
• Advanced migration and environment management tools
yes
MicroStrategy’s metadata compatibility enables departments to incrementally migrate their business logic into a consolidated BI environment. MicroStrategy’s metadata abstraction layer allows companies to “re-point” the metadata to automatically access new data locations without disrupting reports or requiring redesign.
MicroStrategy Object Manager can automatically consolidate disparate departmental BI applications while reconciling all overlaps or conflicts that may arise.
no
Microsoft does not provide a unified metadata layer that can be used across the entire BI platform. The lack of a unified metadata layer results in difficulty, complexity, and high costs when customers try to consolidate departmental applications.
Microsoft does not offer robust migration tools that can be used to automatically consolidate different departmental deployments. Multiple overlapping tools that are loosely integrated with one another further increases the complexity of consolidating multiple departmental applications.
KEY BI REQUIREMENTS MICROSTRATEGY 9 MICROSOFT
high Performing Multi-source Data access
• Unified multi-dimensional business model across multiple data sources • Optimized retrieval of multi-source
data
• Smart Push-Down architecture • Automatic multi-source drill
anywhere
• Support for distributed workload database architectures
• Direct access to multi-dimensional data sources including SAP®
BW InfoCubes and QueryCubes, Hyperion Essbase, and Microsoft Analysis Services.
• Direct reporting from salesforce.com
yes
MicroStrategy’s unified multi-dimensional business model allows companies to create a single logical view spanning multiple data sources, making it easy to add new data sources. Users are able to seamlessly drill across multiple data sources.
MicroStrategy optimizes the retrieval of data from heterogeneous data sources. MicroStrategy dynamically selects the most efficient data source to query. The MicroStrategy SQL engine automatically creates queries optimized for each data source for fast performance without IT tuning efforts.
MicroStrategy’s Smart Push-Down architecture 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.
lIMIteD
Although Microsoft’s Unified Dimensional Model allows data to be accessed from multiple data sources, data must mainly be accessed from Microsoft Analysis Services. The current lack of more open data access in Microsoft Reporting Services through Report Builder is a big limitation. In addition, Excel or PowerPivot is typically used for performing analysis on local data sources that are not integrated with the enterprise-wide BI semantic layer, creating administration challenges and resulting in multiple versions of the truth and spreadmart problems.
Microsoft lacks MicroStrategy’s automatic multi-source drill anywhere capabilities that allow users to drill across hierarchies, for example, from a region to customers. Microsoft’s lack of automatic drill- anywhere capability prevents users from leveraging all of their organization’s data assets and limits end user analysis efficiency. Microsoft Analysis Services cubes pre- calculate all possible combinations of data. Bringing in this unnecessarily large amount of data across the network increases network traffic and decreases response time. rapid Departmental BI
application Development • No need for a data warehouse or
ETL tool
• Graphical and intuitive design interface to minimize IT effort • Automatic detection wizard for
creation of business logic and table mappings
• Pre-created templates for quick project and dashboard development • Command line administrative tool
for high volume tasks
• Comprehensive data model support yes
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.
MicroStrategy’s graphical design interface makes it fast and easy to add new data sources and define business logic. A set of pre-created templates speed dashboard development.
MicroStrategy automatically detects data types from data sources and creates the entire business logic layer, speeding development.
MicroStrategy provides a scripting interface that allows project developers to schedule massive and repetitive tasks in a matter of seconds.
lIMIteD
Microsoft requires heavy IT effort to develop a Business Intelligence environment. Building and deploying Analysis Services cubes requires substantial training, as well as IT development time. IT resources represent the largest cost component in multi-year Business Intelligence lifecycle ownership expenditures. As a result, many customers find Microsoft’s IT-intensive development cost prohibitive.
Use of Excel and PowerPivot for end user reporting is heavily dependent on SharePoint as well as SQL Server components. For example, in order to create and share a PowerPivot workbook, users will have to first create a PowerPivot workbook and publish it to SharePoint to share it with other users. The PowerPivot workbook published to SharePoint is deployed as an Analysis Services cube. In order to use PowerPivot for departmental deployments IT may have to first install and configure SharePoint and Analysis Services. Microsoft offers limited automation of high-volume tasks through a command line administration tool. Lack of a centralized scripting tool translates into higher administrative efforts.
KEY BI REQUIREMENTS MICROSTRATEGY 9 MICROSOFT
Centralized and De-Centralized administration
• Web-based administration for business managers
• Allows distribution of administrative tasks, including object promotion, data integrity checking, and user management
• Update Packages allow distributed development
yes
MicroStrategy 9 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, their own BI applications, and their own metadata within the same infrastructure as the enterprise BI environment.
MicroStrategy 9 Update Packages can automatically consolidate disparate development teams’ updates and changes.
lIMIteD
Microsoft requires several administration points for its BI platform components including: SQL Server Analysis Services, SQL Server Reporting Services SharePoint Server, and PerformancePoint. Multiple components and multiple points of administration dramatically increase administration complexity and prevent Microsoft from allowing centralized distribution of all administrative tasks. Microsoft does not offer update packages that can consolidate different teams’ development efforts.