1001 Freelance Projects
Latest Projects from Freelance Marketplaces
Today is: 23-Oct-2025 18:48 GMT
View Project
View this project in detail (Note: you will be redirected to external marketplace)
Project title: Excel Dashboard Developer – Performance Tracker
Posted by: External project from PeoplePerHour
Started: 21-Oct-2025 04:38 GMT
Description: Project Overview:

I’m looking for an experienced Excel specialist to build an automated performance dashboard for my estate agency group.

We have six Sales offices and six Lettings offices, and I want to track daily performance metrics from two data sources:
1. Call logs (exported from our phone system)
2. Reapit CRM reports (valuations, viewings, instructions, offers, sales agreed, exchanges, etc.)

The aim is to have one Excel workbook that I can easily update each day by pasting in new data or refreshing Power Query connections. The dashboard should automatically show:
• Individual Negotiator activity (calls, talk time, performance vs target)
• Office-level summaries for each of the 12 branches
• Department-level views (combined Sales and Lettings totals)
• A simple front page with clear charts, slicers (Office / Negotiator / Date), and key KPIs.



What I Need:
• Build an Excel-based dashboard with dynamic visuals and KPIs
• Automate data refresh (via Power Query or macros)
• Create clean dashboards for:
• Individual negotiators
• Each office (6 Sales, 6 Lettings)
• Department summaries (Sales & Lettings)
• Use a clean blue and white theme with easy navigation
• Include a short guide or Loom video showing how to update the data daily



Skills Required:
• Advanced Excel (Power Query, PivotTables, Dashboard Design)
• Strong visual layout and performance reporting experience
• Familiar with CRM or sales data structures (Reapit experience a plus)
• VBA experience (nice to have but not essential)
Project ID: 3454729
Project category:
Project budget:
View this project in detail (Note: you will be redirected to external marketplace)
Last Projects / Browse Projects
  Project Started
AI Integration for Pitch and Memo Automation
Category: AI Chatbot, AI Development, API Development, Graphic Design, Laravel, PHP
Budget: ₹37500 - ₹75000 INR
23-Oct-2025
16:04 GMT
Amazon Home Goods Listing Optimization
Category: Amazon, Content Writing, Data Analysis, Internet Marketing, Keyword Research, Link Building, Search Engine Marketing (SEM), SEO
Budget: ₹600 - ₹1500 INR
23-Oct-2025
16:04 GMT
Open-Plan Office Design Concept
Category: 2D Drafting, 3D Modelling, 3D Rendering, 3D Visualization, AutoCAD, Building Design, Building Information Modeling, Interior Design
Budget: $10 - $30 USD
23-Oct-2025
16:03 GMT
Mailchimp Workshop Promo Email
Category: Branding, Content Creation, CSS, Email Marketing, HTML, Mailchimp, Marketing Strategy, Web Design
Budget: $30 - $250 USD
23-Oct-2025
16:03 GMT
App Nativa Seguridad Ciudadana
Category: Android, Android App Development, API Development, IOS Development, IPhone, Mobile App Development, Mobile Development, PhoneGap, REST API, UI / User Interface
Budget: $750 - $1500 USD
23-Oct-2025
16:03 GMT
Self-Hosted Cold Email Setup
Category: Automation, CRM, Data Management, Database Management, Email Marketing, Lead Generation, Marketing Strategy, Scripting
Budget: $8 - $15 USD
23-Oct-2025
16:02 GMT
Resolve Old Traffic Ticket Suspension
Category: Admin Support, Contracts, Legal, Legal Analysis, Legal Consultation, Legal Research, Tax Law, Time Management
Budget: $250 - $750 USD
23-Oct-2025
16:01 GMT
Minimalist Bold Logo Needed
Category: Adobe Illustrator, Branding, Graphic Design, Illustration, Logo Design, Photoshop, Vector Design, Visual Design
Budget: $250 - $750 USD
23-Oct-2025
16:01 GMT
Booklet-Ready PDF Conversion
Category: Adobe Acrobat, Adobe InDesign, Brochure Design, Graphic Design, PDF, Print Design, Proofreading, Visual Design
Budget: $10 - $30 USD
23-Oct-2025
16:01 GMT
E-Commerce App Mockup Design
Category: Adobe XD, Figma, Graphic Design, IPhone, UI / User Interface, User Interface / IA, UX / User Experience, Web Design
Budget: €12 - €18 EUR
23-Oct-2025
16:00 GMT
Wordpress + Canva Specialist
Category: Canva, Content Creation, Graphic Design, Video Editing, Video Production, Visual Design, Web Design, WordPress
Budget: $2 - $8 CAD
23-Oct-2025
16:00 GMT
6940binkii Concept Prototype -- 2
Category: Graphic Design, Mobile App Development, UI / User Interface, User Interface / IA, UX / User Experience, Web Development, Web Design
Budget: $250 - $750 USD
23-Oct-2025
15:59 GMT
python script
Category: Automation, Programming, Python, Scripting, Software Architecture, Software Development
Budget: $250 - $750 SGD
23-Oct-2025
15:58 GMT
GHL - Asistente Virtual Multicanal con Workflows en GoHighLevel (WhatsApp, Instagram y Facebook)
Category: Automation, Chatbot, Conversational AI, CRM, Data Integration, Digital Marketing, Email Marketing, Facebook API, Instagram API, Lead Generation
Budget: $10 - $30 USD
23-Oct-2025
15:56 GMT
Crypto Investor Lead Generation
Category: Content Marketing, Cryptocurrency, Digital Marketing, Internet Marketing, Lead Generation, Leads, Social Media Marketing, Twitter
Budget: ₹1500 - ₹12500 INR
23-Oct-2025
15:56 GMT
Browse All Projects
Projects by Skills ...
Projects for 'android'
Projects for 'ajax'
Projects for 'asp'
Projects for 'aspnet'
Projects for 'cms'
Projects for 'cpp'
Projects for 'csharp'
Projects for 'css'
Projects for 'delphi'
Projects for 'design'
Projects for 'drupal'
Projects for 'excel'
Projects for 'facebook'
Projects for 'flash'
Projects for 'html'
Projects for 'java'
Projects for 'javascript'
Projects for 'joomla'
Projects for 'iphone'
Projects for 'mysql'
Projects for 'photoshop'
Projects for 'php'
Projects for 'python'
Projects for 'ruby'
Projects for 'seo'
Projects for 'sql'
Projects for 'sysadm'
Projects for 'translate'
Projects for 'typing'
Projects for 'twitter'
Projects for 'vbnet'
Projects for 'xml'
Projects for 'wordpress'
Projects for 'writing'
Read RSS feeds ... New!
RSS feed for 'android'
RSS feed for 'ajax'
RSS feed for 'asp'
RSS feed for 'aspnet'
RSS feed for 'cms'
RSS feed for 'cpp'
RSS feed for 'csharp'
RSS feed for 'css'
RSS feed for 'delphi'
RSS feed for 'design'
RSS feed for 'drupal'
RSS feed for 'excel'
RSS feed for 'facebook'
RSS feed for 'flash'
RSS feed for 'html'
RSS feed for 'java'
RSS feed for 'javascript'
RSS feed for 'joomla'
RSS feed for 'iphone'
RSS feed for 'mysql'
RSS feed for 'photoshop'
RSS feed for 'php'
RSS feed for 'python'
RSS feed for 'ruby'
RSS feed for 'seo'
RSS feed for 'sql'
RSS feed for 'sysadm'
RSS feed for 'translate'
RSS feed for 'typing'
RSS feed for 'twitter'
RSS feed for 'vbnet'
RSS feed for 'xml'
RSS feed for 'wordpress'
RSS feed for 'writing'
New!
Проекты на русском
(Projects in Russian)

Long URL:
www.1001freelanceprojects.com
Mobile version:
m.1001fp.com
Copyright © 2005-2024 1001 Freelance Projects