Dashboards can become quite complex as it is very common to have multiple queries executing at once, especially during the initial load. When we encounter performance issues, it is very difficult to pinpoint exactly where the issue is coming from. Fortunately, we can use the Fiddler tool to help us identify the root cause of a performance-related issue.
Download Fiddler from http://www.telerik.com/download/fiddler. Create a simple dashboard that contains one query and one chart. In our example, we created a query that contains the Calendar Year dimension and Sales Amount measure. The data is then plotted on a Column Chart.