I have extensive google sheets/excel/vba experience in an reporting and analytics. Ive worked as an operations analyst at some of the biggest ecommerce companies in aus/globally (eBay, Groupon) creating automated solutions to drive optimisation.
I have both implemented, and assisted in setting up databases for a business. This has included extracting data from various inputs/ sources and linking them together to give a business visibility on its performance, as well as categorically redirecting different inputs into a a master file which could then be analysed historically. to accompany this, I created a dynamic dashboard linked to the database which displayed key metrics and could be altered by the user.
I tailor made all components of this process on the front end (the form, invoice sheets etc) and back end (scripting and automation) to achieve the most efficient, simple solution. Im sure I could do the same for you.
can share examples.