We are looking for someone who can create a system in either excel or other that can create a set of reports from a csv file.
The csv file is a mobile phone bill showing a number of mobile phone users and the numbers they have called, it also lists the type of call, the duration of the call , the cost of the call.
Each line shows a seperate call, We are looking to use this same tool every month by just inserting a sheet called "current month" which will of different number of entries each month and then all the reports will automatically update.
The reports need to shows:
Top 10 users with the most usage in time
Top 10 users with the most usage in cost
Top 10 users with the most usage in each type of calls
Top 10 users with the most usage in SMS
Top 10 frequently dialed numbers and by who.
Please see below the headings that the csv file contains:
Date Time Number Called By Country Type of Call Description Usage Cost
10 freelancers are bidding on average $70 for this job
I am working with as a Process Analyst with a Multinational company. We do all kind of analysis in Excel day in and day out. In Excel, there is no =impossible()