Build an Executive KPI Dashboard for My Business
Worldwide
I'm looking for an experienced Business Intelligence / Dashboard expert to build a KPI dashboard for my business. The goal is simple: I want to open one dashboard every morning and immediately understand the health of my business, identify bottlenecks, and know exactly where to focus to increase sales and profitability. What I Need The dashboard should automatically update daily and pull data from multiple sources, including: Meta (Facebook & Instagram Ads) Excel spreadsheets CRM exports (Pipedrive) Other marketing and sales data sources The dashboard should be scalable so additional data sources can be added over time. The Dashboard Must Include Executive Overview Revenue Marketing spend Leads Calls booked Calls completed Show rate Sales Average sale value ROAS Cost per lead Cost per sale Daily, weekly, monthly and yearly comparisons Campaign Performance For every campaign, I want to see: Spend Leads Cost per lead Calls booked Calls completed Show rate Sales Revenue generated ROAS Cost per sale Conversion rates Ad / Creative Performance For every individual ad: Spend Leads Cost per lead Sales generated Revenue ROAS Conversion rate Ability to identify winning and losing creatives Marketing Platform Comparison Compare performance across different sources like: Facebook Instagram Google TikTok Organic Referral Email Other sources Sales Funnel Show conversion percentages at every stage. Sales Team Performance Sales by closer Close rate Revenue generated Average sale value Calls completed Conversion rates Trends Daily, weekly and monthly charts for: Revenue Leads Marketing spend ROAS Sales Cost per lead Cost per sale Requirements Modern, clean executive dashboard Easy to understand in less than five minutes Automatic daily updates Interactive filters (date, campaign, platform, country, sales rep, etc.) Fast performance even with large datasets Well-organized backend that can easily be expanded Preferred Skills Power BI (preferred) Excel Dashboard Development Power Query Power Pivot Business Intelligence Data Visualization Meta Ads reporting Marketing analytics CRM integrations KPI dashboard design Please Include in Your Proposal Examples of executive dashboards you've built. Experience with marketing and sales dashboards. Which tools you recommend (Power BI, Excel, Looker Studio, etc.) and why. Your estimated timeline. How you would structure this project. I'm looking for someone who thinks like a business owner, not just someone who builds charts. I want a dashboard that helps me make better decisions every day, identify opportunities, and scale the business efficiently. If you've built dashboards that have improved decision-making for CEOs or founders, I'd love to see your work.
- Less than 30 hrs/weekHourly
- < 1 monthDuration
- IntermediateExperience Level
$5.00
-
$15.00
Hourly- Remote Job
- One-time projectProject Type
Skills and Expertise
Activity on this job
- Proposals:20 to 50
- Last viewed by client:yesterday
- Interviewing:3
- Invites sent:0
- Unanswered invites:0
About the client
- United StatesScottsdale1:39 AM
- $15K total spent28 hires, 11 active
- 1,175 hours
- Mid-sized company (10-99 people)
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers earned on Upwork in 2020
Find the best freelance jobs
Growing your career is as easy as creating a free profile and finding work like this that fits your skills.
Trusted by