Looking for BI performance standards (response time)

View previous topic View next topic Go down

Looking for BI performance standards (response time)

Post  Rajesh on Tue Jan 18, 2011 9:27 pm

We are trying to establish bench mark for BI report performance. Is there any Industry Standards on BI reports response time, like

What is the average response time for an average standard report.
Average response time for drill down/drill through query to shown up.
Dashboard/Scorecard refresh time.

Any reference would be helpful. Thanks in advance.

Rajesh

Posts : 1
Join date : 2011-01-18

View user profile

Back to top Go down

Re: Looking for BI performance standards (response time)

Post  ngalemmo on Thu Jan 20, 2011 2:17 am

Other than it being better than the old system, there isn't a standard or benchmark that I am aware of. There are far too many variables to have any number mean anything.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

5 seconds

Post  Mike Honey on Tue Mar 01, 2011 8:34 pm

My target is always 5 seconds - "Analysis At the Speed of Thought".

If any of those actions take longer than that, the user often gets frustrated and either gives up discouraged or cancels and retries. When a user is analysing, longer delays mean they will lose the mental map of what they are investigating.

That said, it's a "target", so I don't get too fussed about the performance of extreme cases (e.g. users using Excel PivotTables on SSAS cubes as a data dump tool for thousands of rows, or users with weak PCs / network connections).
avatar
Mike Honey

Posts : 185
Join date : 2010-08-04
Location : Melbourne, Australia

View user profile http://www.mangasolutions.com

Back to top Go down

Re: Looking for BI performance standards (response time)

Post  Vishy on Wed Mar 14, 2012 5:24 am

Be realistic and have eyes on following parameters :

1) Time of the day report is being run.
2) From which locations reports will run.
3) Whether a report is data hungry.
4) Bandwidth of the internet/intranet available.

------------
If using cubes then design some reports which are readymade and can directly give the data.
If few reports needed every now and then , schedule those reports so that in morning when users come they get the direct report output.

More in depth analysis is propotional to more number of queries and data requirments.
Set the expectations right in the beginning else .... difficult in the end.


Vishy

Posts : 75
Join date : 2012-02-28
Location : India

View user profile

Back to top Go down

Re: Looking for BI performance standards (response time)

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum