Performance / Efficiency

The performance of reports depends on the underlying data model. There is a rule of thumb that every action in the report should not take longer than 10 seconds. If an action takes longer, there should be a valid explanation or justification.

Simple things like data types can already have an impact on performance, especially as data volumes increase. For example, a column containing text data can occupy much more space than a column with numerical data. This can slow down the performance of queries and reports.

Additionally, significant performance gains can be achieved through the use of aggregation. Aggregation is the process of combining data to create a higher-level summary. (Less detail) This can significantly enhance the performance of queries and reports, especially for users interested in the big picture and not the details (unless something is wrong).