We currently run a Magento e-commerce website with a MySQL database. We're looking for a freelancer MySQL expert to generate ad-hoc reports for us. We will probably be requiring about 4 hours a week, although initially it will be more then that. We are looking to create reports that show things like: Sales broken down by item with a lot of info about type/time. Reports that integrate with Google Analytics and Mailchimp.
I've attached an example report. Please comment on how long you think it would take to complete.
> x axis represents number of weeks
> y indicates the users move from one step to the next
> the values are accumulating - in other words after 1 week 30% of new members have shopped for the first time. in the second week another 5% shop for the first time, the value is now 35%.
> There may be some blank data as it hasn't been a year since someone shopped for the 7th time. This is just an example, I'm not sure if that's true
> We should be able to filter this report by sign up date AND/OR referrer (which is effectively channel)
7 freelance font une offre moyenne de R157/heure pour ce travail
Extensive experience in MySQL development and DBA activities. Proficient in developing complex SQL queries that execute efficiently (good explain plan).
I have 3 yesrs of working experience on SQL and other data related tools. Currently I am focusing on freelancing tasks. So, I can give extra efforts if required.