Paql queryproiecte
I have a node.js project and have many sql query to load data on first load. the loading time is slow for first load. I need someone who is experienced to help to optimise the first load speed.
I need an experienced Power BI expert to assist me with my project. The main goal of the project is data visualization, and the data source is a SQL database. Specifically, I require help with Query and Group by functions. The ideal candidate should possess the following skills and experience: - Advanced level of experience with Power BI - Proficient in SQL and Query functions - Ability to create effective data visualizations - Strong communication skills to discuss project details and requirements If you have experience with similar projects and possess the skills outlined above, please don't hesitate to contact me for further discussion.
I need someone with experience in POSTGIS to help me fix invalid geometries. I have a query that is giving an error: select (st_area(st_union(st_intersection(, ))::geography)) as cov_area, zip from a, b where st_intersects(,) group by zip ERROR: GEOIntersects: TopologyException: side location conflict at -x, y. This can occur if the input geometry is invalid.
I am looking for an experienced Oracle SQL script writer to assist me with a project. The primary purpose of the SQL script is data retrieval, and the complexity of the query required is intermediate, including JOINs and subqueries. I have a specific schema that I would like to work with. Please find the attached case document. Ideal skills and experience for this job include: - Expertise in Oracle SQL scripting - Familiarity with data retrieval and intermediate query complexity - Experience working with specific database schemas - Ability to write efficient and optimized SQL code - Strong attention to detail and ability to troubleshoot and debug code - Excellent communication and collaboration skills to work effectively with me throughout the project.
Temos dezenas de mapas financeiros e de indicadores feitos em MS Excel usando power query e power BI com SQL e ODBC´s e precisamos de contratar por uns dias por mês um Analista de dados que consiga gerir e criar novos preferencialmente que resida na zona de Leiria ou Arredores.
I need a Codeigniter developer to make changes to an existing project. To implement a new feature into the existing codebase. The project already has all the necessary code, so the developer wouldn't need to start from scratch. Attached `` : We need to run select query and use some data in insert. You can expect 1 hour work for this, which we will explain. Attached `` , from which, you can understand that we have already working Excel import feature. Now we need 1 more radio button for New format of excel import Attached : Excel will have same data, we have to verify if that data does Not, we have to insert (if data exist, do Nothing) Attached `` : 1) We have to hide checkbox in Note column. 2) We have to hide Responsible
I am looking for a DAX Query and Consultant to help me finish my Power BI view. I am an intermediate user of Power BI and DAX. My project has an urgent, I mean its just a few calculation based on the table IF anyone is available to work now . I have a detailed list of specific requirements for the DAX query. The ideal candidate for this job should have experience with Power BI and DAX at an advanced level. They should also have experience with creating DAX queries and providing consultation. If you have the skills and experience required for this job, please contact me.
Hi there I have a pivot table that pulls information from a database. it displays day and month as values for each row. Now I want to be able to pull up year as well. This is the query right now SELECT`nombre`,`apellido`,`apellido2` ,`dia`,`mes` FROM `visitas` I would like to add: SELECT`nombre`,`apellido`,`apellido2` ,`dia`,`mes` , `ano` FROM `visitas`
I am looking for a skilled developer who can work with Microsoft SQL Server to create a query that select multiple columns from multiple tables.
I am looking for a freelancer who can help me create a MySQL query for data retrieval. The ideal candidate should have experience and skills in MySQL and query creation. The project involves the following: -to Remove such Characters from ID For an example ID = IG.1234567-1, ID = IG.1234567-1-BC in this example there is a -BC at last so dont consider -BC ID and -1-BC iD bcoz -BC is billing canceled like that - And Also Helps in SQL join As well Query If you have experience in MySQL and query creation, please apply for this project.
I am looking for a freelancer to help me with creating a PowerBi dashboard. The dashboard will draw data from an MS Graph Query and display the information in a visual format. I want the dashboard to utilize visualisations such as bar graphs, pie charts, maps, and table formats. I expect the dashboard to be able to draw from multiple data sources such as Excel files, external databases, or API connections. I have an existing query that pulls all the groups from Azure and displays them in the slicer(As show in the attached pic). All I need is to show all the members in a table from the selected group. Since I am asking for an experienced professional, the ideal candidate must understand PowerBi capabilities, technical limitations, and any other topics related to the proje...
I need to update my logo, but I want to keep the existing colors and only change the name. The preferred file format for the revised logo is PNG. I don't need any additional design elements added. https://nl.freepik.com/premium-vector/mensen-familie-medische-zorg-logo-sjabloon_35215720.htm#query=wellness%20logo&position=16&from_view=keyword&track=ais Name must be Dushi Wellness Ideal skills and experience: - Graphic design experience - Proficiency in logo design and editing tools - Attention to detail - Ability to follow specific design requirements
I am looking for someone to conduct a Performance Test on how my Airbnb listing ranks in one country, using a desktop computer. The goal of this test is to determine how well the listing performs in terms of visibility and engagement. This test is intended to measure the components of the Airbnb algorithm such as relevance to the search query, availability, rate, and other user experience factors. The results of the test will be used to guide decisions on how to optimize my Airbnb listing results. This is a very simple project i am just looking for the top 20 airbnbs if one is searching as 1 ,2,3,4,5,6,7 people I am only interested in full apts or houses I am trying to understand if there is a diference depending of which country you are coming from.
For my project, I am looking for an experienced freelancer to help me create a simple and efficient database with query functionality. I need a database hosted in Excel or other software that allows for easy form entry. Query functionality is important to me, but I'm not sure what type of query I need - so advice in this area would be really appreciated. My criteria would be the Data Type, Number of Entries, and Date Range. This project is time sensitive, so having somebody experienced with databases and queries who can work efficiently and quickly is ideal. I need to create a database of vendors and subcontractors with the ability to search by different criteria with easy entry.
Generating text file for all the orders and invoices. when a product has warrant selected, the product listed 2 times. one with warranty and another one without warranty. 1. fix the duplicate lines of product when warranty selected 2. we want to take this file and have a separate controller, it should be called whenever we want for debugging purpose when we pass a increment id, in the query string, it should generate order and invoice file for that increment id alone
I am looking for a web development specialist to build a static website for me which will have the data from two existing database tables connected to it. Additionally, the website is intended to be hoste...skills of a web developer to configure the IIS server, design and program the website, and create the proper protection for the data. The website should be visually appealing and easy to use, while being built and maintained using web standards to ensure compatibility between devices. I have a current windows 10 computer running IIS, and have attached it to my sql server and i also have the sql query written out. exactly what i need is a basic blank webpage, with a place to enter an item #, and click submit, then it will fill out data into 2 fields for quanity on hand from my sq...
Hello I have managed to query Facebook Graph API and extract correct data, which is available at an ad_id level. Now my problem is that we have hundreds of ad_ids, due to which the API keeps reaching its rate limit. So I want someone who ALREADY HAS PAST EXPERIENCE of working with Facebook Batch Async API to send batch requests and get 100% correct data that I am after. Please do not bid if you DO NOT have past experience with sending batch requests to Facebook API.
Load the dataset into MongoDB. Then query the dataset using MongoQuery. Implement a Mongo/Flask API server for a dash frontend to visualise. dataset: 's%20Datasets/retails_data. P.s: you can suggest any dataset you would like.
After rebuilding my PC and installing a newer version of XAMPP (origin PHP version: 7.2.34 / new PHP version 8.2.4) several of my PHP programs no longer work. The attached files are for one of them. We need someone...received when running this program: Fatal error: Uncaught TypeError: mysqli_query(): Argument #1 ($mysql) must be of type mysqli, null given in C:xampphtdocsskokielabelspi_classes Stack trace: #0 C:xampphtdocsskokielabelspi_classes(20): mysqli_query(NULL, 'set global char...') #1 C:xampphtdocsskokielabelspi_classes(20): AbstractDB1->query('SELECT * FROM `...') #2 C:xampphtdocsskokielabels(194): user->item_list() #3 {main} thrown in C:xampphtdocsskokielabelspi_classes on line 20
Update existing web access to include a query for CAS # related data from seven tables.
I have a partially developed ms access project. I need to develop the function for sending emails of records contained in a form and automatically sending emails for expired records form a query
I am looking for someone to help with developing a custom Azure Devops Extension. Must be familiar with the Azure Devops SDK, Azure Devops Api, React / Typescript, REST API. This project will have several phases. The first phase is: 1) Creating a Hub Group 2) Adding a Hub 3) Adding the Query UI from SDk to that user can run queries.
Hello I have managed to query Facebook Graph API and extract correct data, which is available at an adid level. Now my problem is that we have hundreds of ad_ids, due to which the API keeps reaching its rate limit. So I want someone who ALREADY HAS PAST EXPERIENCE of working with Facebook Batch Async API to send batch requests and get me 100% correct data that I am after. Please do not bid if you DO NOT have past experience with sending batch requests to Facebook API.
...for location selection Home screen: Shows the user the current beach conditions and whether it's a good day for going to the beach, along with a user-friendly scale ranging from "Excellent" to "Poor." Also displays the sunrise and sunset times for the current day. Includes a search bar for finding specific beaches. Beach search results: Displays a list of beaches that match the user's search query. Each beach listing includes a photo, name, rating, and distance from the user's current location. Beach details: Shows detailed information about a specific beach, including parking availability, beach amenities, and water quality. Includes a map view and directions to the beach. 7-day forecast: Displays a week-long forecast with recommendations o...
...furniture and outdoor furniture and furnishings in the United States. The ideal candidate 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
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
...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 information into succinct reports, presentations and documents to convey complex topics in an easy-to-understand manner is essential. If you think y...
...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 data, firing actions with a button, previewing and publishing the application. To recap, I am in need of a qualified professional who is available to provide 5 hours of one-on-one help immediately, on US time zones, with excellent English language skills,...
I am 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 practices for data...
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 ...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...
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.
...allows my users to send a limited number of queries via an API call to GPT-3.5 based on a monthly package they select. For example, 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&rd...
...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. :1681386173284&source=hp&ei=veo3ZJWOD4GxoASWu7GwBA&iflsig=AOEireoAAAAAZDf4zWReEune2IBJx2S__TgbTvlV_F6K&uact=5&oq=devops+jobs+in+india&gs_lcp=Cgdnd3Mtd2l6EAMyBQgAEIAEMgUIABCABDIGCAAQFhAeMgYIABAWEB4yBggAEBYQHjIGCAAQFhAeMgYIABAWEB4yBggAEBYQHjIGCAAQFhAeMgYIABAWEB46B
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,
Requiero una persona que me de un entrenamiento sencillo y practico de dos horas sobre Power Query, alistando datos para conectar y subir los datos a Power BI. La idea es organizar aprender a organizar los datos bien para que al subirlos a Power BI, todo esté okey
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 not null. For e...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 query ...
Homepage: List all available Pokemon with pagination (20 Pokemon per page). Display each Pokemon's image, number, name, and types. Refer to https://www.po...Pokemon's image, 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.
Keywords: Sigma Js, D3, Network link analysis, Graphocal Network analysis Please check above keywords to match your profile. We are seeking an experienced and motivated Network Link Analysis D...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 in data visualization tools and libraries such as D3.js or Cytoscape. • Excellent problem-solving and analytical skills. Intereste...
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
...details. List of items to be measured: • Topsoil excavation • Topsoil retention • Reduced level excavation • Disposal of excavated material • External trench excavation • Disposal of excavated material • Concrete in trench foundation • Brickwork below DPC (up to DPC level) • Blockwork below DPC (up to 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 bed...
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....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_vie...
...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, frequency, etc.) Develop initial queries for profiling data, validating analysis, testing assumptions, driving data quality assessment specifications, and define a path to deployment. Familiar with best practices for data ingesti...