Is is better to have 1 line-1entry data or 1 line-multiple entries for reporting purposes?

[Anonymous]

Hello,

I produce datasets in SAS where I can have ~10M of lines, based on the number of accounts and extraction date.

To reduce the size of the files to keep (I have to keep them because it is mandatory) and connect to PowerBI, can I use before the upload a "group by" in sas to reduce the # of lines?

Example: instead of importing 1000 lines all with the same profile (customers that possess product 1, that live in city x and that used credit card), I make a group by and only import 1 line with the total of revenue for that profile.

The groups/profile combination normally don't change and if there would be an extra category to add to the group by, there would be just extra lines but not the 10M.

Is this sensible or I risk to jeopardize my dashboards in case I need to add another segmentation?

[ray_aramburo]

Group by is an excellent way of reducing rows, but its usage will depend on the granularity requirements you may have as for sure you will lose some detail.

Answer is plainly It depends on your requirement.