Seeking an Excel Expert to Create Detailed Reports from Excel Exports

We have exported 3 different files (all .csv) from Infusionsoft for 4 U.S. Cities:
1. Registered List
2. Attended List
3. Buyer List

This totals 12 .csv files in total which will be provided. What were looking for are eye-pleasing reports (maybe in a couple of different styles) that show the correlation between the date people registered, the attendee/show rate, and whether or not they purchases (as buyers).

We envision something that provides a lot of information about the relationships between when people register for an event, how close they register in relation to their attendance date and then whether they buy or not. A few questions wed like answered in these reports:

-Whats the correlation between WHEN people REGISTER and whether or not they ATTEND?
-How many DAYS out BEFORE the event they choose to attend do they register?
-Are people who register CLOSER to an event MORE likely to attend it or less likely?
-Whats the correlation between WHEN people register and the likelihood they will BUY?
-What are the MOST popular event TIMES?
-What TIMES bring in the most ATTENDEES?
-What TIMES bring in the most BUYERS?
-% that SHOW up
-% that BUYS

Were open to how this data is visually shown as long as we are able to easily see these correlations. Wed like a 48-hour turnaround. Delivery no later than EOD Saturday.

Thanks so much for your interest!
About the recuiter
Member since May 20, 2018
Khoiril Anwar
from Laane-Viru, Estonia

---

---

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions