
Excel spreadsheet data mining required (possibly into database?)
- or -
Post a project like this4400
£70(approx. $94)
- Posted:
- Proposals: 1
- Remote
- #235902
- Awarded
Description
Experience Level: Intermediate
No idea the right price for this!
Basically we have a spreadsheet of data from a website where we have performers. The spreadsheets are taken from the websites and split into sheets with the credits received and any debits. This could mean money for a show performed, subscription to their services, credits from a special offer etc. The data show the time and date, the buyers username, the amount paid, the charge associated to our performer (amongst others).
So, heres what we need asap! We need this data in an easy to read front page. We need it to be able to do some preset queries and show this data in perhaps chart formats. Example queries might be:
1) Most active user
2) Most active user by date/week period in each month/by service (show/special offer/subscription)
3) Best days of the month across all performers
4) Best performer
5) Number of special offers by type and again by time of the month
6) Average added number of Twitter followers
7) Commission and charges over given period
Ive attached the spreadsheet to the job, we have three of these for different people, the only data not here is for other platform they perform on but we can add those at a later date and would like to too.
Any questions come back to me...!
Basically we have a spreadsheet of data from a website where we have performers. The spreadsheets are taken from the websites and split into sheets with the credits received and any debits. This could mean money for a show performed, subscription to their services, credits from a special offer etc. The data show the time and date, the buyers username, the amount paid, the charge associated to our performer (amongst others).
So, heres what we need asap! We need this data in an easy to read front page. We need it to be able to do some preset queries and show this data in perhaps chart formats. Example queries might be:
1) Most active user
2) Most active user by date/week period in each month/by service (show/special offer/subscription)
3) Best days of the month across all performers
4) Best performer
5) Number of special offers by type and again by time of the month
6) Average added number of Twitter followers
7) Commission and charges over given period
Ive attached the spreadsheet to the job, we have three of these for different people, the only data not here is for other platform they perform on but we can add those at a later date and would like to too.
Any questions come back to me...!

Alistair M.
100% (102)Projects Completed
94
Freelancers worked with
74
Projects awarded
48%
Last project
25 Apr 2025
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies