Data Cleansing Projects

opportunity

Build Shopify, Klaviyo Dashboards in Looker Studio via Coupler

Description: We are an established UK interiors e-commerce brand seeking a data specialist to build automated business performance dashboards in Looker Studio, powered by Coupler.io. Important: We (the company) will own all Coupler.io and Looker Studio accounts and provide log-ins. You will work entirely within our accounts to ensure full ownership and transparency of all data connections and dashboards. Scope of work Set up data connections and build a custom Looker Studio dashboard visualising key company metrics across: Shopify -Draft orders / quotes: - Quotes created, open vs closed - Quote-to-order conversion rate - Quote value, aging, and expiry tracking Trade metrics: -Trade account sign-ups and approval conversions -Trade purchases as a % of total sales -Average order value for trade vs retail customers -Repeat purchase rate for trade customers Overall performance: Monthly and year-to-date sales, orders, profit, AOV, and growth rate Klaviyo -Email list growth and segmentation (Trade vs Retail) -Campaign and flow performance (open, click, conversion rates) -Revenue attributed to flows and campaigns Meta Ads + Google Ads -Spend, conversions, and ROAS per channel -Campaign performance by audience and creative Deliverables ✅ Coupler.io data pipelines connected and scheduled for automated sync ✅ Custom Looker Studio dashboard with branded visuals and date filters ✅ Segmented views for Trade vs Retail performance ✅ Short documentation or Loom video explaining how to update or maintain the setup We will provide: -Metric definitions and KPI list -Access to Shopify, Klaviyo, Meta Ads, and Google Ads -Brand colour palette and design preferences Skills required: Looker Studio, Coupler.io, Shopify (including draft orders and customer tags), Klaviyo, Meta Ads, Google Ads, Data Visualisation, Google Sheets Questions for applicants: 1.Have you created Coupler.io → Looker Studio dashboards before? 2.Have you worked with Shopify draft order or trade-tagged customer data? 3.Can you share examples of previous e-commerce dashboards? 4.How long would you estimate this setup to take from start to finish?

Facebook and Snapchat Ad Support

Need an expert in ads to supercharge our business. Must have 5+ years of experience and be data driven and be open to reporting results daily.

opportunity

Mobile app development required

We are looking to engage a developer (or team of developers) to create an app for our charity. The app will allow users to search for nearby facilities and to filter on activities being run at those facilities by times/ dates etc. We have created a rudimentary excel spreadsheet of data showing address and contact details of the facilities as well as the activities they run and timings for them when available. We need the following activities completed: Moving all the data from excel to an agreed database. We can have a conversation on normalising the data to make filtering and sorting easier Setting up an admin site so that we can adjust the data for all facilities without having to manipulate it in the database directly. We should also be able to add/ delete facilities from this site Leaving the option to give access to facility managers to data for their facility only on the same admin site via username and password Creating the app including suggesting UI and design layout and working with us to create something best suited for our needs Integrating google maps API so we can show the facilities on a map view Have an option for a contact us button so users can communicate directly with us.

Power BI Data Analyst (PL-300) Certification Trainer

##Trainer Needed: Intensive 3-Day Preparation for Microsoft Power BI Data Analyst (PL-300) Certification ### Project Overview I am a Business Analyst professional seeking dedicated, expert-led training to prepare for and pass the **Microsoft Power BI Data Analyst (PL-300) Exam**. I am looking for an instructor who can provide a fast-track, highly focused training experience, ideally delivered live and hands-on, covering every exam objective in depth. While the recommended experience level for this type of intensive training is intermediate, I require a comprehensive learning structure suitable for a professional serious about attaining this certification. ### Trainer Qualifications (Required) The ideal freelancer will possess the following background and expertise: 1. **Certification and Experience:** Must be a well experienced trainer, preferably a **Microsoft Certified Trainer (MCT)**, specializing in practical data solutions. 2. **Specialized Tools:** Expertise must include **Power BI, Excel, and Power Query**. 3. **Teaching Style:** Must bring a practical teaching approach with a focus on real-world scenarios and proven exam techniques. 4. **Content Delivery:** Able to provide interactive, live instruction and guide me through hands-on labs and exercises. ### Scope of Work and Training Objectives The training must be intensive, focused on transforming raw data into actionable insights using Power BI's advanced features, and designed to cover all necessary content for the PL-300 exam, potentially within a short timeframe (such as 3 days of intensive instruction). The training must cover the following core areas based on the PL-300 exam structure: #### 1. Get started with Microsoft data analytics * Essential insights into how data analysts use Power BI to drive informed business decisions. * Topics include: Discover Data Analysis, Get started building with Power BI, and creating interactive reports using Copilot for Power BI. #### 2. Prepare data for analysis with Power BI * Focus on using **Power Query** to extract data from different data sources, choosing storage modes and connectivity types. * Topics include: Getting data in Power BI, and cleaning, transforming, and loading data in Power BI before modeling. #### 3. Model data with Power BI * Instruction on what a Power BI semantic model is and which data loading approach to use. * Key modules include: Describing Power BI Desktop models, choosing a Power BI model framework, writing **DAX formulas** for models, adding measures, using DAX time intelligence functions, optimizing models for performance, and enforcing model security. #### 4. Build Power BI visuals and reports * Focus on turning data into interactive, actionable insights. * Topics include: Scoping report design requirements, designing Power BI reports, creating visual calculations, configuring report filters, enhancing report designs for user experience, and performing analytics in Power BI. #### 5. Manage workspaces and datasets in Power BI * Learning how to publish Power BI reports to the Power BI service. * Key modules include: Creating and managing workspaces, managing semantic models, creating dashboards, and implementing **row-level security**. ### Project Expectations * **Format:** Live, interactive instruction is crucial. * **Methodology:** Training must include real-world exercises and hands-on labs to ensure readiness for the exam. * **Support:** Guidance on certification logistics, including preparing for the exam itself and understanding the exam structure/question types, is highly valued. * **Quality:** I am seeking premium training equivalent in quality to high-end bootcamps, which often charge over $2,000 for similar content, but offered at a smart price suitable for an individual investment. ### Deliverables The primary deliverable is comprehensive training that provides the skills and confidence required to master Power BI and successfully pass the Microsoft Certified: Power BI Data Analyst Associate Exam (PL-300).

Design Clean, Minimal Figma Dashboards for B2B eSIM Platform

Project Description We’re building a B2B eSIM management platform for small and medium businesses (SMEs). The system lets companies buy, manage, and assign eSIMs to their employees — with 4 user portals: - SME Admins - Employees - Family Members - System Admins (our internal dashboard) We already have a detailed sitemap and functional flow (in Excel and interactive HTML). Now we need a Figma designer to create a clean, modern, and minimal dashboard UI based on that structure. Design Requirements: - Style: Simple, clean, minimal (Material 3 or similar aesthetic) - Create 4 dashboard layouts (one for each role) using shared components - Use auto layout, variants, and component library for reusability - Design for desktop (responsive preferred) - Include sidebar, tables, modals, buttons, and data cards - Organised, consistent use of colour, typography, and spacing Deliverables: - Figma file with: * Shared design system (buttons, inputs, cards, tables, sidebar, top bar) * SME Dashboard * Employee Dashboard * Family Dashboard * Admin Dashboard - Optional: simple interactive prototype for navigation References: - Use Material 3 Figma Design Kit (official Google kit) What We Provide: - Full sitemap (Excel + interactive HTML) - Branding color + logo (optional) - Notes on data and functionality per screen

opportunity

VAPI + Google Sheets Integration for Outbound Calling System

PROJECT DESCRIPTION: I'm looking for an experienced VAPI integration specialist to connect my AI calling system with Google Sheets and other essential tools for a property investment outreach project. IMPORTANT: I already have a VAPI account set up and the AI assistant configured. I can make calls. What I need is help with the integrations and data flow. REQUIRED INTEGRATIONS: Google Sheets Integration (Bidirectional): Pull data FROM Google Sheets for each outbound call: company name, director name, phone number, property addresses, previous transactions, financial data, investment focus Write data BACK TO Google Sheets after each call: call summary (max 60 words), conversation outcome (positive/negative/neutral), willingness to sell rating (high/medium/low/none), property-specific information, next steps Real-time sync - Google Sheets acts as the central database Calendar Integration: When a prospect agrees to a meeting during a call, the AI should be able to create a calendar appointment automatically Integration with Google Calendar (or similar) Capture date, time, and contact details Inbound Call Recognition: When someone calls back, the system should recognize their phone number Match the number to the correct contact/row in Google Sheets Pull up their information so the AI knows who they are and what was discussed previously Continue the conversation with full context SMS Capability (Two-Way Texting): Send text messages to contacts when requested during calls Receive and log text message responses Associate all SMS communication with the correct contact in Google Sheets Call Recording, Transcription & Summary: Configure call recording (if not already set up) Automatic transcription of all calls Generate call summaries using a custom format and write them back to Google Sheets DATA FLOW SUMMARY: Google Sheets → VAPI (pulls lead data) → AI makes call → Call outcome, summary, SMS, calendar booking → All data writes back to Google Sheets in real-time WHAT'S ALREADY DONE: ✅ VAPI account set up ✅ AI assistant configured and can make calls ✅ Custom prompts and knowledge base documents prepared WHAT I NEED: ❌ Google Sheets integration (read and write) ❌ Calendar integration ❌ Inbound call recognition and contact matching ❌ SMS two-way texting ❌ Call recording/transcription/summary configuration (if not already active) PROJECT REQUIREMENTS: Must have proven experience with VAPI integrations - please provide examples of past projects Experience with Google Sheets API and bidirectional data sync Experience with calendar APIs (Google Calendar or similar) Experience with SMS integration (Twilio or similar) Ability to work quickly and efficiently Clear communication and ability to explain technical setup TIMELINE: I'm looking to complete this project as quickly as possible. Please provide your realistic timeline in your proposal. TO APPLY: Please include in your proposal: Examples of past VAPI integration projects you've completed (links, screenshots, or case studies) Your estimated timeline to complete all integrations Your total cost (fixed price preferred) Any questions you have about the project requirements I will only accept proposals from freelancers with a proven track record of VAPI or similar AI calling system integrations. Please do not apply if you do not have relevant experience. BUDGET: Open to proposals - please provide your best quote based on the scope outlined above.

Automated PDF Text Extraction Database

I need a streamlined way to turn a large collection of PDFs into a searchable database focused on data extraction and analysis. The core requirement is to pull every piece of text data from each file—headings, body copy, footnotes, everything—and store it in a structured repository that I can query later. Here’s what I’m looking for: 1. Ingestion & Parsing • A script or small utility that ingests bulk PDFs from a folder or S3 bucket. • Automatic OCR fallback for any scanned pages (Tesseract or a comparable engine). • Reliable parsing of the extracted text using Python, Apache Tika, pdfminer-six, or a tool you recommend. 2. Storage Design • A relational database (PostgreSQL/MySQL) or a text-search solution such as Elasticsearch—whichever best supports fast full-text queries. • Each document should be tagged with filename, date added, page numbers, and any basic metadata found in the PDF header. 3. Query & Export • Simple CLI or lightweight web interface where I can search keywords, filter by metadata, and export results to CSV for further analysis. • Basic analytics endpoints (word frequency, document counts) would be a plus. 4. Documentation & Handoff • Clear setup instructions, dependency list, and commented code. • A short README that shows example import, search, and CSV export commands. I’m comfortable running this on a Linux environment and can provide sample PDFs immediately. The budget targets a functional prototype with clean, maintainable code rather than a polished enterprise UI, so focus on core extraction accuracy and searchable storage. If you’ve built similar ETL pipelines or OCR workflows, let me know—I value proven experience and concise solutions.

opportunity

Custom connector for power bi to directquery sqlite db via odbc

We are seeking an experienced developer to create a custom connector for Power BI that facilitates DirectQuery access to an SQLite database via ODBC. This project involves designing a seamless integration that allows users to efficiently query SQLite data within the Power BI environment. The ideal candidate should have a strong understanding of Power BI, ODBC connections, and SQLite databases. Your expertise will be crucial in ensuring optimal performance and functionality. Please submit your proposals detailing your relevant experience and approach to this project.

Cold Calling / Telesales - Appointment Booking

We are a home improvements / insulation company who provide different insulation upgrades to peoples homes B2C. Mainly this involves loft insulation but could cover all aspects of energy efficiency / renewable insulation methods. We are looking for hard working telesales representatives to cold call our data lists to book loft/property surveyrs for our technical surveyors. The purpose of the survey appointment would be for one of our surveyors to visit the customer and give them a full report on the current condition of the loft insulation & then advise on any improvements that could be made. We will then potentially sell our products on the back of the reported information (if there are any issues, or its not up to standard) We mainly work from google sheets but also have an inhouse CRM and app which we use when booking appointments. Full training will be provided to the right candidates.

Magento to Shopify Website Migration

We are looking for an experienced Shopify developer (or agency) to migrate our existing Magento-hosted eCommerce website to Shopify. The goal is to ensure a seamless transition of all products, customers, orders, content, and SEO value, with minimal downtime and a visually polished new storefront. Scope of Work: 1. Data Migration Migrate all products, variants, SKUs, categories, collections, attributes, and images. Transfer all customer data, order history, and user accounts. Maintain product URLs and meta data for SEO continuity. Ensure all redirects (301s) are set up properly. 2. Design & Theme Implement a modern, responsive Shopify theme that reflects our brand identity. Customize theme layout, colors, and fonts as per our existing or improved branding. Replicate or enhance key pages (Home, Product, About, Contact, Blog, etc.). 3. Functionality & Integrations Integrate necessary Shopify apps for functionality equivalent to Magento extensions. Configure payment gateways, shipping methods, taxes, and email notifications. Ensure integration with CRM, ERP, and marketing tools (if applicable). 4. Content Migration Migrate CMS pages, blog posts, and media (banners, images, videos). Ensure proper formatting and linking in the new platform. 5. SEO & Performance Maintain URL structure or set up SEO redirects. Transfer meta titles, descriptions, alt text, and structured data. Optimize load speed and mobile performance. 6. Testing & Launch Conduct thorough QA testing before launch (desktop & mobile). Verify checkout process, payment, shipping, and tax calculations. Post-launch monitoring and support for 2–4 weeks. ***ADDENDUM** ***The Magento website URL is... www.lithobee.com *** *** PLEASE CAN YOU ALSO PROVISE A FIXED PRICE QUOTE **

Excel financial model

We are seeking an experienced financial modeler to develop a comprehensive Excel financial model inspired by the structure demonstrated in the provided video link. The ideal candidate will possess a strong proficiency in Excel, a solid understanding of financial principles, and the ability to present complex data in a clear, user-friendly format. The model should encompass key financial statements, projections, and analytical tools that facilitate informed decision-making. Attention to detail and adherence to timelines are crucial. We look forward to reviewing your proposals and collaborating on this project. https://www.youtube.com/watch?v=pSz38L6dz1Y

Dental Practice Acquisition

I am seeking an experienced research professional or consultant to help identify and evaluate potential businesses (dental practices) for acquisition. This is a research-only role — not a brokerage or sales position. The focus is on market mapping, due diligence, and shortlisting opportunities based on defined criteria. About Me I am a healthcare professional based in South East England, currently exploring the purchase of an established or semi-established dental practice that aligns with my vision for a modern, patient-centred clinic. While experience in healthcare or dentistry is welcome, it is not essential — the key requirement is strong analytical and research capability. Target Region The focus area is the East London / Essex corridor, ideally within or around: Hornchurch, Romford, Upminster, and Wanstead. Proximity, local demographics, and accessibility are important considerations. Scope of Work The consultant will: Conduct open-source and data-based research to identify suitable businesses within the target region that may be potential acquisition opportunities. Gather and summarise key details for each opportunity, including: Business type and size (approximate number of rooms, staff, etc.) Ownership or lease information where available Online footprint and reputation (e.g. Google, CQC, NHS or review platforms) Location suitability and local competition Indications of whether the business might be open to sale or partnership Compile a shortlist of 5–10 potential opportunities with supporting information and evidence. Provide a summary report outlining findings, insights, and next steps for outreach or verification. Deliverables A concise research report (Word or PDF) summarising market context and identified opportunities. A spreadsheet of shortlisted businesses, including location, key data points, and relevant links. Recommendations for further due diligence or contact strategy. Ideal Candidate Strong research, data collection, and analytical skills. Proven ability to find information using open sources, business directories, public records, and creative search techniques. Capable of presenting findings clearly and concisely. Independent, discreet, and reliable. (Experience in healthcare or property research is a bonus but not required.) Budget & Timeline Fixed project fee or hourly rate (please specify). Initial research to be completed within 4–6 weeks. How to Apply Please include: A short summary of your relevant research experience. Examples of previous market or business research projects. Your proposed fee and turnaround time. Confirmation that you work independently and are not affiliated with any brokerage.

Prepare my statements to do annual return for Singapore company

I am seeking a skilled freelancer to assist in preparing annual return statements for my Singapore-based hair salon. The ideal candidate should have a profound understanding of Singaporean corporate regulations and compliance requirements. Responsibilities will include compiling financial data from bank statements and POS reports, ensuring accuracy in reporting, and adhering to submission deadlines. Attention to detail and familiarity with local accounting practices are crucial. This project aims to ensure all documentation is meticulously prepared in accordance with the Accounting and Corporate Regulatory Authority (ACRA) standards. A reliable partnership may lead to long-term collaboration as we transition to dedicated accounting software. Currently, the freelancer has to work with bank statements, POS reports as we do not have dedicated accounting software set up.

Integrate Shopify with my Software

I am seeking an experienced professional to facilitate the integration of my software with Shopify's subscription and marketing functionalities. This integration is crucial for enhancing user engagement and streamlining operations. The ideal candidate should possess a deep understanding of both Shopify's API and subscription management, ensuring seamless data flow and robust marketing capabilities. Your expertise will be instrumental in creating a cohesive platform that maximizes the potential of both systems. I look forward to collaborating with a skilled freelancer to bring this project to fruition.

London Based Research Assistant Required

I’m seeking a virtual assistant based in London, ideally in the South or Southeast London areas, to assist with a small research project. The primary task is to download, install and then run our software on a Windows PC to collect information from an online source, downloading the data into a pre-defined Excel spreadsheet. The task should take a maximum of about two hours. This project requires basic software skills, familiarity with Excel, good communication, and able to meet deadlines. While this is a one-off project, there’s potential for ongoing work in the future. Thank you.

Fix Table Mapping (Coordinates) for OCR Tool – ClubGG Poker

Description: I already have a working OCR tool. I just need an experienced developer to fix or update the table mapping file so that all coordinates match correctly with the ClubGG poker client. Tasks: • Adjust coordinate mapping for cards, stacks, player names, and actions • Ensure accurate detection across multiple tables and screen resolutions • Test and verify correct data extraction Requirements: • Experience with OCR tools and table mapping (OpenCV, Tesseract, or similar) • Familiarity with poker layouts (ClubGG preferred) • Fast and precise work — must deliver tested and verified coordinates Goal: A clean, fully functional mapping file that ensures all table elements are correctly read by the OCR system. Budget: Flexible depending on speed and experience.

Google api setup

The Professional & Comprehensive Ad (Best for attracting serious businesses) Headline: Google API Expert | Setup, Integration & Automation | Sheets, Apps Script, Cloud Functions Ad Body: Struggling with OAuth credentials, service accounts, or confusing API documentation? Let me handle the technical complexity of Google APIs so you can focus on using your data. I am a specialist in setting up and integrating various Google APIs to automate workflows, sync data, and build powerful custom solutions. I can help you with: ✅ Google API Setup & Authentication Secure OAuth 2.0 & Service Account configuration Setting up projects in Google Cloud Console Managing API keys & credentials securely ✅ Popular Google API Integrations Google Sheets API: Connect external apps to read/write data automatically. Google Drive API: Automate file management, uploads, and organization. Gmail API: Automate email sending, labeling, and parsing. Google Calendar API: Sync events, create meetings, and manage calendars. Google Apps Script: Custom automation between Google Workspace apps. ✅ Custom Solutions Build a dashboard that pulls data from multiple sources. Automate repetitive reporting tasks. Create a custom integration between your software and Google Workspace. Why work with me? Clear Communication: I explain technical concepts in plain English.

urgent

React.js / Supabase TypeScript Edge Functions development

UK/EU Preferred Requirements: • Create TypeScript Edge Functions for React.js/Supabase project based on provided specifications derived from Bubble.io workflows. (Knowledge of Bubble.io not required.) • Implement database operations using Supabase client • Maintain existing business logic and data structures • Handle error management • Create comprehensive API endpoints for each workflow Required Skills: • TypeScript/JavaScript proficiency • Supabase database operations • RESTful API development • Database schema design • Authentication & authorization Preferred Experience: • Supabase Edge Functions development (major advantage) • Deno runtime experience • PostgreSQL/SQL expertise Deliverables: • Fully functional Edge Functions • Database migration scripts • API documentation • Testing & validation

opportunity

Audit & Implement EU Brevo Email Alert System (Node.js)

We recently completed a UK-specific automated email alert system that connects our PostgreSQL + Google Sheets data to Brevo (Sendinblue) for user notifications. The system is fully functional and documented in detail (22-page technical document provided). We’ve now parted ways with the original developer, and we’re looking for a new expert to: Audit and verify the completed UK alert system — ensuring it meets best practices, follows clean architecture, and that there are no code or performance issues. Duplicate and adapt the same system for our European Union product (France, Germany, Spain, and Ireland). What’s Already Done (UK System): Node.js + Express + TypeScript backend PostgreSQL (Neon) + Drizzle ORM Google Sheets API integration for live savings data Automated Brevo lists + contact sync 6 email templates for various alert types Daily + weekly cron jobs Duplicate prevention, scheduled emails, and smart alert logic Full system documentation (provided) Your Tasks: Phase 1 — Audit (Estimated: 1–2 days) Review all code, configuration, and Brevo integration Verify cron jobs, email triggers, and database schemas match documentation Test end-to-end flow (sign-up → Brevo list → email delivery → logs) Identify and fix any reliability, performance, or data consistency issues Phase 2 — EU Implementation (Estimated: 2–3 days) Duplicate UK alert flow for EU region (France, Germany, Spain, Ireland) Integrate EU-specific Google Sheets data endpoints (already hosted) Create separate Brevo lists and folder for EU alerts Ensure rate updates trigger relevant EU emails Update templates where necessary (e.g., "Weekly Roundup EU") Deploy and test full flow on Replit Deliverables: Verified and clean UK alert system EU alert system live and fully functional Separate Brevo folder and lists for EU contacts Working cron jobs (daily + weekly) Test documentation and basic setup instructions Tech Stack: Node.js + Express + TypeScript PostgreSQL (Neon) with Drizzle ORM Brevo API (v3) Google Sheets API Hosted on Replit What We’re Looking For: Strong backend skills in Node.js/TypeScript Experience with PostgreSQL + Drizzle ORM Knowledge of Brevo (Sendinblue) or similar email systems Familiarity with cron jobs, background tasks, and transactional email logic Proven ability to work from and extend existing codebases Budget & Timeline:

Scraping stock levels from a website

NOTE* This website is not mine, nor do we have any admin rights for it. The website clearly shows product Title, SKU & Exact Stock Levels. You must be logged in as a user to see the stock levels. I can provide the website and login details for this. Task: Clearly show stock level changes through time. For example, the solution will scrape stock levels for the entire product collection in the store daily and will clearly display changes in stock levels. A suggested way to output the information would be for it to go into a Google Spreadsheet, which can then clearly display a chart or something alike that shows which products are selling the most in order by SKU and Product Title. I think a scrape or data collection should be once per day - I don't think its necessary to perform the task more times than this. It must keep the data and changes forever since the day the system is implemented. The above way via Google Spreadsheet is just an example - if you have a better way, please provide the solution to me. Please provide an example how of how the solution will look - if happy, we will then provide you with login details for the website.