Database analysis - either VBA or SQL
Budget: £20 – £250 GBP
We have a lot of databases thar require quick analysis. The data is all on there but we need to find a way to get all of the calculations we want to look at in a simple way. We suspect it will be through VBA loops.
In short we want to measure various people/or other data in our database. Most have multiple entries. We would require you to come up with a VBA to quickly calculate and return the results we required. See photo attached as a guide.
It seems like a pretty straightforward job if using excel and the budget is not huge.
Someone has mentioned the possibility of SQL but that is something we are completely unknowledgeable on. One of the databases is updated daily, the rest are historical.
If using SQL, I have a website we can use.
Get in touch if you are interested.
In short we want to measure various people/or other data in our database. Most have multiple entries. We would require you to come up with a VBA to quickly calculate and return the results we required. See photo attached as a guide.
It seems like a pretty straightforward job if using excel and the budget is not huge.
Someone has mentioned the possibility of SQL but that is something we are completely unknowledgeable on. One of the databases is updated daily, the rest are historical.
If using SQL, I have a website we can use.
Get in touch if you are interested.