Query project data jobs

...will have experience in researching and compiling lists of suppliers, and will have excellent attention to detail. The project will involve the following tasks: - Conducting research on home furniture drop shippers in the United States on Big Commerce vendors here: - Compiling a comprehensive list of drop shippers with their contact information and product offerings and pricing - Providing recommendations for the best drop shippers based on their reputation, pricing, unique offerings and customer service - Delivering the final list in a clean and organized format, such as a spreadsheet or database The project requires the following skills and qualifications: - Strong research and analytical skills - Familiarity with the home

I have a project which I have to present to a large audience and all I have at the moment is loads of unstructured data. The data given is about a feasibility study to find out if it's worthwhile getting funding for an app that would help people cook at home and save money. All this is fictional but needs to be presented properly. I would need details of the work as I have to present this project

PoC: We need sample code (T-SQL) to query data from ssms from Salesforce sandbox rest api (json). - install ssms - get salesforce account - run t-sql and query salesforce api

...Business Intelligence Analyst to help me with important data analysis work. I need someone who has comprehensive knowledge in business analysis and can compare different sets of data to uncover trends, dependencies, and correlations. This is a critical role, as the insights and knowledge gleaned from the analysis will inform strategic decisions. The analyst should have a strong background handling large datasets. The ability to visualize results, create meaningful and actionable reports, and work with SQL to query and process data would be advantageous. Moreover, the analyst must also have a strong understanding of Business Intelligence techniques and highly developed skills in presenting analytical data. The ability to incorporate data and ...

...me a strong understanding of data integrations, APIs, SFTP, and Webhooks. The position I am interviewing for requires additional skills beyond what I currently possess, including the ability to create connections on the fly within the platform. To demonstrate my capabilities, I have been tasked with creating examples in a demo environment. While I can follow instructions, I am seeking a qualified individual who can provide me with 5 hours of personalized, one-on-one assistance through a screen-sharing application like Zoom. The assistance I require will cover various topics, including making HTTP requests, inputting and adding query parameters, transforming collected data, defining output, global variable definitions, running data flow from a UI, displaying...

...seeking an experienced MySQL Admin/Performance Tuner to assist with an existing web application. The project involves reviewing DB setup and settings, looking at DB tuning and possibly proving assistance with query tuning. We are looking for someone who has extensive experience in tuning SQL databases, specifically MySQL databases in an AWS environment. The successful candidate should also have experience monitoring performance, and making adjustments to ensure optimal performance. The successful candidate should have excellent organizational skills, attention to detail, and be able to execute the project effectively and efficiently. We are looking for someone who can take charge of this project from start to finish, as well as someone who can advise best...

I am in need of a MySql expert who can help me optimize a query to reduce server load. The database structure is fixed and cannot be modified. This optimization needs to be done immediately. Ideal skills and experience for this job include: - Strong understanding of MySql database optimization - Experience with query optimization techniques - Knowledge of server load management - Ability to work quickly and efficiently under tight deadlines

We have a team of C# .NET developers but we are currently seeking a C++ developer to make some minor changes to an open source Windows C++ desktop application project. The program does not have an API interface, we would like to add this. There C++ libraries available that offer this functionality. Then we will want the program to connect our web API and based on certain events we want the C++ application to query our web API and then display the results in the C++ interface. You should be familiar with Windows C++ applications and programming as well as an understanding of web API.

We have website, that consumes high CPU power and the hosting provider suggest me to optimize the queries. The website developer is not able to do these things. So i need a person who have wide knowledge in query optimization.

The procject, to be made on Microsoft Power Automate (Cloud) consist in creating a process with the following steps: > Once an email arrive (officex360) with Subject " TO BE SPECIFIED " > Create a copy of the attached file ( it is a .xls file ) > Apply a filter that exclude the all rows containing "VALUE I DONT WANT" in column "COLUMN TO CHECK" > Save the copy on a dropbox path Connections with email and drobox are already set, it should be a very basic task for who knows Mycrosoft power automate.

...package #1 is $5 and allows for 10 API queries to GPT. Each API query will be based on 5 fields within their portal where the user enters information. When the user clicks a submit button located below these 5 fields, the API query is sent to GPT. Then information from those 5 fields is combined and sent to GPT along with a permanent prefix prompt that I have specified. (I use a similar Function in Zoho already and can provide access to that code.) Each API query will contain two questions for GPT. The GPT answers are then provided in two answer area/fields. Both answer areas will contain a heading, such as “Answer One” and “Answer Two.” Below the answers should be one button “Copy to Clipboard” so the user can copy the ...

...full-time job postings from google job search results and store them in a CSV format. The code should be able to efficiently collect relevant data such as Company name, company website, descriptions, posted dates, job title, and organize it properly into a CSV file. I need someone who has experience with Python coding, web scraping, and creating databases. The ability to work quickly and efficiently is a must. All code should be written in compliance with any legal protocols for using online data. If you are confident you have the necessary skills and experience, please contact me for further discussion. I also want python code. Google job search query link is below & screen shot is attached. :16

Friends, I have to make a single-page download website and I also want to know whether this website is possible in WordPress or will be made in PHP. I have my own hosting and Domain name. I want a fully responsive website for any desktop and any mobile. and I want this website in 5 to 7 days also I,m providing all details and information. any query then contacts me. here is an example of some websites: :// :// ://

I'm looking to clean up an excel /csv file and create multiple columns from a single column. i'm attaching explanation. I need this either in power query, pandas or regex python. for speed purposes. will pay $30 thank you,

I am looking for a freelancer to help me add pagination to the homepage of my WordPress Colibri WP child theme. Specifically, I need pagination for the homepage only and I require that it includes tags but not custom post types. Additionally, it must work with a specific search query. If you think that you can help me with this project please let me know. Thank you!

Hello, I have a Snowflake database, which has 3 columns, Column 1 is a unique identifier and Column 2 and 3 are start and end date for leave. I want a new column based on following condition: IF ACTUAL_LEAVE_START_DATE is not null Count the number of days between 2023-05-11 - 2023-06-01 for ACTUAL_LEAVE_START_DATE and ACTUAL_LEAVE_START_DATE if n...2023-06-01 for ACTUAL_LEAVE_START_DATE and ACTUAL_LEAVE_START_DATE if not null. For example if ACTUAL_LEAVE_START_DATE = 2023-05-15 ACTUAL_LEAVE_START_DATE = 2023-05-29 The the days between would be 14 days Similarly if, ACTUAL_LEAVE_START_DATE = 2023-04-15 ACTUAL_LEAVE_START_DATE = 2023-06-1 The the days between would be 21 days Needs to be done ASAP, I will share the data for the table with you in excel and I want the que...

Homepage: List all available Pokemon with pagination (20 Pokemon per page). Display each Pokemon's image, number, name, and types. Refer to number, name, and types. Refer to for layout inspiration. Statically render the first three paginated pages at build time. Render the remaining pages in real-time. Pokemon detail page: Display name, image, height, weight, classification, type, weakness, and resistance of the Pokemon. Include a button to open a popup showing the Pokemon's evolutions. Query evolution data only when the button is clicked, not beforehand. Refer to for an example of a Pokemon detail page. Statically render the detail pages for the first 20 Pokemon at build time.

Hello, I have a VPS where plesk stopped working and it's urgent to be fixed. This is the error: DB query failed: SQLSTATE[HY000] [2002] No such file or directory Please help urgently.

...network link analysis solutions using JanusGraph database. • Conduct analysis of large data sets to identify relationships and patterns. • Work closely with stakeholders to define requirements and develop custom solutions. • Develop and maintain data models, schema, and taxonomy for the JanusGraph database. • Implement data visualization tools to represent analysis results. • Develop and maintain documentation for design, development, and implementation of solutions. • Provide technical expertise and guidance to team members and stakeholders. • Strong knowledge of graph database concepts and JanusGraph architecture. • Strong experience with data modeling, schema design, and query optimization. • Experience...

Hi i need one row htaccess query. i changed my website but it cant find files: old url (files will be found): new url, cant found: So i want just edit htaccess file so it shows pictures (.jpg) from old url. my budged $10

...DPC level) Your submission should include: a. A taking off list b. Marked up drawings c. A query and answer sheet d. Measurement in the traditional dimension paper (approximately 800 words equivalent) Specification 600mm wide x 1500mm deep C20 mass concrete foundation footing. Taken down to 2.2m below structural floor level. Walls below ground 100mm semi engineering brick outer leaf. 100mm standard dense concrete block inner leaf bedded in 1:3 cement mortar. A bill of quantities is not required. Assume the construction of the walls below ground is the same all the way around the building The project in Scenario 1 has now moved on to the post contract stage. The Client decided to use BIM on the project for a number of reasons: - The design team is made up of arc...

I need help solving a slow MySQL query issue and creating a new multi-column database index for a large database table. The database structure I'm currently using is MySQL, I do have an existing database index for this table, but it needs to be improved. The size of the database table is between 1GB and 3GB. I'm looking for a reliable Freelancer who has experience in database optimization and can promptly address this issue.

I am looking for a freelancer to create a social media post for me. This project involves creating an image post using a combination of both my own supplied images and also creating images. The post should not exceed 140 characters. This is a one-time project with an expected completion timeline of 1 - 3 business days. I look forward to working with the ideal freelancer. i need somting like this for my restaurant : https://www.freepik.com/free-psd/food-menu-restaurant-social-media-banner-template_31598573.htm#query=post%20media%20social%20food%20chiken&position=24&from_view=search&track=ais

...building and maintaining data streaming jobs using Amazon Kinesis Desired experience in working with database technologies and data development such as Python, PLSQL, etc. Solid understanding of writing test cases to ensure data quality, reliability, and high level of confidence. Track record of advancing new technologies to improve data quality and reliability. Continuously improve quality, efficiency, and scalability of data pipelines Knowledge of working with queries/applications, including performance tuning, utilizing indexes, and materialized views to improve query performance. Identify necessary business rules for extracting data along with functional or technical risks related to data sources (e.g., data latency, fr...

From the given training data, our goal is to learn a function that can predict the wine quality rating of a wine sample, based on the objective features. the predictor function will be constructed as a k-d tree. Since the attributes (objective features) are continuously valued, you shall apply the k-d tree algorithm for continuous data, as outlined in Algorithms 1. Once the tree is constructed, you will search the tree to find the 1-nearest neighbour of a query point and label the query point more details will be provided

I need help creating an Excel Database to store my data and query it as needed. Additionally, I will need the database to be integrated with an existing system. Having expertise in VBA is a must, as it will make setting up the database much easier. I’m looking for someone who’s experienced with creating such databases, and who can integrate the data with my existing system. I need someone who can quickly deliver results, so being able to execute the project diligently and accurately is also essential. If you think you can help me with this, please reach out!

...month. Unused questions can be carried over to the next month An eCommerce payment portal needs to be linked. The user receives an invoice and receipt and a copy of the invoice comes to the company/ can be exported ad hoc. If you believe you can deliver this project to a high standard, please get in touch. The landing page contains backghround image, logo, logon/registration button, dialogue entry container with "ask" button, and text on initial landing that is overwritten with the answer text, and a link to a contact page to submit a query....

I am in need of someone to add basic custom coding functionality to my Wordpress site. I have specific functions in mind that need to be coded. The project does not require complex functionality, but instead requires basic coding skills. If you are an experienced coder and believe you can complete this project in a timely manner, I'd love to see your proposal. Thank you for your interest! The specific requirement is to be able to conditionally display a page based on a databases query that takes the value of a hidden field on a contact 7 form and if a match is returned then display page otherwise display another page. The site is hosted on GoDaddy

...“INSERT INTO…” statements or Oracle bulk load. To get some realistic data, my suggestion is to grab and process some data from the Facebook website. Although you may not be able to populate a table with lots of content, you are required to estimate the number of records for tables that you created. The absolute numbers are not as important as the relative sizes of the tables. This information is important for choosing indexing and query optimization. 4. Fourth phase: you will come up with 10 typical queries that you expect to run frequently on your database. A good place to start is to look at the search and browse sections of the Facebook website. You will need to write down the English question and its SQL statement for each query and run...

I have a Java application that makes it easier for me to query for and apply for new jobs on Indeed but it needs some debugging. It is dependent on my local configuration and the only way to run it is with screen-sharing. I want to do this daily at 3 p.m. My current time is UTC +5 and is accurate at this URL I want to do this with you every day without fail where the goal will be to use the tool or do the work manually to apply to at least 25 jobs where my qualifications match and where the employer has been flagged as "responsive". Indeed does a good job of saving my most currently uploaded resume in the system as well as some prior responses. You can debug as much as you want but we must reach our target of 25 applications as well. Considerable experience in Java a...

...the percentage of students who were retained in grade, by US state, grade in school (K-8), in four different years (2011-12, 2013-14, 2015-16, and 2017-18). So this is a straightforward but laborious data acquisition and merging task. Take a look at the instructions and data sources below before you place a bid that's realistic about the time required. The percentage of students who were retained in grade can be calculated by dividing (1) by (2) below: (1) The total number of students retained in each grade and state is available in the State and National Estimations tab of the Civil Rights Data Collection, at . This is probably the hardest part because it involves downloading a different spreadsheet for each state and year, and the formatting of the spreads...

I need an HTML front end for Chat GPTX that will enable a user to cut and paste text into a box then hit one of six buttons below to have Chat GPTX rewrite the copy in a specific style. The button should both choose the style and initiate the call the Chat GPTX's API So the front end will send a query to Chat GPTX in the form Rewrite this {Copy from Box} in the style of {Style associated with button} Those styles are: Disruptors: Elon Musk Masters of the Universe: Jeremy Clarkson Heart and Souls: A Jerry Seinfeld monologue Campaigners: Simon Sinek Visionaries: A TED talk pitch without mentioning TED or talking Chief Fun Officers: Russell Brand Please see attached PDF for a very rough idea of the layout

Project Overview 1.1. Objective To design and develop a Windows service that automates sending emails and updating SQL backend database. 1.2. Scope This project document outlines the requirements, architecture, design, implementation, and testing strategy for the Windows service. Requirements 2.1. Functional Requirements 2.1.1. Email Sending The service must be able to send emails using SMTP protocol. The service should be able to fetch email recipients, subject, and content from the SQL database. The service should be able to handle email attachments. The service should provide support for multiple email providers (e.g. Gmail, Outlook,yahoo, smartermail etc.). The service should support retry mechanism for failed email sending. 2.1.2. SQL Backend Update The service shou...

My project involves creating a Wordpress Search PlugIn that will search Content as well as post and pages. The PlugIn will be coded in Full-text search, with a level of customization of Basic. The PlugIn should allow users to easily search through blog content as well as pages and posts according to their desired query. Specifically, the PlugIn should offer basic features including easy navigation and search, filtering results according to post categories, and an autosuggestion search box. I am looking for someone who can develop this PlugIn quickly and efficiently. The ideal candidate should have solid experience in developing PlugIns in Wordpress, particularly in regards to creating full-text search and basic customizations. If this unique project interests you, pl...

columns - Jan2034, Apr2034, Jul2034, Oct2034, Jan2035, Apr2035, Jul2035, Oct2035, Jan2036, Apr2036, Jul2036, Oct2036 table path - -- write simple sql query ---- targetallocation(column) is the first non zero value and the corresponding month/yyyy is the 1stmonthyyyy as starteff(column) and the same ending value giving row is endeff(column) and if the value changes then (target allocation(column) is the first non zero value and the corresponding month/yyyy is the 1stmonthyyyy as starteff(column) and the endeff is the day if it ends in Janyyyy then 31marchyyyy , Aprilyyyy then 30 june yyyy , Julyyyy then 30septemberyyy, octyyyy then 31decyyy)

I am looking for an experienced freelancer to help me with a dynamic 365 FinOps - SQL query project. Specifically, I need a data retrieval SQL query link to excel file. The query must be able to access invoice data. I have fairly complex needs and require someone with a great deal of experience in writing efficient and secure queries. I need someone who understands data structures, relational databases and how to best design them. Familiarity/experience with Dynamics 365 is a must. If you think you are capable of completing this project and meeting all my requirements, please do not hesitate to contact me. I look forward to working with you.

I need help with Crystal Reports 8.5 and Visual Basic 6. Specifically, I am looking for troubleshooting errors remotely or online. I need this help as soon as possible. A financial application was don...need this help as soon as possible. A financial application was done using Visual Basic 6 with Crystal Reports. It has 47 reports done in Crystal Reports 8.5 that reference ttx files. I am upgrading the application to C# but the reports are an issue. Because the reports reference txt files all the fields are defined there and I cannot determine what tables they reference and exactly what SQL query is used. The database is an Access database. I need someone to examine the application code and extract the queries and create views for all the reports which I can then use in my C# ap...

Edit Code like this: Website: After Login: "Call to undefined function mysql_query()" The website runs on Joomla.

I have the database below set up in SQL. I would like a query that calculates the liquidation fee when a user decides to liquidate some of their total investment. If the amount the user wants to liquidate requires liquidating more than one of their investments, the oldest ones should be sold first and the fee is 8% of the investment minus 1% for each full year old the investment is with a minimum fee of 0%. For example, an investment made 9 years ago would have a 0% liquidation fee and an investment made just over three years ago would have a liquidation fee of 5%. I want to know the total liquidation fee for the amount that the user wishes to sell. In this case, the user with a userid of 1234567 wants to liquidate $238 of their investment in the property called Links. After liquida...

I'm in need of an experienced PHP expert to handle an ongoing process for my project. I require someone experienced in development for off-site work, and who understands the ins and outs of databases and related frameworks. In particular, I need someone well-versed in PHP 7. Some level of flexibility would also be appreciated. If you are an experienced and reliable PHP developer, please consider applying for this project. task description : we have an online game , that stores players tasks in id , with every page refresh we execute a query thats job is get the tasks with execution time = now . after that , we will create some kind o locker on db in order to forbid processing same task twice ,if locker created successfully , then we must go to processes functi...

...get_page_by_title() (previously declared in /home/flyprinc1/public_html/wp-includes/) in /home/flyprinc1/public_html/wp-includes/ on line 4557 Notice: Function is_embed was called incorrectly. Conditional query tags do not work before the query is run. Before then, they always return false. Please see Debugging in WordPress for more information. (This message was added in version 3.1.0.) in /home/flyprinc1/public_html/wp-includes/ on line 5865 Notice: Function is_search was called incorrectly. Conditional query tags do not work before the query is run. Before then, they always return false. Please see Debugging in WordPress for more information. (This message was added in version 3.1.0.) in /home/flyprinc1/public_html/wp-includes/ on line 5865 There

Edit Code like this: Website: After Login: "Call to undefined function mysql_query()" The website runs on Joomla.

...databases to Postgres. Here are the steps we took: Analyzed the existing MySQL databases to identify any issues or constraints that might affect the migration process. Created a detailed migration plan that included steps for transferring data, recreating tables and indexes, and testing the new Postgres databases. Worked closely with developers to ensure that any application-level changes required for the migration were made in a timely manner. Used specialized migration tools and scripts to transfer data from MySQL to Postgres, and then manually verified that the data was transferred accurately and completely. Recreated tables and indexes in Postgres, and then tested the new databases to ensure that they were functioning correctly. Provided training and support to...

...mobile app developer to create an engaging consumer-facing mobile app for me. The app must be built for Android devices, but I'm also interested in hearing about options for scaling the project to include iOS support. Furthermore, I want UI/UX design services, as my project calls for a unique and user-friendly design. Basic Specifications as below: 1 Multi Language (Initially 3 (English, Gujarati, Hindi) 2 Map Integration 3 Route dislay on map 4 Camera Integration 5 Share feature 6 Dynamic Data feeding/Update/Notification from Server 7 Integration with Server 8 Form Filling 9 Message integration 10 Data query and response with server to update dynamic input and display information 11 Total Main 14-16 Screen 12 Approx. 4-6 sub screen 13 Advertise...

I am offering an opportunity to work on a fascinating conservation biology project. Develop a list of search terms that can be used to generate a query in Web of Science that will capture as many publications as possible relevant to the concepts included in your conservation question. Create a table that includes the main concepts of your question and the associated query generated from the list of search terms. Using the PRISMA guidelines create a diagram that transparently demonstrates how studies were assigned (as above) and were removed or included in the meta-analysis. At minimum, please demonstrate how you handled 200 papers.

...must. This person needs to be highly experienced, knowledgeable and reliable when it comes to database development. The successful candidate must also need to have strong technical expertise and problem-solving skills. The developer should have knowledge of database management system concepts, implementation and usage as well as data flow and storage techniques. The successful candidate will be able to identify and resolve issues related to database functions, query optimization, indexing and dealing with database constraints. The developer should have at least 5 years of experience in developing software applications and have in-depth knowledge of current technologies and their uses in the development of enterprise scale databases. The candidate should be able to develo...

Query 1: Produce a report on Adult's shoes performance for the date range 26th-30th. (Revenue, Transactions, Clicks, Cost Impressions, Cost/Click) Query 2: Identify the top 5 products by revenue for each gender. (male, female, unisex) Using WITH, SELECT, INSERT, INNER JOIN, ORDER BY, AS, ASC PD: There is not access to database, only from Excel sheet. Solution in Excel is already done

Hi Guys.. I’m a dev and need to outsource a part of a larger project. Currently, we get prices from an API, but we want to create a distributed price aggregation network which will allow for a distributed set of nodes to connect to different APIs and keep a distributed median price db using Gun JS (), a distributed graph database. - We want to Monitor 35 pairs. Full list will be provided. -To monitor the APIs and insert records into the Gun JS database, we'll create a a node service that utilise Gun JS. This node js service will fetch data from APIs and insert records into the Gun JS database at the 0.5-second interval. - To ensure the correct price is selected in cases of discrepancies, we'll use a median consensus mechanism by modifying the core funct...

...script which will query an Arbitrum chain wallet balance. The script should be written in Python, and capable of running on Mac OS. The script will take parameters such as private key, and return the cryptocurrency wallet balance associated with that account. The returned data should be reliable, accurate and up-to-date. the format of the result should: Private key :: Balance in ETH: Balance in USD :: Wallet address The script should also be well coded with best framework and easy to customize and modify, should the need arise. Attached you can find a sample script which shows almost everything that needs to be done, your task is to write a better and working script. ( sample private keys are included in comments on same script) If you think you are qualified for thi...

The job involves analyzing and providing feedback on text, web pages, images, and other types of information for leading search engines, using an online tool. Raters log on to the online tool to select tasks to do on a self-directed schedule. A Rater reviews the results returned in a specific search query and rates them in terms of relevance The platform is open 24/7, we need a full-time worker. Please review the guidelines attached and let us know if you have worked with them.