I am looking for a Power BI expert who can assist me with specific tasks in Power BI. The ideal candidate should have experience in the following areas: - Data modeling and visualization - Power Query and data transformation - DAX calculations and measures I have a specific dataset that I will be working with in Power BI. Therefore, the candidate should be familiar with connecting and working with datasets in Power BI. This project has an urgent timeline of 1-3 days, so the candidate must be able to work quickly and efficiently. If you have the skills and experience required for this project, please submit your proposal.
...THIS IS NOT THE PROJECT FOR YOU. I am looking for a freelancer who can add line graphs to my excel sheet. The data is simple and I have specific data fields that I want to be included in the graphs. My example graphs are on the Graphs tab. Data to be added is in column A in Graph Data Tab starting in row 79. I have already produced row 79 and row 80 graphs. Macro must stop at space below (row 260) and process only visible rows. Macro must be able to start where I put my cursor in column A. I have another section to process and these graphs will be in the next space to the right of previous graphs as shown in the example I have multiple sections to add which are not on this spreadsheet. I need the code to process this new data which is not shown in this worksheet. ...
I am looking for a Power BI and Power Query analysis and design expert who can help me with both data visualization and data transformation. I already have the dataset for the analysis, so no need to source it. The level of complexity required for the analysis is advanced, involving complex data manipulation and predictive analytics. Skills and Experience: - Proficiency in Power BI and Power Query - Strong knowledge of data visualization techniques - Experience in data transformation and manipulation - Familiarity with predictive analytics - Ability to work with complex datasets - Attention to detail and accuracy in analysis
I need help in Ms Access and Excel. Where in excel need some help with power query. Will discuss the detail over chat.
I'm looking for an experienced SEO specialist to help improve my website's ranking using localized strategies. I have a general idea of the keywords I'd like to target, and...localized strategies. I have a general idea of the keywords I'd like to target, and my main objective is to boost my website's ranking in search engine results. The right freelancer should have a comprehensive understanding of local search engine optimization tactics and strategies, and be able to bring measurable results to the organization. This position may require knowledge of Google's algorithm refreshes such as Google Penguin or Buzz. If you think you have the necessary skills and experience, I look forward to hearing from you and learning more about the strategies you can ap...
I am looking for a skilled freelancer to create an interlinked Google Spreadsheet Macro software for me. The main requirements for this project are data entry, sharing and collaboration, as well as high level security measures with multi-factor authentication. Specific features needed for this software include: - Data sharing capabilities to allow multiple users to access and collaborate on the spreadsheet - The ability to input and calculate data within the spreadsheet - Data visualization and charting capabilities to present the data in a visually appealing way Additionally, I already have some data that needs to be integrated into the software, with the intention of adding more data later on. In terms of security and privacy, I require high level security measures with multi...
...werden 10 neue Dateien erstellt) - die neuen Dateien in einem anderen sftp hochladen Dieser Prozess sollte stündlich passieren. Wer kann mir dabei helfen? _________________________________________________________________________________________________ Hello I have a small project. The following steps are to be carried out automatically. - downloaded from sftp - updated an excel tap - start a macro (this will create 10 new files) - upload the new files in another sftp This process should happen every hour. Who can help me with this? ...
Project Title: VBA Macro modification Description: I am looking for a skilled VBA developer to modify Macro 1 within a tight deadline of 24 hours. The specific modification required is to add new features to the existing macro. Skills and Experience: The ideal candidate for this project should have: - Strong proficiency in VBA development - Extensive experience in modifying VBA macros - Ability to understand and work with existing code - Attention to detail to ensure seamless integration of new features - Ability to work under pressure and deliver within a strict deadline
...french verbs - a user should log in - there are four kind of users : admin, teacher, student, free user - a teacher can create groups, manage some students in a group, make personal lists. - a student can be independent or join a teacher-group A student: - a page on which he can select some parameters to generate excercices (+/- 20 parms) These parameters are just parms for the "select query" of the verb database (provided) - a student can save sets (= list of his preferred verbs), These sets are one of the selectable parameters (eg. "difficult verbs", "verbs for test", ...) A teacher: - a teacher can save sets (= list of his preferred verbs) eg. "verbs for first grade", "verbs the must know", ... - a teacher...
Hola, busco un proceso automatizado para realizar unos procesos, no busco una persona para que lo haga a mano, si no un programa, macro, aplicación, etc. tengo documentos ppt, los cuales tienen diapositivas con información. ejemplo: Diapositiva 1, tiene los siguientes textos: Cuadro de texto 1: Partes de un coche Diapositiva 2, tiene los siguientes textos: Cuadro de texto 1: Ruedas Diapositiva 3, tiene los siguientes textos: Cuadro de texto 1: Ruedas. (aquí hay un intro) Volante Diapositiva 4, tiene los siguientes textos: Cuadro de texto 1: Ruedas (aquí hay un intro) Volante Cuadro de texto 2: Luces D...
We're looking for an experienced Laravel developer to create a web-based application. The system should include functionalities like table views, search filters, user authentication, and CSV import capabilities. Requirements: 1. User Interface - Design a UI based on a provided layout - Resemble an existing structure for easy user adoption 2. Table Views and Form View - Implement a table view to display database records - Implement a form view to display individual records 3. Search and Filter Functionality - Global search bar to query across all data - Column-specific filters for more refined searching 4. User Authentication - Implement basic user authentication - Minimum of two user roles with variable permissions (read-only, admin) 5. CSV Import Functionality - I...
I am looking for a skilled PHP developer to modify my current Panel/Dashboard for Teamspeak 3. The project requires both design changes and functionality improvements. Specific Requirements: - The modifications should focus on adding changing features. - I have specific instructions for the design changes and would like the developer to follow them. - In addition to design changes, there should also be improvements in functionality to enhance the overall user experience. - The ideal candidate should have experience in PHP framework and Teamspeak 3 to effectively make the necessary modifications. - Attention to detail and the ability to understand and implement specific instructions are crucial for this project.
I am looking for a skilled developer to create a web platform that can scan QR codes. The platform should have the following features: - QR code scanning capability - User authentication - User Registration - Coupon Code Entering and validating - User Roles Dashboards Ideal skills and experience for this job: - Proficiency in web development languages such as HTML, CSS, and JavaScript - Experience with QR code scanning libraries or APIs - Familiarity with database management systems and query languages - Knowledge of user authentication methods and frameworks Please note that the design of the platform should be customizable to allow for a unique and user-friendly interface. Additionally, the ability to analyze and extract data from the scanned QR codes would be a ...
I am looking for a freelancer who can create a macro-enabled Excel sheet for me. The specific functionalities I need in the sheet include data analysis and reporting. I have complete data that needs to be incorporated into the Excel sheet. The complexity of the data analysis required is basic, involving sums and averages. The ideal freelancer for this project should have experience in Excel macros and be skilled in data analysis and reporting. They should also have knowledge of basic Excel functions such as sums and averages.
A website that allows users to query their own PDF documents through a chat interface. The system will use a PostgreSQL database with PGVector and the 'text-embedding-ada-002' model for text embeddings, and Langchain for retrieval augmented generation (RAG).
As can be seen from my website, I have both Products and Banners as Advertisement already in place for product details page and Search results page. They are appearing there based on some settings. Now I want those Banners appear based on product being viewed or on Search query so, if someone searched for "Banana" in fruit category, then Fruit category Ads Banner/s may appear in paid order. Also, if someone wants to promote a product "ABCX perfume bottle" and pay for the Ad, and then if a visitor searched for anything in perfume category, then this ABCX perfume will appear on top of the search results page as a promotional product Likewise, someone selling BBBX brand shirt and if someone searched for shirt, then this BBBX Brand Shirt will be on top, etc Also...
I am looking for a freelancer to create an Excel file with a macro that will primarily focus on formatting and organizing data. Specific tasks for the macro include: - Automating data entry - Performing data analysis and calculations - Ensuring proper formatting and organization of data The macro will be operating with an existing data set provided by me. I would like the macro to be triggered by clicking a button within the Excel file.
Project Title: MSSQL query to get tabular format of an employee organizational chart tables Description: I am looking for a skilled MSSQL developer to create a query that will generate a tabular format of our employee organizational chart tables. The data structure is hierarchical, and all fields are important for the query. Skills and Experience: - Proficiency in MSSQL and understanding of hierarchical data structures - Ability to create optimized queries for large data sets - Familiarity with employee organizational chart tables and their relationships - Strong attention to detail to ensure all fields are included in the query
...experienced Freelancer to create a fraud detection system for me using Neo4j. This system will be used to detect fraudulent transactions and provide accurate predictions for risk management. WORK: Select a credit card dataset and detect fraud rings using cypher query language. Then with the same dataset, choose 3 or 4 graph algorithms and compare the accuracy of these graph algorithms in Neo4j. Algorithm which is giving more accuracy, predict fraudulent transactions with this algorithm. Milestones: 1) Detecting fraud rings using Cypher query language 2) choose 3 or 4 graph algorithms and compare the accuracies in Neo4j. Predict fraudulent transactions using graph algorithm giving highest accuracies NOTE: Prediction should be done in Neo4j itself and for both milestones...
...freelancer who can provide daily job support in PHP coding, SQL database management, and AngularJS development. Tasks: - Provide support in PHP coding, including troubleshooting and debugging - Assist in SQL database management, including query optimization and data manipulation - Support in AngularJS development, including front-end development and integration with backend systems Requirements: - Strong proficiency in PHP, SQL, and AngularJS - Experience in building and maintaining web applications - Knowledge of best practices in database management and query optimization - Familiarity with front-end development principles and frameworks Daily Support: - I anticipate requiring 3-4 hours of support daily - Support can be provided in real-time or asynchronousl...
...freelancer who can provide daily job support in PHP coding, SQL database management, and AngularJS development. Tasks: - Provide support in PHP coding, including troubleshooting and debugging - Assist in SQL database management, including query optimization and data manipulation - Support in AngularJS development, including front-end development and integration with backend systems Requirements: - Strong proficiency in PHP, SQL, and AngularJS - Experience in building and maintaining web applications - Knowledge of best practices in database management and query optimization - Familiarity with front-end development principles and frameworks Daily Support: - I anticipate requiring 3-4 hours of support daily - Support can be provided in real-time or asynchronous...
I need a skilled VBA macro developer to help me generate reports quickly and efficiently. The macro should integrate with Excel and be able to be completed within the next 24 hours. I need this done quickly so that I can get important information quickly and accurately, and without having to do the same repetitive task over and over again. Someone with experience in data analysis and manipulation, and automation of repetitive tasks, as well as Excel integration would be ideal. I am looking for someone who can take the raw unprocessed data and quickly and accurately turn it into meaningful information.
I am looking for SEO ex...keyword research and optimization techniques. - Familiarity with search engine algorithms and best practices. - Strong analytical skills to track and measure the effectiveness of SEO strategies. - Excellent communication and collaboration skills to work with the client and other team members. -Crawl accessibility so engines can read my website -Compelling content that answers the searcher’s query -Keyword optimized to attract searchers & engines -Great user experience including a fast load speed -Share-worthy content that earns links, citations, and amplification -Title, URL, & description to draw high click-through-rate (CTR) in the rankings -Snippet/schema markup to stand out in SERPs -Optimizing my website to help search engines better u...
I need a webservice to query a SQL database (database is to manage license expiration) to retrieve licenses that are 30 days away from expiring. It will take that entire row with (data included such as first name last name license number and expiration date) and send that in an email to a single email (distribution group).
...reaching out because I'm facing a critical issue with my OpenCart 3.0.2.0 website, which uses the Journal Theme 3.1.4. This issue is causing me to lose clients as my website is experiencing slow load times, exceeding 30 seconds, and frequently displaying an error 500. Upon investigation, I've identified that the problem seems to be related to a specific database query that's impacting the overall performance of the site. Here is the SQL query that's causing the problem: PHP Fatal error: Uncaught Exception: Error: MySQL server has gone away<br />Error No: 2006<br /> SELECT p.product_id, ( SELECT AVG(rating) total FROM `oc_review` r1 WHERE r1.product_id = p.product_id AND = '1' GR...
Project Title: MSSQL query to get tabular format of an employee organizational chart tables Description: I am looking for a skilled MSSQL developer to create a query that will generate a tabular format of our employee organizational chart tables. The data structure is hierarchical, and all fields are important for the query. Skills and Experience: - Proficiency in MSSQL and understanding of hierarchical data structures - Ability to create optimized queries for large data sets - Familiarity with employee organizational chart tables and their relationships - Strong attention to detail to ensure all fields are included in the query
Project Title: MSSQL query to get tabular format of an employee organizational chart tables Description: I am looking for a skilled MSSQL developer to create a query that will generate a tabular format of our employee organizational chart tables. The data structure is hierarchical, and all fields are important for the query. Skills and Experience: - Proficiency in MSSQL and understanding of hierarchical data structures - Ability to create optimized queries for large data sets - Familiarity with employee organizational chart tables and their relationships - Strong attention to detail to ensure all fields are included in the query
I am looking for a Python developer with experience in Selenium and Spyder to create code to automatically query a website without detection (). No agencies
Project Title: Oracle BIP Reporting Setup I am looking for a freelancer to assist me with setting up Oracle BIP reporting. The ideal candidate should have experience in Oracle BIP reporting. Requirements: - Expertise in Oracle BIP reporting - Expertise in writing oracle sql query to support BIP work Responsibilities: - Collaborate with me to understand the specific requirements and objectives of the reports Specific Layout or Format: - I have a specific layout or format in mind for the reports If you are experienced in Oracle BIP reporting and have a strong background in SQL, I look forward to discussing the project further with you.
Project Title: Advanced SQL Query Optimization Description: I am looking for a skilled SQL developer who can assist me with an advanced SQL query in MySQL. Specific Database Management System: MySQL Complexity Level: Advanced Optimization: The need for optimization is uncertain at this stage. Requirements: - Strong proficiency in MySQL and database management systems - Expertise in writing complex SQL queries - Familiarity with query optimization techniques - Ability to analyze query performance and suggest improvements - Experience in troubleshooting and debugging SQL code - Attention to detail and ability to deliver accurate results Ideal Skills and Experience: - Proven track record of successfully handling complex SQL queries in MySQL - In-depth knowle...
I’m looking to build an intelligent document search tool for lawyers. The tool needs to be able to intelligently identify the most relevant documents from among a large library of internal documents (MS Word and PDF documents) based on the user’s natural language search query. A user may, for example, wish to find a particular type of legal document containing a particular type of provision and might therefore search for “shareholder agreement with reverse shotgun clause”, and the search tool needs to be able to find any such documents.
Hello, I have a macro (attached) that almost does what I need, but a few improvements must be made before i can use it, exactly 3 improvements for now. EXPLANATION OF HOW IT WORKS AND WHY: The idea behind this excel macro is to transform a "list of items in a table" into something my clients can make orders with, there are 4 sheets: 1º "Listado ( no modificable )" sheet: It is the table with all the items available to sell. Always same columns. 2º "Run Macro" sheet: it is a sheet with only a button to trigger the macro. 3º "Realizar pedido" Sheet is a sheet that is created when the macro runs. Here is where my clients can type how many units they want. They indicate so typing how many units they ...
I am looking for a Power BI and Power Query expert to develop various reports for my sales, purchase, inventory, customer, and supplier data. Reports Needed: - Sales Reports - Purchase Reports - Inventory Reports Specific Requirements: - I have specific requirements for the metrics and data that should be tracked in the reports. Data Source: - I have an existing data source that needs to be integrated into Power BI for the report development. Ideal Skills and Experience: - Proficiency in Power BI and report development - Strong understanding of sales, purchase, inventory, customer, and supplier data analysis - Ability to work with specific requirements and metrics - Experience in integrating existing data sources into Power BI Please provide examples of previous Power BI repor...
I am looking for an experienced freelancer to update the macros I have set up in Office 2003 for my existing business. I need someone to update all of my macros to the newest version of Office 2021. This job requires someone who is experienced in working with Microsoft Office, both older versions and more recent versions. The project must be completed to the highest level of accuracy and efficiency to ensure that my business can continue to grow and succeed. I have confidence in the freelance community and I am looking forward to receiving your proposals! Please let me know if you have any questions. Thank you for your attention and I look forward to hearing from you soon.
I am looking for a freelancer who can create a Process flow Diagram in Visio for a complex process with many steps. I am open to suggestions regarding the format and style of the diagram. The process flow will be a process to generate a final report. i) A query is run to generate a file from Database. I will send the query so you can understand what is happening. ii) When query runs and a file is generated then there involves different steps like manual steps, communicate with stakeholders, update few tables in DB and so on. I will share the details as well. iii) After all these steps are done then file is sent for validation then we are done with the file. iv) Last step is to update couple of tables mannually in a folder based on the communication happened. I did mak...
DO NOT APPLY UNLESS YOU MEET ALL MANDATORY CRITERIA. Excel and Power BI EXPERT required to write blog style tutorials. Must have the following mandatory skills: Advanced Excel skill including - Formulas (incl. Dynamic Arrays) - PivotTables - Conditional Formatting - Charts/dashboards Power Query Power Pivot Power BI Excellent written English Must provide evidence of Excel and Power BI work. ***Please do not apply if you cannot provide examples.*** Not mandatory, but will be a bonus: - VBA - Python - Tutorial writing/content writing experience - examples welcome. This is an ongoing role with weekly deliverables. Please only respond via Freelancer. Do not email or contact me via LinkedIn.
I am looking for a freelancer who can create a Process flow Diagram in Visio for a complex process with many steps. I am open to suggestions regarding the format and style of the diagram. The process flow will be a process to generate a final report. i) A query is run to generate a file from Database. I will send the query so you can understand what is happening. ii) When query runs and a file is generated then there involves different steps like manual steps, communicate with stakeholders, update few tables in DB and so on. I will share the details as well. iii) After all these steps are done then file is sent for validation then we are done with the file. iv) Last step is to update couple of tables mannually in a folder based on the communication happened. I d...
I am looking for a freelancer with BigQuery experience on GCP to assist me with my project. The ideal candidate should have the following skills and experience: Tasks: - Query optimization - Data modeling - Data visualization Specifics: - Build a POC on BigQuery to efficiently process data from GCS using Data Fusion Datasets: - I am open to any datasets for this project Timeline: - The expected timeline for this project is short-term, ranging from 1-4 weeks If you have experience in BigQuery and are able to optimize queries, model data, and visualize data, please submit your proposal.
Want to create Autocad Macro, that reads the drawing, and be able to know the connenctions between different elements and transfer the information to excel sheet.
...on square footage. I do have a domain name but will consider hosting to meet the need. However, what I do need is additional services for web and design - specifically CRM that will include user management (Admin, Client Residential, Client commercial, Employee), booking calendar for services and assign to a user that particular service, estimating, invoicing, payment acceptance, scheduling, auto texting prior to arrival, before and after pictures and videos, after-sales reviews and reminders, content creator and auto-update on social media once jobs are completed, an affiliate-loyalty program for returning customers, a chatbot to answer a query in real-time, FAQ page newsletter signup, blog and search engine optimization. I'm looking for an experienced freela...
I'm looking for an experienced web developer to create a comprehensive price comparison website. The website will primarily focus on healthcare and laboratory products. I will provide the list of suppliers to include in the price comparision, and I'm particularly interested in the implementation of an effective price history tracking feature. I am open to any constructive suggestions for additional features that may improve upon the user experience. The project should also be compatible with any necessary government requirements or regulations. 1. Data Collection: Collect data from various suppliers and manufacturers, including product details, prices, shipping costs, and any additional relevant information. Store this data in a structured database. 2. Data Normalizatio...
We are a startup in the food engineering industry, building a food product for animals consists of insects. Currently we are conducting a research on how insect-based feeding can be beneficial for certain needs (e.g. digestive problems, hypoallergenic etc.) of specific species (e.g. dogs, cats etc.) in comparison to other feeding options. W...to point our advantages and advise on marketing strategies. Our product development focuses on: The animal species on which the work should be focused are mainly companion animals such as dogs and cats. In addition, where possible, also farm animals such as chickens, laying hens, pigs and fishes. The nutrient criteria to be taken into consideration are carbohydrates, fats and crude proteins, macro and micro nutrients, vitamins, bioactive ...
...design. This two-way relationship between plant and people and plant and planet (so with the plant/assets at the centre of things) nicely encapsulates what we mean by “Sustainable by Design”. For a project to be considered “Sustainable by Design”, it must be designed to: Safeguard the HEALTH & SAFETY of workers and the public throughout full lifecycle. Protect the ENVIRONMENT at a micro and macro level in the short and long-term. Ensure SECURITY of the asset from physical and cyber threats. Achieve reliable operation to promote a just and resilient ECOMONY. Promote a fair and ethical SOCIETY. We want to articulate these contributing elements to “Sustainable by Design” through an infographic of a healthy tree where the 5 elemen...
I am looking for a MongoDB expert to help me create a new query for my collection. The current structure of the collection is an array of documents. Skills and Experience: - Strong knowledge of MongoDB and query optimization - Experience in creating complex queries for array of documents - Ability to work efficiently and deliver results within a tight deadline of 24 hours.
I have an app in django. It has a report system that show to each user stats or views. Then suddenly all query that should give back data to show o nthe graph are empty and i'm unable to debug where is the issue. The developer refuse to help me, so i have this bug to fix.
I am looking for a machine learning expert to help me with fine-tuning the 7B Llama 2 model on our domain-specific data. We want to optimize this model or reduce the weight, so I can run or process 10-20 query in a second with Nvidia T4 GPU 16 GB RAM. The current performance of the model on our data is average. I am specifically looking to achieve increased accuracy after the fine-tuning. Our domain-specific data has specific features that the model should pay more attention to. It's a High School project. Ideal skills and experience for this job include: - Strong background in machine learning and deep learning - Experience with fine-tuning pre-trained models - Ability to identify and extract specific features from the data and feed in model. - Knowledge of techniques to imp...
scripts are attached : fix is needed: fix requirement is attached This script runs through all multiple tenant workspaces & prints aws findings, activity alerts, security incidents etc. to excel. We need to all a column called "TenantId" to excel output - explanation is attached in text file
I am looking for an experienced Angular developer to fix a bug and implement a counter that auto refreshes for all users without exiting the page when a bid is placed with extra 5 minutes. Bug Fix: - The current bug is that the counter is not updating the extra 5 minutes correctly once new bid in inner item page. - Home page to be created a timer of count down and it should also when a bid is placed to increase extra 5 minutes. Counter Refresh: - The counter should refresh on every new bid. Timeline: - The bug needs to be fixed ASAP. Ideal Skills and Experience: - Strong proficiency in Angular - Experience with real-time updates and data synchronization - Knowledge of websockets and event-driven programming - Attention to detail and ability to troubleshoot and debug code efficie...
Law Review project - fixing our microsoft word macro that often crashes
Project Overview: We are seeking a skilled Excel VBA developer to create two VBA macros for automating tasks in our Excel workflow. The project consists of two main tasks: Auto-generate Invoices: We have an Excel workbook with a raw data sheet containing invoice details and an invoice template. We need a VBA macro that can generate multiple invoices at once, using a trigger number in a specific cell plus how many rows of data in a separate cell, and populate the template with relevant data from the raw data sheet. So for example, trigger number is 2356, and then number of rows to retrieve data is 10. this would generate 10 invoices numbered 2356-2365. Auto-send Invoices via Email: We want to automate the process of sending these generated invoices as PDF attachments to different e...
