Five Steps to Optimizing BI, Data Warehouse Performance

In recent years, business intelligence and data warehouse systems have evolved from their beginnings as batch-oriented systems for basic reporting, querying and analysis used by small, well-defined user communities. Today, many are enterprise systems that handle many kinds of queries and must be continuously available for diverse user communities.
The pressure is on business intelligence and data warehousing professionals to handle ever-higher data volumes and ever more complex queries while reducing decision latency. There is a five-step approach to identify key business drivers, optimize system performance, guide new technology deployments, improve responsiveness, and invest for future performance demands.
Source: Intelligent Enterprise