Business Intelligence (BI) - ERP - Dashboards

Performance Tuning

The Performance tuning of 3 areas to look for are as below. These tasks can easily take around a week.

1) ETL - Since Loading data is very time consuming ,its best to put that activity in a night load job.The ETL process needs to be tuned more and more as possible,since some problems are out of control of DW team.

2) Query Processing -Query performance is a big issue in cases where the reports are run directly against Relationship database.(especially ROLAP).for this situation the DW team has to spend considerate amount of time in tuning the query.

3) Report Delivery - End users can experience delays in receiving their reports due to factors other than the query performance. For example, The type of server settings, network traffic, end user’s own computer and the Reporting tool used. It is important for the data warehouse team to look into these areas for performance tuning.

The DW team has to create document on
· Performance tuning document -( Goal and Result )

Next >> Quality Assurance

Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, ERP

Free Dashboards