データ統合 Jobs

For this project I need customer information that is currently scattered across several files merged, de-duplicated, and polished inside one master Excel or Google Sheets workbook. Once the sheet is tidy, every contact detail—name, phone, email, and address—has to be cross-checked against reliable web sources to make sure the data is accurate and up to date. When the verification step is done, the final workbook must follow my formatting guidelines (column order, header style, conditional colour coding). I will share a short style guide and a small sample so you can mirror the look and feel exactly. Deliverables • Cleaned and consolidated customer-info spreadsheet • Column-by-column log of any corrections made, including URLs or screenshots that confirm each u...

My priority is to build and refine Microsoft Dynamics 365 Business Central through new AL objects, with the spotlight on custom tables and pages. These pages must support clean data entry, run their own validation, trigger custom workflows, and surface key metrics in dashboard-style reports. Beyond the UI layer, I need business logic that enforces bespoke validation rules and handles data integration processes so information moves reliably between internal modules and any external systems we connect later. Additional work will include, when required, adjusting RDLC or Word layouts for reports, extending posting and approval workflows, exposing data through APIs or web services, and tuning SQL for performance. Deliverables • AL code for tables, pages, and supporting codeunit...

I manage our university’s Student Information System and need a technically savvy partner to keep it running at peak performance while we expand its capabilities. Day to day, the work ranges from fine-tuning system configuration, maintaining a clean permission hierarchy, and automating routine admin tasks, through to digging into database queries when the system slows down or an integration drops data. You’ll be hands-on with: • System configuration & ongoing management • User account lifecycle, roles, and permissions • Reporting, analytics, and custom queries Current pain points I want resolved quickly: • Intermittent performance slow-downs during high-traffic periods • Data integration failures between the SIS and our LMS/HR platforms ...

Title: Automated Gym Management System (Python & Excel) Overview: A complete, automated system designed to streamline gym operations, track memberships, and monitor financial health. Built using a powerful combination of Python and Excel, this project removes the manual guesswork from daily gym administration, allowing owners to focus on their clients. Key Features: Automated Fee Tracking: Easily monitor which members have paid for the current month and quickly identify outstanding dues. Financial Tracking (P&L): Built-in Profit & Loss formulas to give gym owners an instant, accurate view of their revenue and expenses. Member Database: Organized, structured data management for quick access to member records and renewal dates. Data Integration: Smooth inter...

I’m putting together a showcase-worthy sales workbook for my Data Entry & Excel portfolio and need an expert touch. The dataset is retail-focused and will be a mix of records I supply and additional, realistic entries you create to round it out. Everything must live in a single Excel file and look clean, consistent, and professional. Here’s what I’m after: • A well-structured table that holds customer and product details, quantities, unit prices, order dates, payment status, and a calculated line total. • Thorough data cleaning and formatting so every field is validated, dates align to one format, and currency values carry two decimals. • Built-in formulas (SUMIFS, COUNTIFS, IF, XLOOKUP or similar) for automatic totals. • Sorting and filter...

I have an AI-enabled smart collar on every cow in my herd. The collars stream real-time health metrics and behaviour-analysis data that I want flowing straight into an ERP so I can treat each animal like a live SKU inside my wider inventory, analytics and supply-chain workflows. I have not selected the ERP platform yet; SAP, Oracle or Microsoft Dynamics are all on the table. Part of the assignment is to advise which option will connect most cleanly to the collar data pipeline and to my existing farm-management processes, then build the actual integration. The finished solution should: • pull the collar’s health and behaviour data automatically (API, MQTT or another method you recommend) • map and normalise those fields inside the chosen ERP so they support inventory m...

Fuel Management Dashboard – Proposal and Scope of Work This proposal defines the scope of work for the design, development, and implementation of a comprehensive Fuel Management Dashboard platform integrating real-time IoT and OEM server data for effective monitoring, control, and decision-making. The system aligns with existing deployments similar to K92 and Hi-Lift operations. SQL is what we have used in the past. We are looking to be migrating from our current dashboard service provider and therefore would like to go from scratch but to keep the same logic in an ugraded visual and functional quality. 1. Overview The Fuel Management Dashboard provides a unified, real-time view of fuel operations across all sites. It consolidates data from IoT-enabled devices, ATG systems, issuan...

I’m ramping up a set of data-heavy initiatives that all run on Microsoft Fabric, and I need an experienced hand who can jump in right away. The focus is pure data integration: designing and orchestrating Fabric pipelines, unifying data from disparate sources, and getting everything landed, cleaned, and ready for downstream consumers. While some reporting or admin work may pop up, the core responsibility is building robust, production-grade integration workflows inside Fabric itself—knowledge of only Power BI, SSIS, or generic ETL will not be enough. The engagement starts at a guaranteed 20 hours a week, with the real possibility of expanding to a full 40 as we move deeper into the roadmap. Work from home is perfectly fine, and for compliance and collaboration reasons I’m...

I need a digital twin that zeroes-in on my building’s energy performance. Right now I only have partial data—BMS exports, sub-metering on a handful of panels, and monthly utility bills—so the model must be able to start with what’s available, validate any gaps, then scale as more sensors come online. Primary improvement targets: • Heating and cooling systems • Overall energy consumption The twin should connect to the existing BIM (Revit) files, ingest the live and historical data, and run calibrated simulations—EnergyPlus or an equivalent physics-based engine is fine—so I can visualise real-time KPIs and generate “what-if” scenarios for retrofit ideas. I’m interested in clear, actionable outputs such as predicted savings...

The Problem — Dispatch Verification & Label Management at Surya Road Lines Surya Road Lines operates as a Carrying & Forwarding (C&F) agent handling goods for multiple companies including Chambal Fertilizers. Every day, goods from multiple principals are received at the godown, stored, and dispatched to dealers and retailers across 13 districts of Madhya Pradesh. The operation involves multiple products, multiple parties, and multiple transporters — all moving simultaneously. The core problem is threefold: 1. Mixed-up goods during dispatch The godown stores dozens of products at any given time. Many of these products — especially crop protection chemicals and specialty nutrients — come in packaging that looks nearly identical. Same size box, same colo...

I'm seeking a skilled professional to perform a full forensic extraction of my Twitter (X) app activity. This is for personal review and security purposes. Requirements: - Extract account login and logout activity - Provide a comprehensive timeline of every time I opened the app - Cover all available data, not just the last 30 days or last 6 months - Deliver the extracted data in PDF format Ideal Skills and Experience: - Experience with forensic data extraction - Familiarity with Twitter(X) app and its data structures - Ability to generate detailed activity reports - Proficiency in creating organized, readable PDFs

I need a Macro script to automate the process of comparing two Excel spreadsheets and generating a CSV file. The script will also dump this CSV into our ERP system (EPICOR) using the DMT tool. Requirements: - Compare the two spreadsheets cell-by-cell. - Highlight mismatches. - Include all columns in the resulting CSV file. Ideal Skills and Experience: - Proficiency in PowerShell - Experience with Excel and CSV manipulation - Familiarity with EPICOR and DMT tool (Plus) - Attention to detail and accuracy

I have three separate customer data reports that I download regularly. I need an offline solution—Excel-based is preferred, but I’m open to any lightweight desktop approach—that can pull the data from those three files, combine and clean it automatically, and then present the final results back in Excel across multiple worksheets. Core needs • A simple way for me to point the tool to the three source reports (file picker, drop zone, or even just pasting paths). • Behind-the-scenes logic that matches customer records, removes duplicates, and reconciles any field name differences. • Output to an .xlsx file with clearly labelled multiple sheets (e.g., Combined_Data, Exceptions, and any other logical splits you suggest). • Everything must run full...

I need an interactive HR analytics dashboard that lets me look at two things side by side: 1) how each employee is performing and 2) why people leave. The core of the build is employee performance tracking, paired with turnover analytics, so the same screen should let me jump from an individual’s productivity to the bigger attrition picture without switching tools. Data in scope • Performance – I’ll supply spreadsheets with ratings, KPIs and other performance-related figures. • Attrition – separate files include exit dates, exit-interview summaries and job-satisfaction survey scores. Metrics and factors to highlight • Attrition trends appear alongside performance metrics in every view. • Job-satisfaction levels must be an explicit f...

Hi I will share the details with the shortlisted candidates. Thanks

I'm seeking an AI-powered tool or software to help with digital music distribution, specifically in playlist generation. Key Requirements: - Develop an AI tool for automated playlist generation. - The tool should analyze user preferences, trends, and song attributes. - It should be user-friendly and integrate with existing music distribution platforms. Ideal Skills and Experience: - Expertise in AI and machine learning. - Experience in music industry and digital distribution. - Strong software development skills. - Familiarity with user interface design. Looking for a freelancer who can deliver a robust and intuitive solution within budget.

I have an Excel sheet that tracks tasks and I want a fully-working Power Automate flow that will, once a month, pull the following columns from that file and draft an Outlook email for every row that matches my criteria: • Due dates • Task descriptions • Contact details . IRD Numbers . Due month . Amount due The flow should run automatically on the 15th business day of each month, create one email per task, and leave each message in Drafts so I can review before sending. Please configure the subject line and body so the information is clearly formatted and easy to read. Deliverables I need from you: 1. The finished cloud flow exported so I can import it into my tenant. 2. A short set-up note (screenshots or a quick Loom video are fine) showing where to place the E...

The work centres on configuring several practical-skill assessments inside Mobius and pairing each one with live ProctorU supervision. I already have the questions, grading rubrics, and scheduling details; what I need is the technical side handled from end to end. Scope of work • Build the assessment shells in Mobius, upload the existing content, and apply the correct timing, grading, and accessibility rules. • Connect each exam to ProctorU, selecting the appropriate security level, ID verification flow, and environment checks. • Create candidate and proctor accounts, map the correct roles, and confirm that data flows (scores, session recordings, incident reports) remain intact between both platforms. • Run a full dry-run with two test candidates, document the ...

I need a .txt file converted into .835 format for payment remittance. The source format and delimiter are currently unknown. Ideal Skills and Experience: - Experience with .835 file format - Proficiency in handling various text file formats - Ability to determine and work with unknown delimiters Please provide a brief overview of your approach and any relevant experience.

I need help moving a blend of text and numerical fields from a few online databases into one well-structured Excel workbook. You’ll be working directly inside my shared Excel file, adding each record row by row, double-checking that the numbers copy over exactly and that text values keep their original spelling, punctuation and capitalization. I’ll provide: • Login credentials to the source databases • A template workbook with column headings and data-validation rules Your task: • Copy every field from the database screens into the matching Excel columns • Follow the simple formatting notes included on the first sheet • Flag any inconsistencies, duplicates or unreadable characters so I can review them quickly Accuracy is more important than...