Preferred Method to aggregate daily data

kpasa

Board Regular
Joined
Nov 20, 2015
Messages
82
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.
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

FDibbins

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
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
 

Watch MrExcel Video

Forum statistics

Threads
1,095,322
Messages
5,443,785
Members
405,251
Latest member
shanezer

This Week's Hot Topics

Top