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
Related Q&A from Brian Jordan
Expert Brian Jordan discusses three common mistakes that BI teams make when training business users and offers advice on how to avoid them. Continue Reading
Are businesses deploying business intelligence dashboards and scorecards to workers other than managers and senior executives? Learn about high-level... Continue Reading
Learn about some business intelligence trends that are affecting the BI market and BI industry. Learn about packaged analytics software and agile BI. Continue Reading