I have a database of mobile numbers (some 2 million +),
each has done specific kind of recharge ( around 8 types), and revenue for particular month, I have this data for 3 months
These recharges are done multiple times and some numbers have done multiple types of recharges in same month.
I have to check if there is any trend in this data like
- increase in revenue after selection of particular pack?
- trend of pack selection over months
this all can be done easily in excel but can’t import this to excel, also i have very limited knowledge of access.
I tried using power pivot in excel but the pivot output also exceeds rows in workbook ( around 1 million)