Data cleansing jobs

I need a small utility or script that pulls our Sales data from a shared FileMaker Pro file and drops them straight into a pre-existing Excel workbook. The process has to run twice a day—once in the morning and againat 7pm—without anyone clicking a button. No data cleansing or re-formatting is required; I just want the exact export that FileMaker produces to appear in Excel, ready for further analysis. You’re free to choose the most reliable route—FileMaker Server schedules, an ODBC connection, a FileMaker script coupled with Power Automate, even a lightweight VBA or Python bridge—so long as it works unattended on Windows and can be quickly adjusted if the report layout changes. Deliverables: • A fully configured automation script o...

...ingests raw financial data, cleans and normalises it, then runs machine-learning routines so the results can be consumed by dashboards, reports, or downstream models. The exact data source—stocks, crypto, or transactional feeds—is still being finalised, so the solution must stay modular enough to swap connectors without large rewrites. I expect the work to centre on Python with pandas, NumPy, scikit-learn (or similar), and a well-structured ETL workflow orchestrated by notebooks or a lightweight API layer. Good documentation and clean, reproducible code are essential; once delivered, my in-house team must be able to extend the models or plug in new data streams without your help. Deliverables • A fully functioning preprocessing and feature-e...

​Job Description: We are looking for an experienced Global Trade Data & Market Research Analyst to conduct a comprehensive international trade analysis and lead generation project for Freeze-Dried Bananas and Turmeric Powder. ​The ideal freelancer will have direct access to leading trade intelligence databases (such as Volza, Import Genius, Panjiva, or TradeMap) to extract customs shipment data, map supply chain dynamics, identify international buyers, and retrieve verified procurement contact information. ​Target Product Lines & HSN Classifications ​Freeze-Dried Bananas: HSN Code 0803-9090 / 0803-9010 ​Turmeric Powder: HSN Code 0910-3030 ​Key Responsibilities & Deliverables ​1. B2B Importer & Decision-Maker Lead Extraction (Excel) ​Extract an active list of v...

Operations Data in my last company Collaborate with business stakeholders to gather functional requirements and translate them into scalable BI reporting solutions. • Designed and implemented robust data integration workflows by consolidating data from Excel, SharePoint, Salesforce, and SQL Server into a centralized reporting model. • Performed comprehensive data profiling, cleansing, transformation, and modeling using Power Query (M) to deliver high-quality, analysis-ready datasets. • Designed and developed dynamic dashboards using custom visuals, hierarchical drill-down structures, geo-maps, and drill-through features to enhance analytical depth and improve strategic business decisions. • Proficient in advanced DAX (YTD, QTD, MTD, Y...

...job costing, accounting, construction billing, and service. We already have: A consolidated ERP implementation scope containing approximately 88 requirements and 16 acceptance scenarios A functional specification and proposal from a bidding Odoo contractor An existing Zoho CRM/Zoho One environment An existing CPQ and pricing process Airtable, spreadsheets, website systems, and other operational data Defined concepts for product/SKU management, customer baskets, custom inquiries, marketing attribution, and project delivery We need an independent, senior Odoo solution architect to review everything, identify blind spots, convert the requirements into implementation-ready specifications, and act as Seaquatic’s owner-side representative during implementation. This is not a ...

I have several CSV files that contain a mix of text and numeric columns. I need a Python script that reads these files, cleans obvious issues (extra whitespace, stray symbols, inconsistent number formats, blank rows) and then applies flexible filtering rules I can adjust myself later. Key points • Source files are plain CSV; no database or API connection is involved. • The data is mixed, so the script must recognise both text and numeric fields and keep their types intact after processing. • Filtering is the only required transformation for now—think along the lines of dropping rows that fail certain thresholds, keeping records that match specified keywords, or combining multiple filter conditions with AND/OR logic. Deliverable 1. A well-commented ...

...Title: Power BI Data & Inventory Analytics Specialist## About Us We are an established, fast-growing multi-channel e-commerce brand managing a catalog of approximately 450 active products. We partner with large-scale distributors and manage data pipelines across several retail platforms and independent web storefronts. Our business model relies on operational efficiency, data precision, and real-time capital allocation. ------------------------------ We are looking for a skilled Data Analytics & Inventory Specialist to build, optimize, and maintain an automated data pipeline using Power BI and the Microsoft Ecosystem. Your primary mission is to consolidate data from multiple distinct sources—including daily/weekly distributor spre...

...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 ...

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...

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. ...