How to use pivot for two columns in sql server jobs

I am in need of an expert Power BI developer who can help me integrate AI features into my existing project. Specifically, I'm looking to incorporate Natural Language Processing, Machine Learning Models, and Predictive Analytics functionalities. Key Requirements: - Proven experience in implementing AI features in Power BI is a must. - Strong background in Natural Language Processing, Machine Learning Models, and Predictive Analytics. - Proficient in working with SQL databases and Online APIs for data integration. - Ability to deliver a dashboard with basic filtering and sorting capabilities. Your main tasks will include: - Integrating the AI functionalities into the Power BI project. - Ensuring seamless communication bet...

More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Past work How soon do you need your project completed? ASAP

...moving from a slow reseller account to a VPS. No configuration necessary as keeping same domain name Current website is very slow and couldn't take a back up using updraftplus plugin I need all files and Database copying to new server and testing that it function OK I am in need of a specialist with broad experience in WordPress platform to move my website from its current location to a Virtual Private Server (VPS). Requirements: - Comprehensive knowledge of WordPress site architecture and components. - Extensive experience in website server migration, particularly to VPS hosting. - Ability to ensure that no data is lost during the migration process. - Skilled in backup creation and r...

Hey everyone, I'm on the hunt for a talented backend developer to join me on an exciting journey to build something truly game-changing! Here's the deal: I've been working tirelessly on the frontend of an innovative app called Arthwise using React Native. It's all about democratising financial expertise and empowering users with valuable insights to navigate the world of investments. Now, I need someone with backend wizardry to help bring Arthwise to life! This isn't your typical job post – it's more of a collaborative side hustle. We'll be building something together that has the potential to change the game in the finance world. What I'm Looking For: Someone who's pa...

...specialized in Java, JavaScript, and PL-SQL, as well as familiar with Oracle Database, PL-SQL Developer, Oracle SQL Developer, Eclipse. The project involves writing comprehensive tests for a range of technologies including: - Java and JavaScript. - Spring Framework. - Oracle Database. - XML and JSON. - Junit. - Eclipse/Intellij. - PL-SQL Developer. - Utilizing Github and other version control tools. The ideal candidate must have a deep understanding and practical experience with these technologies. The project has an urgent timeline, so the selected candidate must be able to work under pressure and deliver high-quality results quickly. Ideal Skills: - Proficient in Java, Spring Framework, Oracle, XML, JSON, Junit, and JavaScrip...

I need an experienced server administrator to assist me in setting up a domain remotely. he should have some experience with Digital Ocean and Linux server setups The ideal freelancer for this project should have experience in: - Setting up Linux servers, particularly on Digital Ocean - Proficiency in configuring and managing Ubuntu - Experience with Nginx web server software - Understanding of web hosting best practices and security measures - Strong troubleshooting skills in case of any issues. Please note that the server will be used for hosting a website, so it should be optimized for performance and security.

I want a Linux Ubuntu 24.02 expert who knows multiple domain handling on the server. I already created a .conf file but respective subdomain is redirecting to another website than required.

...PHP developers to enhance the capabilities of multiple open source projects. The exact projects requiring development haven't been specified, but the key components will include: Brief description: Members can also upload items (only to designated columns set by administrators). Assumption: The administration will set up a category column—Card Trading. Members who log in can upload related items to sell, but only to that column; they cannot upload to other columns. Let's break it down step by step: User Column: Modify the administrator's product management template. The administrator will set up a category, such as the Card Trading Market. Then, all items uploaded by users will be categorized under this c...

I'm looking for an expert in Excel to assist with a project involving data entry and analysis. The Excel sheet you'll be working on has more than 50 columns and rows and will contain a mix of text, numbers, and dates. You'll be responsible for the following: - Accurate and timely entry of the data provided - Ensuring the data is appropriately formatted and organized - Conducting thorough data analysis, including but not limited to trends, comparisons, and any other insights that can be drawn from the data The ideal candidate for this project should have: - Proficiency in Excel and experience with large data sets - Strong attention to detail - Ability to perform data analysis and present insights - Good ...

I am looking for a specialist to develop a Network-Attached Storage (NAS) server primarily for backup and storage purposes. The server is expected to handle: - A data volume between 1TB and 5TB initially. - Primarily cater to Windows operating system. Ideal Skills: - Strong knowledge of server architecture and NAS - Familiarity with data backup systems - Expertise in Windows operating systems. Your proposal should detail your experience with similar projects and provide an outline on how to approach and execute this task.

Project Duration: 1 Hour Project Type: Python Script Modification Project Level: Normal Server Type: Ubuntu 22.04 Number of Changes Required: 1 Project Overview: We have an existing Python script that allows us to upload a CSV with two columns: Prompt Output The script then submits each “Prompt” to the OpenAI API, inserts the output into the “Output” column. We would like one change made to the existing script. Change Required: We would like to add one more column to the CSV file, “Id”, it will be the first column. We use “Id” as our own reference number for the row This column and its value should be retained in the output file. 5* FEEDBACK WILL BE LEFT ...

...including formulas and charts. I need someone to transfer this data into tables, with the primary goal of organizing the information for better clarity and ease of understanding. Key Tasks: - Type the data into tables: This needs to be done with meticulous attention to detail to ensure accuracy and integrity of the data. - Apply borders and shading: To enhance the visibility of the tables and make them aesthetically pleasing. - Utilize headers: Rows and columns should have appropriate headers to aid in quick data navigation. Ideal Freelancer: - Proficient in Excel: Ability to work with intermediate level of data such as formulas and charts. - Strong attention to detail: Critical for ensuring tha...

I am in need of a well-versed Python expert to assist in managing a Linux server. This project is task oriented and requires specific skills including: • Working with server data analysis • Implementing web scraping techniques • Establishing automation processes The role also demands a comprehensive understanding of Linux operations and the ability to print headers. A background in server security, setting up database servers and performance optimization would be ideal, but the focus is primarily on Linux server management via Python. Proficiency in Python, Linux, server data analysis and web scraping are must-haves. Experience in automation and server management will highly be app...

I need messages I receive in a specific server channel to be forwarded to my own servers channel, I do not have admin role for the server channel I will need messages forwarded from, so I need a script or anything you can come up with, I am allowed to invite accounts to the server channel

I'm c...developer who has proven expertise in Python, Java, and Ruby. I need someone who can guide me through whether to use the current source code or start from scratch, a decision that we can make together as the project evolves. As our project's main responsibility is to handle authentication and server configuration, the perfect candidate should be experienced in: - Setting up, managing, and sustaining server configurations - Handling various authentication tasks - Expertise in Python, Java, and Ruby - Decision-making skills concerning source code development This project will be rewarding for someone who enjoys tackling unique challenges and has a flair for problem-solving. If you're up to...

I am currently working on a proje...on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valua...

I'm looking for a proficient professional who can create a report in Microsoft Access from a MySQL database. The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, wi...

I'm looking to set up a Minecraft 1.16 server focused on mini-games. Initially, I'd need 4-6 mini-games to be developed. Key Responsibilities: - Configure and set up a Minecraft 1.16 server - Design and implement 4-6 engaging mini-games - Ensure the server's smooth running and performance Ideal Skills: - Proficiency in Minecraft server setup - Proven experience in mini-games development - Strong understanding of Minecraft 1.16 mechanics - Ability to manage and maintain server performance - Creative problem-solving skills to enhance player experience Looking for a dedicated and experienced Minecraft developer who can not only set up the server but also create fun and unique mini-games withi...

As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.

I am in need of a competent data engineer for a small-scale data analysis task. - The project primarily revolves around performing data analysis. - The ideal candidate should be proficient in data analysis techniques. - Previous experience with data engineering will be a significant advantage. Your role will mainly involve performing data analysis tasks, so a deep understanding of data engineering and analysis is essential for this project. A strong background in Python, R, or SQL is highly preferred, though not mandatory. Please note that the project timeline is quite flexible, so you will have ample time to complete this task.

...programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this project requir...

I need a skilled professional to help me creating email servers to send bulk emails and managing. - **Email Marketing**: I have been using the server for bulk mailing and email marketing. I need an expert who can optimize these operations, ensuring that the emails are being delivered effectively and not marked as spam. - **Troubleshooting and Support**: Although I did not select this as a specific task, I might need help with troubleshooting and support in the future. It would be great if the individual could provide this assistance as needed. The ideal candidate for this project is someone with extensive experience in managing email servers, particularly with SMTP, bulk mailing, and email marketing. A deep understanding of email delive...

I'm looking for a skilled freelancer to help me create a pivot table in Microsoft Excel that will be used to find pricing quicker Key Requirements: - The pivot table must be created in Microsoft Excel. - The purpose of the pivot table is to find pricing easier The data sources which the pivot table will be using are confidential, and will be shared with the selected freelancer.

...hand are primarily data entry, table creation in Excel and development of an instruction manual in Word. Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the data. - Develop an instruction manual in Word. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel, with a strong expertise in data entry and structuring information. - Proficiency in creating tables, and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content. - Attention to detail, as accurate data entry is vital. - Strong communication skills to understand the...

I have a file uploading system installed in my localhost server that's working perfectly. But when I tried to move it to an IIS server, it's not working.

I am seeking an experienced developer to create a two-way SMS app that is compatible with iOS and web-based platforms. The app should enable users to: - Send and receive SMS messages - Manage contacts - View message history Moreover, I'd like the following features integrated: - Push notifications - Message search functionality - Support for attachments Proficiency in iOS and web development, experience with SMS-based applications, and understanding of push notifications, search functionality and attachment support are crucial for this project. Your insight and suggestions to optimize the user experience would be highly appreciated. similar to

Hello to all talented SQL freelancers! We are seeking an advanced SQL specialist with proven experience in handling multi-level marketing (MLM) databases, as well as knowledge of Dolibarr ERP. We need someone who can understand the complex terms associated with MLM compensation plans and create effective SQL queries to extract the necessary data, as well as integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requi...

I'm currently facing a server error labeled "Laravel 500" on my website. This error presents itself whenever the website is visited. I've recently made some changes which involved reinstalling the website from another hosting to my own server, and this could be the possible cause of the issue. I need a professional who understands Laravel framework thoroughly and has significant experience in troubleshooting similar errors to fix this issue. Additionally, Key Skills and Experience: - Laravel Framework - Error Troubleshooting

I'm in need of a skilled freelancer who can deliver a well-rounded Google sheet to capture important aspects of monthly personal finance, it's crucial that the created sheet can be adaptable to handle text, numerical, and date/time data. Key features: - Data validation - Pivot tables - Conditional Formatting - charts/graphs To be a right fit for this task, you should have a strong grasp on creating and optimizing Google Sheets, with these particular functions. Showcasing your past work in similar projects will strengthen your application. I'm looking forward to collaborating with you on this project to create a solid and functional Google sheet.

I'm currently facing some integration problems with my CI runner on GitHub. I'm looking for an experienced freelancer who can help me resolve this issue. Github Repository Push --> target is that runner push code to cloud linde automatically Key requirements: - Previous experience with GitHub CI runners and Linde Cloud Server. - Strong problem-solving skills in identifying and resolving integration issues. - Good understanding of continuous integration and deployment processes. - Ability to communicate effectively on the progress and steps taken towards resolving the issue. Please include similar project experiences in your application. Looking forward to working with a competent professional who can get this resolved quick...

I am in need of a specialist who can set up a DayZ server for Xbox, with in-depth knowledge of the DayZ game mechanics and server maintenance. Here are the specifics: - OS: As my console of choice is Xbox, I require someone who can effectively deal with a server setup on this console. - Mods: I am looking for custom mods. It would be highly advantageous if you have experience in customizing mods fitting to the specific needs of the players. The ideal candidate should have solid experience in DayZ server setup on Xbox, and extensive know-how in custom mod implementation. Sound knowledge in maintaining and troubleshooting Xbox servers would be a plus. Please, detail your experience with the ab...

I'm in need of a skilled professional to set up an OpenVPN server on a Linux machine. The main goal of this setup is to enable site-to-site connectivity in a secure manner. This project requires a unique approach to access control; this will be managed based on data stored in a MongoDB database. Key Responsibilities: - Configure an OpenVPN server on a Linux machine for site-to-site connectivity. - Implement routing based on MongoDB database records. Ideal Skills: - Proficient in Linux server setup and configuration. - Experience in OpenVPN server setup, particularly for site-to-site connectivity. - Familiarity with MongoDB, especially in integrating it with ...

...able to monitor their tickets' progress with ease. Ticket Priorities: - The system must classify tickets with a three-tiered system: Critical, Major, and Minor. Each category should have its distinct features and priority level. User Roles: - The ticketing system should incorporate three crucial user roles: Admin, Agent, and User. - Admin: Full control over the entire system. - Agent: Responsible for handling and resolving tickets. - User: Able to submit tickets and monitor their progress. Ideal skills and experience for the job would be expertise in web development, specifically in creating ticketing systems. Familiarity with user management, role assignment, and priority matrix are essential. Fluent in programming...

I require a skilled freelancer to carry out photo retouching work on a series of images intended for commercial use. - Task Specifics: The focus will be on retouching the images. I'm aiming for a natural, unforced look, so your advanced retouching and corrective editing skills will come in handy. - Ideal Skills: Proficiency in industry-standard photo editing software, with a keen eye for detail, and previous experience in commercial image editing. - Deliverables: High-quality, naturally retouched images suitable for commercial use. Please get in touch if you have the skills and the vision to help bring this project to life.

I am in need of a skilled PHP programmer to address an "undefined variable" error within my user authentication system. The system primarily relies on email and password authentication. Key Requirements: - The error lies within the user authentication system - The primary method of user authentication in the system is email and password Ideal Skills and Experience: - Proficiency in PHP, SQL - Experience with user authentication systems - Familiarity with handling undefined variable errors - Understanding of secure email and password authentication Your task is to identify the root cause of this error and implement a solution to rectify it. Please provide specific examples of similar work you have done in the past.

Please Sign Up or Login to see details.

Hi I need to setup MSSQL server on AWS Cloud. If you have the desired skills please do not hesitate to bid. Thanks

Hi, I need to setup windows IIS web server and docker on AWS. If you have the required skills please do not hesitate to bid. Thanks

...developer with solid skills in webscraping to gather data from the Premier League's stats page (). The required task involves capturing all available statistics and organizing them into rows and columns within a single CSV file: every season is a row, with different statistics as columns. Applicants should be able to provide the following: - Evidence of past work, particularly related to webscraping. - Their robust experience in Python language and relevant industries. - Detailed project proposals outlining strategy and timeline. Given specified needs, Python is the preferred programming language for this project. Previous experience in similar webscraping projects is desirable, demonstrating your ability to...

...expert to adapt my advanced financial models to reflect our current business strategies. The project involves: - Adapting advanced financial models: The existing models are highly complex, with intricate formulas and extensive use of macros. The ideal candidate should be comfortable working with such complexity. - Business strategy alignment: The primary goal is to ensure that these models accurately mirror our updated business strategies. This may involve tweaking existing formulas, adding new ones, and making the models more responsive to changing market conditions. Ideal Skills: - Advanced Excel Proficiency: A deep understanding of advanced Excel functionalities, including complex formulas, pivot tables, and macros is critical. - Financial ...

i need unity backend developer that experience with node.js and mongodb to the migration from aws server to vps server

We are searching for a highly skilled and experienced developer to assist us in building robust API integrations using CloudQuery. Our project involves extracting and integrating data from various sources into our system for advanced data analysis and reporting. We're looking for a developer who can effectively use CloudQuery to build these integrations in a scalable and efficient manner. Key Responsibilities: Design and implement API integrations using CloudQuery. Be able to write DBT transformations. Extract and manipulate data from various data sources (SQL, NoSQL, APIs, etc.). Ensure the integrations are scalable, efficient, and maintain high performance. Collaborate with our team to understand requirem...

I'm looking for a skilled .NET developer with experience in JSON, MS SQL, AJAX, and HTML to help me migrate my existing website to a new template. The specific features that need to be migrated are the design layout and content pages. To give some context, the primary objective of this migration project is to enhance the functionality of the website. An ideal candidate should be well-versed in enhancing user experience and updating design aesthetics. Your role will be pivotal in ensuring that the new template not only preserves the existing features but also improves the functionality. The key difference I'm aiming for in the new site is faster loading times. This means that you should be able ...

...is open only to individuals. Agencies need not apply. Freelancers with no rating need not apply. Generic copy-paste responses will be marked as spam. Your past freelance feedback should clearly show that you have completed similar tasks. I require a specialist in web scraping to extract the body text from articles on Google News. The information will be earmarked for natural language processing, hence, accuracy of extraction and correct formatting into an excel file is of utmost importance. Key responsibilities and skills: - Experience in web scraping, specifically from news websites. - Knowledge of creating Python or PHP scraping scripts or using API. - Ability to deliver results fast, as the project needs to be completed ASAP. Plea...

I'm seeking a skilled server administrator to help with the general maintenance and smooth operation of my Linux server (CPanel). Key Tasks: - Server Security: This is a top priority. I need the freelancer to ensure that the server is secure, and all necessary security measures are in place. - Monitoring and Backups: Regular monitoring of the server's performance and creating a backup plan. - Software Installations and Updates: Installing necessary software and ensuring that everything is up-to-date. - Migrations - Accounts setup and transfer - Reports: Providing regular reports on the server's health and performance. The ideal candidate should have: - Proficient experience with Linux server administration....

ITE USE One page elementor website

Project Students are expected to design and build an interactive website based on the material learned in the class using content management systems such as Joomla. This project aims to allow students to use their innovativeness and creativity to build an e-business idea in small teams based on 2 students. Students can pick pure or partial e-business models that can have online transactions through a website. The project should contain all the components of a well-made website. It should include: • Web pages, videos, images, banners, menus • Forms • Server-side scripts • Database The following are some sample projects which you may work on one of them: a) Online magazine in health/sport etc. ... b) Online li...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

Hi, I need to create a new script based on our existing scripts. Have two parameters: one for sheet ID and and one for collection. When you run the script, it extracts all data from that collection and puts it into a sheet tab with DateTime as tab name. Also can handle collections within a collection and create them as separate columns on the sheet.

I need a skilled python developer to create a JSON to Excel converter. Key Requirements: - You'll be working with Flat JSON data - How to handle missing data is up to you - Mapping of JSON fields to Excel columns is flexible Ideal Skills: - Proficient in Python - Experience with JSON parsing - Excel manipulation skills I'm open to suggestions on the best way to map the data, so please include your ideas in your bid. Let me know if you have any questions.