Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dashbord optimization

Hello everyone. I have a dashboard with a large number of custom card visuals (about 150). Also, for each visual there is a slice for filtering, the parameters for which are taken from the corresponding tables. All this worked very slowly, so there was a question of optimization. I see two ways to optimize this: disabling the influence of visuals on each other, or somehow merge tables with data for slices into one, but there is no clear understanding of how to do this, because in this case all the slices will display the same value. Please tell me if it makes sense to combine tables, can it help? Or maybe there are some other ways to optimize a heavy board. I would be grateful if you share your experience. Thanks

  • 150 cards on a page is too many. I suspect when you use Performance Analyzer for that page, you see high values in the "other" category (while each visuals waits for the other ones to render). Look into a different design to convey your information, or switch to visuals that have small multiples (or use the Cards with States visual). Another option is to use the Deneb visual, so that you can create a single visual that has all the same elements (probably with the "fold" transform and the use of faceting).

     

    Pat

     

4 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee

    150 cards on a page is too many. I suspect when you use Performance Analyzer for that page, you see high values in the "other" category (while each visuals waits for the other ones to render). Look into a different design to convey your information, or switch to visuals that have small multiples (or use the Cards with States visual). Another option is to use the Deneb visual, so that you can create a single visual that has all the same elements (probably with the "fold" transform and the use of faceting).

     

    Pat

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Anonymous First, is this a dashboard or a report page? Other than that, there is very little to go on here. What does  your data model look like?

    • Anonymous's avatar
      Anonymous
      Not applicable

      This is a dashboard, a data model is a set of tables imported from excel