Problem solve Get help with specific problems with your technologies, process and projects.

The basics of improving BI performance

Find some basic ways of improving BI performance at your company. Learn about in-memory analytics, columnar databases and how data aggregation affects BI performance.

What are some basic ways of improving BI performance?

If you mean the speed at which reports and other types of business intelligence data get to the users, there are several ways to improve that. 

The first option is to aggregate your data; that automatically produces better performance. In addition, you can scale back the amount of data you let users query and analyze. For example, even though you have 10 years of historical data in your data warehouse, only two years might be used for day-to-day analysis, with archived tables for the data from the other eight years. 

A popular approach these days is to use columnar databases vs. traditional databases with a row orientation.  Columnar software typically indexes and compresses data, which can significantly increase performance. 

In-memory analytics is another BI trend that leverages a system's memory cache to load, index and compress data, giving users access to high volumes of data with nearly instant response rates on queries. Those are some of the most common ways of improving BI performance.

Dig Deeper on Business intelligence best practices

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.