| Switch to standard view |
![]() |
Self-Service Business Intelligence empowers business users to generate reports and run ad hoc analysis without impacting other users or risking crashing the data warehouse and without increasing the workload on IT for database tuning.
|
The ability to provide self-service options for business intelligence has significant benefits for business users as well as IT departments. By not restricting access to reporting, and providing greater flexibility for running queries, business users have faster access to the information they need, and higher satisfaction. If IT can support these requirements without jeopardizing service levels or without special tuning, they can conserve time and resources. Business users often need access to reports outside of established reporting windows, but providing self-service options for many types of reports against traditional data warehouse systems is not practical because reporting functions may involve many database tables and summary functions that severely impact the performance of other data warehouse applications. Ad hoc analysis can be especially problematic, because self-service user-defined queries may incur a very high processing cost, unbeknownst to the user, or in too many cases may risk crashing the data warehouse system for all users. The self-service business intelligence solution is a BI system designed to handle these highly desirable, but unpredictable workloads, without special tuning and running efficiently on standard hardware platforms. Sybase IQ gives enterprises a data warehouse that runs both prepared reports and ad hoc queries 10-100 times faster than traditional data warehouses, giving decision makers timely access to a consolidated view of critical operational data with one data warehouse. Unlike traditional data warehouses, enterprises can also support many users simultaneously with Sybase IQ, enabling business users to break their dependence on reporting teams and access critical information directly.
Sybase?s product offerings for self-service business intelligence include:
Learn More |