Seeking an Excel Expert to Create Detailed Reports from Excel Exports

Budget

$300.00FIXED

Client

Khoiril Anwar Estonia

Status

OpenApr 14, 2019
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 we're 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 we'd like answered in these reports:

-What's 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?
-What's 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

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

Thanks so much for your interest!

Skills & Expertise Required

Data Analytics Data Management Data Mining Excel 

Offer to work on this project closes in 288 days!

Submit A Proposal

Share this project with your friends



Other jobs by this client

Need a tax professional to help prepare taxes. - Hourly

Freelancers You May Hire


Here are our top professional picks for you to hire



Similar Projects

Data Science Troubleshoot

I need additional data visuals that can be added to make my analysis stronger and I need my logistic regression model improved if possible.

Not to mention, I need to make sure the code deals...read more

Fixed, $20.00

Church List

I need an Excel spreadsheet listings g all of the Christian churches in Brooklyn and Queens. I would need:

1. Name of the Church
2. Name of the Pastor of the Church
3. Phone number of...read more

Fixed, $100.00

Craigslist listing scraping

I need data from Craigslist.
I will share a craigslist link with with shortlisted candidates

I need title, description, price, address and most important Phone and email address given un...read more

Hourly, $10.00

Data scraping task 1

I need Google map data for marketing companies. Mainly i need name, Address, Contact number, website and email. I need 200 records.

Hourly, $15.00