
Especially in a datawarehousing environment where the reports
run directly against the relationship database, query performance
can be an issue and it is hence ideal for the data warehousing
team to invest some time in performance management.
It is also possible that end users are experiencing significant
delays in receiving their reports due to factors other than the
query performance. For example, network traffic, server setup,
and even the way that the front-end was built sometimes play
significant roles.
DataFactz can play a vital role in performance management and
can deliver an iterative solution with a proven methodology. We
approach the system in different dimensions as shown below
- Database tuning
- BI Tool optimization techniques
- Network Issues
- Server setup