Data cleansing jobs

...shape. Here’s exactly what I’m after: • Fix every data-entry error you spot in the customer details, sales figures, and product sheets. • Replace outdated customer, product, and pricing information with the new data set I’ll provide. • Audit all existing formulas—SUMIF/S, VLOOKUP/XLOOKUP, pivots, percentages—and correct anything that is returning the wrong results or referencing the wrong ranges. Acceptance criteria The file comes back with: 1. No broken formulas or #ERROR values. 2. Customer, product, and sales tabs perfectly aligned with the master lists I supply (no duplicates, no stale rows). 3. A brief changelog sheet summarising what you corrected or replaced so I can track the updates. If you’re quick...

Our raw sales dataset needs a full analytical pass that starts with rigorous data cleansing. The main focus is on standardising every field—dates, currencies, product codes, customer IDs—so the data can be trusted for downstream reporting. Once the formats are consistent, I want a concise exploratory analysis in Python (Pandas, NumPy, Matplotlib or Seaborn) that highlights high-level trends, seasonality, and any obvious outliers. If you spot missing values or duplicate rows along the way, feel free to resolve them; the primary acceptance criterion, however, is clean, consistently formatted data backed by a short insight summary. Deliverables • Python notebook or script that performs the cleaning and analysis • A cleaned CSV (or Parq...

This project centres on translating my raw operational data into a clean, insightful Power BI dashboard that drives data-driven decisions across the business. I already have the data and a clear outline of the story it needs to tell; what’s missing is the expert build that weaves everything together. You will start by shaping and cleansing the source tables in Power Query, then layer in advanced DAX to create the calculated measures that matter most for efficiency tracking—think throughput, cycle time, utilisation, variance to target, and any other ratios needed for real-time performance checks. Once the numbers are reliable, the visual experience comes next: KPI cards for headline figures, interactive charts that can drill through to root causes, a...

...duration: 2–3 weeks across Sandbox, UAT and Production go-live) Note: The indicative end date is based on current planning assumptions and may be adjusted upon mutual agreement, particularly around client data-readiness and go-live cut-off timing. 4. Description of Activities The Vendor shall perform the following activities to set up three (3) new companies — ARO Investments, Noru NZ and Noru SG — within the Client's existing Microsoft Dynamics 365 Business Central tenant. All three entities will share a common Chart of Accounts framework, with entity-specific customer and vendor master data, tax/statutory setup, and opening balances. 4.1 Scope of Activities Phase 1 – Sandbox Build (New Companies in Existing BC Tenant) ● Create three new co...

...business and sustainability datasets into meaningful dashboards, reports, and actionable insights. The ideal candidate should have strong expertise in Power BI, SQL, data modeling, and business intelligence, with the ability to work closely with stakeholders and convert business requirements into impactful reporting solutions. Key Responsibilities • Design, develop, and maintain interactive dashboards and reports using Power BI • Build scalable data models, DAX calculations, and Power Query transformations • Develop KPI dashboards, drill-through/drill-down reports, and executive MIS reports • Manage and optimize ETL workflows and data transformation processes • Perform report optimization for performance, usability, and scalability &bu...

I need a small but reliable robot that logs in to our QuickCEP CRM every five minutes, extracts both Inbound call data and Activity logs, re-formats and merges the results, then writes the refreshed figures into a single Excel workbook that the team already uses for reporting. The flow should handle: • Secure sign-in to QuickCEP • Field mapping, basic cleansing and time-stamping of the pulled records • Overwriting or appending in the correct Excel tabs without breaking our existing formulas Any Windows-friendly RPA platform is fine—UiPath, Power Automate Desktop, —so long as it can run unattended and you deliver the full source so we can schedule it on our own machine. Deliverables • Packaged workflow with readable annotations &...

...engine—think “Customers who viewed this item also liked…,” driven by collaborative and content-based filtering, reinforced with machine-learning techniques such as matrix factorisation or deep-learning embeddings where appropriate. Here is how I picture the engagement: • Model design and training: You will work with the historical purchase, click-stream and catalogue data I provide, choose the most suitable algorithms, handle data cleansing, feature engineering and model evaluations. And ving v v by • API or micro-service deployment: The trained model must run behind an easily consumable REST or GraphQL endpoint so my front-end team can fetch ranked product lists with minimal latency. • Website integration support: ...

My Terraform code already spins up the MySQL source, VPC, subnets and security groups; Glue can reach the database without additional networking work. What I still need is the Glue side itself—fully defined in Terraform—so the data moves from that MySQL backend into the raw tier of my data lake. Here is what has to happen: • The Glue job (PySpark preferred) connects to MySQL via JDBC, performs the required data cleansing, then writes the output as Parquet files into a specified S3 prefix. • All Glue resources—Job, Connection, IAM role, catalog tables, optional crawler—must be described in Terraform so a single terraform apply recreates the stack in any account. • Partitioning or dynamic frame optimisations that make ...

I’m ready to scale my remote team and need a dedicated recruiter who can quickly present qualified candidates for two profiles: • Virtual Assistants focused on customer support and email management. • Data Entry specialists who can handle database updates, transcription, and rigorous data verification/cleansing. Your day-to-day work will centre on proactive sourcing through job boards, social media campaigns, and professional networking platforms. I’m looking for someone who already knows where the best remote talent hangs out, how to craft hooks that attract them, and how to screen for attitude as well as skill. Deliverables I expect from you: 1. A short-list of pre-screened candidates for each role, complete with résumés, po...

I have a raw file of roughly 1.5 million B2B contacts pulled from several sources, and I need it converted into a campaign-ready database that maximises email deliverability. The work revolves around four core actions: cleaning, verifying, standardising and finally organising the data for import into my CRM and marketing platforms. Key focus • The main objective is to eliminate hard bounces and spam-trap risks so every outbound send has the highest possible delivery rate. • Three fields must come back fully standardised and de-duplicated: – Email addresses – Company names – Contact names Scope of the job You will run the list through proven large-scale email verification tools and apply additional checks for syntax, domain health and...

...LibraryThing (CSV) Project Overview I need an Excel / CSV data specialist to clean, format, and successfully import a personal catalog of 2,700 physical books into LibraryThing. The current dataset was exported as a CSV file from Bookcat, a legacy library database software that is no longer supported. Because the data originates from an outdated system, the file contains severe formatting quirks that cause modern systems to fail. The collection consists of a mix of modern books (with 10-digit or 13-digit ISBNs) and older/vintage books (which completely lack ISBN identifiers). A previous bulk import attempt stalled at 683 records because of these internal structure bugs. I need a professional to clean, prune, and structure this Bookcat data to match LibraryThing'...

I need an experienced Syndigo specialist to move our product specifications and attribute data into the platform and set up a sustainable content-management flow for Kroger. Right now the data sits in a mix of spreadsheets and legacy exports—partially organized but still inconsistent—so the first step will be cleansing and mapping it to Syndigo’s required fields. After migration, I want you to configure best-practice workflows so our team can enrich, approve, and publish product content without bottlenecks. This includes defining attribute groups, validation rules, and any automation you recommend to keep the catalog clean. Deliverables • Cleaned and normalized spec/attribute files ready for upload • Successful import into Syndigo PI...

...segmentation inside Instantly, including domain and inbox warm-up • Compelling cold-email copy and subject lines designed to prompt replies • A/B testing of variations, daily monitoring of open/reply metrics, and rapid tweaks when numbers dip • Ongoing inbox management—unsubscribes, bounce handling, cleansing, and tagging so data stays clean • Short weekly summary reports highlighting leads generated, key metrics, and next steps I’ll supply target industries and any existing data; you bring Instantly know-how, persuasive copywriting, and an eye for deliverability best practices (SPF, DKIM, DMARC, custom tracking domains, etc.). If you’ve previously grown pipelines through Instantly, let me see example metrics or brief ...

**Project Title:** Data Processing & Cleaning Script using Python (Pandas / NumPy) **Project Description:** I am looking for a skilled freelancer who can develop a robust and efficient data processing script using Python. The main goal of this project is to clean, transform, and analyze raw datasets to make them ready for further analysis and visualization. **Key Requirements:** * Load data from CSV / Excel files * Perform data cleaning (handle missing values, remove duplicates, fix data types) * Standardize column names and formats * Handle inconsistent or incorrect data entries * Perform basic transformations and feature engineering * Generate summary statistics and insights * Output clean dataset in CSV / Excel format **Technical Skills ...

...meaningful analysis, the data needs a careful pass of cleansing—removing duplicates, fixing inconsistent formats, standardising account names—and then re-entered into a tidy, well-structured sheet that aligns with my chart-of-accounts layout. Here is what I expect: • Every line item in each workbook reviewed and corrected for spelling, date and numeric formatting. • Uniform column order (period, account code, account name, amount, notes). • One consolidated, error-free master sheet delivered back in .xlsx format. I will provide the existing Excel files and a brief style guide for headers and acceptable account names. No OCR or PDF conversion is required; everything is already in spreadsheet form. To be sure we are on the same page, please ...

...meaningful analysis, the data needs a careful pass of cleansing—removing duplicates, fixing inconsistent formats, standardising account names—and then re-entered into a tidy, well-structured sheet that aligns with my chart-of-accounts layout. Here is what I expect: • Every line item in each workbook reviewed and corrected for spelling, date and numeric formatting. • Uniform column order (period, account code, account name, amount, notes). • One consolidated, error-free master sheet delivered back in .xlsx format. I will provide the existing Excel files and a brief style guide for headers and acceptable account names. No OCR or PDF conversion is required; everything is already in spreadsheet form. To be sure we are on the same page, please ...

...Implementation of data quality queues. ● Phase 2 — Deal Registration (The Funnel Convergence): Implementation of the dual-funnel strategy on a single Opportunity view. Configuration of distinct statuses, probability weightings, and mandated fi elds (funnel_type, partner, end_customer, vendor/product line) based on the chosen motion. 6 ● Phase 3 — Quotation & B2B Operations: Enforcing strict quote generation from Opportunities. Confi guration of complex document outputs (letterheads, terms) specifi c to the issuing BU, along with multi-level discount/approval workfl ows. ● Phase 4 — Visibility & Management: Delivery of custom Executive and Cluster Manager dashboards. Surfacing KPIs such as pipeline by BU/Company, win rates by vendor line, MTD performance,...

...meaningful analysis, the data needs a careful pass of cleansing—removing duplicates, fixing inconsistent formats, standardising account names—and then re-entered into a tidy, well-structured sheet that aligns with my chart-of-accounts layout. Here is what I expect: • Every line item in each workbook reviewed and corrected for spelling, date and numeric formatting. • Uniform column order (period, account code, account name, amount, notes). • One consolidated, error-free master sheet delivered back in .xlsx format. I will provide the existing Excel files and a brief style guide for headers and acceptable account names. No OCR or PDF conversion is required; everything is already in spreadsheet form. To be sure we are on the same page, please ...

...segmentation inside Instantly, including domain and inbox warm-up • Compelling cold-email copy and subject lines designed to prompt replies • A/B testing of variations, daily monitoring of open/reply metrics, and rapid tweaks when numbers dip • Ongoing inbox management—unsubscribes, bounce handling, cleansing, and tagging so data stays clean • Short weekly summary reports highlighting leads generated, key metrics, and next steps I’ll supply target industries and any existing data; you bring Instantly know-how, persuasive copywriting, and an eye for deliverability best practices (SPF, DKIM, DMARC, custom tracking domains, etc.). If you’ve previously grown pipelines through Instantly, let me see example metrics or brief ...

...preparation and segmentation inside Instantly, including domain and inbox warm-up • Compelling cold-email copy and subject lines designed to prompt replies • A/B testing of variations, daily monitoring of open/reply metrics, and rapid tweaks when numbers dip • Ongoing inbox management—unsubscribes, bounce handling, cleansing, and tagging so data stays clean • Short weekly summary reports highlighting leads generated, key metrics, and next steps I’ll supply target industries and any existing data; you bring Instantly know-how, persuasive copywriting, and an eye for deliverability best practices (SPF, DKIM, DMARC, custom tracking domains, etc.). If you’ve previously grown pipelines through Instantly, let me see example metrics o...

...segmentation inside Instantly, including domain and inbox warm-up • Compelling cold-email copy and subject lines designed to prompt replies • A/B testing of variations, daily monitoring of open/reply metrics, and rapid tweaks when numbers dip • Ongoing inbox management—unsubscribes, bounce handling, cleansing, and tagging so data stays clean • Short weekly summary reports highlighting leads generated, key metrics, and next steps I’ll supply target industries and any existing data; you bring Instantly know-how, persuasive copywriting, and an eye for deliverability best practices (SPF, DKIM, DMARC, custom tracking domains, etc.). If you’ve previously grown pipelines through Instantly, let me see example metrics or brief ...

...meaningful analysis, the data needs a careful pass of cleansing—removing duplicates, fixing inconsistent formats, standardising account names—and then re-entered into a tidy, well-structured sheet that aligns with my chart-of-accounts layout. Here is what I expect: • Every line item in each workbook reviewed and corrected for spelling, date and numeric formatting. • Uniform column order (period, account code, account name, amount, notes). • One consolidated, error-free master sheet delivered back in .xlsx format. I will provide the existing Excel files and a brief style guide for headers and acceptable account names. No OCR or PDF conversion is required; everything is already in spreadsheet form. To be sure we are on the same page, please ...

...meaningful analysis, the data needs a careful pass of cleansing—removing duplicates, fixing inconsistent formats, standardising account names—and then re-entered into a tidy, well-structured sheet that aligns with my chart-of-accounts layout. Here is what I expect: • Every line item in each workbook reviewed and corrected for spelling, date and numeric formatting. • Uniform column order (period, account code, account name, amount, notes). • One consolidated, error-free master sheet delivered back in .xlsx format. I will provide the existing Excel files and a brief style guide for headers and acceptable account names. No OCR or PDF conversion is required; everything is already in spreadsheet form. To be sure we are on the same page, please ...

I have several datasets in Excel/CSV format that need to be transferred, verified, and scrubbed for accuracy. Every record must be entered exactly as it appears in the source files, then checked for duplicates, incomplete rows, and obvious errors. Once the data is in place, I’d like all phone numbers brought to a single, consistent format so the file is ready for import into our CRM. You’ll be working solely with the Excel/CSV sheets I provide—no PDFs or scans—so strong command of spreadsheets and formulas is essential. A sharp eye for detail matters more than speed; I need each entry cross-checked against the original before moving on. If anything looks questionable, simply flag it and I’ll clarify. Deliverables • A cleaned, fully organized Exce...

...workflows, and cycle counts. • Order processing – reservation of stock, pick/pack/ship steps, and automatic status updates feeding Sales and Purchase modules. Migration requirement We already run an in-house inventory system; its data (items, locations, transactions, serials) must be migrated with zero loss and minimal downtime. Expect to handle schema mapping, cleansing, validation, and a final cut-over script. Acceptance criteria • All three functions above are accessible through responsive web screens with role-based permissions. • Migrated data reconciles 100 % against the legacy system. • RESTful endpoints documented in OpenAPI for later module integrations. • Unit and integration tests covering critical paths. I&rs...

...If you are feeling overwhelmed, physically exhausted, or emotionally blocked, my tailored distant healing sessions are designed to channel positive universal life force energy directly to you, no matter where you are in the world. What I Offer: Distant Reiki Healing: Deep relaxation and healing from the comfort of your home. Chakra Balancing & Cleansing: Aligning your energy centers to boost mental clarity and emotional stability. Aura Cleansing: Removing negative energies and emotional blockages. Stress & Anxiety Relief: Helping your mind and body return to a peaceful state. Why Choose My Services? Certified and experienced Reiki healer. Compassionate, private, and judgment-free healing space. Personalized post-session feedback and guidance. Let’s ...

...duplicate products, missing records, and data inconsistencies. * Ensure products display correctly on the storefront. * Verify collections, navigation, filters, and search functionality after the import. * Produce a validation report outlining any issues identified and the actions taken. Required Skills * Proven experience with Shopify administration. * Extensive experience performing bulk product imports into Shopify. * Strong knowledge of Shopify CSV imports/exports, bulk editing, and product management. * Experience using Shopify APIs or bulk import applications where appropriate. * Advanced Excel or Google Sheets skills for data cleansing and validation. * Excellent attention to detail and quality assurance. * Ability to troubleshoot import errors and data...

...begins, please run data cleansing, normalisation, and spatial-temporal interpolation so that missing or erratic values do not distort the forecast. Deliverables • A file geodatabase containing the cleaned 2022-2026 input layers, intermediate surfaces, and ten yearly AQI prediction rasters (2027-2036) at a resolution suitable for district-level policy work. • A Geostatistical Analyst layer file (.lyr) or open GDB kriging model that can be rerun when new data arrive. • A brief method note (PDF or DOCX) summarising preprocessing choices, semivariogram parameters, validation statistics (e.g., RMSE, ME), and any ArcPy snippets you used so that results remain reproducible. I will test the deliverables by rerunning the saved model on a withheld s...

...name, ZIP, or last-purchase date are welcome if you have them. • Validation evidence showing at least 95 % of the numbers pass an HLR or comparable real-time check. • Written confirmation that the data was sourced in full compliance with U-S privacy and telemarketing laws. When you reply, include samples from past work that demonstrate your ability to deliver high-volume, high-quality consumer datasets. Generic pitches without proof of previous results will be ignored. I am ready to move quickly once authenticity is confirmed, so feel free to outline your timeline for extraction, cleansing, and final delivery....

Python, SQL, ETL, PySpark, Spark SQL, AWS EMR, AWS Lambda, AWS Step Functions, Amazon S3 (Data Lake – Raw & Processed Zones), AWS CloudWatch, AWS SNS, Pandas, Excel, Veeva CRM Project Overview Designed and implemented an end-to-end AWS-based data engineering pipeline to bifurcate, process, and deliver pharmaceutical sales, HCP, call activity, territory, and marketing data for Europe (EU) and Russia (RU) regions into Veeva CRM. The solution automated data ingestion from external APIs, validated and transformed high-volume datasets using Spark on EMR, and enforced multi-layer data quality checks based on business rules. Final curated datasets were delivered to Veeva CRM to support daily call planning, HCP targeting, territory alignment, and field ...

I'm seeking a skilled professional to migrate data from The Key to CRM Brain which is an new product from the same provder The migration involves: - Data Types: Contacts, Sales Data, Client Files - Data Formats: Primarily involves data cleansing on existing data. Ideal Skills & Experience: - Familiarity with The Key & CRM Brain - Strong data migration experience - Proficiency in data cleansing and validation - Attention to detail and accuracy - UK based

I need a robust end-to-end data pipeline that reliably pulls data from two main sources—our MySQL transactional database and several third-party APIs—and lands it in a clean, query-ready store. The primary objectives are to automate ingestion, ensure data quality through basic validation checks, and make the transformed data available on a predictable schedule for our analytics team. Here’s how I picture the workflow: 1. Ingestion • Incremental extracts from MySQL (binlog or timestamp strategy). • Scheduled API calls with rate-limit awareness and retry logic. 2. Transformation & Validation • Lightweight cleansing, type casting, and schema enforcement. • Simple anomaly detection (row counts, ...

...exclusively on data cleaning and preprocessing. The raw sources arrive in mixed formats—numbers, categorical fields, free-text comments—so I need a specialist who feels at home moving across KNIME, SQL, Python and, once the dust has settled, feeding the tidied tables into Power BI for quick checks. Here is what success looks like to me: • An end-to-end KNIME workflow (or equivalent Python script, where it makes more sense) that imports the files and database tables, handles missing values, normalises data types, and flags outliers without hard-coding paths. • Reusable SQL snippets for in-base cleansing steps. • A final, well-documented output table or file that drops directly into Power BI with no additional manipulation needed. ...

...high-resolution sensor feeds in JSON and is backed by several years of curated historical performance data. The goal is to turn those two sources into accurate failure-risk forecasts and actionable maintenance recommendations. You will design and implement the full workflow—data ingestion, cleansing, feature engineering, model training, and deployment—inside a Python-based stack (pandas, scikit-learn or similar; feel free to propose alternatives such as PySpark or TensorFlow if they offer clear advantages). Real-time scoring must run fast enough to support control-room dashboards, and the results should be exposed through an API the rest of the system can call. Key deliverables • Data pipeline that pulls JSON sensor streams and historical...

Build an AI-Powered Demand Forecasting Application Develop an end-to-end Demand Forecasting application capable of ingesting historical and external demand drivers, performing automated data preparation, generating forecasts using multiple statistical and AI/ML models, and comparing model performance to identify the most accurate forecasting approach. 1. Data Inputs The application should support importing historical demand data from Excel (.xlsx) and CSV files. A. Transactional and Supply Chain Data Sales Orders from Order Management systems Item Master Attributes Customer Attributes Organization/Business Unit Attributes Inventory Levels Stockout History Supplier Lead Times Production Capacity Constraints Supplier Disruptions Logistics and Transport...

I’m commissioning a comprehensive “how-to” textbook that equips aspiring analysts to operate at a truly professional level within Revenue and Enterprise teams. The book must walk the reader from core principles to advanced practice, blending real-world experience with rigorous instruction. Content scope • Data Analysis Techniques – from dataset acquisition and cleansing through statistical modelling, SQL/Python workflows and dashboard storytelling. • Financial Modeling – complete P&L, cash-flow and scenario models, guidelines for sensitivity analysis, plus tips on linking models to strategic recommendations. • Market Research Methods – quantitative surveys, qualitative interviews, competitive intelligence and how t...

Build an AI-Powered Demand Forecasting Application Develop an end-to-end Demand Forecasting application capable of ingesting historical and external demand drivers, performing automated data preparation, generating forecasts using multiple statistical and AI/ML models, and comparing model performance to identify the most accurate forecasting approach. 1. Data Inputs The application should support importing historical demand data from Excel (.xlsx) and CSV files. A. Transactional and Supply Chain Data Sales Orders from Order Management systems Item Master Attributes Customer Attributes Organization/Business Unit Attributes Inventory Levels Stockout History Supplier Lead Times Production Capacity Constraints Supplier Disruptions Logistics and Transport...

...Responsibilities: experience 14+Years ● Design, develop, test, and maintain scalable ETL data pipelines using Python. ● Architect the enterprise solutions with various technologies like Kafka, multi-cloud services, auto-scaling using GKE, Load balancers, APIGEE proxy API management, DBT, using LLMs as needed in the solution, redaction of sensitive information, DLP (Data Loss Prevention) etc. ● Work extensively on Google Cloud Platform (GCP) services such as: ○ Data-flow for real-time and batch data processing ○ Cloud Functions for lightweight serverless compute ○ BigQuery for data warehousing and analytics ○ Cloud Composer for orchestration of data workflows (on Apache Airflow) ○ Google Cloud Storage (GCS) for managing data at scale ○ IA...

PROFESSIONAL SUMMARY Detail-oriented and systems-focused Data Specialist specializing in end-to-end data pipelines for remote business environments. Proven expertise in taking raw, fragmented business datasets and transforming them into structured, automated, and visually striking Power BI dashboards and Excel models. Expert in data cleansing, relational data modeling, and advanced business intelligence analytics (DAX, Power Query, XLOOKUP, and Pivot Tables) aimed at helping remote teams optimize operations, increase sales performance, and make data-driven decisions. TECHNICAL SKILLS MATRIX Data Analysis & BI: Power BI Desktop, Power BI Service, Power Pivot, Data Modeling (Star Schema), DAX (Data Analysis Expressions) Meas...

PROFESSIONAL SUMMARY Detail-oriented and systems-focused Data Specialist specializing in end-to-end data pipelines for remote business environments. Proven expertise in taking raw, fragmented business datasets and transforming them into structured, automated, and visually striking Power BI dashboards and Excel models. Expert in data cleansing, relational data modeling, and advanced business intelligence analytics (DAX, Power Query, XLOOKUP, and Pivot Tables) aimed at helping remote teams optimize operations, increase sales performance, and make data-driven decisions. TECHNICAL SKILLS MATRIX Data Analysis & BI: Power BI Desktop, Power BI Service, Power Pivot, Data Modeling (Star Schema), DAX (Data Analysis Expressions) Meas...

I’m looking to turn a collection of well-structured tables—currently sitting in SQL and a few spreadsheets—into reliable, production-ready predictive models. The core of the engagement is predictive modeling and machine learning; everything else (EDA, cleansing, visual stories in Power BI) supports that goal. Here’s what I need: • Take the structured source data, verify its quality, then engineer features that make sense for modeling. • Build, tune, and validate classification and/or regression models in Python (pandas, scikit-learn, XGBoost, or similar). • Surface model insights inside Power BI so business users can explore results interactively. Although the raw inputs are structured, some records link to image files. If incor...

The Data Engineer is responsible for designing, constructing, and maintaining the systems and infrastructure required to process and analyze large volumes of data. This role will work closely with data scientists, analysts, and other stakeholders to ensure data is collected, stored, and processed efficiently. The Data Engineer will also develop and implement data pipelines, perform data quality checks, and optimize data storage and retrieval. Develop and maintain KPIs, metrics, and dashboards by leveraging diverse datasets. Ensure data quality and integrity through data validation, cleansing, and error handling. Design and implement back-end processes using data warehouse modeling techniques. Build and...

I have two parallel data-oriented tasks that need to move quickly and accurately. First, raw information arrives daily in mixed formats; your job is to place it into a structured spreadsheet, respecting the column order I provide and double-checking for typos or missing fields before you hit save. Once the spreadsheet portion is solid, the same data feeds into an existing SQL database. I need you to connect (MySQL/PostgreSQL—whichever you prefer), run targeted cleansing queries, and eliminate duplicates, malformed dates, stray white-space, and other common inconsistencies. No schema changes are required—just clean, validate, and report back. Deliverables • Completed spreadsheet, fully validated • SQL scripts (or a log of statements) used for...

...need a set of Power Automate flows that connect seamlessly to my Microsoft Office 365 environment, focusing on data-heavy workbooks stored in OneDrive and shared through Excel Online. The goal is to eliminate the manual steps I now take when updating, cleansing, and distributing spreadsheet data across teams. Here’s what I have in mind: • A flow that triggers when a source workbook is updated, copies the fresh data into a structured table, and applies predefined formatting and validation rules. • Automated look-ups or calculations (e.g., merging reference lists, adding calculated columns) executed without opening the file. • Conditional email or Teams notifications only if data fails validation, keeping noise to a minimum. ...

...move our advisory business onto Salesforce Financial Services Cloud and need an experienced partner to guide the entire journey—customisation, data migration and system integration—until we are live in production. Customisation is first on the list. You’ll be building workflow automation (Flows / Apex where needed), fine-tuning the Lightning UI for relationship managers, and producing the executive-level custom reports and dashboards we rely on for compliance and performance tracking. Next comes data migration. All of our customer, policy and transaction history is locked inside a proprietary legacy system. You will own the extraction, cleansing and field-level mapping, then load everything into FSC—verifying that every record, attachme...

...a skilled Freelance Data Analyst / BI Consultant with strong expertise in Power BI and Power Automate, and preferred experience with Microsoft Dynamics 365 Business Central (BC). The ideal candidate will have hands-on experience delivering end-to-end data warehousing solutions, including data ingestion, transformation, modelling, reporting, and exposure to AI/advanced analytics layers. Key Responsibilities Design and develop interactive dashboards and reports using Power BI Build and maintain automated workflows using Power Automate Integrate and extract data from Dynamics 365 Business Central (preferred) and other enterprise systems Design and implement end-to-end data warehousing pipelines, including: Data ingestion (ETL/ELT) Data tr...

...building a cloud-hosted as well as on premises platform that ingests exam results from schools and coaching institutes and turns them into actionable insights on learning gaps, performance trends, and individualized improvement areas. The data you will receive is never uniform—each upload can combine multiple-choice scores, long-form essays, and other descriptive answers—so the analytics engine needs to handle mixed question types seamlessly. Core expectations • End-to-end data pipeline: secure upload (CSV, Excel or API), automatic parsing, storage, and cleansing. • Analytics engine:  - MCQ analysis for accuracy, distractor strength, topic mastery  - NLP models to evaluate essays for structure, content, and rubric alignment ...

I need help transferring data from Cliniko and Timely to Phorest as well as Google Docs to upload Data types include: - Client records - Appointment history - Billing information I'm unsure if data cleansing is necessary and would appreciate your advice on this. Ideal skills and experience: - Experience with Cliniko, Timely and Phorest ideal but not necessary as pretty straight forward - Familiarity with data migration and CRM systems - Ability to provide guidance on data cleansing

I need a technician who knows FreeSWITCH inside-out to set up an automated voice-broadcasting system that will deliver a single marketing message to a list of contacts I will supply. The list arrives clean and ready for import, so your focus is the server build, dial-plan logic, and campaign workflow, not data cleansing or list generation. Here’s what I’m after: the call engine must pick numbers from my CSV, play one pre-recorded promotional message, handle basic call outcomes (live answer vs. voicemail) and generate a concise completion report with call status statistics. No per-recipient personalisation is required; the same audio goes to everyone, keeping the logic straightforward. I already have a VPS available; you are welcome to recommend tweaks to its spe...

I have a single dataset that blends both free-form text and numerical fields, and it needs to be made analysis-ready. For the text columns I need every duplicate row removed, all formatting inconsistencies ironed out, and obvious spelling mistakes corrected so the wording is uniform and machine-readable. On the numer...as long as the results can be reproduced. Please include a brief outline of the cleaning logic in well-commented code or a notebook so I can audit each decision. Deliverables • Cleaned master dataset in its original file format • Reproducible script or notebook with explanatory comments • One-page summary detailing what was changed and why I will provide the raw file and any relevant data dictionaries once we begin; just let me know th...