When you design for business intelligence (BI) or mobile BI, the response time (sometimes also referred to as load time ) will always come into question. The concept of fast loading pages is nothing new. Plenty of material exists on the web that covers everything from designing web sites to developing apps.
Every so often I am presented with this question: What is an acceptable response time for a mobile BI asset? And my answer—“it depends”— generally causes confusion. This is often because the person asking the question is looking for a magic number of seconds that’s regularly quoted on the web by different surveys or studies.
But to provide consistent results can be more challenging than it may appear. There are several factors that will ultimately dictate our success. We can manage some of them through best practices. Others will be completely out of our control.
Let’s take a look at several pieces that may come into play.
Mobile network presents challenges for response time
Mobile BI inherits many of the same challenges that exist with data-driven apps, which are at the mercy of the mobile networks that they run on. In a previous blog post, I referred to this network as the “digital bridge.” People frequently forget that this digital bridge can be made up of multiple networks and can lead to unreliable bandwidth.
In order to manage the challenges related to mobile networks, consider:
- Displaying warning messages when a slow connection is detected. This is a common method used with many mobile apps that heavily rely on live wireless connections
- Providing testing tools that your users can use to obtain objective feedback regarding connectivity, especially in remote locations
- Promoting the offline feature to minimize the use of wireless connections for assets with less frequent data updates
Data vs. Page Load
Typically, the response time in traditional mobile BI implementations is made up of two main parts. First is the data load, which includes the download of results from the database query. Second is the page load, which includes the necessary elements to display on the page.
In order to manage the challenges related to both pieces, consider:
- Minimizing the query time by tuning the database objects. If the database query takes 60 seconds to return the results on your server, it’s not going to magically take less time on the mobile device.
- Developing mobile-ready assets (reports and dashboards) with highly focused target deliverables instead of saving desktop reports that are designed for downloads to spreadsheets
- Designing or leveraging other BI application options that can use advanced features to minimize multiple requests for the same report
Adjust based on your audience
One of the reasons why I always say that “it depends” is because the concept of response time is dictated more by user expectations or perception and less by the actual time it takes for the page to load. The terms fast and slow are relative depending on your audience. What may be acceptable to one set of users may not be to another.
In order to manage the perception, study the target user audiences to match the solution with their expectations:
- With roles that are customer-facing and demand frequent travel, such as executive teams or sales, the expectation may be in single digits—especially if the solution is required for customer interactions
- Users with analysts or research roles may be more tolerant due to their past experience and type of work
Unless you are taking advantage of new technologies, such as in-memory computing, you’ll need to successfully manage response time. Your users’ perceptions, which are largely influenced by their daily (and sometimes less complicated) experiences with their mobile devices, will have a direct impact on the success of your solution.
What are other factors to consider in order to improve response time?
By Kaan Turnali, EPM Channel Contributor, from: http://turnali.com/blog/mobile-bi-design-framework-response-time/
As Global Senior Director, Business Intelligence (BI), for SAP’s Global Customer Operations (GCO) Reporting & Analytics Platform, Kaan Turnali is responsible for the development, oversight, and execution of strategy for the BI platform across GCO’s worldwide user base. Prior to joining SAP in 2006, he worked as a senior BI consultant specializing in strategy, design, and development of enterprise BI solutions for SMEs and Fortune 500 companies. His background and experience in the integration of business and technology span over two decades. He is also an adjunct professor, teaching BI in the doctor of business administration program at Wilmington University. See Kaan’s articles on EPM Channel here.