Preferred Method to aggregate daily data

[kpasa]

Hello Community! I'd like to get your thoughts on how I should approach a new project.

We get a daily report from one of our partners with subscriber usage stats. It comes in the form of a CSV and is only 1 day's worth of data. Our goal is to aggregate the data in order to do calculations on subscriber usage stats.

My question to you is how do recommend performing this data collection. On one hand, it seems logical to import and append each day to a master list and just set up a simple pivot table or macro to extract the subscriber stats. This could, however, be a potential problem, as that is going to be a lot of data by the end of the month, and I'd like to be able to drill down to daily data, if needed.

Do you have any suggestions or methodology you prefer when working with this type of problem/solution? Initially, I'd like to keep the data local, although I might consider using some data visualization tools, such as domo or tableu.

 

[FDibbins]

For me, I would add the data as you described - 1 day below the other, all on the same sheet. This keeps calcs (relatively) simple. Keep in mind that if this data is coming from a different program/app, the dates may be text dates and not real dates - but that is fairly simple to fix