Data Manipulation Projects
Looking for freelance Data Manipulation jobs and project work? PeoplePerHour has you covered.
Operational Metrics Dashboard Design
I'm looking for an expert in analytics to create a compelling dashboard that pulls data from Excel spreadsheets. You would be focussing primarily on reflecting operational stats in a clear and concise way. Key duties: • Integration of Excel spreadsheet data into the dashboard • Showcasing operational metrics, specifically focusing on account monitoring status on a daily basis like inspection due date Perfect for someone who: • Has experience with data integration from Excel spreadsheets • Understands operational metrics and how to present them effectively • Can deliver a user-friendly dashboard for easy understanding of data • Has a keen eye for details and accuracy.
4 days ago15 proposalsRemoteSelenium-based data scrape of targeted LI profiles
The creation of a SQL database by scraping data from ~345,000 records from LinkedIn. - Selenium scripts to capture multiple fields from LI profiles (including Summary, Role Descriptions, Dates in Roles) - The storing of the data in an SQL database - Detailed technical documentation about each script
4 days ago30 proposalsRemoteAnalyzing Foot Traffic Patterns
We are seeking an analytical and detail-oriented professional with a passion for harnessing data to address critical business inquiries. The role entails analyzing diverse data sets, including but not limited to, geographical data, foot traffic analytics, and marketing insights. Responsibilities encompass: Analyzing foot traffic patterns at our headquarters to unearth trends on a daily, weekly, and monthly basis. Determining the employee-to-visitor ratio within our facilities. Benchmarking the foot traffic at our headquarters against that of nearby competitors. Identifying areas within our headquarters that see peak activity at different times of the day. Reviewing device count data at our and our clients' headquarters over the past year to detect trends. Investigating commuting trends to our headquarters, pinpointing origin cities, states, and countries. Calculating the duration spent by both employees and visitors on our premises. Monitoring our employees' post-work destinations, including eateries, gyms, coffee shops, customer locations, and other interests. Examining the visitation trends of employees from our top 5 dealers to our headquarters. Fostering an environment that welcomes innovative ideas and best practices to enhance our data-driven decision-making process. The ideal candidate should have direct access to the necessary data and a background in competitive intelligence. This position is ideal for individuals who are enthusiastic about data analysis and its real-world application to drive strategic business decisions, with a profound understanding of competitive landscapes and the capacity to independently collect and analyze pertinent data. Candidates should confirm their ability to undertake this project, including having access to actual foot traffic data from sources like Foursquare, Placer.ai, or others. The final deliverable must encompass RAW data, including latitude and longitude coordinates for mapping some of the findings. IF YOU DO NOT HAVE ACCESS TO FOOT TRAFFIC DATA DO NO APPLY!
5 days ago9 proposalsRemoteAngular Developer Needed for Figma to Angular Conversion
We are looking for a skilled Angular developer to convert 15 pages from Figma designs into a fully functional Angular application. This project requires a strong attention to detail and the ability to translate design elements seamlessly into a dynamic web environment. Responsibilities: Convert Figma designs to Angular components with a high level of fidelity. Ensure the created pages are responsive and optimized for multiple devices. Collaborate closely with the design team to understand and implement specific design requirements. Integrate APIs and data retrieval/manipulation mechanisms as required. Maintain code quality and ensure the application is scalable and easily maintainable. Requirements: Proven experience in Angular and TypeScript. Strong understanding of HTML, CSS, and JavaScript. Experience with responsive and adaptive design. Good problem-solving skills and attention to detail. Excellent communication and teamwork skills. Ability to work under strict deadlines and adhere to design specifications. Additional Notes: The selected candidate will be required to sign a Non-Disclosure Agreement (NDA) before beginning the project to ensure confidentiality of the designs and project specifics. Please include examples of previous work similar to this project in your application.
14 days ago29 proposalsRemoteResearching data, sales support, marketing campaigns.
A woman's fashion brand seeks an independent contractor for wholesale market research, sales support and assistant in a monthly basis. The primary tasks involve identifying potential retail buyers on the wholesale platform Faire who may be interested in stocking the client's clothing line. This will require researching distributors' profiles to determine good matches for the brand. Subsequently, the contractor will send pre-written emails through Faire's portal to engage matched retailers. Additional assistance may include basic administrative duties to help manage the brand, such as inputting product data. The project initially centers on research and outreach, with prospects for ongoing collaboration supporting the client's growth. The ideal candidate can commit 2 -3 hours weekly and possesses strong research, written communication, and organizational skills.
10 days ago5 proposalsRemoteWe're looking for assistance with the clean up of our database
We're looking for a detail oriented person who can assist with the organization, clean up and maintenance of our database. Key objectives: Identify inconsistencies and errors within the database and implement corrective measures promptly and accurately. Merge duplicate accounts to streamline data and eliminate redundancy. Establish linkages between parent accounts and associated entities for comprehensive data mapping. Identify and delete inactive or obsolete accounts, enhancing database efficiency. Update missing or outdated information on database records to maintain data integrity and completeness. Your attention to detail will be essential in ensuring the integrity and reliability of our database. You will work closely with our team to identify and resolve database issues, and implement necessary improvements to enhance data accuracy and efficiency. If you have a passion for data management and are eager to contribute to a dynamic team, we would love to hear from you. Please submit your resume highlighting your relevant experience and skills.
6 days ago15 proposalsRemoteDatabase Design for Fleet Management
Summary: We are looking for an experienced freelance Database Engineer to create a high-performance database tailored for managing operational data from our truck fleet. The role involves collaborating with the Original Equipment Manufacturer (OEM) of the trucks to integrate our internal server with theirs. This integration will facilitate the transfer of real-time operational data. The primary goal is to store this data in our internal database, enabling data analytics to optimize fleet operations. +++ Scope of Work: The project will be executed in four main stages, with the initial contract focusing on the first two stages: 1. Database Design and Development: Design and implement a high-performance database hosted on our internal servers. This database will be linked to real-time data on the servers of the truck's OEM, ensuring seamless synchronization and data integrity. 2. Data Visualization and Reporting: Develop basic visualization and reporting capabilities to allow for easy interpretation and analysis of the collected data. This will include the creation of dashboards or reports that highlight key metrics and trends. (Future Stages to be Scoped Separately) 3. Develop a web portal, hosting data reports developed in stages 1 and 2. 4. Develop a mobile app, hosting data reports developed in stages 1 and 2. +++ Deliverables: 1. Develop and host a database on an internal server that maintains a consistent and complete dataset of real-time operational data. 2. Establish and document automatic synchronization between the internal database and the servers hosted by the OEM. 3. Create a basic dashboard for visualizing the operational data stored in the database, featuring essential metrics and real-time updates. +++ Key Responsibilities: • Analyze and understand the structure of the existing data on the OEM servers. • Design a scalable and secure database architecture. • Implement the database on our internal servers, ensuring real-time data synchronization with the OEM servers. • Develop basic tools or dashboards for data visualization and reporting. +++ Skills and Qualifications: • Proven experience in database design and development, especially with large and complex datasets. • Proficiency in database management systems (e.g., SQL, NoSQL) and data visualization tools. • Excellent analytical and problem-solving skills. • Ability to work independently and in collaboration with cross-functional teams. • Effective communication skills, with the ability to document and explain technical details clearly. +++ Project Timeline: The initial scope of the project (stages 1 and 2) is expected to be completed over the course of eight (8) full time days within a one-month timeframe (April 29th – May 31st). This period allows for actual development, with additional time allocated for necessary engagements with external stakeholders at the OEM. +++ Application Process: Interested candidates are invited to submit a proposal outlining their approach to the project, including a timeline, budget estimate, and a portfolio of relevant work. Shortlisted candidates may be invited for an interview to discuss the project in further detail. +++ About Us: At Bisedge we provide, maintain and operate mainly electric material and cargo handling equipment for companies in Africa.
5 days ago38 proposalsRemoteI need to extract data using API or data scrapping
HI I need to scrap data from website in excel. I also have API and list of user id. I need to get this done very quickly. Also i have a pretty low budget. Thank you
a month ago65 proposalsRemoteB2B Data - Marketing, Digital & Events Agencies
Hi. I'm looking to purchase a list of Marketing, Digital & Events Agency contacts. The contacts should be senior level i.e. Director, with a personal email address and NOT generic emails. Ideally looking to purchase 1k-2k contacts ASAP as a test. If the data is accurate, I'm happy to buy more data within this sector on a weekly basis. Thanks,
10 days ago32 proposalsRemoteopportunity
B2B UK Data
Please provide a count of available data for the each of the below industries. Contacts need to be the below IT Manager / Director Operations Manager / Director CEO COO Company sizes need to be the below. 25 - 500 employees - based in England and Wales only. Companies - NO IT Companies 1 - Travel and Tourism 2 - Manufacturing 3 - Retail and Distribution 4 - Hotels / Events Spaces 5 - Financial Services 6 - Professional Services Please provide a count of verified email addresses for each of the above industries.
24 days ago66 proposalsRemoteAzure Data Engineer
Requirement Azure Data Engineer Experience 6+ yrs Project Timing 2 PM – 11 PM (2 nd shift) Skills- Databricks, SQL, Pyspark Databricks Certification- Good to have Good comm's and problem solving skills o Relevant experience in Azure data engineering: 4+ years. o Relevant experience in Databricks (PySpark / Scala / SparkSQL): 2+ years. o Relevant experience in Azure Data Factory (ADF): 2+ years. o Relevant experience in SQL: 2+ years. o Experience leading a small team o Required Skills: Azure Synapse, Azure Analysis Services, Azure Data Lake Storage, and Azure SQL databases. o Good to have: Power BI, Azure IAAS services, Python, and Excel
25 days ago11 proposalsRemoteopportunity
Companies House API
I am looking to pull data from companies house using their api. (https://developer-specs.company-information.service.gov.uk/companies-house-public-data-api/reference) I would like the script to look up the company name in column A of this gsheet https://docs.google.com/spreadsheets/d/15rRpXZMmf0wUXl0hfQy05HBGifTCAAHl19q_gqzZJNg/edit#gid=0 and return the company number, director and persons of significant control. I would preferably like the script to work in Appscript within the gsheet if possible? It does require an API token so it will require you to register to create a token.
2 days ago41 proposalsRemoteopportunity
GitHub-Backed Data Web App
Hey! I hope you're well; I am currently looking for a developer who can assist with the creation of my website. This is a web application that is in the cybersecurity niche, and doesn't appear to be too complex. In short the following will take place; - User Accounts & Permissions - Several website "Features" behind a paywall. - Data to be pulled (and stored) from a Private GitHub repo, and depending on the data pulled several other fields that are part of the data. - This is then displayed on the site, but is expected to be filtered depending on the data If you send me a proposal, and want to know roughly what this would look like - let me know and I will send you one of our competitors :) At the moment, we're still writing up the full project plan and designs, however, these will be provided, so really just looking for an estimate at the moment.
18 days ago32 proposalsRemoteExcel Product Data Enrichment in Dutch, French and English
I want to improve the search function of a webshop. I want to do this by adding extra data to the products (in the form of tags). I have a list of 11,000 product names in Dutch. These product names consist of a piece of proper name, noun and then sometimes some content information. For example: Orange Cleaner degreaser 5L c We are looking for a quick way to see the noun plural in the column next to it. Also, one or more synonyms in the column(s) next to it would be nice. Example: degreasers (=plural) I understand this can be done with a Python script that performs these tasks. This script uses the Natural Language Toolkit (NLTK) library to identify multiples and synonyms. This script assumes you have a list of product names and want to find the plurals and synonyms for each of them. It prints the original product name, the plural (if found) and the synonym (if found). I am looking for someone to help me create this list. I have the same list in English and French which the same thing needs to be done. Ideal Skills and Experience: - Advanced Excel skills. - Familiarity with implementing plural forms and synonyms. - Ability to ensure data integrity and consistency.
10 days ago13 proposalsRemoteZapier Integrations Expert
Hello All, We are looking for a Zapier expert to help us integrate our customer order data in our eCommerce platform (Wix) with our email sending platform (Mailchimp) and our postage platform (Royal Mail). We need our customer data to be transferred between these systems and relevantly tagged and sadly Wix do not have any native integrations available. If you have expertise in this area, please get in touch. Many thanks
11 days ago23 proposalsRemoteopportunity
Integrate website sign up forms with Mailchimp and Monday.com
We are a small new company and have decided on Mailchimp (MC) as our email campaign platform and Monday.com as our CRM. We also have two websites - a main site, and a second one for training, which also has the facility for participants to create a login and pay online for courses. We envisage data being added to MC and Monday.com in three ways: 1. Manually, when we are in contact with an individual contact (probably directly into Monday.com) 2. Manually upload a csv file from Typeform, where we have invited individuals to register for a standalone workshop, or asked individuals to provide more information relating to a project we are working on. Some of the fields may be too niche for capturing in MC or Monday.com but the form will still include basic contact details, and the relevant GDPR questions. 3. THE MAIN REASON FOR THIS PROJECT REQUEST: We also want to embed sign up forms into our two websites, and for all the contact/preferences data we collect, to be automatically feed back to MC and Monday.com. These sign up forms should include the standard contact fields, plus some other fields relating to interests and engagement (in the form of both single down drop selection and multi-selection drop down fields). Please note no matter which of the above options is used, we still want all data collected to end up in both platforms by way of a 2-way API to ensure both platforms are always in sync. We also need to include the necessary GDPR questions in those embedded sign up forms, and for that data to be captured and visible in both MC and Monday.com. Obviously MC will then manage ongoing GDPR with opt-out, unsubscribe etc. Keeping Monday.com updated with changes as they come through, for reference purposes. At the moment we have separate basic stand alone sign up forms in both our websites. These are not fit for purposes as they can only collect limited data and there is currently no integration with MC or Monday.com. We have made a start by creating one of these embedded sign up forms in MC (the one to go into the training website) but we need with the following: a) embed this form into our training website b) create a second sign up form in MC so that we can embed a slightly different form in our main website c) make sure MC and Monday.com are set up ready to receive the data from both of these forms d) correctly capture the GDPR component in MC so that our processes remain compliant moving forward e) create the necessary APIs to ensure the ongoing data collection/GDPR process is automatically synced between both platforms. And finally, if we could also find a way to embed the data captured via Typeform (option 2 above) instead of doing this manually, this would be an added bonus.
7 days ago26 proposalsRemoteopportunity
Database Module for .NET application
I have a running application currently working and the data exchange part is by using APIs for Oracle and saving some data locally. Now will by moving to SAP S/4HANA with its own set of APIs, as well as the local data would be organized and saved into Postgresql databases. I need to create a database module that would seamlessly integrate with the application and perform the data exchange related tasks with the multiple databases. The application is .NET desktop windows application. POSTGRESQL Databases are with network access on linux. SAP S/4HANA database is cloud based, with its API provided and has minimal data exchange.
19 days ago16 proposalsRemoteWeb Scraping
Hi, I want to scrape data from justdial.com. It is showing only 100 records per 1 query but I need to bypass the security and scrape 1k-2k records instead of 100. Can anyone help? FYI, It is a business directory like yelp, yellowpages etc.
4 days ago25 proposalsRemoteReplicate a financial research paper
I need a skilled freelancer who can perform basic/intermediate financial data analysis and efficiently replicate the findings of a particular research paper, which I have chosen. Main responsibilities: - Collect public financial data relevant to the research paper - Analyze the data using Python to precisely mirror the paper's conclusions - Interpret the data analysis results Ideal candidate profile: - Experience in basic/intermediate financial analysis - Proficiency in data collection and analysis using Python A comprehensive understanding of the specific research paper's methodologies and conclusions would be an added advantage. Replicating this research paper precisely is highly crucial for my project. Therefore, a strong attention to detail is necessary. Please come equipped with the requisite skills and experience in financial data analysis and interpretation.
19 days ago4 proposalsRemoteI need someone to help me replicate a financial research paper
I need a skilled freelancer who can perform basic/intermediate financial data analysis and efficiently replicate the findings of a particular research paper, which I have chosen. Main responsibilities: - Collect public financial data relevant to the research paper - Analyze the data using Python to precisely mirror the paper's conclusions - Interpret the data analysis results Ideal candidate profile: - Experience in basic/intermediate financial analysis - Proficiency in data collection and analysis using Python A comprehensive understanding of the specific research paper's methodologies and conclusions would be an added advantage. Replicating this research paper precisely is highly crucial for my project. Therefore, a strong attention to detail is necessary. Please come equipped with the requisite skills and experience in financial data analysis and interpretation.
19 days ago11 proposalsRemote