Share

Home > High Performance Business Intelligence

High Performance Business Intelligence

Technologies Enabling High Performance BI

64-Bit Architecture for Maximum Capacity

MicroStrategy 64-bit BI means more information for more users with higher performance and higher system availability. Beyond the cost efficiency and performance benefits, 64-bit establishes a stable foundation for future BI expansion. 64-bit delivers increased BI capacity through the ability to add more users, run more reports, access more data, perform advanced calculations more frequently, and develop more BI apps.

Learn more about 64-bit BI »

In-Memory BI for Speed-of-Thought Performance

MicroStrategy’s in-memory technology is engineered to meet the increased demand for higher BI performance, which is driven by the rapid expansion of both data volumes and the number of BI users in organizations across industries. MicroStrategy accelerates performance by pre-calculating computations and placing the results into its in-memory acceleration engine to dramatically improve real-time query performance.

Learn more about in-memory BI »

Faster Dashboards for Richer Data Analysis

Dashboards provide visual, executive views into KPIs, enabling quick business insights. MicroStrategy enables higher performing dashboards, averaging 30-45% faster execution and interactivity. Using new compression methods, MicroStrategy dashboards have a smaller footprint than ever before – up to 55% smaller – resulting in faster delivery using less network bandwidth or delivering even more analysis and data for dashboard users.

Try high-performance dashboards »

Linear Scalability:
Scale-in & Scale-out

Successful BI applications accelerate user adoption and enhance productivity, resulting in demand for more users, data, and reports. MicroStrategy provides the ability to adapt quickly to constant changes and evolve along with business requirements. MicroStrategy Intelligence Server has been proven in real-world scenarios to deliver the highest performance at scale with the fewest servers and minimum IT overhead.

Highly Optimized SQL

High performance BI starts with optimizing SQL queries to retrieve results from the database as quickly as possible. BI performance is dependent largely on the time queries take to execute in the database. An average reporting request usually takes 40 seconds to complete, out of which 34 seconds, or 85% of the query time, is spent executing in the database. Therefore, it is critical to optimize report queries to reduce database execution time.

Automated Problem Prevention

MicroStrategy Health Center automatically scans all BI servers to anticipate and correct system problems. System performance is enhanced through problem prevention and system uptime is improved with faster issue resolution. Administrators are alerted to problems or potential problems and provided with suggestions. Health Center generates a collection of logs and diagnostic information that can be sent directly to Tech Support.

Find out more about Health Center »

High Performance BI Webcast Series

High Performance BI Webcast

MicroStrategy is pleased to offer a series of educational webcasts with practical tips to enhance the performance of your MicroStrategy BI applications. Each webcast in the series is focused on new aspects of developing or fine-tuning BI environments for faster BI applications, growing numbers of BI applications, increasingly high data volumes, and expansive user communities. See more information and schedule for the High Performance BI Webcast Series.

The webcast series will provide key information on areas such as:

  • How to improve performance with in-memory BI
  • Best practices for VLDB optimizations
  • Caching strategies
  • Optimal configuration settings
  • Aggregation techniques
  • How to optimize report and dashboard design
  • Hardware considerations
  • Best practices for performance and stress testing

MicroStrategy Performance Analysis

MicroStrategy Professional Services can help customers assess and prioritize their performance opportunities with a comprehensive Performance Analysis.

Each BI implementation is unique. Therefore, our performance specialists will look at particular requirements, guide customers through the hundreds of factors that impact performance, and deliver a customized Performance Roadmap to help customers achieve their performance goals.

In just one week, our performance specialists will conduct a thorough examination of your BI implementation, providing you with actionable recommendations on these five key areas to improve overall BI performance.

The MicroStrategy Performance Analysis delivers:

  • Performance Optimization Roadmap. A report that contains prioritized recommendations to achieve higher performance.
  • System Configuration. Optimum configuration setting recommendations to achieve more efficient use of resources across different MicroStrategy products.
  • Performance Monitoring Plan. A set of key performance indicators to proactively monitor and identify performance opportunities.

Talk to your local MicroStrategy team and request a Performance Analysis from one of our specialists. For more information, download the brochure.

New BI Software Standards for High Performance

MicroStrategy Enables High Performance BI

Up to 10x Faster BI Applications

Today’s BI applications must efficiently access terabytes and even petabytes of data. Average BI application query response times often range from 10 seconds to one minute or more, with query optimization relegated to the database.  Poor performance can undermine successful adoption and growth of a BI application. MicroStrategy’s high performance initiative will set a new performance standard, aiming to deliver up to 10x faster query response time at any data scale.

Faster than 3-Second Response Time for Most Predictable Queries and Analyses

The majority of business queries are predictable: business people often run similar reports on a daily, weekly, or monthly basis.  MicroStrategy’s In-memory technology caches computations and places the results into server memory, accelerating repetitive operational reports as well as most subsequent analyses.

Faster than 5-Second Response Time for Most Ad Hoc Queries

By optimizing and accelerating all aspects of its BI platform, from SQL generation to SQL execution to data rendering, MicroStrategy seeks to enable 50% of all ad hoc queries to return in less than 5 seconds. Specific areas of R&D include:

  • Faster Database Queries: MicroStrategy’s ROLAP technology leverages database engines for complex calculations and data joins, employing the latest new techniques to reduce database processing time and optimize overall query performance, including (1) database-specific optimizations, (2) workload balancing across multiple databases using improved aggregate awareness, and (3) reduced number of SQL passes for sophisticated analyses to improve database query time by as much as 75%.
  • Larger Data Caches: MicroStrategy is further enhancing its data loading algorithms to allow organizations to incorporate more data into memory within regular data loading windows. The latest enhancements in MicroStrategy 9 Release 2 show performance improvements of over 30% in cube data load time.
  • Faster Web Interactivity: End users experience faster Web interactivity as a result of minimized data transfer, streamlined processing, optimized page construction, faster page rendering, and on-demand Javascript loading. The objective is to continue to provide the richest user interactivity with rapid performance on Web browsers and mobile devices.
  • Faster Dashboards: MicroStrategy’s dashboard technology has led to a new model of business information delivery called DashboardApps, which can contain an entire day’s worth of information within a single dashboard for even the most novice and non-traditional BI users. Further enhancements will include on-demand data transfer technology, enhanced data compression algorithms, and optimized rendering algorithms to make dashboards faster and easier to use.

Leading Companies Are Leveraging MicroStrategy High Performance BI

Read Case Studies »

High Performance BI Press Releases