Optimize Your Success on Upwork with Data Cleaning Projects

Instagram Manager for Dental Office | Content Creation, Reels & AI Automation

Job Type: Freelance, ongoing
Experience Level: Intermediate to Expert
Industry: Dental / Healthcare
Goal: Grow our Instagram presence, attract new patients, and build trust in our dental practice.

About the Project

We are a dental office looking for a creative, reliable Instagram Manager to help grow our practice through professional social media content, engaging Reels, and consistent posting.

We are also building an AI automation system using a Mac Mini and OpenClaw. We would love to work with someone who understands how AI tools can streamline content creation, scheduling, reporting, and other repetitive marketing tasks.

Our goal is to build a professional, trustworthy, modern dental brand that attracts new patients and keeps our existing community engaged.

Responsibilities
1. Instagram Content Creation
Create engaging Instagram Reels, posts, Stories, and carousels.
Develop educational dental content that is easy for patients to understand.
Create content about preventive care, cosmetic dentistry, teeth whitening, veneers, Invisalign or clear aligners, and other services we offer.
Design professional graphics using Canva or similar tools.
Maintain a consistent brand voice, visual style, and posting schedule.
Turn approved photos and videos from our dental office into engaging content.
2. Instagram Growth
Develop a strategy to grow local followers and reach potential patients.
Research relevant local hashtags, trends, and content opportunities.
Optimize captions, calls to action, and Instagram profile information.
Encourage legitimate engagement and build relationships with our local community.
Track profile visits, reach, engagement, inquiries, and appointment requests.

We prioritize attracting real local patients, not buying followers or chasing vanity metrics.

3. Engagement & Lead Generation
Monitor comments and direct messages.
Respond to routine questions using office-approved templates.
Direct appointment inquiries to our front desk or approved booking process.
Escalate questions about symptoms, diagnosis, treatment, pricing exceptions, or emergencies to the appropriate staff member.
Never provide independent clinical advice or make promises about treatment outcomes.
4. AI & Automation

We are setting up a dedicated Mac Mini with OpenClaw and want to explore ways to make our marketing more efficient.

Potential responsibilities include:

Creating draft captions and content ideas with AI.
Building a monthly content calendar.
Organizing approved content and reusable templates.
Automating reminders for content review and publication.
Generating weekly or monthly Instagram performance reports.
Exploring approved integrations with social media scheduling tools.

You do not need to be an OpenClaw developer, but experience with AI-powered marketing workflows is a strong advantage.

All AI-generated content must be reviewed and approved before publication. Any automation must follow Instagram's rules and our privacy policies.

Qualifications
Proven experience managing Instagram business accounts.
A portfolio showing Reels, social media graphics, and measurable results.
Experience with local businesses, dental offices, medical practices, or other service businesses.
Strong copywriting, visual storytelling, and editing skills.
Familiarity with Canva, CapCut, Meta Business Suite, or equivalent tools.
Understanding of Instagram analytics and local lead generation.
Experience with AI tools such as ChatGPT and automated marketing workflows is a plus.
Excellent communication and ability to follow an approval process.
Monthly Deliverables

We are open to your recommendations, but our starting expectations are:

12–16 Instagram feed posts or Reels per month.
12–20 Instagram Story frames per month.
Monthly content calendar.
Captions, calls to action, and relevant local hashtags.
Basic community management and monitoring of incoming messages.
Monthly performance report with recommendations.
A monthly planning meeting or written strategy update.

Please clarify whether filming on-site, video editing, photography, paid advertising, and responding to DMs are included in your proposed price.

Important Privacy & Compliance Requirements

We are a healthcare business and take patient privacy seriously.

No patient photos, videos, testimonials, or identifying information may be published without appropriate documented authorization.
Never share patient information in AI tools or external platforms without prior approval and an appropriate privacy and security review.
All treatment claims, before-and-after content, and promotional offers must be reviewed and approved by our office.
No misleading claims, fake reviews, purchased followers, or unauthorized automated engagement.
Our office retains final approval over all published content and patient communications.
To Apply, Please Answer These Questions
Have you managed Instagram for a dental office or another healthcare business? Please share examples.
Can you share three Reels or posts you created and explain their results?
What would your first 30-day content strategy look like for our dental office?
How would you use Instagram to generate local appointment inquiries rather than simply increase followers?
Which tools do you use for content creation, scheduling, and analytics?
Do you have experience using AI to streamline social media management?
What is your proposed monthly fee, and exactly what does it include?
Our Ideal Candidate

We want someone who combines creativity, consistency, marketing strategy, and professionalism. We are interested in a long-term working relationship with someone who can help grow our practice while building efficient AI-assisted marketing workflows.

Please include your portfolio, proposed monthly package, and a brief outline of what you would accomplish during your first month.

I’m providing a set of Excel and CSV files that are currently cluttered with duplicate rows and a variety of missing or incorrect values. Your job is to give each file a thorough scrub so the data is fully analysis-ready.

You’ll receive the raw spreadsheets along with a short set of validation rules (required columns, acceptable ranges, and a few business-specific checks). Working in Excel, Power Query, Python/pandas, or any other reliable tool of your choice, please remove all duplicates, repair or clearly flag invalid or empty cells, and make sure the overall structure of each sheet stays intact.

Deliverables
• A cleaned version of every spreadsheet (.xlsx or .csv as supplied) with duplicates removed and faulty entries fixed or flagged.
• A concise change log or notes tab summarising what was altered—enough for me to trace the adjustments quickly.

When you reply, highlight the relevant data-cleaning experience you have; no lengthy proposal needed. If you can turn this around within two days, great—otherwise include an accurate timeline so I can plan accordingly.

Skills: Python, Data Processing, Data Entry, Excel, Data Scraping, Data Analysis, Data Management, Data Annotation

develop free account software for import export business

We need a reliable freelancer to clean and organize an existing database, verify data accuracy, and collect new information from online sources. The work includes reviewing current records, identifying and correcting inconsistencies, updating missing fields, and maintaining a consistent, accurate dataset. You should be comfortable handling structured data, following clear guidelines, and delivering clean, organized results on time. This is a part-time project with potential for ongoing work for the right fit.

* I Will Create a Stunning Interactive Power BI Dashboards.

*Pricing:* Starter 80$

*Description:*

*Is your data in Excel but you need a CEO-level dashboard?*

I will convert your messy Excel / SQL / CSV data into a beautiful, interactive Power BI dashboard.

*What You Will Get:*

*Starter ($80):*
- 1 Page Dashboard
- Up to 2 Data Sources (Excel/CSV)
- Basic Charts & KPIs
- 2 Revisions
- Delivery: 2 Days

*Standard - MOST POPULAR ($180):*
- Up to 3 Pages Dashboard
- DAX Calculations, Filters & Slicers
- Data Cleaning + Power Query
- Insights Summary PDF
- 5 Revisions + Video Guide
- Delivery: 3 Days

*Advanced ($350):*
- Up to 6 Pages Full Business Dashboard
- SQL Integration + Automation
- Row-Level Security + Live Data Refresh Setup
- Full Documentation + 14 Days Support
- Delivery: 5 Days

*My Expertise:* Power BI, DAX, Power Query, SQL, Excel

*What I Need From You:*
- Your data file (Excel, CSV, Google Sheet or SQL)
- What KPIs you want to track
- Any example/dashboard you like

*Why Me?* My team delivers 3x faster. We have 50+ pre-built templates.

---

* I Will Clean, Automate and Analyze Your Excel Data Using Python and Advanced Excel

*Pricing:* Starter $50 | Standard $120 | Advanced $250

*Description:*

*Tired of spending hours cleaning Excel sheets? I will automate it forever.*

I will clean your dirty, duplicate, messy Excel data and build automated reports using Python & Advanced Excel.

*What You Will Get:*

*Starter ($50):*
- Data Cleaning (Remove duplicates, errors, formatting)
- Cleaned Excel File + Basic Pivot Report
- Up to 5,000 rows
- Delivery: 2 Days

*Standard ($120):*
- Advanced Cleaning + Data Analysis
- Pivot Tables, Charts & Dashboard in Excel
- Python Script for Future Automation (Pandas)
- Insights Report (What to improve)
- Up to 25,000 rows
- Delivery: 3 Days

*Advanced ($250):*
- Complete Excel Automation System
- VBA Macros + Power Query Automation
- Python Script + User Guide
- Google Sheets / Excel Integration
- Unlimited Rows + 7 Days Support

*My Edge:* My team cleans and validates in parallel. You get error-free data in hours.

---

I’m looking for a reliable Virtual Assistant to help with administrative support, file management, document organization, and record updates. This is a small ongoing project requiring approximately 5 hours of work per week.

Tasks Include:
- Organizing digital files and documents
- Maintaining folders and file management systems
- Updating records, spreadsheets, and databases
- Performing general administrative support tasks
- Reviewing documents for accuracy and consistency

Requirements:
- Experience in virtual assistance and administrative support
- Good file management and document organization skills
- Basic knowledge of Microsoft Excel and Google Sheets
- Strong attention to detail and ability to follow instructions
- Reliable communication and timely task completion

Please share your relevant experience with virtual assistance, admin support, and document organization when applying.

We’re looking for a reliable virtual assistant to handle ongoing data entry and database updates for about 5 hours a week. Most of the work is in Airtable and Google Sheets, with some light web research when records need missing details. This is a long-term, hourly role for someone accurate and consistent.

Scope of work:

Update and maintain records in our Airtable base and Google Sheets
Enter new data from forms, emails, PDFs, and shared files
Handle recurring data updates on a weekly schedule
Clean up existing records: fix formatting, remove duplicates, fill blank fields
Do small web research tasks to find or verify company and contact details
Keep spreadsheets and databases organized, consistent, and easy to use
Flag errors, missing info, or anything unclear instead of guessing
Send a short weekly update on what was completed

What we’re looking for:

Experience as a virtual assistant with data entry and database management
Comfortable with Airtable (views, fields, linked records) and Google Sheets
Strong attention to detail and data accuracy
Basic web research and data verification skills
Good written English and clear communication
Able to work independently and follow written instructions
Available for a steady 5 hours a week, with room to grow

To apply, please answer:

What kind of Airtable or Google Sheets work have you done for past clients?
How do you keep data accurate when doing recurring updates?
What days and times are you usually available each week?

Start your proposal with “Airtable” so we know you read the full post.

AI Automation Expert | Data Science, Machine Learning & AI-Powered Workflows

Project Overview

We are looking for a skilled **AI Automation Expert with strong experience in Data Science, Artificial Intelligence (AI), and Machine Learning (ML)** to design, develop, and implement intelligent automation solutions that streamline business operations, reduce manual work, and improve decision-making.

The ideal candidate should be able to understand real-world business challenges and translate them into practical, scalable AI-powered solutions. You should have hands-on experience building automation workflows, integrating AI models and third-party APIs, processing and analyzing data, and deploying machine learning solutions that deliver measurable business value.

Key Responsibilities

**1. AI-Powered Workflow Automation**
- Design and build intelligent workflows to automate repetitive, time-consuming business processes.
- Connect different applications, databases, APIs, and business tools to create seamless automation pipelines.
- Use AI to automate tasks such as document processing, data extraction, classification, summarization, report generation, and information handling.
- Identify opportunities to replace manual processes with reliable, efficient automation systems.

2. AI Agents and Large Language Models (LLMs)
- Develop AI agents and AI assistants that can understand requests, retrieve information, and perform specific tasks.
- Integrate LLMs such as OpenAI GPT and other suitable AI models into business workflows.
- Build retrieval-augmented generation (RAG) systems that allow AI applications to answer questions using company documents, databases, or internal knowledge bases.
- Implement appropriate safeguards, validation, and error handling to improve the reliability of AI-generated outputs.

**3. Data Science and Machine Learning**
- Collect, clean, transform, and analyze structured and unstructured data.
- Develop predictive models for forecasting, classification, customer behavior analysis, anomaly detection, and other business use cases.
- Apply statistical analysis and machine learning techniques to identify patterns, trends, and actionable insights.
- Evaluate model performance, improve accuracy where appropriate, and prepare models for practical deployment.

**4. API Integration and System Development**
- Integrate AI services, external APIs, databases, CRMs, and other business applications.
- Build automation pipelines using tools such as n8n, Make, Zapier, or Python-based solutions, depending on project requirements.
- Develop custom scripts and backend components where standard automation tools are insufficient.
- Ensure workflows are maintainable, secure, scalable, and properly documented.

**5. Testing, Optimization, and Deployment**
- Test workflows and models against real-world scenarios.
- Monitor performance, troubleshoot errors, and optimize execution speed and cost.
- Implement logging, exception handling, and human approval steps where necessary.
- Document the solution and provide guidance for ongoing maintenance and future improvements.

## Required Skills and Experience

- Strong practical experience in AI automation and workflow development.
- Solid knowledge of Data Science, Machine Learning, and statistical analysis.
- Proficiency in Python and relevant libraries such as pandas, NumPy, scikit-learn, or similar tools.
- Experience working with LLM APIs, prompt engineering, and AI application frameworks.
- Experience integrating REST APIs, webhooks, databases, and third-party services.
- Familiarity with automation platforms such as n8n, Make, or Zapier.
- Understanding of data cleaning, model evaluation, testing, and deployment.
- Strong analytical and problem-solving skills, with the ability to translate business requirements into technical solutions.

## Nice to Have

- Experience building AI agents, RAG pipelines, and document-processing systems.
- Familiarity with vector databases and embedding models.
- Experience with cloud platforms, Docker, and deploying AI applications.
- Knowledge of business intelligence, forecasting, and predictive analytics.
- Experience integrating AI solutions with CRM, ERP, marketing, sales, or customer-support systems.
- Understanding of data privacy, security, and responsible AI practices.

Expected Deliverables

Depending on the project scope, deliverables may include:

- A working AI automation workflow or AI-powered application.
- Integrated APIs, AI models, and relevant business systems.
- A predictive model or data analysis pipeline, where required.
- Testing results and performance documentation.
- Technical documentation, setup instructions, and handover support.

How to Apply

Please include the following in your proposal:

1. A brief overview of your experience with AI automation, Data Science, and Machine Learning.
2. Examples of similar projects you have completed, including your specific contribution and the results achieved.
3. The technologies and tools you would recommend for this type of work.
4. Your approach to understanding business requirements and developing a reliable solution.
5. Your availability, estimated timeline, and preferred pricing model.

We value practical problem-solving, clear communication, and solutions that deliver measurable business outcomes. We are interested in building reliable AI systems that solve real problems—not just prototypes or demonstrations.

Please share relevant portfolio projects or GitHub repositories where available.

We are a growing B2B platform looking for a reliable, tech-savvy Lead Generation Specialist to build highly targeted business-to-business list databases for our outbound marketing campaigns across Sub-Saharan Africa. This is a long-term, weekly milestone-based role requiring roughly 3 to 5 hours of work per week.

Your Core Responsibilities:
• Sourcing 500 high-quality B2B contact lists per week (Company Name, Website, Mobile/WhatsApp Number, and Email) across Sub-Saharan Africa based on specific industry verticals.
• Using a variety of creative data-sourcing methods, including web directories, public registries, industry trade event lists, map networks, and localized search strings.
• Cleaning and formatting data in Google Sheets (standardising proper capitalization, stripping out corporate suffixes like "Ltd/Inc/PLC", and removing duplicates).
• Verifying contacts through bulk tools to ensure high list hygiene and zero dead numbers/emails.
Requirements:
• Proven track record of finding data in emerging markets, specifically across African regions where standard LinkedIn coverage can be low.
• Mastery of data extraction tools, scrapers, and list cleaning.
• High attention to detail: leads must look completely natural when dropped into our automation tags (no all-caps, no broken symbols).

To apply, please answer these 3 quick questions:
1. What are your primary tools and methods for sourcing niche business contacts across African markets, where standard LinkedIn coverage is often low but mobile/WhatsApp numbers are critical?
2. What is your preferred tool for bulk contact and phone/email verification?
3. What is your data cleaning process to ensure company names look natural for automated merging (e.g., fixing all-caps or cleaning messy formatting)?

Note: All specific industry niches, keywords, and target geographic countries will be shared privately with shortlisted candidates under strict confidentiality.


Pay Structure: Fixed Price - $35 USD per week

Hi,

I own Veltrix Electrics Ltd, an electrical company in the UK. I am looking for an experienced lead generation and sales specialist to help me get more electrical jobs. Our focus is in the London and Essex areas.

I need someone who can do more than just generate leads. I want someone who can:

- Find potential customers, including landlords, letting agents, estate agents, property managers, and homeowners.
- Contact customers by phone, email, and other appropriate methods.
- Explain our electrical services professionally and generate genuine interest.
- Follow up with customers and quotations.
- Arrange appointments and help convert enquiries into confirmed jobs.
- Build long-term relationships with landlords and letting agents to secure regular electrical work.

Our services include EICRs, consumer unit and fuseboard upgrades, rewiring, EV charger installation, emergency lighting, fire alarms, and electrical maintenance.

I am looking for someone experienced who can manage the lead generation and customer communication process independently.

Please tell me about your experience, how you would generate customers for my business, your expected costs, and what results you could realistically deliver.

I would prefer to start with a small trial and increase the work if the results are good.

Thank you.

Seeking a skilled Data Analyst / Technical Freelancer to assist with data organization, extraction, and validation tasks for an ongoing project. This is a short-term, fully remote contract requiring high attention to detail and experience working with data files.

Key Responsibilities:
• Review, clean, and organize multi-format data inputs to ensure formatting consistency.
• Extract specific text datasets, annotations, and contextual elements based on predefined rules.
• Cross-reference and validate tabular data, numeric figures, and written information against primary sources for absolute accuracy.
• Format final deliverables into clean Markdown (.md), CSV, or text documentation files as required.

Required Qualifications & Skills:
• Proven experience in Data Analysis, Technical Data Entry, or Business Analytics.
• Strong proficiency in managing large text datasets and handling unstructured data.
• Familiarity with Markdown formatting and spreadsheet software (Excel/Google Sheets).
Project Type: One-time project (Short-term)

Skills: Data Processing, Data Entry, Excel, SPSS Statistics, Data Extraction, Business Analytics, Data Analysis, Data Management

Expert B2B Researcher – Booking Software Opportunities

We are seeking a highly experienced B2B research and lead generation specialist to identify exceptional business opportunities worldwide for our bespoke booking software solutions.

This is a research-intensive role requiring strong commercial judgement, detailed investigation and the ability to distinguish genuine buying opportunities from ordinary business contact lists.

About the opportunity

We provide tailored online booking systems for businesses and organisations across multiple industries. Solutions can integrate with existing websites or include a new website where appropriate.

Our focus is helping businesses improve bookings, scheduling, reservations, customer management and related administrative processes.

Ideal businesses to identify

We are particularly interested in businesses and organisations that:

* Handle substantial recurring bookings, appointments, reservations, registrations or customer payments.
* Experience genuine difficulties managing bookings through telephone calls, emails, WhatsApp, social media, spreadsheets or manual processes.
* Have evidence of missed enquiries, scheduling difficulties, administrative overload, booking errors or inefficient customer management.
* Use existing booking software that is unsuitable, unreliable, restrictive or causing demonstrable dissatisfaction.
* Have outdated or poorly functioning booking systems that could benefit from a tailored alternative.
* Operate at significant scale, ideally generating hundreds or thousands of bookings monthly, although exceptional smaller opportunities are also welcome.

All industries and geographical locations may be researched.

Research and qualification requirements

We require thorough investigation using Google, business websites, social media, public reviews, forums and other credible sources.

Recent, verifiable evidence of genuine unresolved problems is particularly important.

Candidates must assess existing booking arrangements, investigate competing solutions and establish whether there is a compelling reason for each business to consider an alternative.

We are not interested in speculative leads or businesses that already have satisfactory solutions.

Researchers must actively eliminate weak opportunities, including businesses that:

* Have effective existing systems and little incentive to change.
* Are satisfied with their current arrangements.
* Depend on manual customer interaction where automation would provide little benefit.
* Have already resolved the problems identified.
* Would face unnecessary disruption from adopting a new solution.
* Have insufficient recurring booking activity.

Manual processes or existing software do not automatically disqualify a business. The key consideration is whether there is clear evidence of an unresolved problem and a meaningful opportunity for improvement.

Required deliverables

Qualified opportunities must be presented in a structured spreadsheet containing:

* Business name, industry, location and website.
* Active contact channels and relevant decision-makers.
* Current booking methods and software.
* Specific problems identified, with supporting evidence and source links.
* Realistic estimated monthly booking volume and the reasoning behind it.
* Explanation of why the business could benefit from our solution.
* Potential objections or reasons for rejection.
* Recommended contact channel and personalised outreach approach.
* Overall opportunity assessment.

We prioritise quality, evidence and realistic conversion potential over lead quantity.

Experience required

Applicants should demonstrate:

* Extensive B2B prospect research and qualification experience.
* Strong investigative and analytical skills.
* Experience researching SaaS, software or technology-service opportunities.
* Ability to identify genuine business needs and commercial buying signals.
* Excellent written English and clear reporting.
* Independent working ability and sound commercial judgement.

Experience with personalised outreach and converting researched opportunities into interested clients is highly desirable.

Working arrangement

We will begin with a short paid trial to evaluate research quality, accuracy and commercial relevance.

Successful applicants may receive substantial ongoing work and opportunities for a long-term working relationship.

When applying, please provide examples of previous research projects, measurable results, and whether you personally perform the work or delegate it to a team.

We're a legal recruiting firm. We need a careful, detail-focused person to work by hand inside our Firm Prospects subscription (a law-firm attorney database) on two tasks. After hire, you'll get a workbook listing every firm, with step-by-step instructions.

TASK 1: TWO SAVED JOB ALERTS
Add 100 employers to one job alert and 167 to another, using the employer filter only. Send screenshots of both employer lists and the count for each.

TASK 2: ASSOCIATE EXPORT
For 208 law firms, export associates (Associate, Senior Associate, Associate Attorney) who graduated 2016–2025. Record each firm's count in our workbook and deliver two combined files (one per tier), with each person listed once. We expect roughly 40,000–50,000 records. Firm Prospects limits exports to 5,000 records at a time, so you'll work in batches.

STRICT RULES (a condition of this contract)
- Everything must be done manually. No scrapers, bots, browser extensions, macros, auto-clickers, scripts, automation software or VPNs. Our license forbids them, and using them would get our account shut down.
- Never exceed 20,000 records per day (the database's limit). If you see "Too Many Requests," stop for the day and message us. It resets the next day.
- If a firm name doesn't match or you're not sure it's the same firm, stop and ask. Don't guess.
- The data is confidential and used only for this job. Login details are shared after hire and changed when the job ends.

ACCURACY IS THE PRIORITY
We check every file against your per-firm counts, and for duplicates, titles and graduation years, before releasing payment.

Fixed price: $95 in two milestones ($30 for the job alerts, $65 for the export), each paid after review. Please finish within 5 working days of hire.

MORE WORK FOR THE RIGHT PERSON
We don't need this every week, but we do have work like this often. If you do this job well, we'll invite you back for future projects.

We need someone who goes beyond producing reports—someone who asks the right questions, spots opportunities, and clearly explains what actions we should take.

Key Responsibilities

Analyze large booking datasets to identify trends across hotels, destinations, booking channels, and travel dates.

Measure cancellation rates and timing, booking windows, length of stay, average booking value, and repeat customer behavior.

Identify the hotels and markets contributing the most bookings, revenue, and profit.

Evaluate profitability after cancellations, refunds, supplier costs, processing fees, and advertising expenses, where data is available.

Analyze Google Ads and Microsoft Ads performance alongside booking results to identify profitable acquisition opportunities.

Build dashboards and recurring reports that give leadership a clear view of business performance.

Clean and validate data, resolve duplicate hotel records, and establish consistent metric definitions.

Work with developers to improve data collection and connect information across booking, marketing, and payment systems.

Present findings in plain language with specific, prioritized recommendations.

Required Qualifications

At least 3 years of professional data analysis experience, including ownership of business reporting and recommendations.

Strong SQL skills and advanced proficiency in Excel or Google Sheets.

Experience building dashboards in Power BI, Tableau, Looker, or a similar platform.

Experience working with large transactional datasets and combining data from multiple sources.

Strong understanding of revenue, profitability, customer acquisition costs, and conversion metrics.

Ability to distinguish booking-date performance from stay-date performance and account for cancellations and refunds.

Excellent attention to detail and the ability to explain findings to nontechnical stakeholders.

Ability to work independently and take an analysis from an initial question through to a business recommendation.

Preferred Experience

Experience with an online travel agency, hotel booking platform, e-commerce business, or online marketplace.

Python or R for data cleaning, automation, and deeper analysis.

Familiarity with Google Ads, Microsoft Ads, and Google Analytics 4 data.

Experience with forecasting, customer segmentation, or cancellation risk analysis.

What Success Looks Like in the First 90 Days

Review our data sources and identify gaps, duplicates, and reporting inconsistencies.

Establish reliable reporting for bookings, cancellations, revenue, and profitability.

Deliver a dashboard showing performance by hotel, market, and acquisition channel.

Present actionable opportunities to reduce cancellations, improve marketing efficiency, and increase profitable bookings.

Excel BMW Sales Analysis
Sales data analysis of BMW Sales Analysis using Excel to identify revenue trends, top-performing models, regional performance, and monthly growth insights.

BMW Sales Analysis (Excel Project)
Project Overview
This project focuses on analyzing BMW vehicle sales data using Microsoft Excel to uncover key business insights, track performance trends, and support data-driven decision-making. The dashboard provides a clear view of revenue patterns, model performance, and regional sales distribution.

Tools Used
• Microsoft Excel • Pivot Tables & Pivot Charts • Data Cleaning & Transformation • Conditional Formatting • Excel Formulas (IF, SUMIFS, VLOOKUP/XLOOKUP) • Interactive Dashboard Elements (Slicers, Timelines)

Key Analysis Performed
• Monthly Sales Trend Analysis • Region-wise Sales Performance • Top-Selling BMW Models • Revenue Performance Insights • Growth Percentage Calculation

Insights Derived
• SUV models (X series) are the top revenue contributors • Sales show peak growth in festive and year-end months • Europe and North America are the strongest performing regions • Certain sedan models show stable but slower growth compared to SUVs • Monthly sales indicate fluctuations due to seasonality and promotions • Premium models generate higher revenue despite lower unit sales

Dashboard Features
• Interactive slicers for Region, Model, and Time Period • Dynamic charts • KPI indicators • Clean and user-friendly layout for quick decision-making

Conclusion
The project demonstrates how Excel can be used as a powerful analytical tool to transform raw sales data into meaningful business insights.

Skills: Data Processing, Excel, Statistics, Business Analysis, Business Intelligence, Data Visualization, Data Analysis, Market Analysis

We're looking for someone to help us clean up spreadsheets. Our tables come from several sources and they need tidying: duplicate rows, inconsistent formatting, missing fields, and entries that don't match our rules. You'll work through a list of files we provide, fix what's clearly wrong, and flag anything that needs a decision from us.

We care more about care and consistency than about advanced Excel skills. If you can spot a duplicate, follow a rule, and keep track of what you changed, you'll fit in well. Training takes about half an hour, and we review your first files before you move on to the rest.

On a typical task you'll open a file from the list, check it against our cleaning rules, remove duplicates, standardize formatting, and fill in what can be filled in from the reference data we provide. You'll log what you changed in a short note and leave anything uncertain untouched for us to review.

What matters to us: attention to detail, the ability to follow rules and apply them consistently, basic comfort with spreadsheets (Google Sheets or Excel), and reliability, meaning you finish the files you take on and ask before guessing.

What you get: flexible hours you can plan around your day, remote work from anywhere, clear cleaning rules and reference data, feedback on your first files, and ongoing part-time work with a steady flow of tables.

Skills: Data Processing, Data Entry, Excel, Web Search, Data Analysis, Data Governance, Google Sheets, Data Management

We are seeking a reliable freelancer based in or near Central London to complete an in-person customer-service evaluation and submit a detailed written report.

Location
SKIMS – Regent Street
245–247 Regent Street, London, W1B 2EN, UK

The assignment

Review the instructions and questionnaire before your visit.

Spend at least 20 minutes inside the store.

Interact naturally with a store associate using an agreed customer scenario.

Note the associate’s name if provided or visible on a name badge.

Evaluate customer service, product guidance, store presentation, and cleanliness.

Take the required photos where permitted, including the storefront and a receipt if a purchase visit is agreed.

Complete the post-visit questionnaire with accurate, specific observations and supporting evidence.

Available customer scenarios

Everyday shapewear: Ask about comfortable options and compression levels.

First-time SKIMS shopper: Ask about the brand and best-selling products.

Special event: Seek advice on shapewear under a fitted dress.

Versatile loungewear: Explore options suitable for home and casual errands.

Sizing guidance: Ask for help choosing an appropriate fit.

Seamless options: Ask about items suitable for light-colored or lightweight clothing.

Visit type and payment

Inquiry and purchase visits are available, subject to assignment approval. The visit type, scenario, deliverables, and deadline will be agreed before work begins.

Fixed fee for the visit and completed report: US$[insert amount]

For an approved purchase visit: [insert exact purchase allowance and explain whether it is separate from or included in the total payment]

All payments will be made through Upwork. Please do not visit the store or make a purchase until the contract is active and the agreed milestone is funded.

No professional mystery shopping experience is required. You should be observant, dependable, and able to provide a clear written report in English. This is private customer-experience research; no public review or positive assessment is required.

To apply, please include:

Your availability to visit the location.

Whether you prefer an inquiry or purchase visit.

Your preferred customer scenario.

Any relevant experience, if applicable.

Please apply and communicate through Upwork. Full instructions and the reporting questionnaire will be provided after hiring.

I have a text-based dataset that needs a focused round of data cleaning and formatting. The core task is to identify and remove every duplicate entry so the final file is lean, accurate, and ready for analysis. No mining or scraping is necessary—everything is already collected; it simply needs to be cleaned.

You will receive the raw text file (CSV). I expect back the same file structure, duplicates removed, and a short log outlining what was eliminated so I can trace the changes. A quick turnaround and careful attention to detail are important, as any missed duplicate will skew later processing.

If you’re comfortable working with large text datasets in tools such as Excel, Google Sheets, or Python (pandas), you’ll find this straightforward.

Skills: Data Processing, Data Entry, Excel

We are looking for a detail-oriented Lead Generation Specialist to build accurate, targeted B2B prospect lists for our sales and marketing team. The ideal candidate will research companies and decision-makers, extract lead details from websites, Google Maps, LinkedIn, and business directories, and organize the data in Excel, Google Sheets, or a CRM. You should be experienced with tools such as LinkedIn Sales Navigator, Apollo.io, Hunter.io, or similar platforms, and have strong data-cleaning, verification, and Excel/Google Sheets skills.The role requires excellent attention to detail, the ability to work independently, and a commitment to accurate, high-quality lead data. Please share your relevant experience, tools you use, and samples of previous work when applying.

DataScienceRoadmap.co.in — Website Development Requirements
1. Project Overview
Website Name: Data Science Roadmap
Domain: datascienceroadmap.co.in
Website Type: Educational and informational website focused on Data Science learning.
Project Objective
Develop a user-friendly, responsive, SEO-friendly educational website that guides learners through the complete Data Science learning journey, from foundational mathematics and statistics to programming, data analysis, machine learning, and portfolio development.
The website should help beginners understand what to learn, follow a structured learning sequence, practise their skills through tutorials and projects, and prepare for relevant career opportunities.
The website should be scalable so that additional learning paths, tutorials, project guides, and resources can be added over time.
2. Target Audience
The website should serve:
• Beginners starting their Data Science journey.
• College students and recent graduates.
• Working professionals upgrading their analytical skills.
• Python and SQL learners interested in Data Science.
• Aspiring Data Analysts, Data Scientists, and Machine Learning Engineers.
• Career changers seeking a structured learning roadmap.
3. Website Navigation and Structure
The primary navigation should include:
• Home
• Topics / Learning Paths
• Tutorials
• Projects / Resources
• Blog
• About Us
• Contact
Proposed website structure
Home
• Introduction to Data Science Roadmap.
• Overview of the Data Science learning journey.
• Featured beginner learning path.
• Key skills and technologies.
• Featured tutorials and projects.
• Portfolio-building guidance.
• Career paths and related resources.
• Calls to action directing visitors to the appropriate learning path.
Topics / Learning Paths
Organise the main learning topics into a logical sequence:
1. Mathematics and Statistics
2. Python Programming
3. SQL and Databases
4. Excel and Data Analysis Fundamentals
5. Data Cleaning and Preparation
6. Exploratory Data Analysis (EDA)
7. Data Visualization
8. Probability and Statistical Inference
9. Machine Learning
10. Model Evaluation and Feature Engineering
11. Advanced Topics and Specializations
12. Portfolio Projects and Career Preparation
The sequence should be flexible enough to support different learner goals, such as Data Analyst, Data Scientist, and Machine Learning Engineer.
Tutorials
• Python tutorials for Data Science.
• SQL tutorials and practical queries.
• Statistics and probability explanations.
• Data cleaning and preprocessing guides.
• Exploratory Data Analysis tutorials.
• Data visualization tutorials.
• Machine learning implementation guides.
Projects / Resources
• Beginner, intermediate, and advanced projects.
• Dataset resources and documentation.
• Project implementation guides.
• Portfolio-building resources.
• Useful tools, libraries, and reference materials.
Blog
• Data Science concepts and explanations.
• Tutorials and how-to articles.
• Industry applications.
• Tool and technology comparisons.
• Career advice and interview preparation.
• Learning strategies and roadmap updates.
About Us
• Website purpose and mission.
• Intended audience.
• Learning philosophy and editorial approach.
Contact
• Contact form.
• Enquiry confirmation message.
• Spam protection.
4. Design and User Experience
• Create a clean, modern, professional design suitable for an educational technology website.
• Make the learning roadmap the primary feature of the homepage.
• Present learning stages in a clear visual sequence.
• Use progressions, cards, timelines, or flow diagrams where appropriate.
• Make the website fully responsive on mobile, tablet, and desktop.
• Use consistent typography, spacing, colours, and reusable design components.
• Provide clear navigation, breadcrumbs, and related-content links.
• Include a search feature for tutorials, topics, and projects.
• Use readable layouts for code examples, tables, and technical explanations.
• Avoid unnecessary animations, intrusive pop-ups, and cluttered layouts.
5. Learning Roadmap Functionality
The roadmap should be a central feature of the website.
The developer should create a roadmap page or reusable roadmap template that allows users to:
• View the recommended learning sequence.
• Understand prerequisites for each learning stage.
• Open dedicated topic pages from each roadmap step.
• Navigate to related tutorials and projects.
• Identify recommended tools and technologies.
• Understand the next step after completing a topic.
A visual roadmap may use connected nodes, numbered stages, or a timeline.
Initial scope: A public, static roadmap that visitors can browse without creating an account. Personal progress tracking and user-specific learning dashboards are not required for the initial launch.
6. CMS and Content Management
Implement a suitable content management system that enables the website owner or content team to publish and update:
• Standard pages.
• Learning path pages.
• Topic pages.
• Tutorials.
• Projects.
• Resources.
• Blog articles.
Use reusable page templates and a consistent category and tagging structure. Routine content publishing should not require developer assistance.
The developer should document the content publishing workflow and provide the necessary administrative access.
7. SEO Requirements
Implement technical SEO fundamentals from the beginning.
• Clean, descriptive URLs.
• Editable SEO titles and meta descriptions.
• Logical H1, H2, and H3 heading hierarchy.
• XML sitemap generation and maintenance.
• Appropriate robots.txt configuration.
• Canonical URL support.
• Index/noindex controls.
• Breadcrumbs where appropriate.
• Descriptive image alt text.
• Internal linking between topics, tutorials, projects, and learning paths.
• Appropriate structured data for eligible content.
• Proper handling of pagination, category pages, tags, and duplicate URLs.
• Prevention of accidental indexing of staging and administrative pages.
The site structure should help search engines understand the relationships between foundational concepts, learning stages, tutorials, and practical projects.
8. Performance and Technical Requirements
• Optimise Core Web Vitals and loading performance.
• Use responsive images and modern formats where supported.
• Configure caching and compression.
• Minimise unnecessary scripts and plugins.
• Implement HTTPS.
• Ensure stable layouts and mobile usability.
• Configure security measures and regular backups.
• Test forms and important navigation paths.
• Check major browsers and common screen sizes.
The developer should recommend an appropriate hosting and deployment setup based on budget, expected traffic, maintainability, and performance requirements.
9. Analytics and Tracking
Configure Google Analytics 4 and Google Search Console.
Where appropriate, track:
• Roadmap step clicks.
• Learning path and tutorial engagement.
• Project and resource clicks.
• Contact form submissions.
• Downloads, if offered.
• Outbound resource links, where useful.
Define the required events before implementation and test them before launch. Avoid collecting unnecessary personal information.
10. Future Scalability
The architecture should support future additions such as:
• New learning paths and specializations.
• More tutorials and project guides.
• Downloadable resources.
• Newsletter subscriptions.
• Interactive quizzes.
• Learning progress tracking.
• User accounts or premium features, if approved in the future.
These future features should not be built into the initial scope unless separately approved.
11. Initial Launch Requirements
The initial launch should include:
• Homepage and core navigation.
• Main Data Science roadmap.
• Core topic and learning path templates.
• Tutorial and project templates.
• Blog functionality.
• About Us and Contact pages.
• Basic technical SEO configuration.
• Analytics setup.
• Responsive design and performance testing.
Final page counts and content volumes should be agreed upon before development begins.
12. Developer Deliverables
The developer should provide:
• Completed responsive website.
• Approved navigation and page structure.
• CMS and administrative access.
• Roadmap functionality.
• Reusable page templates.
• SEO configuration.
• Analytics and Search Console integration.
• Contact form testing.
• Security and backup configuration.
• Performance and mobile testing.
• Documentation for publishing and maintaining content.
• Handover of credentials and relevant project files.
• List of plugins, paid services, and recurring costs.
• Agreed post-launch support terms.
13. Proposal Requirements
Please provide:
• Recommended CMS and technology stack.
• Proposed design and website architecture.
• Development timeline and milestones.
• Total development cost and payment milestones.
• Hosting and recurring expenses, if applicable.
• Features included and excluded.
• Maintenance and support terms.
• Any dependencies or information required before starting.
14. Acceptance Criteria
The website will be considered complete when the agreed pages and roadmap are implemented, the site is responsive, content can be managed through the CMS, technical SEO basics are configured, forms and analytics are tested, and all agreed access credentials and documentation are handed over.

Skills: SEO, Data Science, Web Development, Content Management System (CMS), Web Design

DataAnalyticsPath.tech — Website Development Requirements
1. Project Overview
Website Name: Data Analytics Path
Domain: dataanalyticspath.tech
Website Type: Educational and informational website focused on Data Analytics skills and workflows.
Project Objective
Develop a modern, responsive, SEO-friendly educational website that guides learners through the complete Data Analytics process, from collecting and cleaning data to analysing information, building dashboards, and communicating business insights.
The website should help beginners and working professionals learn practical analytical skills, follow structured learning paths, practise through projects, and understand how analytics tools are applied in real business scenarios.
The architecture should support future expansion through additional tutorials, projects, tool guides, and career resources.
2. Target Audience
The website should serve:
• Beginners starting their Data Analytics journey.
• College students and recent graduates.
• Working professionals upgrading their analytical skills.
• Excel and spreadsheet users moving into advanced analytics.
• Aspiring Data Analysts and Business Intelligence Analysts.
• Business professionals who want to make data-driven decisions.
3. Website Navigation and Structure
The primary navigation should include:
• Home
• Topics / Learning Paths
• Tutorials
• Projects / Resources
• Blog
• About Us
• Contact
Proposed website structure
Home
• Introduction to Data Analytics Path.
• Overview of the Data Analytics learning journey.
• Featured learning paths.
• Key analytical tools and technologies.
• Featured tutorials and practical projects.
• Dashboard and reporting examples.
• Business Intelligence resources.
• Latest blog articles.
• Clear calls to action directing users to relevant learning resources.
Topics / Learning Paths
Organise content into these categories:
1. Data Analytics Fundamentals.
2. Excel and Spreadsheets.
3. SQL and Databases.
4. Data Collection and Preparation.
5. Data Cleaning and Transformation.
6. Exploratory Data Analysis.
7. Data Visualization.
8. Power BI.
9. Tableau.
10. Business Intelligence.
11. Dashboard Design and Reporting.
12. Business Analysis and Data Storytelling.
13. Analytics Projects and Portfolio Development.
Each topic should link to related tutorials, exercises, and projects.
Tutorials
• Excel formulas, functions, PivotTables, and reporting.
• SQL queries, joins, aggregations, and window functions.
• Data cleaning and transformation.
• Power Query and data preparation.
• Power BI data modelling, DAX, and dashboards.
• Tableau visualizations and dashboards.
• Business reporting and analytical workflows.
Projects / Resources
• Beginner, intermediate, and advanced analytics projects.
• Sample datasets.
• Spreadsheet exercises.
• SQL case studies.
• Dashboard projects.
• Reporting templates and resources.
• Business problem-solving exercises.
Blog
• Data Analytics concepts.
• Tool comparisons and tutorials.
• Dashboard design principles.
• Business Intelligence use cases.
• Data reporting and storytelling.
• Industry applications and career guidance.
About Us
• Website mission and purpose.
• Intended audience.
• Learning philosophy and editorial approach.
Contact
• Contact form.
• Enquiry confirmation message.
• Spam protection.
4. Design and User Experience
• Create a clean, modern, professional educational website.
• Make the learning path easy to understand for beginners.
• Present analytical workflows as numbered stages, timelines, or diagrams.
• Use consistent layouts, typography, colours, and spacing.
• Ensure responsive design across desktop, tablet, and mobile.
• Include a search feature for tutorials, tools, and projects.
• Use breadcrumbs and related-content links where useful.
• Display tables, formulas, SQL queries, code blocks, and dashboard images clearly.
• Ensure readable layouts for wide tables and technical examples on mobile.
• Avoid unnecessary animations and intrusive pop-ups.
5. Data Analytics Workflow Functionality
The main learning path should demonstrate a typical analytics workflow:
1. Understand the business question.
2. Collect and access data.
3. Inspect and clean the data.
4. Transform and prepare the data.
5. Analyse patterns and trends.
6. Visualise the results.
7. Build dashboards or reports.
8. Communicate insights and recommendations.
Users should be able to open each stage and access relevant topic pages, tutorials, and projects.
The workflow should explain that actual analytical processes may vary depending on the business problem, available data, and tools used.
The initial version should be publicly accessible without requiring registration or login.
6. Content Management System
Implement a suitable content management system that allows the owner or content team to manage:
• Standard pages.
• Learning paths.
• Topic pages.
• Tutorials.
• Projects and resources.
• Blog articles.
Use reusable templates and consistent categories so routine content publishing does not require developer assistance.
Provide administrative access and basic publishing documentation.
7. SEO Requirements
Implement technical SEO fundamentals from the beginning.
• Clean, descriptive URLs.
• Editable SEO titles and meta descriptions.
• Logical H1, H2, and H3 heading hierarchy.
• XML sitemap generation and maintenance.
• Appropriate robots.txt configuration.
• Canonical URL support.
• Index/noindex controls.
• Breadcrumbs where useful.
• Descriptive image alt text.
• Internal linking between learning paths, tutorials, projects, and tool guides.
• Appropriate structured data for eligible content.
• Proper handling of category pages, tags, pagination, and duplicate URLs.
• Prevention of accidental indexing of staging and administrative pages.
The architecture should make the relationship between analytics concepts, tools, workflows, and practical projects clear to search engines.
8. Performance and Technical Requirements
• Optimise Core Web Vitals and page-loading performance.
• Use responsive images and modern formats where supported.
• Configure caching and compression.
• Minimise unnecessary scripts and plugins.
• Implement HTTPS.
• Ensure stable layouts and mobile usability.
• Configure security measures and regular backups.
• Test forms and navigation.
• Test major browsers and common screen sizes.
Recommend hosting based on budget, expected traffic, maintainability, and performance requirements.
9. Analytics and Tracking
Configure Google Analytics 4 and Google Search Console.
Where appropriate, track:
• Learning path clicks.
• Tutorial engagement.
• Project and resource clicks.
• Dashboard or template downloads.
• Contact form submissions.
• Outbound resource links.
Define and test the required events before launch. Avoid collecting unnecessary personal information.
10. Future Scalability
The architecture should support future additions such as:
• Additional analytics learning paths.
• More tutorials and case studies.
• Downloadable spreadsheet templates and datasets.
• Interactive exercises.
• Newsletter subscriptions.
• Quizzes and assessments.
• Learning progress tracking.
• User accounts or premium resources, if approved later.
These features should not be included in the initial scope unless separately agreed.
11. Initial Launch Requirements
The initial launch should include:
• Homepage and primary navigation.
• Main Data Analytics learning path.
• Core topic categories.
• Tutorial and project templates.
• Blog functionality.
• About Us and Contact pages.
• Technical SEO configuration.
• Analytics setup.
• Responsive design and performance testing.
The final number of pages and templates should be agreed before development begins.
12. Developer Deliverables
The developer should provide:
• Completed responsive website.
• Approved navigation and website architecture.
• CMS and administrative access.
• Reusable page templates.
• Data Analytics workflow presentation.
• SEO configuration.
• Analytics and Search Console integration.
• Contact form testing.
• Security and backup configuration.
• Performance and mobile testing.
• Publishing and maintenance documentation.
• Handover of access credentials and relevant project files.
• List of installed plugins, paid services, and recurring costs.
• Agreed post-launch support terms.
13. Proposal Requirements
Please provide:
• Recommended CMS and technology stack.
• Proposed design and architecture.
• Development timeline and milestones.
• Total development cost and payment milestones.
• Hosting and recurring expenses, if applicable.
• Features included and excluded.
• Maintenance and support terms.
• Any information required before starting.
14. Acceptance Criteria
The website will be considered complete when the agreed pages and workflow are implemented, the website is responsive, content can be managed through the CMS, technical SEO basics are configured, forms and analytics are tested, and all agreed access credentials and documentation are handed over.

Skills: SEO, Web Development, Data Analytics

About Us
We are a high-performing emergency infrastructure, rapid-response, and asset hire trade business in Australia. We operate a "one-stop-shop" model handling a diverse mix of services on disaster and construction sites, including:
* Asset Hire: Temporary Fencing and Scaffolding Hire (requires tracking inventory quantities on-site and recurring billing logic).
* Emergency Maintenance & Make Safes: Ceiling collapses, loose roofing tiles, and structural stabilization (requires strict compliance tracking and heavy photo proof).

We operate with a tight team of 4 key field staff. Off-the-shelf trade software does not fit our complex rental and emergency-response model. We are building a lean, highly custom system to decouple our field operations from our administrative database, pushing all finalized data cleanly into Xero.

---

Project Scope & Phases

Phase 0: Historical Data Forensic Audit (900 Invoices)
Before building the new app, the specialist must perform a retrospective cleanup of approximately 900 historical Xero invoices to fix our financial reporting and locate lost gear.
* Data Parsing: Using bulk export and AI-assisted text extraction (via tools like Claude), analyze our 900 historical invoice descriptions to classify old revenue into clean service categories (Temporary Fencing, Scaffolding, Ceiling Make Safes, Roof/Tile Repairs).
* Asset Recovery: Audit historical delivery versus return records to isolate outstanding hire equipment currently deployed in the field. This data will be used to populate our initial Live Asset Ledger.

Phase 1: Xero Accounting Architecture & Invoicing Optimization (Essential)
Our current Xero invoicing environment is not set up correctly to support our workflow, and we require expert assistance to make Xero significantly more functional for our day-to-day invoicing. Advanced Xero knowledge is absolutely essential for this role.
* Chart of Accounts Cleanup: Review and restructure our current Xero Chart of Accounts to separate our core revenue streams accurately.
* Tracking Categories: Configure Xero’s native tracking features so we can easily generate monthly profit-versus-loss (P&L) reports by job type and individual builder.
* Tax Code Mapping: Ensure appropriate GST codes are mapped cleanly to prevent background automation errors.

Phase 2: Database Architecture & Live Asset Ledger (Airtable)
* Relational Database Design: Build a robust backend using Airtable (utilizing a single admin seat).
* Live Builder Asset Ledger: Build a live, real-time dashboard showing exactly what hire equipment (meters of fencing, scaffolding towers) is currently sitting on which builder's job site, tracking deployment dates for automated recurring billing.
* Multi-Tier Builder Rate Cards: Create an underlying pricing matrix matching different commercial builders and insurance groups to their pre-negotiated contract rates. Field staff will never see or input pricing on-site.

Phase 3: Mobile Field Interface (Glide UI)
* Build a clean, mobile-optimized dashboard via Glide (Maker/Explorer Plan) for our 4 field staff.
* Dynamic Module Selection: Workers check boxes for the active services on-site today. The app dynamically reveals *only* the specific data inputs required for those services, keeping the UI fast and clean.
* Insurance & SWMS Gatekeeper: Workers must view and accept digital Safe Work Method Statements (SWMS) on-site before job data fields unlock. The system must hard-log a tamper-proof timestamp and GPS coordinate upon acceptance.
* Image Compression Engine: Workers take high-volume before/after photos directly inside the app. The system must automatically compress images upon upload (~200KB) to prevent platform storage bloat.

Phase 4: Make.com Automation Bridge & Security
* Smart Invoicing: Configure workflows to push completed jobs into Xero automatically as Draft Invoices (with compiled compliance photos attached), separating fixed fees from calculated linear-meter hire rates.
* Business Continuity: Build a set-and-forget background automation that exports all database tables into CSV spreadsheets and backs them up securely to our corporate Google Drive every Sunday at midnight.

---

Required Skills & Experience
* Advanced Xero Literacy (Mandatory): Extensive experience optimizing Xero's internal settings, invoicing workflows, Chart of Accounts, Tracking Categories, and GST mapping. A background in Australian trade bookkeeping or accounting systems integration is a massive plus.
* AI Prompting & Data Analysis: High proficiency using LLMs like Claude to accelerate data cleaning, parse unstructured text from historical spreadsheets, and troubleshoot workflow logic.
* Workflow Automation: Advanced skills in Make.com (preferred over Zapier for handling multi-step logic, webhooks, error catching, and data bundling).
* Proven No-Code Development: Portfolio demonstrating functional, staff-facing mobile applications built using Glide or Softr powered by Airtable.

Project Structure
* Type: Contract / Freelance Project (Fixed-Price with Milestones per Phase).
* Location: Remote (Australian accounting familiarity highly preferred).

I have a growing set of cost and expense data that is starting to out-grow simple spreadsheets. What I need is an Excel file that does three things very well:

• Cleans, organises, and merges the raw data I receive each week
• Uses solid formulas (lookups, dynamic arrays, pivot logic, etc.) to calculate totals, variances, and other key results automatically
• Presents the insights in a clear dashboard—interactive charts, summaries, and trend views that management can understand at a glance

Accuracy is critical, so the first step will be building a reliable data model: duplicate removal, consistent naming, and a structure that can accept new imports without breaking anything. From there, I want the calculations and visuals to update themselves the moment fresh figures are dropped in.

Because some of these charts may later be copied into board-level decks, please set them up with clean formatting and colours that will translate well if I decide to paste them into PowerPoint.

Deliverables I expect:
1. A master workbook with automated data-cleaning routines
2. Calculation sheets (clearly labelled) that drive totals, costs, and other KPIs
3. A dashboard tab with interactive charts and slicers
4. A short hand-off note or video so I can maintain or extend the model after delivery

If you have questions about the current data layout or want a sample file before starting, just let me know and I’ll send it across.

Skills: Visual Basic, Data Processing, Data Entry, Excel, Powerpoint, Visual Basic for Apps, Data Visualization, Data Analysis, Data Modeling, Data Management

Ambient.ai is an Agentic Physical Security company based in Redwood City, California. We help enterprise security teams get more out of their existing cameras and access control systems with AI. Our customers include tech companies, large hospitals, universities, transit agencies, museums, and other Fortune 500 enterprises.

We're looking for an experienced B2B data researcher to build a verified contact list for our business development team. We'll provide a list of target accounts (company name, domain, employee count, and industry). Your job is to identify the people who decide on or influence physical security investments at each account, and provide accurate contact details for them.

This list will be used for direct outreach, so accuracy matters more than volume. We would rather receive five correct contacts per account than ten unverified ones. See attached document for more details.

ABOUT US
We're a film and TV location agency. We represent hundreds of properties (offices, hotels, homes, venues) across New York, New Jersey, Chicago, Atlanta, Boston and Toronto and license them to productions. Our property records live in monday.com and our photos live in a large SmugMug library. We're building an AI-powered location search, and we need a careful, tech-savvy person to help get our data in shape.

WHAT YOU'LL DO (15-20 hrs/week to start)
- Review AI-suggested matches between photo galleries and property records; approve, fix or flag them
- Find and correct missing or wrong street addresses using Google Maps and web research
- Organize photo galleries into the right market folders
- Spot-check AI-generated photo tags for accuracy
- Use ChatGPT, Claude or similar tools to speed up repetitive work, and suggest better ways to do it

YOU ARE
- Available during US Eastern/Central business hours, with at least 4 hours of overlap with 10am-4pm ET (Latin America-based candidates encouraged)
- Fluent in written English and comfortable on video calls
- Experienced with spreadsheets, CRMs or databases (monday.com a plus)
- A regular user of LLM tools who can show how you've used them to work faster
- Detail-oriented: accuracy matters more than speed
- Looking for a long-term, part-time role where you'll build deep knowledge of our system over time

RATE
$15-22/hr depending on experience. We start with a short paid test task.

TO APPLY
In your proposal, tell us:
1. One specific way you've used an AI tool to finish a repetitive task faster
2. Your weekly availability in Eastern Time

We're a UK company that turns guest reviews into data for investors during M&A. We run a documented data-collection pipeline (Python command-line scripts, Excel/Google Sheets, a web upload workbook) a few times per quarter for client projects, and we need a careful, reliable operator to own the execution.

The work: validating project spreadsheets against a written checklist, preparing input files, running our collection scripts (you don't need to write code, you need to run and read it), checking outputs against documented quality checks, and uploading results. Full training manual, recorded walkthroughs, and a supervised first run provided.

You: extremely detail-oriented (the job is mostly catching what's wrong before and after a run); comfortable in a terminal running Python scripts and editing a JSON config; strong with spreadsheets; clear, proactive written English — if something looks off or you're blocked, you tell us the same day, every time; available in bursts at short notice (projects arrive with 2 days notice and run hot for a few days). For the next six months your working hours need meaningful overlap with South America (GMT-3 to GMT-5): you're either based in the Americas or happy to shift your day.

Structure: paid trial task (c.1 hour) → paid onboarding (~15–25 hrs over 2 weeks) → on-call retainer per project. Long-term role for the right person; we'd rather pay well for someone who never drops a ball.

To apply: in your first message, tell us (1) your relevant experience, including a time you caught an error in data that others had missed, (2) your working hours/time zone, and (3) your hourly rate.

I represent 天津市南开飞凡智序科技有限责任公司, an established provider of AI data and digital-technology services in China. I am expanding our B2B network and am now looking for international AI training-data suppliers or data-labelling companies that can work with us on a long-term, project-based basis.

Our most immediate interest is in multi-language speech work: large-scale voice collection, annotated transcriptions and ASR-ready datasets covering a wide range of languages, accents and acoustic environments. If you already curate such corpora or have the capacity to build them, I would like to explore joint delivery models, co-branded offerings or white-label outsourcing.

What we bring to the table
• A 300 + seat data-ops team experienced in speech, NLP and multimodal annotation
• Proven pipelines for data cleaning, segmentation, quality assurance (auto + human) and secure delivery
• In-house tools for speaker recruitment, task routing, progress tracking and acceptance testing
• The ability to scale quickly inside China for localised collection while meeting global compliance standards

What I hope to receive from you
1. Multi-language speech corpora (or a plan to create them) with clear recording specs
2. Time-aligned, language-accurate transcriptions and speaker metadata
3. Your QA methodology and expected word error rate / label accuracy benchmarks
4. Proposed collaboration structure—fixed-price, revenue share or phased milestones (timing is flexible; we have no hard deadline)

If your portfolio also includes text, image or multimodal datasets, that could become part of a broader framework agreement, though speech is our immediate priority. Please share a brief capability overview, sample documentation or links to past projects so that we can schedule a technical discussion and, where appropriate, arrange an NDA.

I look forward to building a reliable, mutually beneficial partnership that delivers high-quality AI training data to clients worldwide.

Skills: Data Collection, Natural Language Processing, AI Model Development, AI Development, AI Quality Assurance, AI Training Data, Data Annotation, Speech Recognition

We’re building a new website for a wholesale auto parts supplier and need a detail-oriented freelancer to prepare the product list in Google Sheets.

The work involves checking product lists against a master spreadsheet by product code, adding product image links from Google Drive, entering vehicle details and flagging any missing or mismatched items.

Step-by-step instructions will be provided before you start.

You should be accurate, comfortable with Google Sheets and Google Drive, and good at following instructions closely.

We are looking for a reliable, detail-oriented Virtual Assistant to help with ongoing data entry, spreadsheet maintenance, and general administrative tasks.

This is a long-term, hourly opportunity requiring approximately 5 hours per week, with the possibility of additional hours as our workload grows.

Key Responsibilities:

* Perform accurate data entry into Google Sheets and Microsoft Excel.
* Update and maintain spreadsheets on a regular basis.
* Organize, clean, and format data to ensure accuracy and consistency.
* Conduct basic online research and collect relevant information.
* Identify and correct errors, duplicates, and missing information.
* Manage recurring administrative and data management tasks.
* Keep records organized and up to date.
* Provide brief progress updates on completed assignments.

Requirements:

* Experience in data entry and virtual assistance.
* Proficiency in Google Sheets and Microsoft Excel.
* Strong attention to detail and organizational skills.
* Good internet research abilities.
* Ability to follow instructions and meet deadlines.
* Strong written communication skills.
* Ability to work independently with minimal supervision.

Job Details:

* Job Type: Ongoing / Long-term
* Payment: Hourly
* Weekly Hours: Approximately 5 hours
* Work Location: Fully Remote
* Schedule: Flexible, with consistent weekly availability
* Experience Level: Entry to Intermediate

Ideal Candidate:

We are looking for someone who is dependable, responsive, and committed to delivering accurate work. The ideal candidate will be comfortable handling repetitive tasks, maintaining well-organized spreadsheets, and proactively identifying issues that need attention.

How to Apply:

Please include the following in your proposal:

1. A brief introduction about yourself.
2. Your experience with data entry and spreadsheet management.
3. Your proficiency in Google Sheets and Excel.
4. Your hourly rate and weekly availability.
5. Examples of similar projects you have completed, if available.

We value accuracy, reliability, and clear communication. We are interested in building a long-term working relationship with the right freelancer.

We look forward to receiving your application!

We use Salesforce as our main CRM and HubSpot for marketing. We need an experienced Salesforce developer to connect the two systems reliably, then build AI capabilities on top using Agentforce and Data Cloud.

Phase 1: Data cleanup and HubSpot to Salesforce integration

Clean and standardize contact, account and deal data in both systems (formats, required fields, picklist values)
Find and merge duplicates, and set up duplicate and matching rules to prevent new ones
Build or fix a bidirectional sync for contacts, deals and activity data, using the native connector, middleware or custom APIs, whichever is most reliable for our setup
Add error handling and logging so failed syncs are visible
Document the field mapping, duplicate rules and sync logic for our team

Phase 2: Data Cloud setup

Configure Data Cloud to unify customer data from Salesforce and HubSpot
Prepare the unified data for use in AI actions and reporting

Phase 3: Agentforce agent

Design and deploy an Agentforce agent with Agent Builder and Prompt Builder, connected to live CRM data and workflows
Set up permissions, testing and guardrails before rollout

Throughout

Apex, Lightning Web Components and Flows where needed
Clean, tested code with proper security and permissions
Short weekly updates on progress and next steps

What we’re looking for

Strong Salesforce development skills: Apex, LWC, SOQL, Flows and REST APIs
Experience integrating Salesforce with other systems
Experience with Salesforce data cleanup, deduplication and migration
Salesforce certifications
Familiarity with Agentforce and Data Cloud, or a clear plan to deliver them
Clear communication and well-documented work

We’d like to start with Phase 1 and continue to the next phases once it’s complete. 

About the Project

We are a growing U.S.-based financial services business looking for an experienced, hands-on HubSpot and Revenue Operations specialist to lead a comprehensive cleanup and optimization of our sales and marketing data, systems, and processes.

Over time, our systems have accumulated data inconsistencies, process gaps, and integration challenges that impact our ability to use data confidently for reporting, automation, and decision-making.

We are looking for someone who can take ownership of assessing our current environment, identifying and correcting underlying problems, and establishing sustainable data governance practices. There are complexities to our processes but this role can help recommend changes to our processes - we are very open to feedback on how we could structure things differently.

Our goal is to complete the agreed-upon RevOps cleanup and foundational systems improvements within six months, leaving us with accurate, organized, reliable data and documented processes that an internal Marketing Operations team member can maintain going forward.

This is a defined project, not a long-term CRM administration.

Project Scope & Responsibilities

1. HubSpot & CRM Data Audit and Cleanup

Audit our existing HubSpot CRM structure, properties, lifecycle stages, lists, workflows, integrations, and data quality.

Identify and resolve duplicate, incomplete, inconsistent, incorrectly categorized, or disconnected records.

Standardize data fields, naming conventions, lifecycle definitions, and other key CRM structures.

Review and correct source attribution, customer and partner tracking, segmentation, and record associations.

Identify the root causes of recurring data issues and implement sustainable fixes.

Establish clear sources of truth, data ownership standards, and processes for ongoing data integrity.

2. RevOps Processes & Systems Optimization

Evaluate how data flows between Marketing, Sales, and other connected business systems, including financial and operational platforms.

Suggest improvement ideas.

Identify broken, inefficient, or inconsistent processes contributing to data quality issues.

Review and optimize HubSpot configurations, existing automations, and integrations.

Identify and resolve issues that prevent accurate reporting or reliable automation.

Recommend practical system improvements that reduce manual work and prevent future problems.

3. Data Governance, Documentation & Quality Assurance

Establish data governance standards and best practices.

Develop clear SOPs for data entry, imports, updates, maintenance, and quality assurance.

Create repeatable data auditing procedures and controls to prevent recurring issues.

Document important CRM configurations, integrations, workflows, and processes.

Provide training and knowledge transfer so our team can confidently maintain the improvements.

4. Reporting & Future Automation Readiness

Establish reliable data structures and consistent definitions to support accurate Marketing and Sales reporting.

Address data quality issues affecting attribution, pipeline visibility, revenue reporting, and customer segmentation.

Identify opportunities for future workflows, automations, reporting enhancements, and operational improvements.

Ensure the cleaned-up environment provides a strong foundation for our internal team to build upon.

What Success Looks Like

At the conclusion of the project, we expect to have:

A comprehensive audit of our existing RevOps data, systems, and processes.

Cleaned, standardized, and quality-checked CRM data across the agreed project scope.

Corrected data structures, configurations, and integrations where needed.

Clearly defined and documented data governance standards and operating procedures.

Processes and safeguards that significantly reduce recurring data quality issues.

Reliable data structures that support reporting, segmentation, and future automation.

Complete documentation, training, and a clear transition plan for ongoing internal management.

Ideal Contractor

We are looking for someone with:

Extensive hands-on HubSpot CRM administration and optimization experience.

Proven success completing substantial CRM or RevOps data cleanup projects.

Deep understanding of CRM architecture, data quality, lifecycle management, and governance.

Experience diagnosing and resolving data issues across connected systems.

Experience with HubSpot workflows, integrations, reporting, and automation.

Strong process design, documentation, and quality assurance skills.

The ability to independently assess problems, recommend solutions, and execute improvements.

Strong communication skills and experience working with both technical and nontechnical stakeholders.

Experience connecting HubSpot with accounting, financial, or operational platforms (such as QuickBooks Online) is a plus.

We strongly prefer someone who has successfully cleaned up and optimized an existing, established HubSpot environment—not just implemented a new CRM from scratch.

Project Structure & Budget

We anticipate the full cleanup and optimization project lasting up to six months, depending on the findings from the initial audit and the agreed scope of work.

Our selection process will include a short, paid discovery and audit phase with three shortlisted contractors. Each contractor will have the opportunity to assess our current environment, identify key issues and improvement opportunities, and present a recommended approach to resolving them.

Following these initial audits, we will select one contractor to lead the full project based on their findings, proposed solutions, relevant experience, estimated timeline, and overall project cost.

We will then work with the selected contractor to finalize the implementation scope, deliverables, milestones, timeline, and budget before proceeding with the larger cleanup and optimization project.

We are open to hourly or milestone-based proposals and would like to understand your recommended approach.

How to Apply

Please include the following in your proposal:

Relevant Experience: Briefly describe one or two substantial HubSpot/RevOps data cleanup projects you have personally completed. What were the challenges, what did you fix, and what were the results?

Your Approach: How would you approach auditing an existing HubSpot environment, identifying the root causes of data issues, and creating a sustainable cleanup plan?

Project Estimate: What is your hourly rate, and what would you estimate for an initial paid audit? If possible, provide a preliminary range of hours or total cost for a project of this nature, recognizing that final scope would be determined after discovery.

Availability: What is your availability over the next six months, and how many hours per week could you dedicate to this project?

Documentation & Handoff: How do you typically document your work and prepare an internal team to maintain systems after the engagement concludes?

We value practical problem-solving, clear communication, and sustainable solutions over unnecessary system complexity.

Our priority is to fix the underlying issues—not simply clean individual records or create temporary workarounds.

We look forward to working with a RevOps expert who can help us build a reliable data foundation for the future.