PowerBI expert required - Must understand QuickBooks Online Data Model
Budget: $25 – $50 CAD
I need a resource who will work with me to create some power BI reports using QuickBooks Online Data along with our current sales metrics. The candiate will do a screen share with me to help me create a model that will take actual expenses for Lead Channels and help me determine:
1) Cost per lead per month (overall)
2) Cost per lead per month (Per Channel)
3) Cost of Aquisition for a new customer based on the month spend. Ie If I spend 2000 and get 5 customers what was our Aquisition payback period, depending on the plan that the customer chose.
4) I'd like # 3 for each channel
5) I'd like one page that is projected sales to actual sales, ie we have certain target metrics in conversions and to see in a period what the projects are then to reference back to see if we exceed or didn't our targets.
My challenge are:
1) linking the channel from our sales data with the account in quickbooks
2) Understanding the data structure for QBO
I would like to do this by hourly rate, and will start with meeting for 2 hrs to see how far we go. Once we accept I"ll book a time in central time - north america, to meet.
Must be able to clearly communicate and must be an expert in power bi. I'm pretty good at it myself so I don't want to waste time.
1) Cost per lead per month (overall)
2) Cost per lead per month (Per Channel)
3) Cost of Aquisition for a new customer based on the month spend. Ie If I spend 2000 and get 5 customers what was our Aquisition payback period, depending on the plan that the customer chose.
4) I'd like # 3 for each channel
5) I'd like one page that is projected sales to actual sales, ie we have certain target metrics in conversions and to see in a period what the projects are then to reference back to see if we exceed or didn't our targets.
My challenge are:
1) linking the channel from our sales data with the account in quickbooks
2) Understanding the data structure for QBO
I would like to do this by hourly rate, and will start with meeting for 2 hrs to see how far we go. Once we accept I"ll book a time in central time - north america, to meet.
Must be able to clearly communicate and must be an expert in power bi. I'm pretty good at it myself so I don't want to waste time.