Most of the time, your users would be spending time navigating the user interface or the dashboard. Besides having a beautiful dashboard, it is important to have a responsive one.
Here are some best practices for a lean mean dashboard.
1. Do not use Calculated Dimensions anytime- It is good idea move this to the data model script and create those dimensions there. Calculate or derive those dimensions in your LOAD scripts.
2. Do not use Set Analysis against large data sets. Minimize using it for normal data sets.
3. Do not use long expressions. If you can simply them or use constant to reduce calculations, do it.
4. Do not use Count Distinct too often. Use it very cautiously!
5. Avoid using Macros – Macros should only be used for approved Reporting need, and any special circumstance.
6. Avoid using nested if statements
7. Reduce the numbers of Sheets and objects in the QVW app.
8. Do not have too many opened Chart objects in a sheet. Try using hiding charts not needed all the time.
9. Use conditional calculations on charts with large charts
No comments:
Post a Comment