About Us

Business Intelligence Topics and Solutions

5 Styles of BI White Paper
Featuring Special Sections on Data Mining, Advanced and Predictive Analysis

» Download Now

An Architecture for Enterprise Business Intelligence
Read about Data Mining, Advanced and Predictive Analysis, and Sophisticated Analysis

» Download Now

Implementation

» MicroStrategy OLAP Services gives both MicroStrategy Web and MicroStrategy Desktop users access to Intelligent Cubes, letting them slice and dice data without having to re-execute SQL against the data warehouse. Intelligent Cubes facilitate ad hoc query and analysis, allowing users to add and hide objects, create derived metrics, subtotal rows, and filter data

» Intelligent Cubes hold data on the MicroStrategy Intelligence Server. Intelligent Cube definitions are saved as reports in the metadata. Intelligence Server utilizes its Analytical and multi-pass SQL generation engines to perform ROLAP operations against the data warehouse.

Statistical Software

What is Statistical Software?

Statistical Software provides functionality to apply statistical theory to data. These statistical functions can range from concepts as simple as a running sum through to advanced financial or probability calculations.

Statistical Metrics and Analytical Functions

It is not sufficient for an enterprise-class BI platform simply to retrieve information from a data source. Business users must be able to apply analytical richness to the data to gain additional insight for accurate, data-driven corporate performance monitoring and decision making.

MicroStrategy enables questions such as how the business is doing, what problems exist, how to solve them, and how to improve operations to be asked at the enterprise level with a consolidated view. To achieve this, the MicroStrategy BI platform:

• Supports a wide range of analytical functions
• Applies these functions across all data sources in the enterprise
• Supports commonly used analytical techniques
• Performs predictive data mining
• Offers rich presentation methods for easy data consumption

MicroStrategy Statistical Software capabilities

Using the Statistical Software capabilities within MicroStrategy, users can pick from more than 270 mathematical, OLAP, financial, and statistical functions. Users then can apply these functions on the fly to any set of enterprise data without any administrative help. These functions range from simple database concepts such as running totals, to full Mathematical functions such as sum, count, average, correlation, slope, and standard deviation; to OLAP functions such as rank, running sum, and exponential moving average; to Financial functions such as internal rate of return and accrued interest; and to Statistical functions such as chi-squared and exponential distributions, kurtosis, skew, and t-tests, among a host of others.